Symptom
In the SYBASE error log file, you noticed that below error keep generating frequently.
Increase the config parameter ‘number of open partitions’ to avoid descriptor reuse. Reuse may result in performance degradation.
Aside to ‘number of open partitions’ error, the same scenario occurred on ‘number of open objects’ and ‘number of open indexes’.
Increase the config parameter ‘number of open objects’ to avoid descriptor reuse. Reuse may result in performance degradation.
Increase the config parameter ‘number of open indexes’ to avoid descriptor reuse. Reuse may result in performance degradation.
Solution
As of SAP Note 1581695 – SYB: Configuration Guide for SAP ASE 16.0 and SAP Note 1749935 – SYB: Configuration Guide for SAP ASE 15.7, SAP requested to set the values as following,
• number of open objects >= 40000
• number of open indexes >= 30000
• number of open partitions >= 30000
If you have followed the minimum values as SAP requested, you may need to increase the values again.
Check the Current Configured Values
1. Execute transaction code DBACOCKPIT or DB02. Go to Database SID tab and click on Performance > ASE Resources.
2. Look for number of open indexes / objects or partitions. In our case, we are highlighting on number of open partitions.
3. Look on the Chart and analyze the Reuse Count.
Note: SAP recommends to increase the configuration values only when the Reuse Count shows a high number or when warning messages appear with high frequency in the ASE error log file.
Increase / Change the Configuration Value
1. Go to Configuration > Server Configuration
2. Look for Meta-Data Caches. Highlight the number of open partitions and click on Change.
3. Set the new value and click on Execute.
Note
• SAP Note 1867120 – How to solve warning message “Increase the config parameter ‘number of open XXX’ to avoid descriptor reuse.” SAP ASE
• SAP Note 1839485 – SYB:Partition descriptor scavenges messages in ASE error log
