PM72781: DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT GENERATE PROPER GRANT STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT GENERATE PROPER
  GRANT STATEMENT
  

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 DB2       *
  *                      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, 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 DB2 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. When DB2 Object Compare encounters
  an ADB1873E error, it will now end with return code 8 instead
  of 0.
  

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:

  UK82101

Modules/Macros

•    ADBCDTS  ADB2CMF  ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK82101

     UP12/09/27 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.