sp_iqlmconfig Procedure

Controls license management configurations, displays and sets license type and status.

Syntax 1

sp_iqlmconfig ’edition’, { ’SE’ | ’SA’ | ’EE’ }
Summary information for "edition" parameter

Topic

Value

Default

’EE’ (Enterprise Edition)

Range of values

’SE’ (Small Business) ’SA’ (Single Application) ’EE’ (Enterprise Edition)

Status

Static

Syntax 2

sp_iqlmconfig ’license type’, { ’CP’ | ’DT’ | ’SF’ | ’AC’ | ’BC’ | 'CH' | 'DH' | 'SH' | 'AH' | 'BH' }
Summary information for "license type" parameter

Topic

Value

Default

’DT’ (Development and Testing)

Range of values

’AC’ (OEM CPU License) ’AH’ (OEM CPU License Chip) ’BC’ (OEM Standby License) ’BH’ (OEM Standby License Chip) ’CP’ (CPU License) ’CH’ (CPU License Chip) ’DH’ (Development and Testing License Chip) ’DT’ (Development and Testing) ’EV’ (Evaluation) ’SF’ (Standby CPU License) ’SH’ (Standby CPU License Chip)

Status

Static

Syntax 3

sp_iqlmconfig ’email severity’, { ’ERROR’ | ’WARNING’ | ’INFORMATIONAL’ | ’NONE’ }

NONE designates that e-mail notification is disabled.

Syntax 4

sp_iqlmconfig ’smtp host’, ’<host name>’ | ’
Parameters

Parameter

Description

host name

Specifies SMTP host used for e-mail notification.

Syntax 5

sp_iqlmconfig ’email sender’, ’<email address>’ |
Parameters

Parameter

Description

<email address>

Specifies the sender’s e-mail address used for e-mail notification.

Syntax 6

sp_iqlmconfig ’email recipients’, ’<email recipients>’ |
Parameters

Parameter

Description

<email recipients>

Specifies a comma-separated list of e-mail addresses to whom e-mail notifications will be sent.

Syntax 7

sp_iqlmconfig |

Privileges

You must have EXECUTE privilege on the system procedure, as well as the SERVER OPERATOR system privilege.

Remarks

At startup, sp_iqlmconfig checks the edition type and license type of the license specified.

  • If the specified license is not found, the server falls to grace mode.

  • The specified license type becomes valid only when a non-null edition value is specified.

  • If sp_iqlmconfig is called with no parameters (Syntax 3), it displays all the information above, as well as other information, such as:

    • Product Edition and License Type

    • Which of the optional licenses are in use

    • License count

    • E-mail information

    • General information about the license

Related concepts
Properties Available for the Server
Related reference
Determining the Security Model Used by a Database