A fix is available
APAR status
Closed as program error.
Error description
The following issues are addressed in this APAR: 1) For DB2 versions below V10, specifying Group Partition By (GPB) = "S" or "J" with LISTDEF results in message HAAB377I being displayed at job build time. HAAB377I should not be displayed since LISTDEF does not support more than one PARTLEVEL number. New message HAAB366W will be displayed instead (HAB366W Group Parts By for REORG TS turned off because DB2 Vnn LISTDEF does not support more than one PARTLEVEL number. LISTDEF overrides grouping of partitioned objects). . 2) For DB2 versions below V10, specifying Group Partition By (GPB) = "S" or "J" with Process Dependent Indexes = "N" and LISTDEF = "N" results in: a) display of message HAAB377I at job build time. b) multiple REORG TABLESPACE control statements, which causes multiple REORG of NPIs. . The fix will produce a single REORG TABLESPACE control statement and NPI reorg will be minimized. Message HAAB377I will be displayed and the single REORG TS control statement will support that message.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Automation Tool. * **************************************************************** * PROBLEM DESCRIPTION: 1. For DB2 versions below V10, * * specifying Group Partition By (GPB) = * * "S" or "J" with LISTDEF results in * * message HAAB377I being displayed at * * job build time. HAAB377I should not be * * displayed since LISTDEF does not * * support more than one PARTLEVEL number. * * New message HAAB366W will be displayed * * instead (HAB366W Group Parts By for * * REORG TS turned off because DB2 Vnn * * LISTDEF does not support more than one * * PARTLEVEL number. LISTDEF overrides * * grouping of partitioned objects). * * 2. For DB2 versions below V10, * * specifying Group Partition By (GPB) = * * "S" or "J" with Process Dependent * * Indexes = "N" and LISTDEF = "N" * * results in: * * a. display of message HAAB377I at job * * build time. * * b. multiple REORG TABLESPACE control * * statements, which causes multiple * * REORG of NPIs. * * The fix will produce a single REORG * * TABLESPACE control statement and NPI * * reorg will be minimized. Message * * HAAB377I will be displayed and the * * single REORG TS control statement will * * support that message. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM86933
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-12
Closed date
2013-04-22
Last modified date
2013-05-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
HAA$BMSG HAA$BUTR HAA#BPRI HAAGGCJ
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
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":"SSAUWB","label":"IBM Db2 Automation Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.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":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
12 February 2021