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
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.
SAP Knowledge Base Article - Preview