DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a Log shipping environment using "roll forward to end of 
logs: during the replay of the transaction logs on the target 
server a SQL1042C is returned. 
 
The cause of the SQL1042C is due to the last logfile in the 
previous "roll forward to end of logs"  only containting the 
initial two log records for a table reorg with the "using" 
clause.  The subseqent rollforward deletes a metadata file in 
the temporary tablespace specified by the "using" clause in the 
reorg,  which is required by the table reorg.

In a Log shipping environment using "roll forward to end of 
logs: during the replay of the transaction logs on the target 
server a SQL1042C is returned. 
 
The cause of the SQL1042C is due to the last logfile in the 
previous "roll forward to end of logs" only containting the 
initial two log records for a table reorg with the "using" 
clause. The subseqent rollforward deletes a metadata file in 
the temporary tablespace specified by the "using" clause in the 
reorg, which is required by the table reorg.

i)  Ensure that any rollfroward contains all logs used for a 
    table reorg in the log shipping environment. 
 
ii) In a log shipping environment use a point in time (PIT) to 
    rollforward, instead of end of logs.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 1.

i) Ensure that any rollfroward contains all logs used for a 
table reorg in the log shipping environment. 
 
ii) In a log shipping environment use a point in time (PIT) to 
rollforward, instead of end of logs.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.07.2009
31.12.2009
31.12.2009

9.7.FP1