Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.