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.




What Others are Reading Now...

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

Post a Comment