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 for Me (Login required).

Search for additional results

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