PM28081: WRONG SQL STATEMENT SET CURRENT SCHEMA='' IN CHANGE FILE GENERATED BY COMPARE JOB.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Wrong SQL statement SET CURRENT SCHEMA='' in change file
  generated by compare job.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Comparison Tool who compares *
  *                 with triggers on source and target.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: SET CURRENT SCHEMA value is set to      *
  *                      blank, before CREATE TRIGGER statement  *
  *                      in changes file ,causing sqlcode -713   *
  *                      when changes are applied.               *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  SET CURRENT SCHEMA value is set to blank, before
  CREATE TRIGGER statement in changes file ,causing
  sqlcode -713 when changes are applied.
  
  Masking did not mask sysenvironment prefix qualifier and name
  in trigger group resulting in blank value.
  

Problem conclusion

• The problem has been corrected in V72 only.
  Problem already fixed in V10.
  

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:

  UK63559

Modules/Macros

•    ADB2MSK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK63559

     UP11/01/07 P F101

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.