A fix is available
APAR status
Closed as new function.
Error description
REORG DFSORT improvement
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of REORG * * TABLESPACE utility with DFSORT * **************************************************************** * PROBLEM DESCRIPTION: * * New function support for REORG * * TABLESPACE utility to invoke DFSORT * * using the IBM Integrated Accelerator * * for Z Sort feature * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR introduces the Db2 REORG TABLESPACE utility support to invoke DFSORT with the IBM Integrated Accelerator for Z Sort feature available in the latest z15 main frame hardware and above. This APAR enhancement is only applicable to the variable length data sort of the REORG TABLESPACE utility when the data records of the target table space are being sorted. This feature improves the CPU and elapsed time in the sort processing by DFSORT utilizing more in-memory sorting. Before this feature can be enabled on the Db2 REORG utility, user needs to apply DFSORT APAR PH03207 and enable the DFSORT Z Sort processing. Please refer to the following link for further information on this DFSORT APAR: https://www.ibm.com/support/pages/node/665449 After the Z Sort feature is enabled on DFSORT side, user would also need to enable the new Db2 subsystem parameter, UTILS_USE_ZSORT, introduced by this APAR to allow REORG TABLESPACE utility to take advantage of the DFSORT Z Sort processing. This new subsystem parameter is added to DSN6SPRM, and it is defaulted to NO. Note that while this subsystem parameter is defined generically for all utility usage, only the data sort of the REORG TABLESPACE utility is affected by this subsystem parameter at the time of this APAR. The UTILS_USE_ZSORT subsystem parameter specifies whether Db2 utilities use the IBM Integrated Accelerator for Z Sort interface when invoking DFSORT for utility processing. However, the use of the integrated sort acceleration depends on other run-time variables and hardware. The following values are supported: NO Db2 utilities do not use integrated sort acceleration when invoking DFSORT. YES Db2 utilities attempt to use the integrated sort acceleration if possible when invoking DFSORT.
Problem conclusion
Temporary fix
Comments
Code is modified to support the aforementioned new function.
APAR Information
APAR number
PH28183
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-04
Closed date
2020-09-21
Last modified date
2020-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71668
Modules/Macros
DSNTINMF DSNDQWPZ DSNWZIFC DSNTIDXA DSNTIVMD DSNTIJUZ DSNTINST DSNTIDXC DSNTIWIA DSNTIDXB DSNTIVIA DSNTIWMD DSNUGBAC DSNTIWIE DSNTIVIE DSNUGSRT DSN@XAZP DSNUGSRP DSN6SPRM DSNURSCN DSNTXAZP DSNTIWPC DSNTIP63 DSNDSPRM DSNUGRAR DSNTIVMN DSNURWI DSNTIWMN DSNTIVAF DSNTIVIN DSNTIWMS DSNTIVMS DSNTIWAF DSNTIWIN DSNUGUCA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI71668
UP20/09/24 P F009
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]
Document Information
Modified date:
05 October 2020