Bizarre Crash Recovery

Michel Esber · *nix forums addict Joined: 15 Aug 2005 Posts: 69

Hello,

Linux V8 FP12 with a 64 bit instance.

My DBA called me and said our instance crashed and recovery would never
end.

[db2inst1@autprd04 db2dump]$ db2 list utilities show detail

ID = 1
Type = CRASH RECOVERY
Database Name = RTMDB
Partition Number = 0
Description = Crash Recovery
Start Time = 07/20/2006 14:14:45.338397
Progress Monitoring:
Estimated Percentage Complete = 0
Phase Number [Current] = 1
Description = Forward
Total Work = 18446671313663709616 bytes
Completed Work = 6993977295 bytes
Start Time = 07/20/2006 14:14:45.338516
Phase Number = 2
Description = Backward
Total Work = 18446671313663709616 bytes
Completed Work = 0 bytes
Start Time = Not Started

How is this number possible? 16 Million Terabytes of logs ?

Is there any *quick* way to put the DB back online ?

Help,

TIA.

Michel Esber · *nix forums addict Joined: 15 Aug 2005 Posts: 69

Google