SAP Knowledge Base Article - Preview

2604896 - Msg 18124 on ASE 160 SP02 PL07 - SAP ASE

Symptom

  • SAP ASE has been recently upgraded to ASE 160 SP02 PL07
  • Error 18124 persists on this release, when checking individual parameters in the group: Non-Volatile caches  -

1> sp_configure 'Non-Volatile Caches'
2> go

Group: Non-Volatile Caches

Parameter Name                                                                                                                                                                                                                                
         Default     Memory Used Config Value Run Value    Unit
         Type
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         ----------- ----------- ------------ ------------ --------------------
         --------------------
NV Cache Threshold                                                                                                                                                                                                                            
                  50           0           50           50 percent
         dynamic
NVCache Lazy Cleaner Pool Size                                                                                                                                                                                                                
                 512           0          512          512 kilobytes
         dynamic
User Defined NV Cache                                                                                                                                                                                                                         
                   0           0            0            0 not applicable
         NULL

(1 row affected)
(return status = 0)


1> sp_configure 'User Defined NV Cache'
2> go
Msg 18124, Level 16, State 1:
Server 'SID', Procedure 'sp_configure', Line 1732:
No matching configuration options.  Here is a listing of groups:

(1 row affected)
(return status = 1)


1> sp_configure 'NV Cache Threshold'
2> go
Msg 18124, Level 16, State 1:
Server 'SID', Procedure 'sp_configure', Line 1732:
No matching configuration options.  Here is a listing of groups:

--------------------------------------------------


1> sp_configure 'NVCache Lazy Cleaner Pool Size'
2> go
Parameter Name                                                                                                                                                                                                                                
         Default     Memory Used
         Config Value                                                                                                                                                                                                                          
         Run Value                                                                                                                                                                                                                             
         Unit                 Type
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         ----------- -----------
         ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         -------------------- --------------------
NVCache Lazy Cleaner Pool Size                                                                                                                                                                                                                
                 512           0
                  512                                                                                                                                                                                                                          
                  512                                                                                                                                                                                                                          
         kilobytes            dynamic

(1 row affected)
(return status = 0)

  • On systems running SAP applications, DBACockpit -> SAP Configuration Checker , a RED light is returned

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL07 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL07

Keywords

18124, NV Cache, sp_configure, Configuration Checker, CR 813451, CCDB, PL07 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.