SAP Knowledge Base Article - Preview

2202254 - Sysam licenses present in license file are not displayed by the system procedure sp_lmconfig

Symptom

When executing the system stored procedure "sp_lmconfig", the output doesn't return any information about the license availability for options.  Even if the licenses for these options are present in the license file.

Below is a sample of the output of the System Stored Procedure sp_lmconfig:

1> sp_lmconfig
2> go

 Parameter Name    Config Value
 ----------------- ------------
 edition           EE
 license type      CP
 smtp host         smtp
 email recipients  *****
 email severity    NONE
 smtp port         25
 email sender      *****

 License Name    Version    Quantity Status       Expiry Date          Server Name
 --------------- ---------- -------- ------------ -------------------- --------------------
 ASE_HA          null       0        not used     null                 null
 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        2016.0331  8        expirable    Apr  1 2016 12:00AM  My_License_Serv
 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
 ASE_TSM         null       0        not used     null                 null
 ASE_IMDB        null       0        not used     null                 null
 ASE_RDDB        null       0        not used     null                 null
 ASE_DTU         null       0        not used     null                 null
 ASE_COMPRESSION null       0        not used     null                 null
 ASE_PRIVACY     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)

Only the license ASE_CORE is reported as used, while the license file used by this ASE Server contains license for the following option:
    ASE_PRIVACY
    ASE_ENCRYPTION
    ASE_RLAC
    ASE_IMDB
    ASE_RDDB
    ASE_HA
    ASE_PARTITIONS
    ASE_TSM
    ASE_COMPRESSION

None of these options are returned as available by the stored procedure sp_lmconfig.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 15.5
  • SAP Adaptive Server Enterprise (ASE) 15.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

SYSAM, option, license, not available, sp_lmconfig , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.