IBM Support

IC74811: RUNSTATS USE PROFILE IGNORES FREQUENCY AND QUANTILE OPTIONS OF THE DISTRIBUTION CLAUSE WHEN "ON ALL COLUMNS" IS ALSO SPECIFIED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a statistics profile exists for a table which specifies
    frequency and/or quantile options that are different from the
    defaults, and the profile also specifies "ON ALL COLUMNS" in the
    Distribution Clause, RUNSTATS USE PROFILE ignores the specified
    frequency and quantile options and uses the defaults.
    

Local fix

  • When creating the profile, specify the Distribution Clause in
    the profile using explicit column specifications for each column
    of the table, without using "ON ALL COLUMNS".
    
    For example, table P73903.T1 has 4 columns and it is desired to
    have a profile where one column has distribution options that
    are different from default NUM_FREQVALUES 10 and default
    NUM_QUANTILES 20.
    
    Instead of:
    RUNSTATS ON TABLE P73903.T1 WITH DISTRIBUTION ON ALL COLUMNS AND
    COLUMNS (c2 NUM_FREQVALUES 25 NUM_QUANTILES 50) AND SAMPLED
    DETAILED INDEXES ALL SET PROFILE
    
    Specify:
    RUNSTATS ON TABLE P73903.T1 WITH DISTRIBUTION ON COLUMNS (c2
    NUM_FREQVALUES 25 NUM_QUANTILES 50, c1, c3, c4) AND SAMPLED
    DETAILED INDEXES ALL SET PROFILE
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When a statistics profile exists for a table which specifies *
    * frequency and/or quantile options that are different from    *
    * the defaults, and the profile also specifies "ON ALL         *
    * COLUMNS" in the Distribution Clause, RUNSTATS USE PROFILE    *
    * ignores the specified frequency and quantile options and     *
    * uses the defaults.                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Version 9.7 Fix Pack 5                             *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74811

  • 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

    2011-03-03

  • Closed date

    2012-01-17

  • Last modified date

    2012-01-17

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

    IZ95860

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74811

Modified date: 17 January 2012