How to check Tivoli Storage Manager (TSM) database health status

TSM Database (db) is the major component in Tivoli Storage Manager Architecture. It contains the transaction details of all the client backups and server data transfers. If TSM db is lost or corrupted it is almost or impossible to recreate the same TSM Server. So, we have to take the db backup regularly or schedule an db backup which runs automatically without user intervention.

Snapshot: A snapshot database backup is a full
database backup that does not interrupt the current full and incremental backup
series. This backup can be stored in offsite for disaster recovery purposes.

Specifies,
as a percentage of the total number of requests, the number of requests for
adatabase page that are already in the buffer
pool. It should always be greater than 97%.

15)How to check db backup is running or not?

Using these commands you can check db backup

Query Session

Query Process

16)How to check the
last db backup is completed or not?

Using these
commands you can check the last db backup.

Query volhist type=dbb

Query event * t=a

Query actlog search="DB BACKUP"

Query db f=d

17)What is the
relation between volhist file and TSM database?

Volhist file: Use volume history information when you reload the database and audit
affected storage pool volumes. If you cannot start the server, you can use the
volume history file to query the database about these volumes. The volume history includes information about the following types of
volumes:

Database backup volumes

Database dump volumes

Export volumes

Backup set volumes

Database snapshot volumes

Database recovery plan file volumes

Recovery plan file volumes

Recovery plan file snapshot volumes

The following sequential access storage pool
volumes:

Volumes added to storage
pools

Volumes reused through reclamation
or MOVE DATA operations

Volumes removed by using the
DELETE VOLUME command or during reclamation of scratch volumes