A fix is available
APAR status
Closed as program error.
Error description
The degree of index parallelism is calculated too conservative with unload/reload parallelism and SORTDATA NO. DB2 calculates the degree of parallelism based on doing data sorts, however the REORG was run with SORTDATA NO. DB2 should not assume memory needed for large data sorts and rather spend most of the memory and assign it ot the index sorts
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All DB2 12 for z/OS REORG utility users * * using SORTDATA NO on partitioned table * * spaces with many indexes * **************************************************************** * PROBLEM DESCRIPTION: * * The degree of index sort parallelism * * may not be optimal when REORG unload/ * * reload parallelism for partitions is * * in effect with SORTDATA NO processing * * and a large number of indexes are * * defined. This could have a negative * * effect on elapsed time. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** REORG reserved memory resources for parallel data sorts which caused less memory to be assigned to parallel index sorts which could degrade the possible degree of index sort parallelism.
Problem conclusion
Code has been changed to correctly calculate needed memory resources when using SORTDATA NO with unload/reload parallelism.
Temporary fix
Comments
APAR Information
APAR number
PI80365
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-04-21
Closed date
2017-05-17
Last modified date
2017-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI47303
Modules/Macros
DSNURPCT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI47303
UP17/06/01 P F705
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":"12.0","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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 June 2017