PM87844: PREFORMAT NEW FUNCTION FOR LOB ON REORG AND LAOD.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • PREFORMAT new function for LOB on REORG and LAOD.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
    *                 users of LOAD and REORG TABLESPACE utility   *
    *                 with the PREFORMAT keyword                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Enable PREFORMAT on LOB table space and *
    *                      auxiliary index during LOAD and REORG   *
    *                      AUX YES execution.                      *
    ****************************************************************
    * RECOMMENDATION: Apply PTF when available.                    *
    ****************************************************************
    Prior to this APAR, LOAD SHRLEVEL NONE and REORG AUX YES do not
    preformat the affected LOB table spaces and auxiliary indexes
    when PREFORMAT is specified.  The objective of this APAR is to
    extend the PREFORMAT option to LOB table spaces and auxiliary
    indexes serialized by these utilities.  This is done to minimize
    the performance penalty caused by formatting of LOB data pages
    during subsequent SQL operations.
    
    This APAR introduces the following changes to externals:
    
    The Utility Guide and Reference has been updated as follows:
    
    Under the REORG TABLESPACE keyword section:
    
      PREFORMAT
    
      Specifies that the remaining pages are to be preformatted up
    | to the high allocated RBA in the table space and index spaces
    | that are associated with the table space or partitions that
    | are being reorganized.  The preformatting occurs after the
      data is loaded and the indexes are built.
    
      PREFORMAT can operate on an entire table space and its index
      spaces, or on a partition of a partitioned table space and
    | its corresponding partitioning index space.  When AUX YES
    | is specified or accepted as the default, the LOB table spaces
    | and auxiliary indexes that are associated with the base
    | partitions that are being reorganized are also preformatted at
    | the end of RELOAD phase.
    
      ...
    
    Under the LOAD keyword section:
    
      PREFORMAT
    
      Specifies that the remaining pages are preformatted up to the
      high-allocated RBA in the table space and index space that
      are associated with the table that is specified in table.name.
      The preformatting occurs after the data has been loaded and
      the indexes are built.
    
      PREFORMAT can operate on an entire table space and its index
      spaces, or on a partition of a partitioned table space and on
      the corresponding partitions of partitioned indexes, if any
      exist.  Specifying LOAD PREFORMAT (rather than PART integer
      PREFORMAT) tells LOAD to serialize at the table space level,
      which can inhibit concurrent processing of separate
      partitions.  If you want to serialize at the partition level,
      specify PART integer PREFORMAT.  See "Option descriptions for
      INTO TABLE" for information about specifying PREFORMAT at the
      partition level.
    
    | The PREFORMAT keyword also applies to LOB table spaces and
    | auxiliary indexes that are associated with the base table or
    | partitions that LOAD serialized.  XML objects are not
    | preformatted.
    

Problem conclusion

Temporary fix

Comments

  • Code has been modified to extend the data set preformats to
    LOB table spaces and auxiliary indexes in LOAD SHRLEVEL NONE
    and REORG AUX YES execution with PREFORMAT.
    

APAR Information

  • APAR number

    PM87844

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-25

  • Closed date

    2013-08-20

  • Last modified date

    2013-10-03

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

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

    UK96871 UK96872

Modules/Macros

  •    DSNURWI  DSNURWT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK96871

       UP13/09/05 P F309

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 #:

PM87844

Modified date:

2013-10-03

Translate my page

Machine Translation

Content navigation