|
Problem IC68875
|
Status: Geschlossen |
IN DB2 V9.1, DB2LOOK WILL EXTRACT DDL FROM SYSTOOLSTMPSPACE THAT INCORRECTLY INCLUDES THE AUTORESIZE CLAUSE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in DB2 Version 9.1 Fix Pack 10. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.05.2010
16.06.2011
16.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
