|
Problem IC74043
|
Status: Closed |
DB2LOOK MAY GENERATE INCORRECT TABLESPACE CONTAINER INFORMATION FOR PARTITIONED DATABASES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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) |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
First fixed in v97 fixpack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.01.2011
19.12.2011
19.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
|
 |
