PM53257: NEW OBJECT GRANT STATEMENTS NOT PROPAGATED ADB1873E PROCESSING ENDED BUT NOT ALL SUPPLIED CATROWS WERE USED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS does not propagate
  DB2 authorizations such as GRANT for new SEQUENCE objects:
  Sequence <schema>.<sequence_name> not found on target
  ADB1873E Processing ended but not all supplied catrows were used
  
    New Sequence <schema>.<sequence_name> will be added
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who run compare to apply a new          *
  *                 SEQUENCE and the authorizations on the new   *
  *                 SEQUENCE is from source to target.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool for z/OS, *
  *                      when compare shows that there is new    *
  *                      SEQUENCE object on source which does    *
  *                      not exist on target, the new            *
  *                      SEQUENCE will be added to target,       *
  *                      however, the authorizations such as     *
  *                      the GRANT for the new SEQUENCE          *
  *                      object is not propagated to target.     *
  *                      Error message ADB1873E is issued in     *
  *                      the compare step:                       *
  *                                                              *
  *                      Sequence                                *
  *                      < schema.sequence_name >                *
  *                      not found on target.                    *
  *                      ADB1873E Processing ended               *
  *                      but not all supplied catrows            *
  *                      were used.                              *
  *                      New Sequence                            *
  *                      < schema.sequence_name >                *
  *                      will be added.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Object Comparison Tool for z/OS, when compare shows
  that there is new SEQUENCE object on source which does not
  exist on target, the new SEQUENCE will be added to target,
  however, the authorizations such as the GRANT for the new
  SEQUENCE object is not propagated to target.  Error message
  ADB1873E is issued in the compare step:
  
  Sequence < schema.sequence_name > not found on target.
  ADB1873E Processing ended but not all supplied catrows were
  used.
  New Sequence < schema.sequence_name > will be added.
  

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:

  UK75075

Modules/Macros

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75075

     UP11/12/24 P F112

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.