PK91283: REORDERING EXCEPTION PROFILES WITH REALTIME STATS CAUSES OBJECTS TO NOT TRIGGER IN DB2 AUTOMATION TOOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Reordering the sequence of Exception Profiles with RealTime
  Statistics (RTS) Exceptions in Jobs Profiles may cause Objects
  that Trigger in one sequence to not Trigger in another sequence.
  
  The type of RTS Exceptions need to be different in each of the
  Exception Profiles and the Exceptions Profiles must be processed
  'One At A Time' for this error to occur.
  
  For example, one Exceptions Profile might specify
  * TABLESPACESTATS.TOTALROWS and
  * a second Exceptions Profile might specify
    REALTIME REORG TS.INS_UPD_DEL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Reordering the sequence of Exception    *
  *                      Profiles with RealTime Statistics (RTS) *
  *                      Exceptions in Jobs Profiles may cause   *
  *                      Objects that Trigger in one sequence    *
  *                      to not Trigger in another sequence.     *
  *                      The type of RTS Exceptions need to be   *
  *                      different in each of the Exception      *
  *                      Profiles and the Exceptions Profiles    *
  *                      must be processed 'One At A Time' for   *
  *                      this error to occur. For example, one   *
  *                      Exceptions Profile might specify        *
  *                      * TABLESPACESTATS.TOTALROWS and         *
  *                      * a second Exceptions Profile might     *
  *                        specify REALTIME REORG                *
  *                        TS.INS_UPD_DEL.                       *
  ****************************************************************
  * 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:

  UK49144

Modules/Macros

• HAA#ERTI
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK49144

     UP09/08/13 P F908

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.