This document updates the IBM® InfoSphere® Optim™ Performance Manager for Linux®, UNIX®, and Windows® configuration information.
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.
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.
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.
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:
Required authorities for the performance data collection user on the monitored database
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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.