Required authorities for the performance data collection user on the monitored DB2 for z/OS subsystems

Product documentation


Abstract

This document updates the IBM® InfoSphere® Optim™ Performance Manager for Linux®, UNIX®, and Windows® configuration information.

Content

For DB®2 for z/OS® subsystems, you can do the following kinds of monitoring. Each kind of monitoring requires privileges for the JDBC driver in addition to monitoring-specific privileges.

  • Health monitoring
    Health monitoring gives you an overview of the performance data for your databases. It starts automatically after the database connection is created.
  • Extended insight monitoring, SQL statements monitoring, and stored procedure monitoring
    Use these kinds of monitoring for in-depth monitoring. You must configure these kinds of monitoring before you can use them.

Privileges for the JDBC driver
To connect to the monitored DB2 for z/OS subsystem, the specified collection user must have the EXECUTE privilege on all DB2 for z/OS packages that the JDBC driver for DB2 on z/OS accesses. If the EXECUTE privileges are not granted to PUBLIC, you can use the DB2Binder utility to grant the EXECUTE privileges explicitly.

Privileges for health monitoring
To monitor the health of DB2 for z/OS subsystems and to display the data in the Health Summary dashboard, the specified collection user must have the required privileges on all of the following stored procedures.

ADMIN_COMMAND_DB2
For information about the required privileges for this stored procedure, see the Authorization section on the ADMIN_COMMAND_DB2 stored procedure page in the IBM Information Management Software for z/OS Solutions Information Center.
ADMIN_INFO_SYSLOG
For information about the required privileges for this stored procedure, see the Authorization section on the NEW DB2 FOR Z/OS STORED PROCEDURE SYSPROC.ADMIN_INFO_SYSLOG APAR page in the IBM Support Portal.
ADMIN_INFO_SYSPARM
For information about the required privileges for this stored procedure, see the Authorization section on the ADMIN_INFO_SYSPARM stored procedure page in the IBM Information Management Software for z/OS Solutions Information Center.

Privileges for extended insight monitoring, SQL statements monitoring, and stored procedure monitoring
To retrieve performance data from the OMPE Collector for extended insight monitoring, SQL statements monitoring, and stored procedure monitoring, the specified collection user must have all of the following privileges.

  • The following GRANT privileges before the monitoring is configured. These GRANT privileges can also be granted to a RACF group or ROLE to which the specified collection user can connect.
    - GRANT BINDADD
    -
    GRANT CREATEIN,ALTERIN,DROPIN ON SCHEMA OPM
    -
    GRANT DISPLAY, MONITOR1, MONITOR2
    -
    GRANT EXECUTE ON PLAN KO2PLAN
  • The privilege to connect to the DB2 for z/OS subsystem or data sharing group that you want to monitor
  • The SELECT privilege on the following tables:
    - SYSIBM.SYSCOLUMNS
    - SYSIBM.SYSPACKSTMT
    - SYSIBM.SYSROUTINES
    - SYSIBM.SYSPARMS

Related information:
Required authorities for the performance data collection user on the monitored database
DB2Binder utility
For DB2 V9: Installing the IBM Data Server Driver for JDBC and SQLJ as part of a DB2 installation
For DB2 V10: Installing the IBM Data Server Driver for JDBC and SQLJ as part of a DB2 installation
Managing authorization for stored procedures

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Optim Performance Manager

Software version:

5.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

7037032

Modified date:

2013-02-11

Translate my page

Machine Translation

Content navigation