Windows: Monitoring space utilization for the database and recovery logs
To determine the amount of used and available active log space, you issue the QUERY LOG command. To monitor space utilization in the database and recovery logs, you can also check the activity log for messages.
Active log
If the amount of available active log space is too low, the following messages are displayed in the activity log:- ANR4531I: IC_AUTOBACKUP_LOG_USED_SINCE_LAST_BACKUP_TRIGGER
- This message is displayed when the active log space exceeds the
maximum specified size. The IBM Spectrum Protect™ server starts
a full database backup.
To change the maximum log size, halt the server. Open the dsmserv.opt file, and specify a new value for the ACTIVELOGSIZE option. When you are finished, restart the server.
- ANR0297I: IC_BACKUP_NEEDED_LOG_USED_SINCE_LAST_BACKUP
- This message is displayed when the active log space exceeds the
maximum specified size. You must back up the database manually.
To change the maximum log size, halt the server. Open the dsmserv.opt file, and specify a new value for the ACTIVELOGSIZE option. When you are finished, restart the server.
- ANR4529I: IC_AUTOBACKUP_LOG_UTILIZATION_TRIGGER
- The ratio of used active-log space to available active-log space exceeds the log utilization threshold. If at least one full database backup has occurred, the IBM Spectrum Protect server starts an incremental database backup. Otherwise, the server starts a full database backup.
- ANR0295I: IC_BACKUP_NEEDED_LOG_UTILIZATION
- The ratio of used active-log space to available active-log space exceeds the log utilization threshold. You must back up the database manually.
Archive log
If the amount of available archive log space is too low, the following message is displayed in the activity log:- ANR0299I: IC_BACKUP_NEEDED_ARCHLOG_USED
- The ratio of used archive-log space to available archive-log space exceeds the log utilization threshold. The IBM Spectrum Protect server starts a full automatic database backup.
Database
If the amount of space available for database activities is too low, the following messages are displayed in the activity log:- ANR2992W: IC_LOG_FILE_SYSTEM_UTILIZATION_WARNING_2
- The used database space exceeds the threshold for database space utilization. To increase the space for the database, use the EXTEND DBSPACE command, the EXTEND DBSPACE command, or the DSMSERV FORMAT utility with the DBDIR parameter.
- ANR1546W: FILESYSTEM_DBPATH_LESS_1GB
- The available space in the directory where the server database files are located is less than 1
GB.
When an IBM Spectrum Protect server is created with the DSMSERV FORMAT utility or with the configuration wizard, a server database and recovery log are also created. In addition, files are created to hold database information used by the database manager. The path specified in this message indicates the location of the database information used by the database manager. If space is unavailable in the path, the server can no longer function.
You must add space to the file system or make space available on the file system or disk.