PI38277: ROLLUP APAR #3

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  1. HAA#AUTO fails with an SQL error = -530 when selecting a
   SYMPTOM_REGISTRY key for an MVS CATALOG Exception.
  2. A U107 ABEND can occur when one exception profile points to
   another via either the Accepted or Rejected Exception Rule and
   NEITHER of the Exception Rules point to a utility profile.
  3. Jobs update display cannot tolerate user sorting. This fix
   prevents sorting of all fields on the JPRU panel.
  4. Abend S0C9 occurs in module HAA#ECDS for a LOB object whose
   underlying VSAM file has been migrated.
  5. Using different utility type profiles for Excp Rule in a job
   profile causes a S0C4 abend in build job.  The abend occurs in
   module HAA$EXCP (offset 0001C1DE). The job ends with condition
   code 0990.
  6. Message HAAM208I does not always get displayed when
   cancelling a profile update or ending (PF3) an update when no
   changes were made to the profile.
  7. "WTO number of triggered Objects" value (panel HAA$EPRU)
   doesn't get saved when updated via job profile.
  8. Exception Profile can become corrupted by unselecting a
   previously-selected exception condition.
  9. Building a V4.1 Job Profile that has a Job Option override
   value specified for "Exp IXs w/DEFN NO TSs" on the HAA$JOVR
   panel does not correctly get populated to V4.2 causing the
   generated JCL to be incorrect.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following       *
  *                      issues:                                 *
  *                      1. HAA#AUTO fails with an SQL error =   *
  *                       -530 when selecting a SYMPTOM_REGISTRY *
  *                       key for an MVS CATALOG Exception.      *
  *                      2. A U107 ABEND can occur when one      *
  *                       exception profile points to another    *
  *                       via either the Accepted or Rejected    *
  *                       Exception Rule and NEITHER of the      *
  *                       Exception Rules point to a utility     *
  *                       profile.                               *
  *                      3. Jobs update display cannot tolerate  *
  *                       user sorting. This fix prevents        *
  *                       sorting of all fields on the JPRU      *
  *                       panel.                                 *
  *                      4. Abend S0C9 occurs in module          *
  *                       HAA#ECDS for a LOB object whose        *
  *                       underlying VSAM file has been          *
  *                       migrated.                              *
  *                      5. Using different utility type         *
  *                       profiles for Excp Rule in a job        *
  *                       profile causes a S0C4 abend in build   *
  *                       job.  The abend occurs in module       *
  *                       HAA$EXCP (offset 0001C1DE). The job    *
  *                       ends with condition code 0990.         *
  *                      6. Message HAAM208I does not always     *
  *                       get displayed when cancelling a        *
  *                       profile update or ending (PF3) an      *
  *                       update when no changes were made to    *
  *                       the profile.                           *
  *                      7. "WTO number of triggered Objects"    *
  *                       value (panel HAA$EPRU) doesn't get     *
  *                       saved when updated via job profile.    *
  *                      8. Exception Profile can become         *
  *                       corrupted by unselecting a             *
  *                       previously-selected exception          *
  *                       condition.                             *
  *                      9. Building a V4.1 Job Profile that     *
  *                       has a Job Option override value        *
  *                       specified for "Exp IXs w/DEFN NO TSs"  *
  *                       on the HAA$JOVR panel does not         *
  *                       correctly get populated to V4.2        *
  *                       causing the generated JCL to be        *
  *                       incorrect.                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI27563

Modules/Macros

• HAA$ATRH HAA$BPRD HAA$BULD HAA$CALL HAA$CVT
  HAA$DCVT HAA$DLCR HAA$EPRD HAA$EPRU HAA$ETRG HAA$EXCP HAA$JOPT
  HAA$JPRU HAA$MAIN HAA$OPRD HAA$OPRU HAA$SINF HAA$UOPT HAA$UPRD
  HAA#AUTO HAA#ECDS HAA#EPRI HAA#JPRI HAA#OBEX HAA@SYMR HAAHJOBV
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R420 PSY UI27563

     UP15/05/20 P F505

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.