Provides a list of all licences currently checked out by the Adaptive Server.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monLicense are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
Quantity |
int |
Quantity of licenses used for this feature. |
|
Name |
varchar(30) |
Null |
Name of the feature license. |
Edition |
varchar(30) |
Null |
Edition of Adaptive Server for which this feature is licensed. |
Type |
varchar(64) |
Null |
License type. |
Version |
varchar(16) |
Null |
Version of the feature license in use |
Status |
varchar(30) |
Null |
Status of this feature license (that is, whether the license is withing a grace period expired). |
LicenseExpiry |
datetime |
Null |
Date that the license expires, if this is an expiring license. |
GraceExpiry |
datetime |
Null |
Date this license expires, if this license was awarded on grace. Refer to the Status column to determine whether this license was awarded a grace period. |
LicenseID |
varchar(150) |
Null |
License identifier. This may not be available if the license has been awarded a grace period. |
Filter |
varchar(14) |
Null |
Filter used when selecting this feature license. Use sp_lmconfig to change the filter. |
Attributes |
varchar(64) |
Null |
License attributes. These attributes are “name=value” pairs which, if specified, limit certain characteristics of Adaptive Server. Possible limiters are:
|
monLicense does not require mon_role permission;
any user can use it.
