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

ROLLFORWARD CAN FAIL WITH SQL1271W ERROR

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Restore & rollforward can fail, if you had the following: 
 
- Backup running 
- alter tablespace reduce max 
 
$db2 rollforward db DB10 complete 
SQL1271W Database "DB10" is recovered but one or more table 
spaces are 
offline on members or nodes "0". 
 
db2diag.log: 
 
2015-06-02-14.04.21.063476-240 I293984E824           LEVEL: 
Severe 
PID     : 701                  TID : 46912971467072  PROC : 
db2sysc 
INSTANCE: db2inst1             NODE : 000            DB   : DB10 
APPHDL  : 0-608                APPID: 
*LOCAL.db2inst1.150602180417 
AUTHID  : DB2INST1             HOSTNAME: db2host1 
EDUID   : 552                  EDUNAME: db2redom (DB10) 
FUNCTION: DB2 UDB, buffer pool services, 
sqlbFindNewHighWaterMark, probe:20 
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not 
exist" 
          DIA8506C Unexpected end of file was reached. 
DATA #1 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes 
96001 
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes 
3 
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes 
96001 
DATA #4 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes 
96000 
DATA #5 : Codepath, 8 bytes 
59:64 
 
2015-06-02-14.04.21.064266-240 I294809E556           LEVEL: 
Error 
PID     : 701                  TID : 46912971467072  PROC : 
db2sysc 
INSTANCE: db2inst1             NODE : 000            DB   : DB10 
APPHDL  : 0-608                APPID: 
*LOCAL.db2inst1.150602180417 
AUTHID  : DB2INST1             HOSTNAME: db2host1 
EDUID   : 552                  EDUNAME: db2redom (DB10) 
FUNCTION: DB2 UDB, buffer pool services, sqlbRedo, probe:0 
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not 
exist" 
          DIA8506C Unexpected end of file was reached.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to in DB2 LUW v10.5 Fixpack 7 or Later.              * 
****************************************************************
Local Fix:
Solution
First Fixed in DB2 LUW v10.5 Fixpack 7.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.06.2015
21.01.2016
21.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