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

NoteIn 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

Permissions

You must be a system administrator to execute sp_lmconfig.

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

See also

Document The Adaptive Server installation guide for your platform.