Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09328 Status: Geschlossen

ROLLFORWARD CAN FAIL WITH SQL1271W ERROR

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to in DB2 LUW v10.5 Fixpack 7 or Later.              * 
****************************************************************
Local-Fix:
Lösung
First Fixed in DB2 LUW v10.5 Fixpack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.06.2015
21.01.2016
21.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList