|
Problem IC81708
|
Status: Closed |
DATABASE ROLLFORWARD MAY FAIL IF IT IS RUN AFTER FIRST RUNNING A FAILING AND THEN SUCCESSFUL TABLESPACE RFWD. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
To hit this problem a customer will have to perform a tablespace
rollforward that fails while processing a LOAD log record.
Then, the customer would have to successfully run the tablespace
rollforward command again. Finally, if the database is restored
and then rolled forward such that the same log file are
processed, the database roll forward may fail.
In the db2diag.log, you may see a message from function
sqlprProcDPSRec with probe 460. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Database and tablespace rollforward with LOAD *
****************************************************************
* PROBLEM DESCRIPTION: *
* The following sequence of rollforward commands may cause *
* database rollforward to fail. First a tablespace *
* rollforward has to fail while processing a LOAD log record. *
* Then, a successful tablespace rollforward, followed by a *
* database restore and database rollforward using the same log *
* files as the tablespace rollforwards. *
****************************************************************
* RECOMMENDATION: *
* Apply DB2 Version 9.7 Fixpack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Apply DB2 Version 9.7 Fixpack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.02.2012
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
