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 IC78439 Status: Closed

BACKUP DATABASE CAN GET BAD PAGELSN ERROR DURING OPEN LOG FILE

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
A database backup 
can receive errors similar to the following in the db2diag.log : 
 
 
2010-07-08-09.21.24.408286+120 I101329A552        LEVEL: Severe 
PID     : 565266               TID  : 40233       PROC : db2sysc 
0 
INSTANCE: db2inst1                 NODE : 000         DB   : 
SAMPLE 
APPHDL  : 0-50630              APPID: 
*LOCAL.db2inst1.100708072117 
AUTHID  : TEST 
EDUID   : 40233                EDUNAME: db2bm.6365.1 (SAMPLE) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpOpenLogForBackup, probe:40 
MESSAGE : Bad pagelsn found for log file: 
DATA #1 : Hexdump, 4 bytes 
0x0700000144BFD99C : 0000 0018 
.... 
 
2010-07-08-09.21.24.409183+120 I101882A530        LEVEL: Severe 
PID     : 565266               TID  : 40233       PROC : db2sysc 
0 
INSTANCE: db2inst1                 NODE : 000         DB   : 
SAMPLE 
APPHDL  : 0-50630              APPID: 
*LOCAL.db2inst1.100708072117 
AUTHID  : TEST 
EDUID   : 40233                EDUNAME: db2bm.6365.1 (SAMPLE) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpOpenLogForBackup, probe:41 
MESSAGE : pagelsn 
DATA #1 : Hexdump, 6 bytes 
0x07000001E9F86006 : 0000 2F25 A935 
../%.5 
 
2010-07-08-09.21.24.409419+120 I102413A544        LEVEL: Severe 
PID     : 565266               TID  : 40233       PROC : db2sysc 
0 
INSTANCE: db2inst1                 NODE : 000         DB   : 
SAMPLE 
APPHDL  : 0-50630              APPID: 
*LOCAL.db2inst1.100708072117 
AUTHID  : TEST 
EDUID   : 40233                EDUNAME: db2bm.6365.1 (SAMPLE) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpOpenLogForBackup, probe:42 
MESSAGE : previous page pagelsn 
DATA #1 : Hexdump, 6 bytes 
0x0700000144BFD7C4 : 0000 2F25 A951 
../%.Q
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See problem description above                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.1  Fixpack 11                       * 
****************************************************************
Local Fix:
Add option EXCLUDE LOGS to backup command
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
First fixed in V9.1 Fixpack 11
Workaround
Add option EXCLUDE LOGS to backup command
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.09.2011
20.01.2012
20.01.2012
Problem solved at the following versions (IBM BugInfos)
9.1.,
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.