PI92435: DB2 ADMIN TOOL - MISSING GRANT FOR SYSACCEL.SYSACCELERATEDPACKAGES IN TCZ

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using TCz to GRANT SELECT on IDAA tables. GRANT statements are
  generated for two tables but missing for
  SYSACCEL.SYSACCELERATEDPACKAGES, causing SQLCODE -551.
  
  SQLCCODEN551
  

Local fix

• Manually GRANT on SYSACCEL.SYSACCELERATEDPACKAGES
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool used with       *
  *                      IBM  Db2  Analytics Accelerator         *
  *                      for z/OS results in SQLCODE = -551:     *
  *                                                              *
  *                       KEYWORDS: SQLCODEN551                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A SQLCODE = -551 is due to the following GRANT statement
  missing from IBM Tools Customizer for z/OS generated job
  template ADBSETUP when the IBM  Db2  Analytics Accelerator
  for z/OS option is enabled and sub-option "GRANT ELECT ON
  TABLE TO" from panel CCQPPRD 'Product Parameters' is used:
  
  GRANT SELECT ON TABLE SYSACCEL.SYSACCELERATEDPACKAGES
    TO PUBLIC;
  

Problem conclusion

• Problem has been resolved.
  
  The following GRANT statements were also identified as missing
  and will also be generated when the IDAA option is enabled:
  
  GRANT SELECT ON TABLE SYSACCEL.SYSACCELERATEDTABLESAUTH
     TO PUBLIC;
  GRANT EXECUTE ON PROCEDURE SYSPROC.ACCEL_GET_QUERIES
     TO PUBLIC;
  GRANT EXECUTE ON PROCEDURE SYSPROC.ACCEL_GET_QUERY_DETAILS
     TO PUBLIC;
  GRANT EXECUTE ON PROCEDURE SYSPROC.ACCEL_GET_QUERY_EXPLAIN
     TO PUBLIC;
  GRANT EXECUTE ON PROCEDURE SYSPROC.ACCEL_MIGRATE
     TO PUBLIC;
  GRANT EXECUTE ON PROCEDURE SYSPROC.ACCEL_UPDATE_SOFTWARE
     TO PUBLIC;
  

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:

  UI54225 UI54226

Modules/Macros

•    ADBEDIAG ADBSETUP ADB2DSNR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI54225

     UP18/03/08 P F803

• RC10 PSY UI54226

     UP18/03/08 P F803

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.