A fix is available
APAR status
Closed as new function.
Error description
REORG PI parallel BUILD improvement for partitioning indexes when running on a table space with a single PI
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of REORG * * TABLESPACE SHRLEVEL REFERENCE or CHANGE * * utility * **************************************************************** * PROBLEM DESCRIPTION: * * Enable REORG TABLESPACE SHRLEVEL * * REFERENCE or CHANGE to build the * * partitions of the clustering * * partitioned index in parallel * * during the RELOAD phase * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR enables REORG TABLESPACE running with SHRLEVEL REFERENCE or CHANGE with data unload/reload partition parallelism to skip the sorting of the clustering partitioned index (PI) and to build the PI partitions in parallel during the RELOAD phase. The enhancement takes place when all of the following criteria are met: - REORG TABLESPACE SHRLEVEL REFERENCE or CHANGE is run on a multi-part range partitioned table space with only one clustering partitioned index defined on the table involved, with no other indexes defined - REORG is sorting the data records into clustering order with the default or specified SORTDATA YES option - Data unload/reload partition is used on the REORG with message DSNU1160I issued - REBALANCE is not specified When the above scenario is in effect, REORG will spawn off additional build tasks to perform the parallel PI build during the RELOAD phase, with potentially some index sort tasks attached but sorting zero records.
Problem conclusion
Temporary fix
Comments
Code has been modified to implement the aforementioned new function for REORG to build PI partitions in parallel. ×**** PE20/10/27 FIX IN ERROR. SEE APAR PH30979 FOR DESCRIPTION ×**** PE21/02/08 FIX IN ERROR. SEE APAR PH34284 FOR DESCRIPTION ×**** PE21/07/05 FIX IN ERROR. SEE APAR PH36695 FOR DESCRIPTION ×**** PE21/07/07 FIX IN ERROR. SEE APAR PH38725 FOR DESCRIPTION
APAR Information
APAR number
PH28092
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-07-31
Closed date
2020-09-02
Last modified date
2021-11-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71385
Modules/Macros
DSNURBXE DSNURBXD DSNURPTB DSNURKAC DSNURPRD DSNURFIT DSNURPCT DSNURPUI DSNURBXA DSNUGUTC
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI71385
UP20/09/10 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:
20 November 2021