PM93265: MODIFY STATISTICS TABLESPACE DOES NOT REMOVE ROWS FROM SYSIBM.SYSCOLDIST_HIST

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • MODIFY STATISTICS TABLESPACE does not remove rows in
    SYSIBM.SYCOLDIST_HIST, only a MODIFY STATISTICS INDEX will.
    However, the tablespace in question does not have an index.
    

Local fix

  • Use SQL DELETE to remove the unneeded rows.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 9 for z/OS and DB2 10 for z/OS users     *
    *                 running MODIFY STATISTICS utility to delete  *
    *                 statistics history records for a table space *
    ****************************************************************
    * PROBLEM DESCRIPTION: MODIFY STATISTICS TABLESPACE does not   *
    *                      delete records from DB2 catalog table   *
    *                      SYSIBM.SYSCOLDIST_HIST                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    MODIFY STATISTICS TABLESPACE does not delete records from
    DB2 catalog table SYSIBM.SYSCOLDIST_HIST. Those records are only
    deleted by MODIFY STATISTICS INDEXSPACE and MODIFY STATISTICS
    INDEX. However, if no index exists for the table in the table
    space MODIFY STATISTICS INDEXSPACE and MODIFY STATISTICS INDEX
    cannot be run and therefore the records cannot be deleted.
    

Problem conclusion

  • MODIFY STATISTICS TABLESPACE has been modified to delete records
    from table SYSIBM.SYSCOLDIST_HIST if DELETE ALL or ACCESSPATH is
    specified.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM93265

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-17

  • Closed date

    2013-09-22

  • Last modified date

    2013-11-04

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

    PM03263

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

    UK97780 UK97781

Modules/Macros

  • DSNUMSTA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK97780

       UP13/10/08 P F310

  • R910 PSY UK97781

       UP13/10/08 P F310

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM93265

Modified date:

2013-11-04

Translate my page

Machine Translation

Content navigation