home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList