PH72077: AOC SETUP JOB FAILS ON CREATE TRIGGER ADB_MT_CHANGE_UPDATE WITH SQLCODE = -206

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AOC setup job fails on CREATE TRIGGER ADB_MT_CHANGE_UPDATE with
  SQLCODE = -206, ERROR:  OLDROW IS NOT VALID IN THE CONTEXT WHERE
  IT IS USED. I have looked at installed APARs and I think this is
  caused by PH69910: RESTRICT INCORRECT COLUMN QUALIFIER IN CREATE
  TRIGGER UPDATE OF LIST
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Tools Customizer (TCz) setup job    *
  *                      ADBSETUP might fail on the CREATE       *
  *                      TRIGGER statement with SQLCODE -206.    *
  ****************************************************************
  The trigger definition in the ADBSETUP job used column names
  qualified by correlation names in the AFTER UPDATE OF clause
  as follows:
  AFTER UPDATE OF OLDROW.STATUS, OLDROW.OWNER, OLDROW.NAME
  With Db2 APAR PH69910, base table column names cannot specify
  qualifiers in UPDATE OF lists. The trigger definition was
  corrected to keep the OLDROW correlation name only in valid
  contexts (REFERENCING and WHEN predicate comparisons).
  

Problem conclusion

• The problem has been fixed.
  

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:

  UO08645

Modules/Macros

• ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO08645

     UP26/07/21 P F607

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.