DB2 - Problembeschreibung
Problem IC99566 | Status: Geschlossen |
ROLLFORWARD TO END OF BACKUP IMAGE MIGHT FAIL DUE TO CLOCK SKEW FOR A DPF DATABASE ON DIFFERENT PHYSICAL NODES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Rollforward to end of backup image for a DPF database might fail with the following db2diag.log message: 2013-12-22-18.37.43.820886-300 I265305E1291 LEVEL: Info PID : 833 TID : 46912807889216PROC : db2sysc 10 INSTANCE: db2inst1 NODE : 010 DB : TESTDB APPHDL : 1-469 APPID: *N1.nypxt110.131222233724 AUTHID : DB2 EDUID : 3315 EDUNAME: db2agntp (TESTDB) 10 FUNCTION: DB2 UDB, data protection services, sqlpProgMonRecStartNextPhase, probe:100 DATA #1 : String, 837 bytes Job Type = 6 Job ID = 13 Start Time = 1387755449.971259 Description = Database Rollforward Recovery Invoker Type = User Total number of phases = 2 Current Phase = 2 Phase Number = 1 Description = Forward Metric = 1 Total Work Units = 64 Completed Work Units = 64 Phase Number = 2 Description = Backward Metric = 1 Total Work Units = 167772104 Completed Work Units = 0 2013-12-22-18.37.43.821274-300 I266597E517 LEVEL: Error PID : 833 TID : 46912807889216PROC : db2sysc 10 INSTANCE: db2inst1 NODE : 010 DB : TESTDB APPHDL : 1-469 APPID: *N1.nypxt110.131222233724 AUTHID : DB2 EDUID : 3315 EDUNAME: db2agntp (TESTDB) 10 FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery, probe:920 DATA #1 : <preformatted> Rollforward is not able to reach the specified point in time. nextLso 82983773121 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW version 10.5.0.4. * **************************************************************** | |
Local-Fix: | |
Rollforward to a point-in-time larger than the end of backup time. | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Apply DB2 V10.5 Fixpack 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.02.2014 16.09.2014 16.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |