PK43476: INTERNAL APAR IN ORDER TO PROVIDE GOC FIX, PK42992 IS ADB APAR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Internal APAR in order to provide GOC fix, PK42992 is ADB APAR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 ADMIN and OBJECT COMPARE TOOL users who  *
  *                 use Change Management and have tables with   *
  *                 RESTRICT ON DROP.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: During a run of a Change Management     *
  *                      (CM) change, runtime analyze is done to *
  *                      generate temporory WSL files to compare *
  *                      against the WSL files that were         *
  *                      generated during normal analyze.  The   *
  *                      problem is that runtime analyze was not *
  *                      producing statements like ALTER TABLE   *
  *                      <name> DROP RESTRICT ON DROP, which     *
  *                      results in the CM Run process reporting *
  *                      WSL differences that stopped the run of *
  *                      the change.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  CM Run incorrectly reported WSL differences when a CM change is
  run that involves an ALTER TABLE <name> DROP RESTRICT ON DROP.
  

Problem conclusion

• The problem has been fixed. The ALTER TABLE <name> DROP RESTRICT
  ON DROP statement is now included in the runtime analyze.
  

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

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK29840

     UP07/10/18 P F710

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.