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 IC84362 Status: Geschlossen

LOAD INTO RANGE PARTITIONED TABLE WITH COPY YES MAY FAIL WITH SQL0901N ON
SANITY CHECK WITH SQLUTRANSFORMMERGEFSCRREQUEST

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
LOAD into range partition table with copy yes may fail on sanity 
check with  sqluTransformMergeFSCRRequest message. 
 
Sample db2diag.log output: 
 
2011-10-24-14.47.58.072296-240 I2119873E8263       LEVEL: Severe 
PID     : 3234                 TID  : 47477101160768PROC : 
db2sysc 2 
INSTANCE: db2inst1             NODE : 002          DB   : TESTDB 
APPHDL  : 1-29825              APPID: 
10.222.1.55.151.36855.11102418465 
AUTHID  : XXXXXX 
EDUID   : 4122                 EDUNAME: db2lbm0 2 
FUNCTION: DB2 UDB, database utilities, 
sqluTransformMergeFSCRRequest, 
probe:3311 
MESSAGE : ZRC=0x82150001=-2112552959=SQLU_GENERIC_ERROR 
"Internal Error" 
          DIA8532C An internal processing error has occurred. 
DATA #1 : LOADID, PD_TYPE_LOADID, 55 bytes 
LOADID: 2485.2011-10-24-14.47.14.078362.1 (65530;32796) 
DATA #2 : String, 41 bytes 
Don't have this page number in my history 
DATA #3 : unsigned integer, 8 bytes 
16000 
DATA #4 : String, 11 bytes 
array index 
DATA #5 : signed integer, 4 bytes 
0 
DATA #6 : SQLU_FSCR_SANITY, PD_TYPE_SQLU_FSCR_SANITY, 264 bytes 
SQLU_FSCR_SANITY: Address:0x2b2dba4e9ce0, Size:x10, Size:16 
   x0004        fscrSanityArraySize           32 
   x0008        fscrArray[0] 
      SQLU_FSCR_SANITY_ARRAY: Address:0x2b2dba4e9ce8, Size:x8, 
Size:8 
         x0000  fscrPageNum                   0 
         x0004  iBMID                         0 
   x0010        fscrArray[1] 
      SQLU_FSCR_SANITY_ARRAY: Address:0x2b2dba4e9cf0, Size:x8, 
Size:8 
         x0000  fscrPageNum                   500 
         x0004  iBMID                         0
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10 Fix Pack 1                                * 
****************************************************************
Local-Fix:
NA
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
First Fixed in DB2 V10 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.06.2012
17.12.2012
17.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList