|
Problem IC68553
|
Status: Geschlossen |
ROLLFORWARD COMMAND FAILED WITH SQL4970N ERROR |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problembeschreibung: |
When DB2 rollforward command with stop option is issued the
requried log file was not found. Rollforwad command can't make
the database consistent. failed with SQL4970N error. There is
extra logic involved that ends up creating a new copy of
required log file. The following messsgae could be db2diag.log
file
2010-03-23-23.15.34.375576-240 I4028087E420 LEVEL: Info
PID : 12262 TID : 183278496096 PROC :
db2sysc 3
INSTANCE: DB2INST1 NODE : 003 DB : SAMPLE
EDUID : 34412 EDUNAME: db2loggr (RAVESTAG) 3
FUNCTION: DB2 UDB, data protection services, sqlpgCallGIFL,
probe:1250
DATA #1 : <preformatted>
New log extent 50800, PId 1269236666, StartLsn 000008D5F5014000 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Any user of rollforward command *
****************************************************************
* PROBLEM DESCRIPTION: *
* Rollforward fails due to creation of new log file. *
****************************************************************
* RECOMMENDATION: *
* Make sure all the requried log file available. Especially *
* when *
* the overflow log path is used for rollward. The following *
* *
* command is recommened: rollforward db <dbname> stop overflow *
* log *
* path (xxXX) *
**************************************************************** |
| Local-Fix: |
Make sure all the requried log file available. Especially when
the overflow log path is used for rollward. The following
command is recommened: rollforward db <dbname> stop overflow log
path (xxXX) |
| verfügbare FixPacks: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Apply fix. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 12.05.2010
29.07.2011
29.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.4
|
 |
