sp_lmconfig

Configures license management-related information on SAP ASE.

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 the SAP ASE 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 SAP ASE, and is valid only when you specify a non-null edition.
license_type_name – specifies the license type of a particular installation of SAP ASE. 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
Note: 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 SAP ASE 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

There are additional considerations when using sp_lmconfig:

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,” the SAP ASE 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.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage server configuration` privilege.
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:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	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