Open objects parameter may be too low

Message text

server: Warning: OPEN OBJECTS parameter may be too low; attempt was made to free up descriptor in desfree().  Run sp_configure to increase parameter value.

or

server: Warning: OPEN OBJECTS or OPEN DATABASES parameter may be too low; attempt was made to free up descriptors in release_dbtable().  Run sp_configure to increase parameter value.

Explanation

This message is a warning indicating that you do not have enough object descriptors or open databases available in the chain containing all the free descriptors.

This message is displayed in the Adaptive Server error log when Adaptive Server reaches the end of its array of allocated object descriptors, tries to recycle previously-used object descriptors and fails. It can also be displayed when Adaptive Server has fewer open databases configured than the number of databases on the Server.

Action

To recover from this error, increase the values of the configuration parameters number of open objects and number of open databases.

The configuration parameter number of open databases sets the maximum number of databases that can exist at one time on Adaptive Server.

The configuration parameter number of open objects sets the maximum number of objects that can be open at one time on Adaptive Server.

Increasing the value for number of open databases or number of open objects does not have a significant impact on performance or storage requirements, but it does require memory. For more information about how Adaptive Server allocates memory, refer to “Memory Use and Performance” in Performance and Tuning: Basics and “Configuring Memory” in the System Administration Guide: Volume 2.

Use the system procedure sp_configure to display the values of the configuration parameters you need to change:

1> sp_configure "number of open databases"
2> go

If the value for number of open databases is less than the value displayed by select count (*) from sysdatabases, increase the value of number of open databases. Otherwise, increase the value of number of open objects only.

To increase either of these values, refer to the instructions in Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1.

Additional information

In Adaptive Server Enterprise version 11.5 and later, use sp_countmetadata to determine the current value of number of open objects and number of open databases. For example:

1> sp_countmetadata 'open objects' 
2> go
There are 338 user objects in all database(s), requiring 
165 Kbytes of memory. The 'open objects' configuration parameter 
is currently set to 500.
1> sp_countmetadata 'open databases' 
2> go
There are 5 databases, requiring 189 Kbytes of memory. The 
'open databases' configuration parameter is currently set to 12.