sp_lmconfig

Description

Configures license management-related information on Adaptive Server.

Syntax

sp_lmconfig
	[
	[ 'edition' [, edition_type ]]										|
	[ 'license type' [, license_type_name ]]										|
	[ 'smtp host' [, smtp_host_name ]]										|
	[ 'smtp port' [, smtp_port_number ]]										|
	[ 'email sender' [, sender_email_address ]]										|
	[ 'email recipients' [, email_recipients ]]										|
	[ 'email severity' [, email_severity ]]
	]

Parameters

sp_lmconfig: without parameters displays the following license status information:

Server Name

License Name

Version

Quantity Status

Expiration Date

edition: is a static configuration parameter to specify the license edition.

edition_type: specifies the edition type, and has the following possible values:

null – is the default value. When a null value is specified, no product edition is configured, and Adaptive Server starts with a license for any edition.

EE – indicates the Enterprise edition.

SE – indicates the Small Business edition.

DE – indicates the Developer’s edition.

XE – indicates the Express edition.

license type: is a static configuration parameter that specifies the license type for the installation of Adaptive Server, and is valid only when you specify a non-null edition.

license_type_name: specifies the license type of a particular installation of Adaptive Server. You need not specify license type if you are using the Developer’s (DE) or Express (XE) edition. The valid, most typical values are:

SRST – server license with network seats

SVST – standby server license with network seats

SRCU – server license with concurrent user seats

SVCU – standby server license with concurrent user seats

SRIA – server license with Internet access license

SVIA – standby server license with Internet access license

CP – CPU license

SF – standby CPU license

null – default

In addition to this list, sp_lmconfig also accepts two-letter abbrevations for specialized and legacy license types. If the license type is not accepted, set the type to null and use the network license server options file to control the license used by this Adaptive Server.

smtp host, smtp host name: designates the SMTP host used to send E-mails for license event notifications.

smtp port, smtp port number: designates the SMTP port used to send Emails for license event notifications.

email sender, sender email address: specifies the E-mail address used as the senders address on license event E-mail notifications.

email recipients, email recipients: is a comma separated list of E-mail recipients who receive license event E-mail notifications.

email severity, email severity: is the minimum severity of an error that causes an E-mail notification to be sent. The default is error, and the other possibilities are warning and informational.

Examples

Example 1

Displays basic license configuration information for a system:

1> sp_lmconfig
2> go

 Parameter Name    Config Value
 ----------------- ------------
 edition           EE
 license type      CP
 smtp host         null
 email recipients  null
 email severity    null
 smtp port         null
 email sender      null

 License Name         Version    Quantity Status     Expiry Date         Server Name
 ---------------      ---------- -------- ---------- ------------------- ----------
 ASE_HA               2010.03314 2        expirable  Apr 1 2010 12:00AM  cuprum
 ASE_ASM              null       0        not used   null                null
 ASE_EJB              null       0        not used   null                null
 ASE_EFTS             null       0        not used   null                null
 ASE_DIRS             null       0        not used   null                null
 ASE_XRAY             null       0        not used   null                null
 ASE_ENCRYPTION       null       0        not used   null                null
 ASE_CORE             2010.03314 2        expirable  Apr 1 2010 12:00AM  cuprum
 ASE_PARTITIONS       null       0        not used   null                null
 ASE_RLAC             null       0        not used   null                null
 ASE_MESSAGING_TIBJMS null       0        not used   null                null
 ASE_MESSAGING_IBMMQ  null       0        not used   null                null
 ASE_MESSAGING_EASJMS null       0        not used   null                null
 
 Property Name Property Value ------------- --------------
 PE            EE
 LT            CP
 ME            null
 MC            null
 MS            null
 MM            null
 CP            0
 AS            A
 
(return status = 0)

Usage

When you do not specify any parameters, sp_lmconfig also displays the server name from the location where the license is checked out.
If you do not specify an edition or use “null,” Adaptive Server looks for and uses whatever license edition it finds when it starts.
The configuration options set by sp_lmconfig are stored in the sylapi properties file.

Permissions

The permission checks for sp_lmconfig differ based on your granular permissions settings.

Granular permissions enabled	With granular permissions enabled, you must be a user with manage server configuration privilege.
Granular permissions disabled	With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect