Skip to Content

Switch to disallow checkout of any optional graced license

SAP IQ server optional license features:

  • IQ_CORE
  • IQ_UDA
  • IQ_LOB
  • IQ_SECURITY
  • IQ_VLDBMGMT
  • IQ_UDF
  • IQ_IDA
  • IQ_URIDA
  • IQ_TS_FSF
  • ALL

SAP IQ server, on attempted usage of  any optional feature would try to check out corresponding license.  If license was available, that license feature becomes available. This caused problems with unintended usage, specially during installation grace period. With this new switch implemented in SAP IQ 16 sp08 and above,  SAP IQ server will not attempt to checkout any grace license unless  it have been 'authorized' by the DBA. DBA will have to authorize using sp_iqlmconfig system stored procedure.

Syntax:

    sp_iqlmconfig 'allow', <license_name> [,quantity]

                 and

    sp_iqlmconfig 'disallow', <license_name>

  • <license_name> can be any one of above listed license optional features.
  • 'quantity'  parameter is only required to change number of available  IQ_VLDBMGMT  licenses.
  • 'ALL'  enables or disables all optional features except IQ_VLDBMGMT

Example:

   sp_iqlmconfig 'allow',  'IQ_VLDBMGMT',6 --------increase IQ_VLDBMGMT license quantity by 6

   sp_iqlmconfig 'disallow',  'IQ_VLDBMGMT' -------sets the IQ_VLDBMGMT license quantity to 0

For documentation:

sp_iqlmconfig Procedure - Reference: Building Blocks, Tables, and Procedures - SAP Library

Tags: