IBM Support

Determining how long DB2 crash recovery will take

Question & Answer


Question

Is there a way to determine how long it will take DB2 to perform it's crash recovery?

Cause

Starting the Tivoli Storage Manager in the foreground after a crash may produce the following messages in the DB2 diag log.

2013-11-04-10.54.49.911000-300 E39840079F462 LEVEL: Warning
PID : 3340 TID : 3584 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.SERVER1.131104155423
AUTHID : TSMINST1
EDUID : 3584 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E Crash recovery has been initiated.

Answer

In order to determine if it is running and how long it can potentially run, open up a DB2 command window and issue the following command.

db2 list utilities show detail

This will provide both the total work and the completed work.



As long as the completed work is increasing, the process is not hung.

To estimate the length of time it will take to complete, you first need to estimate how much is being processed each minute. To do this, take two different reading 10 minutes apart. Subtract the second completed work reading from the first. This will provide you with the amount of work completed in 10 minutes.

Next you need to determine how much work is left. To do this, subtract the completed work from the total work.

Then you can divide the amount of work left by the amount of work completed in 10 min. Then multiply that by 10 to get your final number of minutes remaining to complete the recovery.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU010","label":"Systems - Storage"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.2;6.3;7.1","Edition":""}]

Product Alias/Synonym

TSM IBM Spectrum Protect

Document Information

Modified date:
17 June 2018

UID

swg21655286