PK76689: NEW OPTION TO EXCLUDE SQL UPDATES CAUSED BY A TRIGGER FOR DROPPED OBJECT RESTORE WITH SQL LOG APPLY

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ALA 3.1 added the ability to exclude SQL that was the result of
  a trigger from its SQL generation.  We needed to expose this
  option in object restore. A new option has been added to "User
  Recovery Options" called "Exclude Trigger Caused SQL". The
  default is for this option to be NOT selected (and we will
  apply SQL caused by triggers which is what it has always done).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALA 3.1 added the ability to exclude    *
  *                      SQL that was the result of a trigger    *
  *                      from its SQL generation.  We needed to  *
  *                      expose this option in object restore.   *
  *                      A new option has been added to "User    *
  *                      Recovery Options" called "Exclude       *
  *                      Trigger Caused SQL". The default is     *
  *                      for this option to be NOT selected      *
  *                      (and we will apply SQL caused by        *
  *                      triggers which is what it has always    *
  *                      done).                                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

•    AUOLJCL
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UK42902

     UP09/01/10 P F901

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.