PM71055: IBM INTERNAL APAR FOR OC V720 - PM67393 - OBJECT COMP - GRANT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect GRANT UPDATE(column-name) ON TABLE statement and
  ADB1873E from Compare when target is from DDL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare source DDL to target    *
  *                 DDL which contain GRANT                      *
  *                 UPDATE(column-name,...) or                   *
  *                 GRANT REFERENCES(column-name,...)            *
  *                 statement on the table or view.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for      *
  *                      z/OS generates an incorrect GRANT       *
  *                      UPDATE statement in the APPLY job       *
  *                      or Work Statement List (WSL) when       *
  *                      comparing source DDL and target DDL     *
  *                      containing GRANT                        *
  *                      UPDATE(column-name,...) statement       *
  *                      on a table or view. The correct         *
  *                      GRANT statement should be:              *
  *                                                              *
  *                      GRANT UPDATE(column-name,...)           *
  *                      on TABLE <table-name>/                  *
  *                      >view-name< to >authorization-name<.    *
  *                                                              *
  *                      However, DB2 Object Compare             *
  *                      generates the following statement       *
  *                      with missing column information.        *
  *                                                              *
  *                      GRANT UPDATE() on TABLE                 *
  *                      >table-name</>view-name< to             *
  *                      >authorization-name<.                   *
  *                                                              *
  *                      In the comparison report, there is      *
  *                      an ADB1873E error message displayed     *
  *                      for the table comparison, but Object    *
  *                      Compare still ends with return code 0.  *
  *                                                              *
  *                      ADB1873E Processing ended but not all   *
  *                      supplied catrows were used              *
  *                                                              *
  *                      The same problem exists when the DDL    *
  *                      being compared contains the GRANT       *
  *                      REFERENCES(column-name,...)             *
  *                      statement.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool for z/OS generates an incorrect
  GRANT UPDATE statement in the APPLY job or Work Statement
  List (WSL) when comparing source DDL and target DDL containing
  GRANT UPDATE(column-name,...) statement on a table or view. The
  correct GRANT statement should be:
  
  GRANT UPDATE(column-name,...) on TABLE <table-name>/>view-name<
  to >authorization-name<.
  
  However, Object Compare generates the following statement with
  missing column information.
  
  GRANT UPDATE() on TABLE >table-name</>view-name< to
  >authorization-name<.
  
  In the comparison report, there is an ADB1873E error message
  displayed for the table comparison, but Object Compare still
  ends with return code 0.
  
  ADB1873E Processing ended but not all supplied catrows
  were used
  
  The same problem exists when the DDL being compared contains
  the GRANT REFERENCES(column-name,...) statement.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK81673

Modules/Macros

•    GOC2CMF  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK81673

     UP12/09/12 P F209

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.