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.