home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC81091 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - 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 Version 9.7 Fix Pack 6.                       * 
****************************************************************
Local-Fix:
NA
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 9.7 Fix Pack 6.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84362 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.01.2012
20.06.2012
20.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList