|
Problem IC63606
|
Status: Closed |
BCKT AUTOSTORAGE;TC AUTO9S.PL;DB2V95FP5 - MAINLINE S BATCH |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Software *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2look was generating incorrect tablespace DDL statement *
****************************************************************
* RECOMMENDATION: *
* move to v95 fp5 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
fixed in v95 fp5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.10.2009
05.02.2010
05.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.5
|
 |
