Chat now with support
Chat with Support

We are aware of the intermittent issues with the support portal and are working to resolve them as quickly as possible. If you need assistance with opening a support case, please call support:1 (800) 306-9329 or (949) 754-8000

Foglight for DB2 (Cartridge) 5.9.3.10 - 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.1 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_V91, or SNAP_GET_DB (for DB2 version 10 or later)
•
SNAP_GET_DBM
•
SNAP_GET_DBM_MEMORY_POOL
•
SNAP_GET_DYN_SQL_V91, 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_V91, or SNAP_GET_TAB (for DB2 version 10 or later)
•
SNAP_GET_TBSP_V91, or SNAP_GET_TBSP (for DB2 version 10 or later)
•
DB2_GET_INSTANCE_INFO (for DB2 version 10 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_V91(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
Foglight for DB2 (Cartridge) - 5.9.3.10
Getting Started Guide
Hardware Sizing Guide
Release Notes
User Guide
Showing 1 to 4 of 4 rows

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating