monLicense

Provides a list of all licences currently checked out by the SAP ASE server.

You need not enable any configuration parameters for this monitoring table to collect data.

Note: monLicense does not require mon_role permission; any user can use it.

Columns

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 SAP ASE 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 SAP ASE. Possible limiters are: ME = maximum number of engines MC = maximum number of connections MS = maximum number of disk space MM = maximum number of memory CP = maximum number of CPUs