The reconfiguration templates help you keep user connections, metadata cache, and locks configured properly to meet your current demands.
Sybase reconfigure locks template This template allows you to set up automatic reconfiguration for the number of locks allowed by the server at any one time, based on server data and user input. You can specify the number of locks you want to add.
Sybase reconfigure metadata cache template The metadata cache is a reserved area of memory that is used for databases, indexes, and objects. Using this template, you can create jobs to determine the proper number of each metadata object type for your server. While creating the job, you supply values that are used at runtime to determine the proper number of objects needed for your current server conditions. The job will determine the current number of active objects and adjust the allowable number of objects of the specified type.
Alternatively, you can specify the exact number for one or all metadata object types, bypassing the self-tuning feature of this template.
Sybase reconfigure user connections template This template calls sp_configure to set the number of user connections. You can provide the new number of user connections, or the template can calculate it using information you supplied in the wizard.
