Prerequisites for monitoring DB2 LUW Database
This section provides information about the prerequisites for monitoring DB2 LUW instances.
Permissions for monitoring DB2 LUW database
Foglight for DB2 uses the DataDirect JDBC driver. Before monitoring a DB2 instance, the required DataDirect packages must be installed on the monitored database. On the first connection attempt, Foglight automatically installs these packages if the connecting user has the required BINDADD privilege (or DBADM authority that includes BINDADD). If the required privileges are not available, a database administrator must install the packages manually before monitoring can begin.
Set Account Privileges on:
- SYSMON authority
Grant Select privilege on:
- SYSCAT.COLUMNS
- SYSCAT.ROUTINES
- SYSCAT.VIEWS
- SYSIBMADM.PRIVILEGES
- SYSIBMADM.SNAPADM
- SYSIBM.SYSDUMMY1
- SYSIBM.SYSPLAN
Grant Execute on:
- AUTH_LIST_AUTHORITIES_FOR_AUTHID
Required Monitor Switches
| Monitor switches for version 9.7 | Monitoring parameters for version 9.7.0.5 or above |
|---|---|
| UOW | MON_REQ_METRICS |
| STATEMENT | MON_ACT_METRICS |
| LOCK | MON_OBJ_METRICS |
| SORT TABLE BUFFERPOOL TIMESTAMP |
Monitoring parameters for version 9.7.0.5 or above should be set to at least the base level.
Following are the permissions required to monitor all versions of DB2 LUW database:
| General |
|---|
| ADMIN_CMD |
| ENV_GET_PROD_INFO |
| DB_PARTITIONS |
| ENV_GET_SYS_INFO |
| SNAP_GET_APPL_INFO |
| SNAP_GET_BP |
| SNAP_GET_APPL |
| SNAP_GET_BP_PART |
| SNAP_GET_DBM |
| SNAP_GET_HADR |
| SNAP_GET_DBM_MEMORY_POOL |
| SNAP_GET_FCM_PART |
| SNAP_GET_STMT |
| SNAP_GET_LOCKWAIT |
| SNAP_GET_SWITCHES |
| SNAP_GET_STORAGE_PATHS |
| PD_GET_DIAG_HIST |
Following are the version-specific permissions required to monitor a DB2 LUW database:
| 9.7.0.5 | 10.1 |
|---|---|
| ENV_GET_SYSTEM_RESOURCES | ENV_GET_SYSTEM_RESOURCES |
| MON_GET_PKG_CACHE_STMT | MON_GET_PKG_CACHE_STMT |
| MON_FORMAT_LOCK_NAME | MON_FORMAT_LOCK_NAME |
| WLM_GET_SERVICE_CLASS_AGENTS_V97 | WLM_GET_SERVICE_CLASS_AGENTS |
| MON_GET_WORKLOAD | MON_GET_WORKLOAD |
| MON_GET_TABLESPACE | MON_GET_TABLESPACE |
| ENV_GET_DB2_SYSTEM_RESOURCES | ENV_GET_DB2_SYSTEM_RESOURCES |
| MON_GET_SERVICE_SUBCLASS_DETAILS | MON_GET_SERVICE_SUBCLASS_DETAILS |
| MON_FORMAT_XML_TIMES_BY_ROW | MON_FORMAT_XML_TIMES_BY_ROW |
| MON_GET_UNIT_OF_WORK | MON_GET_UNIT_OF_WORK |
| MON_GET_BUFFERPOOL | MON_GET_BUFFERPOOL |
| MON_GET_TABLE | MON_GET_TABLE |
| MON_GET_CONTAINER | MON_GET_CONTAINER |
| MON_GET_FCM_CONNECTION_LIST | MON_GET_FCM_CONNECTION_LIST |
| MON_GET_CONNECTION | MON_GET_CONNECTION MON_GET_MEMORY_POOL MON_GET_MEMORY_SET |
| SNAP_GET_TBSP_V91 | SNAP_GET_TBSP |
| SNAP_GET_DB_V91 | MON_GET_TRANSACTION_LOG SNAP_GET_DB DB2_GET_INSTANCE_INFO ADMIN_GET_STORAGE_PATHS |
Following are the permissions required to monitor DB2 LUW database version 10.5 and later:
| 10.5 and later |
|---|
| ENV_GET_SYSTEM_RESOURCES |
| MON_GET_INSTANCE |
| MON_FORMAT_LOCK_NAME |
| MON_GET_PKG_CACHE_STMT |
| MON_GET_AGENT |
| MON_GET_WORKLOAD |
| ENV_GET_DB2_SYSTEM_RESOURCES |
| MON_GET_DATABASE |
| ADMIN_GET_STORAGE_PATHS |
| DB2_GET_INSTANCE_INFO |
| MON_GET_TRANSACTION_LOG |
| MON_GET_CONNECTION |
| MON_GET_FCM_CONNECTION_LIST |
| MON_GET_CONTAINER |
| MON_GET_TABLE |
| MON_GET_BUFFERPOOL |
| MON_GET_UNIT_OF_WORK |
| MON_FORMAT_XML_TIMES_BY_ROW |
| MON_GET_SERVICE_SUBCLASS_DETAILS |
| MON_GET_TABLESPACE |
| MON_GET_MEMORY_POOL |
| MON_GET_MEMORY_SET |
Grant Select on these SYSIBMADM administrative views:
- DBPATHS (For DB2 version 9.7.0.5 or later)
- REG_VARIABLES
- BP_HITRATIO
- DBCFG
- MON_LOCKWAITS (For DB2 version 9.7.0.5 or later)
- SNAPDBM
- SNAPFCM
- SYSIBMADM.ENV_PROD_INFO
PureScale environments
Grant Execute on to these table functions:
- MON_GET_CF
- MON_GET_GROUP_BUFFERPOOL
- BP_HITRATIO
Grant Select on these views:
- ENV_CF_SYS_RESOURCES
- SNAPDB
- SYSIBMADM.DB2_MEMBER
