IC72375: ERROR 747 RETURNED ON A REMOTE DDL STATEMENT AFTER RUNNING SPL THAT EXECUTES TRIGGERS ON THE SAME TABLE.

APAR status

• Closed as program error.

Error description

• After successfully running a stored procedure which executes a
  SQL statement that has triggers on the same table, any
  subsequent DDL on the same table will return error 747 -  Table
  or column matches object referenced in triggering statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users on secondary                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A remote update executed from a secondary node on a table    *
  * with trigger runs into an error.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please upgrade to 11.50.xC9 when avaiable.                   *
  ****************************************************************
  

Problem conclusion

• Problem is first fixed in 11.50.xC9.
  

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:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP