PH13596: JULY 2019 PTF - IBM DB2 UTILITIES ENHANCEMENT TOOL FOR Z/OS (ABP)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. FL 504 DB2 v12 does not allow any
  additional syntax after INTO TABLE.
  The ABP code has to be changed to not
  put the INDDN after the 'INTO TABLE'.
  
  2. If the message monitored on the
  POLICY contains the option
  SUPPRESS="YES", duplicate
  journal entries were created.  This fix
  prevents those duplicate entries.
  
  3. Honor suppress yes when multiple
  messages are listed.
  
  4. Correct the processing of multiple
  partitions with HPU.
  Error "CONVERSION ERROR...ERROR CODE
  '14 - INPUT IS INVALID FOR DATE/TIME"
  is resolved with this fix.
  
  5. When parsing multiple Template
  statements, a S0C4 ABEND might occur.
  This was corrected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. FL 504 DB2 v12 does not allow any    *
  *                      additional syntax after INTO TABLE.     *
  *                      The ABP code has to be changed to not   *
  *                      put the INDDN after the 'INTO TABLE'.   *
  *                                                              *
  *                      2. If the message monitored on the      *
  *                      POLICY contains the option              *
  *                      SUPPRESS="YES", duplicate               *
  *                      journal entries were created.  This fix *
  *                      prevents those duplicate entries.       *
  *                                                              *
  *                      3. Honor suppress yes when multiple     *
  *                      messages are listed.                    *
  *                                                              *
  *                      4. Correct the processing of multiple   *
  *                      partitions with HPU.                    *
  *                      Error "CONVERSION ERROR...ERROR CODE    *
  *                      '14 - INPUT IS INVALID FOR DATE/TIME"   *
  *                      is resolved with this fix.              *
  *                                                              *
  *                      5. When parsing multiple Template       *
  *                      statements, a S0C4 ABEND might occur.   *
  *                      This was corrected.                     *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  .
  

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:

  UI64160

Modules/Macros

• ABPPCHCK ABPPCOPY ABPPDITB ABPPDOBJ ABPPEXEC ABPPFSPC ABPPLIST
  ABPPLOAD ABPPOPTS ABPPQUIS ABPPREBU ABPPRECO ABPPREOR ABPPRUNS
  ABPPSTMT ABPPTMPL ABPPUNLD ABPPUTLM ABPPUTLU ABPPUTLX ABPRJSQL
  ABPSINIT ABPSJSQL ABPUFSPC ABPUMAIN ABPUUTLM
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UI64160

     UP19/07/26 P F907

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.