|
Problem IC68875
|
Status: Closed |
IN DB2 V9.1, DB2LOOK WILL EXTRACT DDL FROM SYSTOOLSTMPSPACE THAT INCORRECTLY INCLUDES THE AUTORESIZE CLAUSE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
If you extract the DDL on the tablespace SYSTOOLSTMPSPACE it
returns:
CREATE USER TEMPORARY TABLESPACE "SYSTOOLSTMPSPACE" IN DATABASE
PARTITION
GROUP IBMCATGROUP
PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE
AUTORESIZE NO
EXTENTSIZE 4
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 7.500000
TRANSFERRATE 0.060000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
If you attempt to recreate the tablespace with this DDL it will
fail with:
SQL0109N The "AUTORESIZE" clause is not allowed. SQLSTATE=42601 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Please see Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.1 Fix Pack 10. *
**************************************************************** |
| Local Fix: |
Manually remove the "AUTORESIZE NO" from the db2look file. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
First fixed in DB2 Version 9.1 Fix Pack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.05.2010
16.06.2011
16.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
