Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2006

Tip: Looking for answers? Try searching our database.

Bizarre Crash Recovery

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michel Esber - 20 Jul 2006 19:24 GMT
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 - 20 Jul 2006 19:33 GMT
> Hello,
>
[quoted text clipped - 31 lines]
>
> TIA.

My system came back up after 30 mins of crash recovery. Fortunately, it
seems this Total Work/Completed Work numbers are not valid.

Any other way accurate way to monitor recovery ?

Thanks, Michel.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.