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.

Monitoring Tivoli Storage Manager (TSM) Database

1) How to check the db % utilization?

Using Q DB Command, We can check the DB utilization.

2) How to take the db backup?

Backup db devclass = devclass name type=full/incremental/db snapshot volume=volume name scratch=yes/no wait=yes/no

3) What are types of db backup differentiate them?

There are 3 types of db backup

Full: complete backup of database

Incremental: only modified database transactions will be backed up.

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.

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

4) How to mirror a db volume?

Define dbcopy volumename copyvolumename formatsize=MB wait=yes/no

5) Explain about space trigger in TSM?

TSM prepares an additional space when predetermined thresholds have been exceeded in the database.

Define spacetrigger DB Fullpct=80 spaceexpansion=20 Expansionprefix=c: \TSMDB mirrorprefixes=”F:\mirror1, G:\mirror2” Maximumsize=megabytes STGPOOL=storage pool

Then Increase the size of the DB using “EXTEND” command.

6) What is the use of splitted db architecture in TSM?

Maintaining DB Volumes in different directories or LUNs will increase the TSM Server performance because the I/O resources will be shared between all those directories.

7) What is the maximum TSM DB size in 5.5 & 6.3?

The maximum TSM DB size in 5.5 version is 530 GB, and 4 TB in TSM Version 6.3.

8) What is the database in TSM 6.X versions ?

TSM 6.X versions has DB2 database included. Sql queries can be done to search the queries.

9) How to format a db volume from OS prompt?

You can create volume for db in OS level

C:\Program files\Tivoli\TSM\Console\dsmfmt –db c:\ven\db.dsm 1024

Then you can extend DB in server mode.

C:\Program files\Tivoli\TSM\Server\dsmserv extend db c:\ven\db.dsm 1024

10) How to restore a TSM server db and steps involved in it?

You can create volume for db in OS level

C:\Program files\Tivoli\TSM\Console\dsmfmt –db c:\ven\db.dsm 1024

Then you can extend DB in server mode.

C:\Program files\Tivoli\TSM\Server\dsmserv extend db c:\ven\db.dsm 1024

Then you can restore the DB by

C:\Program files\Tivoli\TSM\Server\dsmserv restore db devclass=devclassname volume name=c:\backup\0987.bm commit=yes

If original database volumes are available. Give only dsmserv restore db command.

Also Read: Take TSM DB backup immediately if you notice these messages

11) How to load db?

dsmserv loaddb devclass=<dev class> volumenames=<volumename>

12) How to dump db?

dsmserv dumpdb devclass=<dev classname>

13) How to upgrade db?

Before upgrading the Tivoli Storage Manager server to the new release. Back up critical server information by using the BACKUP DB, BACKUP DEVCONFIG, and BACKUP VOLHIST commands

      Backup db type=full devclass=tape device

      Backup devconfig filename=filename

      Backup volhistory


 Device configuration information files that you have identified in the dsmserv.opt file, with the DEVCONFIG option.
Volume history information to files that you have identified in the dsmserv.opt file, with the VOLUMEHISTORY option.
Save the TSM Server default directory (DEVICECONFIG, VOLHIST, dsmserv.opt and dsmserv.dsk).
Now install the latest TSM Server software.
Verify that the installation was successful by starting the server. 
An upgrade will not normally create a new database, recovery log, and storage pool volumes. The dsmserv.dsk file points to the locations of the current database and recovery log volumes. 
The installation creates the Database volume (db.dsm), Recovery log volume (log.dsm), Storage pool volumes (backup.dsm, archive.dsm, and spcmgmt.dsm)  volumes in the same directory:

   C:\program files\Tivoli\TSM\Server\dsmserv upgrade db

Also Read: Taking TSM server DB backup when the server is down

14) What is the cache hit % of TSM database?

Specifies, as a percentage of the total number of requests, the number of requests for a database 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

Database:

· It is used to manage information about client files.

· It contains information that is needed for server operations.

· It consists of information about client systems, policy management rules, storage pool information, schedules, locations, sizes .

18) How to list the database volumes using dsmserv command?

dsmserv display dbvolumes

19) What is the default page size of a database?

The default size of database is 4096 KB (4 MB)

20) How to check current db transaction information and related commands?

Q db f=d

Related commands:

Backup db

Define dbcopy

Estimate dborgstats

Define dbvolume

Extend db

Reduce db

Reset bufpool

Reset db maxutilization

21) How to find db vol is online or offline?

Query dbvol

Also Read: Steps to do after successful TSM DB restore

22) How to format a dbvol from OS prompt?

You can create volume for db in OS level

C:\Program files\Tivoli\TSM\Console\dsmfmt –db c:\ven\db.dsm 1024

23) How to take a db backup on a specified volume?

Using this command you can take db backup on a specified volume.

Backup db devclass = devclass name type=full/incremental/dbsnapshot volume=<volume name> scratch=yes/no wait=yes/no

24) How to take a scheduled backup which should run for every 8 hrs?

Using this command you can take schuled backup which should run for every 8 hours

Define schedule domain name schedule name action=incremental/selective/archive/restore/retrieve/image backup/image restore/command/macro startdate=today starttime=04:00:00 duration=8 durunits=hours

25) What is db defragmentation?

A database defragmentation is done by performing a DSMSERV UNLOADDB, DSMSERV, LOADFORMAT and DSMSERV LOADDB.

26) How to delete a DB VOLUME? What are prerequisites for that?

Delete dbvol volumename

Before deleting any db volumes we should make sure that dbvolume is empty. Should move data from one dbvolume to another dbvolume.

Storage & Backup Tutorials

Categories

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

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

Post a Comment

Popular Posts