Changing NetBackup database cache memory settings

Use the NetBackup Database Administration utility to view and change the SQL Anywhere memory cache settings of the relational database server.

Changes to these settings affect all of the relational databases that the database server manages. The changes do not take effect until the NetBackup services are restarted.

The database cache is an area of the memory that is used by the database server to store database pages for repeated fast access. The more pages that are accessible in the cache, the fewer times the database server needs to read data from disk.

Reading data from disk is a slow operation and the amount of cache available is often a key factor in determining performance. The database cache is automatically resized as needed.

The cache grows when the database server can usefully use more, as long as memory is available. The cache shrinks when other applications require cache memory so that the database server does not unduly affect other applications on the system.

To change the NetBackup database cache memory settings

Start the NetBackup Database Administration utility that is located in the following directory:

InstallPath\VERITAS\NetBackup\bin\NbDbAdmin.exe
Enter the database login password and click OK.

See Using the NetBackup Database Administration utility.
Select the Tools tab.
In the Cache section, click Set.

In the NetBackup Database Cache settings dialog box, choose from the pre-set cache settings as described in Table: Database cache settings.

The selection determines the following memory cache settings to control the size of the database cache:

Minimum cache size

Sets the minimum cache size as a lower limit to automatic cache resizing.

This setting represents the -cl option in the server.conf file.

Initial cache size

Sets the initial memory that is reserved for caching database pages and other server information.

This setting represents the -c option in the server.conf file.

Maximum cache size

Sets the maximum cache size as an upper limit to automatic cache growth.

This setting represents the -ch option in the server.conf file.

If the settings are too large, the database server may not start.

Click OK.

Table: Database cache settings

Option	Minimum cache size	Initial cache size	Maximum cache size
Current	As configured	As configured	As configured
Small	25MB (50MB with BMR)	25MB (50MB with BMR)	500MB (750MB with BMR)
Medium	200MB (400MB with BMR)	200MB (400MB with BMR)	750MB (850MB with BMR)
Large	500MB (750MB with BMR)	500MB (750MB with BMR)	1000MB (1000MB with BMR)
Custom	Configurable	Configurable	Configurable

The database cache settings can be configured in the NetBackup Database Administration utility or in the server.conf file. The database server reads the file when it is started.

The server.conf file is found in the following location:

installpath\VERITAS\NetBackupDB\conf