Home » SAP » How to check db2 recovery process

How to check db2 recovery process

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 743,989 hits


Categories


[db2inst1@emadwh3 ~]$ db2 list utilities show detail

ID = 1
Type = CRASH RECOVERY
Database Name = DWH
Member Number = 0
Description = Crash Recovery
Start Time = 04/27/2023 07:12:46.168546
State = Executing
Invocation Type = User
Progress Monitoring:
Estimated Percentage Complete = 40
Phase Number [Current] = 1
Description = Forward
Total Work = 814690500000 bytes
Completed Work = 647811883486 bytes
Start Time = 04/27/2023 07:12:46.168580

Phase Number = 2
Description = Backward
Total Work = 814690500000 bytes
Completed Work = 0 bytes
Start Time = Not Started

[db2inst1@emadwh3 ~]$ db2pd -recovery -db DWH

Database Member 0 — Database DWH — Active — Up 0 days 03:59:53 — Date 2023-04-27-11.12.20.724981

Recovery:
Recovery Status 9000000F40088005
Current Log S1005378.LOG
Current LSN 0000048434716D53
Current LRI 000000000000000100000007F468DBB50000048434716D53
Current LSO 2018963846634260
Job Type CRASH RECOVERY
Job ID 1
Job Start Time (1682554366) Thu Apr 27 07:12:46 2023
Job Description Crash Recovery
Invoker Type User
Total Phases 2
Current Phase 1

Progress:
Address PhaseNum Description StartTime CompletedWork TotalWork
0x000000024D45B568 1 Forward Thu Apr 27 07:12:46 648827679888 bytes 814690500000 bytes
0x000000024D45B6F0 2 Backward NotStarted 0 bytes 814690500000 bytes
[db2inst1@emadwh3 ~]$


Leave a comment

April 2023
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930

Popularity


PageRank

Bookmark and Share