PM88566: DB2 OBJECT COMPARISON TOOL FOR Z/OS GENERATES WRONG GRANT, CAUSING SQLCODE=-554 ERROR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS GENERATES WRONG GRANT IN APP
  LY JOB, RESULTING IN AN SQLCODE=-554 ERROR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration and DB2      *
  *                 Object Comparison Tool for z/OS who run      *
  *                 Compare, ALT 'Alter Table ALT', or Change    *
  *                 Management to generate an APPLY job which    *
  *                 contains GRANT statements.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT, Compare or Change   *
  *                      Management function to generate an      *
  *                      APPLY job, if option 'Run SQLID' is     *
  *                      set to 'SQLID', the SQLID is applied    *
  *                      to the DDL statements and the GRANT     *
  *                      statements in the APPLY jobs.  This     *
  *                      may cause problems because the SQLID    *
  *                      used to create the objects may not      *
  *                      be a security ID that should be used    *
  *                      as the grantor.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT, Compare or Change Management function to
  generate an APPLY job, if option 'Run SQLID'is set to 'SQLID',
  the SQLID is applied to the DDL statements and the GRANT
  statements in the APPLY jobs. This may cause problems because
  the SQLID used to create the objects may not be a security ID
  that should be used as the grantor.
  

Problem conclusion

• A new option 'Object Grantor' is now available on panel GOC5
  'Generate Compare Jobs' for Compare, ALT and Change Management
  functions to allow a choice on the SQLID to be used by the
  GRANT statements in the generated APPLY jobs.  This option
  works in conjunction with the 'Run SQLID' option:
  
  1. When a SQLID is specified for 'Object Grantor' and 'Run
  SQLID' is not specified as '>NONE<', then a SET CURRENT SQLID
  statement will be generated prior to each GRANT statement in
  the APPLY jobs, using the SQLID specified at the 'Object
  Grantor' field.
  
  2. When 'Run SQLID' is specified as '>NONE<', no SET
  CURRENT SQLID statement will be generated prior to the
  GRANT statements even if 'Object Grantor' is specified
  with a SQLID.
  
  3. When 'Run SQLID' is specified with a SQLID and 'Object
  Grantor' is blank, the SQLID set at 'Run SQLID' field will
  also be applied to the GRANT statements in the APPLY jobs.
  
  4. When 'Run SQLID' and 'Object Grantor' both blank, SET
  CURRENT SQLID statements will be generated as necessary.
  
  A new column GRTSQLID needs to be added to the Change
  Management table ADBCHG.
  
  For users of DB2 Administration Tool and Object Comparison
  Tool Version 10.1,  please modify the SADBSAMP member
  ADBCHG05 and submit the job to add this column.
  
  For users of DB2 Administration Tool and Object Comparison
  Tool Version 10.2,  please modify the SADBSAMP member
  ADBCHG04 and submit the job to add this column.
  
  Failure to add this column will cause a SQLCODEN206 /
  SQLCODE=-206 during Analyze.
  

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:

  UK97934 UK97936

Modules/Macros

• GOCCMP   GOCCM2   GOCGCMP  GOC5     GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA10 PSY UK97934

     UP13/09/28 P F309

• RA20 PSY UK97936

     UP13/09/28 P F309

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.