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 , Business Suite on Adaptive Server Enterprise , 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.