|
Problem IC63606
|
Status: Geschlossen |
BCKT AUTOSTORAGE;TC AUTO9S.PL;DB2V95FP5 - MAINLINE S BATCH |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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.500000TRANSFERRATE 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.500000TRANSFERRATE 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 generating incorrect tablespace DDL statement *
****************************************************************
* RECOMMENDATION: *
* move to v95 fp5 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
fixed in v95 fp5 |
| 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.5.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.5
|
 |
