| 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 IC76248 | Status: Closed |
IN CONTROL CENTER, DB2/ZOS TABLE SPACE PARTITIONS APPEAR MORE THAN ONCE IN PARTITION MANAGEMENT TAB OF ALTER TABLESPACE WINDOW | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
In Control Center, when you are connected to a DB2 on z/OS
database and you do the following sequence of actions, each
partition appears multiple times in the Partition Management tab
of the Alter Table Space window:
1) Select 'Table Spaces'.
2) Select a table space.
3) Select 'Alter...'
4) Select the 'Partition Management' tab.
The reason why each table space partition appears more than once
is because Control Center runs an SQL statement like the
following, which is a Cartesian join of the system catalog
tables SYSIBM.SYSTABLEPART and SYSIBM.SYSTABLESPACE:
SELECT
A.PARTITION,
A.TSNAME,
A.DBNAME,
A.IXNAME,
A.IXCREATOR,
A.PQTY,
A.SQTY,
A.STORTYPE,
A.STORNAME,
A.VCATNAME,
A.PERCACTIVE,
A.PERCDROP,
A.FREEPAGE,
A.PCTFREE,
A.CHECKFLAG,
A.SPACE,
A.COMPRESS,
A.GBPCACHE,
A.STATSTIME,
A.TRACKMOD,
B.ERASERULE
FROM
SYSIBM.SYSTABLEPART A ,
SYSIBM.SYSTABLESPACE B
WHERE
(A.TSNAME='<table space name>' AND A.DBNAME='<database name>')
ORDER BY
A.PARTITION
FOR FETCH ONLY WITH UR | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of DB2 for Linux, UNIX and Windows who connect using * * Control Center to DB2 on z/OS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * . * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Solution | |
Problem was first fixed in Version 9.7 Fix Pack 5. At a minimum, this fix should be applied on the client. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.05.2011 14.12.2011 14.12.2011 |
| 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 |
|