PQ81284: VIEW QUALIFIER INVALID DURING COMPARE PROCESS, WHEN OPTION <NONE> IN USE TO SUPPRESS SET SQLID STATEMENTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Comparison Tool added an invalid qualifier to the view
  when comparing DDL against a null target.  Option <NONE>
  to suppress SET SQLID statements and KEEPTGT were in use.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL, who use DB2         *
  *                 Object Comparison Tool to compare DDL        *
  *                 against a null target, are affected.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: An invalid qualifier was added to the   *
  *                      view when comparing DDL against a null  *
  *                      target.  Option <NONE> to suppress SET  *
  *                      SQLID statements and KEEPTGT were in    *
  *                      use.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  INVALID VIEW QUALIFIER WAS ADDED DURING COMPARE PROCESS WHEN
  OPTION <NONE> WAS USED TO SUPPRESS SET SQLID STATEMENTS
  

Problem conclusion

• The reported problem for DB2 Object Comparison Tool is fixed
  in the modules ADB2PA and ADB2FMT of DB2 ADMIN TOOL.
  Problems are addressed in the area of handling names
  internally in the view, especially for embedded subselects.
  

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:

  UQ83060 UQ83061

Modules/Macros

•    ADB2FMT  ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ83060

     UP03/12/19 P F312

• R420 PSY UQ83061

     UP03/12/19 P F312

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.