IBM Support

PM19584: LOAD UTILITY PERFORMANCE ENHANCEMENT.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as unreproducible in next release.

Error description

  • LOAD utility performance improvement option for data that is
    presorted in clustering key order.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
    *                 utility users of LOAD and UNLOAD             *
    ****************************************************************
    * PROBLEM DESCRIPTION: New function to enable LOAD PRESORTED   *
    *                      option to tell LOAD to bypass the sort  *
    *                      of the clustering index when the input  *
    *                      data is already in clustering key order *
    *                      to improve performance                  *
    *                                                              *
    *                      New function to enable UNLOAD FORMAT    *
    *                      INTERNAL option to unload data in       *
    *                      internal format without any conversions *
    *                      to improve performance                  *
    *                                                              *
    *                      New function to enable LOAD FORMAT      *
    *                      INTERNAL option to load input data in   *
    *                      internal format without any conversions *
    *                      to improve performance                  *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    The new LOAD option, PRESORTED YES, indicates to LOAD that the
    input data is sorted in clustering key order and as a result
    the LOAD utility can skip the sort for the clustering index
    to improve the performance of the LOAD utility.
    
    The new UNLOAD option, FORMAT INTERNAL, indicates to the
    UNLOAD utility that the data should be unloaded into DB2
    internal format as is without any conversion to improve the
    performance of the UNLOAD utility.
    
    The new LOAD option, FORMAT INTERNAL, indicates to the LOAD
    utility that the data is already in DB2 internal format
    and no additional coversions are needed to load the data.
    This option provides a performance benefit for the LOAD
    utility as all conversions and data type checking are bypassed
    for an efficient load.
    

Problem conclusion

Temporary fix

Comments

  • Code has been changed to enable the new LOAD PRESORTED YES
    option and the new FORMAT INTERNAL option for both the UNLOAD
    and LOAD utilities.
    
    Please refer to flat file DSNDFINT COPY for
    documentation on the new LOAD PRESORTED option and
    UNLOAD/LOAD FORMAT INTERNAL option.  The DB2
    Utility Guide and Reference, SQL Reference, and
    Messages manuals will be updated with the
    information contained in that file.
    
    DSNDFINT contains the following information:
    -Syntax for LOAD PRESORTED and UNLOAD/LOAD FORMAT
    INTERNAL with option descriptions.
    -Updates on LOAD restartability for PRESORTED
    -Information on the FORMAT INTERNAL data format.
    -Message description for DSNU188I-DSNU192I
    -Updates to SYSIBM.SYSCOPY TTYPE for FORMAT
    INTERNAL
    
    The fix for APAR PM19584 is a companion fix. It requires the
    fix for APAR PM35284, for FMID JDB991K to be applied.
    

APAR Information

  • APAR number

    PM19584

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-30

  • Closed date

    2011-05-24

  • Last modified date

    2011-07-05

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

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

    UK68097 UK68099

Modules/Macros

  •    DSNDFINT DSNDUAR  DSNDURKA DSNDURLD DSNDURTB
    DSNDUSK  DSNDUSMF DSNDUSMS DSNDUSU  DSNDUULA DSNFMDIR DSNFUDRA
    DSNOLDEL DSNUGDDF DSNUGDDS DSNUGMST DSNUGTTF DSNUGTTS DSNUMSGA
    DSNURBXA DSNURELD DSNURILD DSNURMFL DSNURPIB DSNURUSO DSNURWBF
    DSNURWI  DSNURWIK DSNURWT  DSNURWUT DSNUSEOF DSNUULCA DSNUULGL
    DSNUULIA DSNUULXA DSNUUUFA
    

Publications Referenced
GC18984908 SC18985507 GC19297901 SC19298401  

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK68097

       UP11/06/10 P F106

  • R910 PSY UK68099

       UP11/06/10 P F106

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.



Document information

More support for: DB2 for z/OS

Software version: 910

Reference #: PM19584

Modified date: 05 July 2011


Translate this page: