| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC74995 | Status: Closed |
WRONG TBSPACEID VALUE FOR CGTTS IN SYSIBM.SYSDATAPARTITIONS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 5 or later. * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 Version 9.7 Fix Pack 5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.03.2011 20.01.2012 20.01.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.5 |
|