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

WRONG TBSPACEID VALUE FOR CGTTS IN SYSIBM.SYSDATAPARTITIONS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Here is the scenario: 
 
1) db2 "create user temporary tablespace TEMPSPACE" 
 
2) db2 "select TBSPACEID from sysibm.systablespaces where 
TBSPACE='TEMPSPACE'" 
 
 TBSPACEID 
 ----------- 
     6 
 
3) db2 "create global temporary table s1.cgtt1(c1 int) in 
TEMPSPACE" 
 
4) db2 "select CREATOR,NAME,TBSPACE from sysibm.systables where 
CREATOR='S1'  and NAME='CGTT1'" 
 
 CREATOR     NAME     TBSPACE 
 --------------------------- 
 S1         CGTT1     TEMPSPACE 
 
5) db2 "selectTABSCHEMA,TABNAME,TBSPACEID,LONG_TBSPACEID, 
INDEX_TBSPACEID from sysibm.sysdatapartitions where 
TABSCHEMA='S1' and TABNAME='CGTT1'" 
 
 TABSCHEMA  TABNAME TBSPACEID  LONG_TBSPACEID   INDEX_TBSPACEID 
 --------------------------- --------------------------------- 
 S1          CGTT1      0            6                 6 
 
 
When a CGTT is created, the TBSPACEID field in 
SYSIBM.SYSDATAPARTITIONS is set to 0 which is incorrect. The 
LONG_TBSPACEID and the INDEX_TBSPACEID are correctly set to 6.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5 or later.              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.03.2011
20.01.2012
20.01.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList