PI58852: DB2 ADMIN TOOL CUSTOMIZATION - NO ENTRY TO SPECIFY OWNER NAME FOR VIEW RUNSTATS ON PANEL CCQPPRD - 'PRODUCT PARAMETERS'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Admin Tool Customization doesn't provide a field to specify
  Owner name (SQLID) for creation of VIEW RUNSTATS objects on
  panel CCQPPRD - 'Product Parameters: DB2 Admin Tool'. This
  causes the SQLID used to create VIEW RUNSTATS objects and do
  related GRANT to be the same as the one used to create stored
  procedure ADB2RCP.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use IBM Tools Customizer            *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When customizing DB2 Administration     *
  *                      Tool for z/OS, IBM Tools Customizer     *
  *                      for z/OS does not provide a field to    *
  *                      specify a Owner name (SQLID) for        *
  *                      creating VIEW RUNSTATS objects,         *
  *                      creating indexes on the DB2 catalog,    *
  *                      performing a GRANT on DB2 catalog       *
  *                      tables, and handling IDAA related       *
  *                      objects on panel CCQPPRD - 'Product     *
  *                      Parameters: DB2 Admin Tool'.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When customizing DB2 Administration Tool for z/OS, IBM
  Tools Customizer for z/OS does not provide a field to
  specify the Owner name (SQLID) for creating VIEW
  RUNSTATS objects, creating indexes on the DB2 catalog,
  performing a GRANT on DB2 catalog tables, and handling
  IDAA related objects on panel CCQPPRD - 'Product Parameters:
  DB2 Admin Tool', which causes the SQLID used to create
  these objects and perform related GRANTs & handling to be
  the same as the one used to create stored procedure ADB2RCP.
  

Problem conclusion

• The problem has been resolved.
  
  The new field 'Owner' is added under the following four
  categories:  'VIEW RUNSTATS objects', 'Indexes', 'GRANT
  on DB2 Catalog Tables' and 'IDAA' on panel CCQPPRD -
  'Product Parameters: DB2 Admin Tool' to set the owner name.
  When the field 'Owner' is blank, the value specified in the
  previous field 'Default owner of Admin objects' on panel
  CCQPPRD will be used as the default value for owner name.
  
  *VIEW RUNSTATS objects  . . . . . . . . .  YES (YES, NO)
    Owner  . . . . . . . . . . .  . . . .                  >
  *Indexes  . . . . . . . . . . . . . . . .  YES (YES, NO)
    Owner  . . . . . . . . . . .  . . . . .                >
  *GRANT on DB2 Catalog Tables  . . . . YES (YES, NO)
    Owner  . . . . . . . . . . .  . . . .                  >
    TO . . . . . . . . . . . . . . . . . . . .   PUBLIC    >
  *IDAA . . . . . . . . . . . . . . . . . .  NO  (YES, NO)
    Owner  . . . . . . . . . . .  . . . . .                >
    GRANT EXECUTE ON PROCEDURE TO  . . . PUBLIC      >
    GRANT SELECT ON TABLE 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:

  UI39687 UI39688

Modules/Macros

•    ADB$$PRM ADBCUST  ADBSETUP ADB2CUST
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI39687

     UP16/08/04 P F608

• RB20 PSY UI39688

     UP16/08/04 P F608

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.