sp_listsuspect_page  sp_lock

Chapter 1: System Procedures

sp_lmconfig

Description

Configures license management-related information on Adaptive Server. The configuration options set by sp_lmconfig are stored in the sylapi properties file.

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:

“edition”

is a static configuration parameter to specify the license edition.

edition_type

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

“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:

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           null
 license type      null
 smtp host         smtp
 email recipients  cshi
 email severity    ERROR
 smtp port         25
 email sender      cshi

License Name    Version    Quantity Status       Expiry Date
--------------- ---------- -------- ------------ --------------------
ASE_HA          null       0        not used     null
ASE_DTM         null       0        not used     null
ASE_JAVA        null       0        not used     null
ASE_ASM         null       0        not used     null
ASE_EJB         null       0        not used     null
ASE_EFTS        null       0        not used     null
ASE_DIRS        null       0        not used     null
ASE_XRAY        null       0        not used     null
ASE_MESSAGING   null       0        not used     null
ASE_ENCRYPTION  null       0        not used     null
ASE_CORE                   1        graced       Sep 11 2005  2:40AM
ASE_PARTITIONS             1        graced       Sep 11 2005  2:40AM

Property Name Property Value
------------- --------------
PE            null
LT            null
ME            null
MC            null
MS            null
MM            null
CP            null
AS            null

Usage

If you do not specify an edition or use “null,” Adaptive Server looks for and uses whatever license edition it finds when it starts.

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.





Copyright © 2005. Sybase Inc. All rights reserved. sp_lock

View this book as PDF