Check for these messages in TSM actlog for monitoring DB and log space utilization


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.

Monitoring Active log space utilization

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 Tivoli® Storage Manager 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 Tivoli Storage Manager server starts an incremental database backup. Otherwise, the server starts a full database backup.

Also Read: How to increase or decrease TSM DB, active log and archive log size ?

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.

Monitoring the Archive log space utilization

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 Tivoli Storage Manager server starts a full automatic database backup.

Monitoring TSM Database space utilization

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. 

Also Read: SQL commands to query TSM Server

ANR1546W: FILESYSTEM_DBPATH_LESS_1GB
The available space in the directory where the server database files are located is less than 1 GB.


When a Tivoli Storage Manager 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.




What Others are Reading Now...

0 Comment to "Check for these messages in TSM actlog for monitoring DB and log space utilization"

Post a Comment