PM19584: LOAD UTILITY PERFORMANCE ENHANCEMENT.

Obtain the fix for this APAR.

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

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.