A fix is available
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
GC18984908 | SC18985507 | GC19297901 | SC19298401 |
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 July 2011