SYB: Increase the config parameter ‘number of open partitions’ to avoid descriptor reuse



Share this article :

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.

DBACOCKPIT - ASE Resources

2. Look for number of open indexes / objects or partitions. In our case, we are highlighting on number of open partitions.

Number of open partitions

3. Look on the Chart and analyze the Reuse Count.

Details - Chart

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

DBACOCKPIT - Server Configuration

2. Look for Meta-Data Caches. Highlight the number of open partitions and click on Change.

Meta-Data Caches - Number of open partitions

3. Set the new value and click on Execute.

Number of open partitions - Change Configuration Parameter

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

Related posts

Define & Setup SAP Logical System
Find SAP JAVA System Information
SAP Tools for MS SQL Server (STM)
SAProuter: SNC processing failed: SncSetMyNameU
© 2017 ITsiti. All Rights Reserved
Powered by KEEM