IBM Support

db2pd for monitoring DB2 crash recovery progress

Question & Answer


Question

In the event that the Tivoli Storage Manager server or underlying DB2 database crashes, how long will the recovery process take and how can it be monitored?

Answer

There is a DB2 diagnostic tool called 'db2pd' that can be used to obtain information from DB2 about on-going database recovery procedures.

Attempts to start the Tivoli Storage Manager or IBM Spectrum Protect server after a crash may result in a 'db2sysc' process consuming significant memory and CPU resources despite the fact that no dsmserv process is running. It is likely that the db2sysc process is involved in database recovery techniques. This can be confirmed by running the 'db2pd' program from a shell prompt.

For example:

    tsm:~ # db2pd
    db2pd> You are running db2pd in interactive mode.
    db2pd> If you want command line mode, rerun db2pd with valid options.
    db2pd> Type -h or -help for help.
    db2pd> Type q to quit.


To check the status of the database recovery operation, run the command '-recovery -db tsmdb1'. Please note that the database name will always be named 'tsmdb1'. For example, if a recovery is in progress the output would be similar to the following:

    db2pd> -recovery -db tsmdb1
    Database Partition 0 -- Database TSMDB1 -- Active -- Up 0 days 00:00:03
    Recovery:
    Recovery Status 0x04000C01
    Current Log
    Current LSN 0000000D017CA967
    Job Type CRASH RECOVERY
    Job ID 1
    Job Start Time (1272488115) Wed Apr 28 13:55:15 2010
    Job Description Crash Recovery
    Invoker Type User
    Total Phases 2
    Current Phase 1

    Progress:
    AddressPhaseNum Description StartTimeCompletedWorkTotalWork
    0x0000000200CAEF081ForwardWed Apr 28
    13:55:15    		306215037 bytes840613087 bytes
    0x0000000200CAF0902BackwardNotStarted 0 bytes840613087 bytes
The amount of 'completed work' can be compared to the 'total work' needed to approximate how long the recovery will take to complete.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM adsm spectrum protect

Document Information

Modified date:
17 June 2018

UID

swg21610522

Page Feedback