Unix master getting a message in the system logs SQLAnywhere: Performance warning: Server cache size is too small for database "NBDB"

Problem

Unix master getting a message in the system logs  SQLAnywhere: Performance warning: Server cache size is too small for database "NBDB"

Error Message

SQLAnywhere(validation_eng): [ID 702911 user.notice] Performance warning: Server cache size is too small for database "NBDB"

Cause

• Database may have grown beyond the cache memory limit setting
• May be caused by the normal fragmentation of a database

Solution

1. Increase the database  memory settings in server.conf file. In this example the NetBackup master server has 256 GB of installed memory. For the '-ch' value below, use 30% of the RAM available (256 X .30) on the system.

   From:
   cat -s /usr/openv/var/global/server.conf
   -c 6G -ch 32768M -cl 6G -gd DBA -gk DBA -gl DBA -gna 1 -gp 4096 -k -m -n MyMaster
   -o /usr/openv/db//log/server.log -os 1M -ti 0 -ud -wc- -x tcpip(LocalOnly=YES;ServerPort=13785)

   To:
   cat -s /usr/openv/var/global/server.conf
   -c 6G -ch 77G -cl 6G -gd DBA -gk DBA -gl DBA -gna 1 -gp 4096 -k -m -n MyMaster
   -o /usr/openv/db//log/server.log -os 1M -ti 0 -ud -wc- -x tcpip(LocalOnly=YES;ServerPort=13785)

   Start NetBackup services:
   /usr/openv/netbackup/bin/bp.start_all

2. Run EMM Database Defragmentation
   • How to rebuild the NetBackup Database (NBDB)