| Neueste Versionen | 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 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC76248 | Status: Geschlossen |
IN CONTROL CENTER, DB2/ZOS TABLE SPACE PARTITIONS APPEAR MORE THAN ONCE IN PARTITION MANAGEMENT TAB OF ALTER TABLESPACE WINDOW | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 5. At a minimum, this fix should be applied on the client. | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.05.2011 14.12.2011 14.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.5 |
|