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

Examples

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.

See also:
  • The SAP ASE installation guide for your platform.

Permissions

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

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

InformationValues
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