Troubleshooting
Problem
The BACKUP DB command is used to back up an IBM Spectrum Protect server database. The backup operation is completed successfully. However, the ANR4550I message reports a "Total bytes backed up" value that is lower than expected.
Symptom
The query db f=d command output shows amount of database space that is used. For example:
Database Name: TSMDB1
Total Space of File System (MB): 30,720
Space Used on File System(MB): 1,528
Space Used by Database(MB): 1,522
Free Space Available (MB): 29,192
This output shows that the database uses 1528 MB of space on the file system. When the database backup operation is completed, the ANR4550I message shows that the number of backup-up bytes is lower than expected. For example:
<timestamp>ANR4550I Full database backup (process 44) completed. Total bytes backed up: 252,182,528.
Cause
The database backup operation is working as designed. In this case, data compression was enabled, and the message shows the number of bytes when data compression is applied.
Diagnosing The Problem
Review the Compress Database Backups field in the output of the query db f=d command. For example:
Database Name: TSMDB1
Total Space of File System (MB): 30,720
Space Used on File System(MB): 1,528
Space Used by Database(MB): 1,522
Free Space Available (MB): 29,192
...
Compress Database Backups: No
In this example, the Compress Database Backups parameter is set to NO.
Review the BACKUP DB command that is used to back up the database. For example:
backup db dev=file type=full compress=yes
In this example, the compress=yes parameter is used. The COMPRESS parameter on the BACKUP DB command overrides any value that is set in the SET DBRECOVERY command and reported in the query db f=d output.
Resolving The Problem
No action is required.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg22014993