PM76873: REORG TABLESPACE DISCARD FROM TABLE WHEN ON TABLE WITH LOB COLUMN LEAVES BASE TABLE SPACE IN ACHKP

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • REORG TABLESPACE DISCARD FROM TABLE WHEN on table with LOB
    column leaves the base table space in Advisory Check Pending
    (ACHKP)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
    *                 utility users of REORG TABLESPACE DISCARD    *
    *                 WHEN on a table with a LOB column            *
    ****************************************************************
    * PROBLEM DESCRIPTION: REORG TABLESPACE DISCARD WHEN leaves    *
    *                      the base table space in ACHKP status    *
    *                      when the table contains a LOB column    *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    REORG TABLESPACE DISCARD WHEN of a table containing a LOB
    column leaves the base table space in Auxillary CHecK Pending
    (ACHKP) and ends with RC4.  As the REORG will discard rows from
    the base table, it will not discard the associated LOB(s).  As
    these 'orphaned' LOBs do not hurt anything, ACHKP is too
    restrictive a state to place the base table in.
    

Problem conclusion

  • REORG TABLESPACE DISCARD WHEN has been changed to not leave the
    base table space in ACHKP and not set RC4 because of this,
    although the REORG might still end with RC4 for other reason(s).
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM76873

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-10

  • Closed date

    2013-02-12

  • Last modified date

    2013-03-04

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

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

    UK91603 UK91604

Modules/Macros

  •    DSNURWBF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91603

       UP13/02/28 P F302

  • R910 PSY UK91604

       UP13/02/28 P F302

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:

A10

Reference #:

PM76873

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation