DB2 - Problembeschreibung
Problem IC63605 | Status: Geschlossen |
BCKT AUTOSTORAGE ;TC AUTO9S.PL;DB2V97FP1 - MAINLINE S BATCH | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
db2look was generating additional INCREASESIZE value for automatic storage tablespace, even though the value is not specified during the DDL creation. Hence bucket autostorage is failing with parameter p2 on DB2V97FP1 - Mainline S Batch on latest build level on all platforms. Fragment of auto92.dfr < #BEGIN_CHOICE < CREATE LARGE TABLESPACE "T09S6" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE AUTORESIZE YES INITIALSIZE 1 M MAXSIZE NONE EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 $FSC_DTR < #NEXT_CHOICE < CREATE LARGE TABLESPACE "T09S6" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE AUTORESIZE YES INITIALSIZE 32 M MAXSIZE NONE EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 $FSC_DTR < #END_CHOICE < DB20000I The SQL command completed successfully. < > CREATE LARGE TABLESPACE "T09S6" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE AUTORESIZE YES INITIALSIZE 32 M INCREASESIZE 100 M MAXSIZE NONE EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 NO FILE SYSTEM CACHING DROPPED TABLE RECOVERY ON > DB20000I The SQL command completed successfully. > | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Software * **************************************************************** * PROBLEM DESCRIPTION: * * db2look was gnerating incorrect tablespace DDL statements * **************************************************************** * RECOMMENDATION: * * move to v97 fp1 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
fix was provided in v97 fp1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.10.2009 05.02.2010 05.02.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |