SNAPSHOT_TIMESTAMP |
TIMESTAMP |
The date and time that the snapshot was taken. |
SORT_HEAP_ALLOCATED |
BIGINT |
sort_heap_allocated - Total sort heap
allocated |
POST_THRESHOLD_SORTS |
BIGINT |
post_threshold_sorts - Post threshold
sorts |
PIPED_SORTS_REQUESTED |
BIGINT |
piped_sorts_requested - Piped sorts
requested |
PIPED_SORTS_ACCEPTED |
BIGINT |
piped_sorts_accepted - Piped sorts
accepted |
REM_CONS_IN |
BIGINT |
rem_cons_in - Remote connections to
database manager |
REM_CONS_IN_EXEC |
BIGINT |
rem_cons_in_exec - Remote Connections
Executing in the Database Manager monitor element |
LOCAL_CONS |
BIGINT |
local_cons - Local connections |
LOCAL_CONS_IN_EXEC |
BIGINT |
local_cons_in_exec - Local Connections
Executing in the Database Manager monitor element |
CON_LOCAL_DBASES |
BIGINT |
con_local_dbases - Local databases
with current connects |
AGENTS_REGISTERED |
BIGINT |
agents_registered - Agents registered |
AGENTS_WAITING_ON_TOKEN |
BIGINT |
agents_waiting_on_token - Agents waiting
for a token |
DB2_STATUS |
VARCHAR(12) |
db2_status - Status of DB2 instance This
interface returns a text identifier based on defines in sqlmon.h,
and is one of: - ACTIVE
- QUIESCE_PEND
- QUIESCED
|
AGENTS_REGISTERED_TOP |
BIGINT |
agents_registered_top - Maximum number
of agents registered |
AGENTS_WAITING_TOP |
BIGINT |
agents_waiting_top - Maximum number
of agents waiting |
COMM_PRIVATE_MEM |
BIGINT |
comm_private_mem - Committed private
memory |
IDLE_AGENTS |
BIGINT |
idle_agents - Number of idle agents |
AGENTS_FROM_POOL |
BIGINT |
agents_from_pool - Agents assigned
from pool |
AGENTS_CREATED_EMPTY_POOL |
BIGINT |
agents_created_empty_pool - Agents
created due to empty agent pool |
COORD_AGENTS_TOP |
BIGINT |
coord_agents_top - Maximum number of
coordinating agents |
MAX_AGENT_OVERFLOWS |
BIGINT |
max_agent_overflows - Maximum agent
overflows |
AGENTS_STOLEN |
BIGINT |
agents_stolen - Stolen agents |
GW_TOTAL_CONS |
BIGINT |
gw_total_cons - Total number of attempted
connections for DB2 Connect™ |
GW_CUR_CONS |
BIGINT |
gw_cur_cons - Current number of connections
for DB2 Connect |
GW_CONS_WAIT_HOST |
BIGINT |
gw_cons_wait_host - Number of connections
waiting for the host to reply |
GW_CONS_WAIT_CLIENT |
BIGINT |
gw_cons_wait_client - Number of connections
waiting for the client to send request |
POST_THRESHOLD_ HASH_JOINS |
BIGINT |
post_threshold_hash_joins - Hash join
threshold |
NUM_GW_CONN_SWITCHES |
BIGINT |
num_gw_conn_switches - Connection switches |
DB2START_TIME |
TIMESTAMP |
db2start_time - Start database manager
timestamp |
LAST_RESET |
TIMESTAMP |
last_reset - Last reset timestamp |
NUM_NODES_IN_ DB2_INSTANCE |
INTEGER |
num_nodes_in_db2_instance - Number
of nodes in database partition |
PRODUCT_NAME |
VARCHAR(32) |
product_name - Product name |
SERVICE_LEVEL |
VARCHAR(18) |
service_level - Service level |
SORT_HEAP_TOP |
BIGINT |
sort_heap_top - Sort private heap high
water mark |
DBPARTITIONNUM |
SMALLINT |
dbpartitionnum - Database partition
number monitor element |
POST_THRESHOLD_OLAP_FUNCS |
BIGINT |
post_threshold_olap_funcs - OLAP function
threshold |