IBM Support

IC71645: DB2LOOK DOESN'T GENERATE THE COLLECT STATISTICS CLAUSE FOR CREATE INDEX DDL STATEMENT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2 command to create index is :
    
    CREATE INDEX COLSTATSINX1 ON COLSTATS (POS) COLLECT STATISTICS;
    
    
    Return by db2look:
    
    CREATE INDEX "KATYLAO "."COLSTATSINX1" ON "KATYLAO "."COLSTATS"
            ("POS" ASC)
            COMPRESS NO ALLOW REVERSE SCANS;
    
    As we can see that db2look doesn't generate the COLLECT
    STATISTICS clause for CREATE INDEX DDL statement
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2LOOK DOESN'T GENERATE THE COLLECT STATISTICS CLAUSE FOR   *
    * CREATE INDEX DDL STATEMENT.                                  *
    *                                                              *
    * db2 command to create index is :                             *
    *                                                              *
    *                                                              *
    *                                                              *
    * CREATE INDEX COLSTATSINX1 ON COLSTATS (POS) COLLECT          *
    * STATISTICS;                                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * Return by db2look:                                           *
    *                                                              *
    *                                                              *
    *                                                              *
    * CREATE INDEX "KATYLAO "."COLSTATSINX1" ON "KATYLAO           *
    * "."COLSTATS"                                                 *
    *         ("POS" ASC)                                          *
    *                                                              *
    *         COMPRESS NO ALLOW REVERSE SCANS;                     *
    *                                                              *
    *                                                              *
    *                                                              *
    * As we can see that db2look doesn't generate the COLLECT      *
    *                                                              *
    * STATISTICS clause for CREATE INDEX DDL statement             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First Fixed in DB2 V9.7 Fixpack 4.                           *
    ****************************************************************
    

Problem conclusion

  • Please install Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC71645

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-01

  • Closed date

    2011-05-12

  • Last modified date

    2011-05-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC73619

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC71645

Modified date: 12 May 2011