Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 7.2.0 - Getting Started Guide

General Permissions

General Permissions

An agent needs to be able to select and run from the following SYSPROC table functions and procedures:

•
AUTH_LIST_AUTHORITIES_FOR_AUTHID (for DB2 version 9.5 or later)
•
ADMIN_CMD
•
DB_PARTITIONS
•
DB2_GET_INSTANCE_INFO (for DB2 version 9.8 or later)
•
ENV_GET_PROD_INFO
•
ENV_GET_SYS_INFO
•
ENV_GET_SYSTEM_RESOURCES (for DB2 version 9.7.0. or later)
•
PD_GET_DIAG_HIST (for DB2 version 10 or later)
•
MON_FORMAT_XML_TIMES_BY_ROW (for DB2 version 9.7.0.1 or later)
•
MON_GET_PKG_CACHE_STMT (for DB2 version 9.7.0.1 or later)
•
MON_GET_SERVICE_SUBCLASS_DETAILS (for DB2 version 9.7.0.1 or later)
•
SNAP_GET_APPL
•
SNAP_GET_APPL_INFO
•
SNAP_GET_BP
•
SNAP_GET_BP_PART
•
SNAP_GET_DB_V96_3_0, or SNAP_GET_DB (for DB2 version 10 or later)
•
SNAP_GET_DBM
•
SNAP_GET_DBM_MEMORY_POOL
•
SNAP_GET_DYN_SQL_V96_3_0, or SNAP_GET_DYN_SQL (for DB2 version 10 or later)
•
SNAP_GET_FCM_PART
•
SNAP_GET_HADR
•
SNAP_GET_LOCKWAIT
•
SNAP_GET_STMT
•
SNAP_GET_STORAGE_PATHS
•
SNAP_GET_SWITCHES
•
SNAP_GET_TAB_V96_3_0, or SNAP_GET_TAB (for DB2 version 10 or later)
•
SNAP_GET_TBSP_V96_3_0, or SNAP_GET_TBSP (for DB2 version 10 or later)
•
DB2_GET_INSTANCE_INFO (for DB2 version 7_1_00 or later)
•
MON_FORMAT_XML_TIMES_BY_ROW(for DB2 version 9.7.0.1 or later)
•
MON_FORMAT_LOCK_NAME (for DB2 version 9.7.0.1 or later)
•
MON_GET_CONNECTION (for DB2 version 9.7.0.1 or later)
•
MON_GET_UNIT_OF_WORK (for DB2 version 9.7.0.1 or later)
•
WLM_GET_SERVICE_CLASS_AGENTS_V97 (for DB2 version 9.7.0.1 or later), or WLM_GET_SERVICE_CLASS_AGENTS (for DB2 version 10 or later), or MON_GET_AGENT (for DB2 version 10.5 or later)
•
MON_GET_WORKLOAD(for DB2 version 9.7.0.1 or later)
•
MON_GET_BUFFERPOOL (for DB2 version 9.7.0.1 or later)
•
MON_GET_FCM_CONNECTION_LIST(for DB2 version 9.7.0.1 or later)
•
MON_GET_TABLESPACE(for DB2 version 9.7.0.1 or later)
•
MON_GET_TABLE(for DB2 version 9.7.0.1 or later)
•
ADMIN_GET_STORAGE_PATHS(for DB2 version 10 or later)
•
MON_GET_TRANSACTION_LOG(for DB2 version 10 or later)
•
MON_GET_DATABASE(for DB2 version 10.5 or later)
•
MON_GET_INSTANCE(for DB2 version 10.5 or later)
•
ENV_GET_DB2_SYSTEM_RESOURCES (for DB2 version 9.7.0.1 or later)
•
SNAP_GET_CONTAINER_V96_3_0(for DB2 version below 9.7), or MON_GET_CONTAINER (for DB2 version 9.7 or later)

An agent also needs to be able to select from the following SYSIBMADM administrative views:

•
DBPATHS (for version 9.7.0.1 or later)
•
REG_VARIABLES
•
BP_HITRATIO
•
DBCFG
•
ENV_INST_INFO
•
MON_LOCKWAITS (for version 9.7.0.1 or later)
•
SNAPDBM
•
SNAPFCM
•
SYSIBMADM.ENV_PROD_INFO

Permissions for DB2 pureScale Environments

In addition to the General Permissions, an agent requires permission to run the following table functions for pureScale environments:

•
MON_GET_CF
•
MON_GET_GROUP_BUFFERPOOL

An agent also needs to be able to select from the following pureScale views:

•
ENV_CF_SYS_RESOURCES
•
SNAPDB
•
SYSIBMADM.DB2_MEMBER
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating