|
Problem IC74043
|
Status: Geschlossen |
DB2LOOK MAY GENERATE INCORRECT TABLESPACE CONTAINER INFORMATION FOR PARTITIONED DATABASES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2LOOK may generate incorrect tablespace information when
multiple DB2LOOK commands that retrieve tablespace layout
information are run at the same time.
The same container name may be duplicated (as in the example
below where there is actually only one container) or there could
be missing containers:
CREATE REGULAR TABLESPACE "REG1" IN DATABASE PARTITION GROUP
IBMCATGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING
('/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1',
'/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1') ON
DBPARTITIONNUMS (0) |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2LOOK may generate incorrect tablespace information when *
* *
* multiple DB2LOOK commands that retrieve tablespace layout *
* *
* information are run at the same time. *
* *
* *
* *
* The same container name may be duplicated (as in the example *
* *
* below where there is actually only one container) or there *
* could *
* be missing containers: *
* *
* CREATE REGULAR TABLESPACE "REG1" IN DATABASE PARTITION GROUP *
* *
* IBMCATGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING *
* *
* *
* *
* ('/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1', *
* *
* '/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1') ON *
* *
* DBPARTITIONNUMS (0) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97 fixpack 5. *
**************************************************************** |
| Local-Fix: |
Run db2look serially. |
| 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 v97 fixpack 5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.01.2011
19.12.2011
19.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
