|
Problem IC63605
|
Status: Closed |
BCKT AUTOSTORAGE ;TC AUTO9S.PL;DB2V97FP1 - MAINLINE S BATCH |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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.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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Software *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2look was gnerating incorrect tablespace DDL statements *
****************************************************************
* RECOMMENDATION: *
* move to v97 fp1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
fix was provided in v97 fp1 |
| 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.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
