Cache Bindings and Loading Databases

If you dump a database and load it onto a server with different cache bindings, you may want to load the database onto a different server for tuning or development work, or you may need to load a database that you dropped from a server whose cache bindings have changed since you made the dump.

When you bring a database online after recovery or by using online database after a load, SAP ASE verifies all cache bindings for the database and database objects. If a cache does not exist, SAP ASE writes a warning to the error log, and the binding in sysattributes is marked as invalid. Here is an example of the message from the error log:

Cache binding for database '5', object '208003772', index '3' is being marked invalid in Sysattributes.

Invalid cache bindings are not deleted. If you create a cache of the same name and restart SAP ASE, the binding is marked as valid and the cache is used. If you do not create a cache with the same name, you can bind the object to another cache, or allow it to use the default cache.

In the following sections, which discuss cache binding topics, destination server refers to the server where the database is being loaded, and original server refers to the server where the dump was made.

If possible, re-create caches that have the same names on the destination server as the bindings on the original server. You may want to configure pools in exactly the same manner if you are using the destination database for similar purposes or for performance testing and development that may be ported back to the original server. If you are using the destination database for decision support or for running dbcc commands, you may want to configure pools to allow more space in 16K memory pools.