Prerequisites for monitoring DB2 LUW Database
This section provides information about the prerequisites for monitoring DB2 LUW instances.
Permissions for monitoring DB2 LUW database
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
