DB2 - Problem description
Problem IT03449 | Status: Closed |
THE ROLLFORWARD DB COMMAND PRINTED INCORRECT RESULT FOR LOG FILES PROCESSED. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The proceeding rollforward database command printed the incorrect log file name for Log files processed. In the following example, S0000013.LOG is no longer necessary after the rolloforward database command. However, the succeeding rollforward database command needed S0000013.LOG. example) 1. $ db2 rollforward db t27761 to end of logs Rollforward Status Input database alias = t27761 Number of members have returned status = 1 Member ID = 0 Rollforward status = DB working Next log file to be read = S0000014.LOG Log files processed = S0000013.LOG - S0000013.LOG Last committed transaction = 2014-07-11-06.52.00.000000 UTC 2. Deleting S0000013.LOG. 3. $ db2 rollforward db t27761 to end of logs SQL1273N An operation reading the logs on database "T27761" cannot continue because of a missing log file "S0000013.LOG" on database partition "0" and log stream "0". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All user. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5.0.7. * **************************************************************** | |
Local Fix: | |
Do not remove SYYYYYYY.LOG printed at Log files processed. Log files processed = SXXXXXXX.LOG - SYYYYYYY.LOG | |
Solution | |
The problem is first fixed in DB2 version 10.5.0.7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.07.2014 28.01.2016 28.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |