Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

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