IBM Support

LI76423: CANNOT SET EXCLUDE XML COLUMNS CLAUSE IN STATISTICS PROFILE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When running runstats
    on the command line with the Exclude XML Columns clause, it
    works
    perfectly.  However, when the stats profile is set with that
    clause,
    the stats profile ignores it and stores a runstats command for
    ALL
    columns and ALL indexes.
    
    ex:
    
    RUNSTATS ON TABLE sahana12.test2 with distribution on key
    columns and detailed indexes all excluding xml columns set
    profile
    DB20000I  The RUNSTATS command completed successfully.
    
    select substr(statistics_profile, 1, 150) as statistics_profile
    from syscat.tables where tabname='TEST2'
    
    STATISTICS_PROFILE
    ----------------------------------------------------------------
    ------------------------------------
    
    RUNSTATS ON TABLE "SAHANA12"."TEST2" ON ALL COLUMNS WITH
    DISTRIBUTION ON KEY COLUMNS AND DETAILED INDEXES ALL
    
      1 record(s) selected.
    
    
    In the above we see that external statiscs_profile does not
    contain clause 'EXCLUDING XML COLUMN'.
    This problem is only with external statistics_profile storage,
    however when the command is executed runstats does not collect
    statistics on xml columns when 'excluding xml column' option is
    specified.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 9.5 FP8                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When running runstats                                        *
    * on the command line with the Exclude XML Columns clause, it  *
    * works                                                        *
    * perfectly.  However, when the stats profile is set with that *
    * clause,                                                      *
    * the stats profile ignores it and stores a runstats command   *
    * for                                                          *
    * ALL                                                          *
    * columns and ALL indexes.                                     *
    *                                                              *
    * ex:                                                          *
    *                                                              *
    * RUNSTATS ON TABLE sahana12.test2 with distribution on key    *
    * columns and detailed indexes all excluding xml columns set   *
    * profile                                                      *
    * DB20000I  The RUNSTATS command completed successfully.       *
    *                                                              *
    * select substr(statistics_profile, 1, 150) as                 *
    * statistics_profile                                           *
    * from syscat.tables where tabname='TEST2'                     *
    *                                                              *
    * STATISTICS_PROFILE                                           *
    * ------------------------------------------------------------ *
    * ----                                                         *
    * ------------------------------------                         *
    *                                                              *
    * RUNSTATS ON TABLE "SAHANA12"."TEST2" ON ALL COLUMNS WITH     *
    * DISTRIBUTION ON KEY COLUMNS AND DETAILED INDEXES ALL         *
    *                                                              *
    *   1 record(s) selected.                                      *
    *                                                              *
    *                                                              *
    * In the above we see that external statiscs_profile does not  *
    * contain clause 'EXCLUDING XML COLUMN'.                       *
    * This problem is only with external statistics_profile        *
    * storage,                                                     *
    * however when the command is executed runstats does not       *
    * collect                                                      *
    * statistics on xml columns when 'excluding xml column' option *
    * is                                                           *
    * specified.                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.5 FP9                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    LI76423

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-26

  • Closed date

    2013-10-03

  • Last modified date

    2013-10-03

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

    LI76075

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

Fix information

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 October 2013