PM67504: DB2 OBJECT COMPARISON TOOL FOR Z/OS FAILS TO ALTER TRIGGERS WITH PROPER TIMESTAMP SEQUENCE,ENSURE PROPER EXEC SEQ FFA20 PM73422

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS fails to ALTER TRIGGERs with
  proper timestamp sequence to ensure proper execution sequence
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare DB2 triggers that       *
  *                 have the same triggering SQL operation       *
  *                 and activation time.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A DROP/CREATE of a DB2 trigger that     *
  *                      has the same triggering SQL operation   *
  *                      and activation time as other triggers   *
  *                      will be invoked out of order if it      *
  *                      was not originally invoked last.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A DROP/CREATE of a DB2 trigger that has the same triggering SQL
  operation and activation time as other triggers can fail
  because it is invoked out of order.
  

Problem conclusion

• The DB2 Object Comparison Tool has been corrected to maintain
  the invocation order of DB2 triggers that have the same
  triggering SQL operation and activation time.  Note that if a
  new trigger is being added to an existing set of triggers
  with the same triggering SQL operation and activation time,
  at least one of the existing triggers is needed in the source
  to establish a position for the new trigger. If the new
  trigger needs to be positioned last, no existing trigger is
  required.
  

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:

Modules/Macros

•    ADBCDTS  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81227

     UP12/08/24 P F208

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.