System Monitor Guide and Reference

Index

A B C D E F G H I L M N O P Q R S T U V W X

accepted block cursor requests, monitor element (1647)

accesses to overflowed records, monitor element (1629)

acc_curs_blk element (1648)

activating an event monitor (1121)

active sorts, monitor element (1395)

active_sorts element (1396)

Administering Satellites Guide and Reference (2009)

Administration Guide (1989)

Administrative API Reference (1990)

agent ID holding lock, monitor element (1587)

agent pool (1326)

agents

associated (1323)

coordinator (1321)

idle (1324)

subagent (1322)

agents assigned from pool, monitor element (1359)

agents created due to empty agent pool, monitor element (1361)

agents registered, monitor element (1349)

agents waiting for a token, monitor element (1351)

agents_created_empty_pool element (1362)

agents_from_pool element (1360)

agents_registered element (1350)

agents_registered_top element (1354)

agents_stolen element (1366)

agents_top element (1758)

agents_waiting_on_token element (1352)

agents_waiting_top element (1356)

agent_id (1873)

agent_id element (1242)

agent_id_holding_lock element (1588)

agent_pid element (1318)

agent_sys_cpu_time element (1764)

agent_usr_cpu_time element (1762)

APPC, CPI-C and SNA Sense Codes (1992)

application agent priority, monitor element (1283)

Application Building Guide (1991)

application creator, monitor element (1694)

Application Development Guide (1993)

application handle See agent_id

application handle (agent ID), monitor element (1241)

application ID holding lock, monitor element (1589)

application ID, monitor element (1253)

application idle time, monitor element (1315)

application name, monitor element (1251)

application priority type, monitor element (1285)

application snapshot (1085)

application status change time, monitor element (1247)

application status, monitor element (1243)

application with oldest transaction, monitor element (1249)

applications connected currently, monitor element (1344)

applications executing in the database currently, monitor element (1347)

appls_cur_cons (1345)

appls_in_db2 element (1348)

appl_con_time element (1294)

appl_id element (1254)

appl_idle_time element (1316)

appl_id_holding_lk element (1590)

appl_id_oldest_xact element (1250)

appl_name element (1252)

appl_priority element (1284)

appl_priority_type element (1286)

appl_section_inserts element (1521)

appl_section_lookups element (1519)

appl_status element (1244)

associated agent (1325)

associated_agents_top element (1368)

authority required

for event monitors (1115), (1870)

for snapshot monitoring (1073)

authority_lvl element (1288)

authorization ID, monitor element (1257)

auth_id element (1258)

autostarting an event monitor (1122)

availability of data

snapshot monitoring (1104)

binds/precompiles attempted, monitor element (1681)

binds_precompiles element (1682)

blocked event monitors (1879)

bp_info element (1474)

bp_name element (1476)

buffer overflows

pipe (1147)

buffer pool (1431)

buffer pool asynchronous data reads, monitor element (1453)

buffer pool asynchronous data writes, monitor element (1455)

buffer pool asynchronous index reads, monitor element (1459)

buffer pool asynchronous index writes, monitor element (1457)

buffer pool asynchronous read requests, monitor element (1465)

buffer pool asynchronous read time, monitor element (1461)

buffer pool asynchronous write time, monitor element (1463)

buffer pool data logical reads, monitor element (1435)

buffer pool data pages from extended storage, monitor element (1484)

buffer pool data pages to extended storage, monitor element (1480)

buffer pool data physical reads, monitor element (1437)

buffer pool data writes, monitor element (1439)

buffer pool event monitor (1137)

buffer pool hit ratio (1432)

buffer pool index logical reads, monitor element (1441)

buffer pool index pages from extended storage, monitor element (1486)

buffer pool index pages to extended storage, monitor element (1482)

buffer pool index physical reads, monitor element (1443)

buffer pool index writes, monitor element (1445)

buffer pool information, monitor element (1473)

buffer pool log space cleaners triggered, monitor element (1467)

buffer pool snapshot (1089)

buffer pool threshold cleaners triggered, monitor element (1471)

buffer pool victim page cleaners triggered, monitor element (1469)

buffering, event monitor (1878)

bufferpool name, monitor element (1475)

buff_free element (1408)

buff_free_bottom element (1410)

byte order of event data, monitor element (1795)

byte_order element (1796)

cache

catalog (1500)

package (1509)

capabilities, monitoring

activity monitoring (1050)

performance analysis (1052)

problem determination (1051)

system configuration (1054)

catalog cache See cache

catalog cache heap full, monitor element (1507)

catalog cache inserts, monitor element (1503)

catalog cache lookups, monitor element (1501)

catalog cache overflows, monitor element (1505)

catalog node network name, monitor element (1233)

catalog node number, monitor element (1237)

catalog_node element (1238)

catalog_node_name element (1234)

cat_cache_heap_full element (1508)

cat_cache_inserts element (1504)

cat_cache_lookups element (1502)

cat_cache_overflows element (1506)

CE_free element (1416)

CE_free_bottom element (1418)

CLI Guide and Reference (1994)

client communication protocol, monitor element (1279)

client operating platform, monitor element (1277)

client process ID, monitor element (1275)

client product/version ID, monitor element (1261)

client_db_alias element (1264)

client_nname element (1260)

client_pid element (1276)

client_platform element (1278)

client_prdid element (1262)

client_protocol element (1280)

codepage_id element (1246)

Command Reference (1995)

commit statements attempted, monitor element (1659)

committed private memory, monitor element (1369)

commit_sql_stmts element (1660)

communication error time, monitor element (1857)

communication errors, monitor element (1855)

comm_private_mem element (1370)

component_id element (1216)

configuration NNAME of client, monitor element (1259)

configuration NNAME at monitoring (server) node, monitor element (1199)

connection entries currently free, monitor element (1415)

connection for snapshot (1098)

connection information (1090)

connection request completion timestamp, monitor element (1298)

connection request start timestamp, monitor element (1293)

connection status, monitor element (1425)

connection switches, monitor element (1379)

connections event monitor (1138)

connections involved in deadlock, monitor element (1567)

connections_top element (1296)

connection_status element (1426)

Connectivity Supplement (1999)

connects since database activation, monitor element (1341)

conn_complete_time element (1299)

conn_time (1228)

con_elapsed_time element (1854)

con_local_dbases (1340)

con_response_time element (1852)

coordinating node, monitor element (1291)

coordinator agent (1184), (1327)

coordinator agent, monitor element (1319)

coord_agents_top element (1364)

coord_agent_pid element (1320)

coord_node element (1292)

corr_token element (1274)

count element (1790)

counters (1148), (1191)

country_code element (1282)

CREATE EVENT MONITOR statement (1922), (1925)

creating an event monitor (1119)

creator element (1695)

current agents waiting on locks, monitor element (1580)

current number of connections for DB2 Connect, monitor element (1817)

current number of tablequeue buffers overflowed, monitor element (1735)

cursor name, monitor element (1692)

cursor_name element (1693)

data definition language (DDL) SQL statements, monitor element (1667)

data element

types (1190)

Data Movement Utilities Guide and Reference (1996)

data stream (1171)

data stream hierarchy, snapshot (1899)

data stream, event logical data groupings (1984)

data stream, event monitor (1890)

data stream, reading event monitor (1895)

data stream, snapshot (1907), (1915)

data stream, snapshot logical data groupings (1983)

data stream, snapshot monitor (1902)

data, output (1177)

database

information (1959)

monitor, resetting (1964)

database activation timestamp, monitor element (1225)

database alias at the gateway, monitor element (1809)

database alias used by application, monitor element (1263)

database connection

applications connected currently, monitor element (1343)

applications executing in the database currently, monitor element (1346)

connection request completion timestamp, monitor element (1297)

database country code, monitor element (1281)

database deactivation timestamp, monitor element (1229)

database event monitor (1136)

database files closed, monitor element (1451)

database location, monitor element (1235)

database manager

monitor switches, checking (1949), (1953)

statistics (1957)

database manager snapshot (1083)

database manager type at monitored (server) node, monitor element (1203)

database monitor

description (1979)

database name, monitor element (1221)

database path, monitor element (1223)

database snapshot (1084)

Database System Monitor

database system monitor

GET DATABASE MANAGER MONITOR SWITCHES (1950)

GET MONITOR SWITCHES (1954)

GET SNAPSHOT (1958)

RESET MONITOR (1965)

UPDATE MONITOR SWITCHES (1980)

DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (2016)

DB2 Connect Enterprise Edition for UNIX Quick Beginnings (2017)

DB2 Connect gateway first connect initiated, monitor element (1811)

DB2 Connect Personal Edition Quick Beginnings (1997)

DB2 Connect User's Guide (1998)

DB2 Data Links Manager for AIX Quick Beginnings (2018)

DB2 Data Links Manager for Windows NT Quick Beginnings (2019)

DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (2014)

DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (2015)

db2 explain (1053)

DB2 library

books (1988)

Information Center (2026)

language identifier for books (2023)

late-breaking information (2024)

online help (1987)

ordering printed books (2031)

printing PostScript books (2030)

searching online information (2029)

setting up document server (2027)

SmartGuides (1986)

structure of (1985)

viewing online information (2025)

DB2 Personal Edition Quick Beginnings (2010)

DB2 Query Patroller Administration Guide (2020)

DB2 Query Patroller Installation Guide (2021)

DB2 Query Patroller User's Guide (2022)

db2batch (1185)

db2ConvMonStream (1927)

db2eva (1113), (1125), (1929)

db2evmon (1126), (1187), (1931)

db2GetSnapshot - Get Snapshot (1932)

db2gov (1186)

db2start_time element (1197)

db2_status (1218)

db_conn_time element (1226)

db_heap_top element (1523)

db_location element (1236)

db_name element (1222)

db_path element (1224)

db_status element (1232)

DCS application status, monitor element (1829)

DCS database name, monitor element (1805)

dcs_appl_status element (1830)

dcs_db_name element (1806)

ddl_sql_stmts element (1668)

deadlock event monitor (1135)

deadlocks detected, monitor element (1547)

deadlocks element (1548)

degree of parallelism, monitor element (1759)

degree_parallelism element (1760)

direct read requests, monitor element (1492)

direct read time, monitor element (1496)

direct reads from database, monitor element (1488)

direct write requests, monitor element (1494)

direct write time, monitor element (1498)

direct writes to database, monitor element (1490)

direct_reads element (1489)

direct_read_reqs element (1493)

direct_read_time element (1497)

direct_writes element (1491)

direct_write_reqs element (1495)

direct_write_time element (1499)

disconn_time element (1230)

dl_conns element (1568)

drda correlation token, monitor element (1273)

DROP statement (1933), (1937)

dynamic SQL snapshot (1101)

dynamic SQL statements attempted, monitor element (1655)

dynamic_sql_stmts element (1656)

elapsed statement execution time, monitor element (1753)

elapsed time spent on DB2 Connect gateway processing, monitor element (1823)

element, output (1176)

Event Analyzer (1928)

event analyzer (1188) See also db2eva

event monitor

CREATE EVENT MONITOR statement (1924)

DROP statement (1935)

EVENT_MON_STATE function (1940)

FLUSH EVENT MONITOR statement (1944)

SET EVENT MONITOR STATE statement (1968)

event monitor data stream (1891), (1896)

event monitor name, monitor element (1799)

Event Monitor Productivity Tool (1930)

event monitor trace (1888)

event monitors

activating (1120)

authority required (1116)

autostarting (1123)

blocked (1880)

buffering (1875)

creating (1118)

definition (1063), (1128)

disk space (1885), (1919)

event types (1132)

example of deadlock monitoring (1110)

file event monitors (1876)

information available (1133)

matching to application (1874)

non-blocked (1881)

output (1867)

partitioned databases (1163)

pipe event monitors (1144)

processing data (1886)

reading the trace (1124)

restarting (1887)

target (1883)

trace (1109), (1868)

using (1117)

when written (1108), (1131)

event start time, monitor element (1702)

event stop time, monitor element (1700)

event time, monitor element (1803)

event types (1134)

event_monitor_name element (1800)

EVENT_MON_STATE function (1941)

event_time element (1804)

exclusive lock escalations, monitor element (1551)

execution elapsed time, monitor element (1725)

execution_id element (1272)

extended storage (1479)

failed statement operations, monitor element (1657)

failed_sql_stmts element (1658)

fcm buffers currently free, monitor element (1407)

fetch_count element (1711)

file event monitors (1877)

files_closed element (1452)

first_overflow_time element (1792)

fixed structure, snapshot (1908)

FLUSH EVENT MONITOR statement (1942), (1945)

function

scalar

EVENT_MON_STATE (1939)

EVENT_MON_STATE, returning event monitor states (1938)

table

SQLCACHE_SNAPSHOT (1972)

SQLCACHE_SNAPSHOT, options and results (1971)

gauges (1192)

GET DATABASE MANAGER MONITOR SWITCHES (1947)

GET MONITOR SWITCHES (1951)

GET SNAPSHOT (1955)

effect on UPDATE MONITOR SWITCHES (1981)

Glossary (2000)

gw_comm_errors element (1856)

gw_comm_error_time element (1858)

gw_connections_top element (1814)

gw_cons_wait_client element (1822)

gw_cons_wait_host element (1820)

gw_con_time element (1812)

gw_cur_cons element (1818)

gw_db_alias element (1810)

gw_exec_time element (1824)

gw_total_cons element (1816)

hash join overflows, monitor element (1403)

hash join small overflows, monitor element (1405)

hash join threshold, monitor element (1399)

hash_join_overflows element (1404)

hash_join_small_overflows element (1406)

host coded character set ID, monitor element (1831)

host database name, monitor element (1807)

host product/version ID, monitor element (1265)

host response time, monitor element (1849)

host_ccsid element (1832)

host_db_name element (1808)

host_prdid element (1266)

host_response_time element (1850)

ID of code page used by application, monitor element (1245)

idle agent (1328)

idle_agents element (1358)

inactive_gw_agents element (1378)

inbound communication address, monitor element (1837)

inbound number of bytes received, monitor element (1839)

inbound number of bytes sent, monitor element (1845)

inbound_bytes_received element (1840)

inbound_bytes_sent element (1846)

inbound_comm_address element (1838)

information available

from snapshot monitoring (1078)

information data elements (1194)

input database alias, monitor element (1783)

input_db_alias element (1784)

Installation and Configuration Supplement (2001)

instance connection (1099)

interface, database system monitor

event monitor commands (1918)

event monitor GUI (1127)

snapshot monitoring APIs (1075), (1916)

snapshot monitoring commands (1076), (1917)

snapshot monitoring GUI (1077)

internal automatic rebinds, monitor element (1669)

internal commits, monitor element (1671)

internal rollbacks due to deadlock, monitor element (1675)

internal rollbacks, monitor element (1673)

internal rows deleted, monitor element (1631)

internal rows inserted, monitor element (1635)

internal rows updated, monitor element (1633)

int_auto_rebinds element (1670)

int_commits element (1672)

int_deadlock_rollbacks element (1676)

int_rollbacks element (1674)

int_rows_deleted element (1632)

int_rows_inserted element (1636)

int_rows_updated element (1634)

iStoreResult (1103)

last backup timestamp, monitor element (1239)

last reset timestamp, monitor element (1781)

last_backup element (1240)

last_over_flow time (1794)

last_reset element (1782)

LIST ACTIVE DATABASES (1960)

LIST APPLICATIONS (1961)

LIST DCS APPLICATIONS (1962)

local connections executing in the database manager, monitor element (1337)

local connections, monitor element (1335)

local databases with current connects, monitor element (1339)

local_cons element (1336)

local_cons_in_exec (1338)

lock escalation, monitor element (1569)

lock mode requested, monitor element (1571)

lock mode, monitor element (1553)

lock node, monitor element (1561)

lock object name, monitor element (1559)

lock object type waited on, monitor element (1557)

lock snapshot (1088)

lock status, monitor element (1555)

lock wait start timestamp, monitor element (1585)

lock waits, monitor element (1573)

locks

current agents waiting on locks, monitor element (1579)

locks held, monitor element (1541)

total lock list memory in use, monitor element (1544)

total time unit of work waited on locks, monitor element (1582)

locks held, monitor element (1542)

locks_held element (1543)

locks_held_top element (1566)

locks_waiting (1581)

lock_escalation element (1570)

lock_escals element (1550)

lock_mode element (1554)

lock_mode_requested element (1572)

lock_node element (1562)

lock_object_name element (1560)

lock_object_type element (1558)

lock_status element (1556)

lock_timeouts element (1564)

lock_waits (1574)

lock_wait_start_time element (1586)

lock_wait_time element (1576)

loc_list_in_use (1546)

log being rolled forward, monitor element (1605)

log header, reading (1894)

log phase, monitor element (1607)

log stream header, reading (1893)

logical data groupings (1982)

logical view (1153)

log_reads element (1531)

log_space_used element (1536)

log_writes element (1533)

maximum agent overflows, monitor element (1375)

maximum database heap allocated, monitor element (1522)

maximum number of agents registered, monitor element (1353)

maximum number of agents waiting, monitor element (1355)

maximum number of associated agents, monitor element (1367)

maximum number of concurrent connections, monitor element (1295), (1813)

maximum number of coordinating agents, monitor element (1363)

maximum number of locks held, monitor element (1565)

maximum number of tablequeue buffers overflows, monitor element (1741)

maximum package cache size, monitor element (1516)

maximum secondary log space used, monitor element (1524)

maximum total log space used, monitor element (1526)

max_agent_overflows element (1376)

MA_free element (1412)

MA_free_bottom element (1414)

memory requirements (1156)

message anchors currently free, monitor element (1411)

Message Reference (2002)

minimum connection entries, monitor element (1417)

minimum fcm buffers free, monitor element (1409)

minimum message anchors, monitor element (1413)

minimum request blocks, monitor element (1421)

monitor switches

control data collected by the database manager (1057)

query database manager switch settings (1060)

setting explicitly (1058)

setting for a snapshot (1066)

setting implicitly (1059)

monitoring

levels (1055)

monitoring databases (1948), (1952)

mon_heap_sz (1155)

most recent connection elapsed time, monitor element (1853)

most recent response time for connect, monitor element (1851)

most recent statement elapsed time, monitor element (1704)

most recent unit of work elapsed time, monitor element (1306)

multiple partition databases

event monitors (1161)

snapshot monitoring (1158)

subsections (1168)

tablequeue (1169)

node number, monitor element (1289)

nodegroup (1167)

node_number element (1290)

number of agents created, monitor element (1757)

number of agents working on a statement, monitor element (1755)

number of agents working on a subsection, monitor element (1727)

number of associated agents, monitor element (1373)

number of connections waiting for the client to send request, monitor element (1821)

number of connections waiting for the host to reply, monitor element (1819)

number of event monitor overflows, monitor element (1789)

number of idle agents, monitor element (1357)

number of lock escalations, monitor element (1549)

number of lock timeouts, monitor element (1563)

number of log pages read, monitor element (1530)

number of log pages written, monitor element (1532)

number of nodes in partition, monitor element (1787)

number of nodes, monitor element (1423)

number of open cursors, monitor element (1827)

number of rollforward table spaces, monitor element (1609)

number of rows read from tablequeues, monitor element (1737)

number of rows written to tablequeues, monitor element (1739)

number of SQL statements attempted, monitor element (1825)

number of successful fetches, monitor element (1710)

number_nodes element (1424)

num_agents element (1756)

num_assoc_agents element (1374)

num_compilation element (1748)

num_executions element (1746)

num_gw_conn_switches element (1380)

num_nodes_in_db2_instance element (1788)

num_subagents element (1728)

open local cursors with blocking, monitor element (1651)

open local cursors, monitor element (1649)

open remote cursors with blocking, monitor element (1643)

open remote cursors, monitor element (1641)

open_cursors element (1828)

open_loc_curs element (1650)

open_loc_curs_blk element (1652)

open_rem_curs element (1642)

open_rem_curs_blk element (1644)

operation element (1687)

outbound application ID, monitor element (1267)

outbound communication address, monitor element (1835)

outbound communication protocol, monitor element (1833)

outbound number of bytes received, monitor element (1843)

outbound number of bytes sent, monitor element (1841)

outbound sequence number, monitor element (1269)

outbound_appl_id element (1268)

outbound_bytes_received element (1844)

outbound_bytes_sent element (1842)

outbound_comm_address element (1836)

outbound_comm_protocol element (1834)

outbound_sequence_no element (1270)

output format (1173)

output, snapshot (1914)

output, snapshot monitor (1901)

overflows, event monitor (1882)

overflow_accesses (1630)

package cache See cache

package cache inserts, monitor element (1512)

package cache lookups, monitor element (1510)

package cache overflows, monitor element (1514)

package name, monitor element (1688)

package_name element (1689)

page reorganizations, monitor element (1639)

page_reorgs element (1640)

parsing, snapshot (1909)

partial record, monitor element (1801)

partial_record element (1802)

performance monitor, Windows NT (1189)

pipe event monitors

defining (1145)

overflows (1146)

using (1143)

piped sorts accepted, monitor element (1387)

piped sorts requested, monitor element (1385)

piped_sorts_accepted element (1388)

piped_sorts_requested element (1386)

pkg_cache_inserts element (1513)

pkg_cache_lookups (1511)

pkg_cache_num_overflow element (1515)

pkg_cache_size_top element (1517)

pool_async_data_reads element (1454)

pool_async_data_read_reqs element (1466)

pool_async_data_writes element (1456)

pool_async_index_reads element (1460)

pool_async_index_writes element (1458)

pool_async_read_time element (1462)

pool_async_write_time element (1464)

pool_data_from_estore element (1485)

pool_data_l_reads element (1436)

pool_data_p_reads element (1438)

pool_data_to_estore element (1481)

pool_data_writes element (1440)

pool_drty_pg_steal_clns (1470)

pool_drty_pg_thrsh_clns element (1472)

pool_index_from_estore element (1487)

pool_index_l_reads element (1442)

pool_index_p_reads element (1444)

pool_index_to_estore element (1483)

pool_index_writes element (1446)

pool_lsn_gap_clns element (1468)

pool_read_time element (1448)

pool_write_time element (1450)

post threshold sorts, monitor element (1383)

post_threshold_hash_joins element (1400)

post_threshold_sorts element (1384)

prefetchers (1433), (1434)

prefetch_wait_time element (1478)

prep_time_best element (1752)

prep_time_worst element (1750)

previous transaction stop time, monitor element (1313)

previous unit of work completion timestamp, monitor element (1300)

prev_stop_time element (1314)

prev_uow_stop_time element (1301)

process or thread id, monitor element (1317)

product identification, monitor element (1215)

product name, monitor element (1213)

product_name element (1214)

query

database manager monitor switch settings (1061)

event monitor state (1129)

query cost estimate, monitor element (1716)

query number of rows estimate, monitor element (1714)

query_card_estimate element (1715)

query_cost_estimate element (1717)

Quick Beginnings for OS/2 (2011)

Quick Beginnings for UNIX (2012)

Quick Beginnings for Windows NT (2013)

RB_free element (1420)

RB_free_bottom element (1422)

rejected block cursor requests, monitor element (1645)

rej_curs_blk element (1646)

remote connections executing in the database manager, monitor element (1333)

remote connections to database manager, monitor element (1331)

rem_cons_in element (1332)

rem_cons_in_exec (1334)

Replication Guide and Reference (2003)

request blocks currently free, monitor element (1419)

RESET MONITOR (1963)

resetting monitor data (1150)

rf_log_num element (1606)

rf_num_tspaces element (1610)

rf_status element (1608)

rf_timestamp element (1600)

rf_type element (1604)

rollback statements attempted, monitor element (1661)

rollback_sql_stmts (1662)

rolled back agent, monitor element (1595)

rolled back application, monitor element (1593)

rolled back sequence number, monitor element (1597)

rolled_back_agent_id element (1596)

rolled_back_appl_id element (1594)

rolled_back_sequence_no element (1598)

rollforward timestamp, monitor element (1599)

rollforward type, monitor element (1603)

rows deleted, monitor element (1617)

rows inserted, monitor element (1619)

rows read, monitor element (1627)

rows selected, monitor element (1623)

rows updated, monitor element (1621)

rows written, monitor element (1625)

rows_deleted element (1618)

rows_inserted element (1620)

rows_read element (1628)

rows_selected element (1624)

rows_updated element (1622)

rows_written element (1626)

samples

event monitor trace (1112), (1872)

event monitoring on partitioned databases (1162)

lock snapshot (1068)

monitoring deadlocks with a lock snapshot (1106)

query event monitor state (1130)

setting switches (1149)

snapshots on partitioned databases (1160)

secondary connections, monitor element (1371)

secondary logs allocated currently, monitor element (1528)

section inserts, monitor element (1520)

section lookups, monitor element (1518)

section number, monitor element (1690)

section_number element (1691)

sec_logs_allocated element (1529)

sec_log_used_top element (1525)

select SQL statements executed, monitor element (1663)

select_sql_stmts element (1664)

self-describing data stream (1172)

sequence number holding lock, monitor element (1591)

sequence number, monitor element (1255)

sequence_no element (1256)

sequence_no_holding_lk element (1592)

server instance name, monitor element (1201)

server operating system, monitor element (1211)

server product/version ID, monitor element (1205)

server version, monitor element (1207)

server_db2_type element (1204)

server_instance_name element (1202)

server_nname element (1200)

server_platform element (1212)

server_prdid element (1206)

server_version element (1208)

service level, monitor element (1209)

service_level element (1210)

SET EVENT MONITOR STATE statement (1966), (1969)

setting switches

for a monitoring application (1067)

setting up document server (2028)

size, output (1174)

snapshot monitor data stream (1903)

snapshot monitor output (1900)

snapshot monitoring

APIs (1921)

authority required (1072)

availability of data (1105)

commands (1920)

data element categories (1064)

definition (1062)

information available (1079)

information returned (1081)

interface (1074)

partitioned databases (1159)

request types (1080)

required connection (1100)

sample output (1069), (1152)

setting switches (1065), (1151)

snapshot types (1082)

snapshot output (1898)

snapshot parsing (1910)

snapshot request (1911)

snapshot request types (1897)

snapshot scenarios (1905)

snapshot time, monitor element (1785)

snapshot types

application (1093)

buffer pool (1097)

database (1092)

database manager (1091)

lock (1095)

table (1094)

table space (1096)

snapshot, reading output (1913)

snapshots, version 6 (1906)

sort overflows, monitor element (1393)

sort_heap_allocated element (1382)

sort_overflows element (1394)

SQL activity (1102)

SQL communications area (SQLCA), monitor element (1712)

SQL dynamic statement text, monitor element (1706)

SQL Getting Started (2004)

SQL Reference (2005)

SQL requests since last commit, monitor element (1677)

SQL statement

CREATE EVENT MONITOR (1923), (1926)

DROP (1934), (1936)

FLUSH EVENT MONITOR (1943), (1946)

SET EVENT MONITOR STATE (1967), (1970)

SQL syntax

SQLCACHE_SNAPSHOT function, results on set number pairs (1973)

sqlca element (1713)

SQLCACHE_SNAPSHOT function, detailed description (1974)

SQLCODE +1627W (1178)

sqlcode -973 (1157)

sqlmon - Get/Update Monitor Switches (1975)

sqlmon.h header file (1871)

sqlmonsz - Estimate Size Required for db2GetSnapshot() Output Buffer (1976)

sqlmrset - Reset Monitor (1977)

SQLM_ELM (1892), (1904)

sql_reqs_since_commit element (1678)

sql_stmts element (1826)

ss_exec_time element (1726)

ss_node_number element (1722)

ss_number element (1720)

ss_status element (1724)

ss_sys_cpu_time element (1776)

ss_usr_cpu_time element (1774)

start database manager timestamp, monitor element (1198)

start_time element (1703)

statement best preparation time, monitor element (1751)

statement compilations, monitor element (1747)

statement event monitor (1139)

statement executions, monitor element (1745)

statement node, monitor element (1679)

statement operation start timestamp, monitor element (1696)

statement operation stop timestamp, monitor element (1698)

statement operation, monitor element (1685)

statement sorts, monitor element (1708)

statement type, monitor element (1683)

statement worst preparation time, monitor element (1749)

static SQL statements attempted, monitor element (1653)

static_sql_stmts (1654)

statistics

database manager (1956)

status element (1310)

status of database, monitor element (1231)

status of DB2 instance, monitor element (1217)

status_change_time element (1248)

stmt_elapsed_time element (1705)

stmt_node_number element (1680)

stmt_operations element (1686)

stmt_sorts element (1709)

stmt_start element (1697)

stmt_stop element (1699)

stmt_sys_cpu_time element (1768)

stmt_text element (1707)

stmt_type element (1684)

stmt_usr_cpu_time element (1766)

stolen agent (1329)

stolen agents, monitor element (1365)

stop_time element (1701)

subagent (1330)

subsection node number, monitor element (1721)

subsection number, monitor element (1719)

subsection status, monitor element (1723)

subsections (1718)

definition (1165)

monitoring (1164)

tablequeue (1166)

switches (1056)

system CPU time used by agent, monitor element (1763)

system CPU time used by statement, monitor element (1767)

system CPU time used by subsection, monitor element (1775)

system CPU time, monitor element (1771)

System Monitor Guide and Reference (2006)

system_cpu_time element (1772)

table event monitor (1141)

table file ID, monitor element (1637)

table name, monitor element (1613)

table schema name, monitor element (1615)

table snapshot (1086)

table space event monitor (1142)

table space name, monitor element (1577)

table space snapshot (1087)

table type, monitor element (1611)

tablequeue (1170)

tablespace being rolled forward, monitor element (1601)

tablespace_name element (1578)

table_file_id element (1638)

table_name element (1614)

table_schema element (1616)

table_type element (1612)

taking a snapshot (1912)

issuing get snapshot command (1070)

sample output (1071)

time (1196)

time of database connection, monitor element (1227)

time of first event overflow, monitor element (1791)

time of last event overflow, monitor element (1793)

time waited for prefetch, monitor element (1477)

time waited on locks, monitor element (1575)

time zone displacement, monitor element (1219)

timestamp (1195)

time_stamp element (1786)

time_zone_disp element (1220)

tools

control center (1182)

db2batch (1179)

db2evmon (1181)

db2gov (1180)

event analyzer (1183)

total buffer pool physical read time, monitor element (1447)

total buffer pool physical write time, monitor element (1449)

total fcm buffers received, monitor element (1429)

total fcm buffers sent, monitor element (1427)

total hash joins, monitor element (1397)

total hash loops, monitor element (1401)

total inactive DRDA agents, monitor element (1377)

total lock list memory in use, monitor element (1545)

total log available, monitor element (1539)

total log space used, monitor element (1537)

total number of attempted connections for DB2 Connect, monitor element (1815)

total number of tablequeue buffers overflowed, monitor element (1733)

total sort heap allocated , monitor element (1381)

total sort time, monitor element (1391)

total sorts, monitor element (1389)

total system CPU for a statement, monitor element (1777)

total time unit of work waited on locks, monitor element (1583)

total user CPU for a statement, monitor element (1779)

total_buffers_rcvd element (1430)

total_buffers_sent element (1428)

total_cons element (1342)

total_exec_time element (1754)

total_hash_joins element (1398)

total_hash_loops element (1402)

total_log_available element (1540)

total_log_used element (1538)

total_sec_cons element (1372)

total_sorts element (1390)

total_sort_time element (1392)

tot_log_used_top element (1527)

tot_s_cpu_time element (1778)

tot_u_cpu_time element (1780)

TP monitor client accounting string, monitor element (1865)

TP monitor client application name, monitor element (1863)

TP monitor client user ID, monitor element (1859)

TP monitor client workstation name, monitor element (1861)

tpmon_acc_str element (1866)

tpmon_client_app element (1864)

tpmon_client_userid element (1860)

tpmon_client_wkstn element (1862)

tq_cur_send_spills element (1736)

tq_id_waiting_on element (1744)

tq_max_send_spills element (1742)

tq_node_waited_for element (1732)

tq_rows_read element (1738)

tq_rows_written element (1740)

tq_tot_send_spills element (1734)

tq_wait_for_any element (1730)

trace

event monitor (1107)

format (1869)

sample (1111)

size (1884)

viewing (1114)

trace, event monitor (1889)

transaction event monitor (1140)

transaction ID, monitor element (1847)

Troubleshooting Guide (2007)

ts_name element (1602)

type, output (1175)

uid_sql_stmts element (1666)

unit of work completion status, monitor element (1308)

unit of work log space used, monitor element (1534)

unit of work start timestamp, monitor element (1302)

unit of work status, monitor element (1311)

unit of work stop timestamp, monitor element (1304)

uow_comp_status element (1309)

uow_elapsed_time element (1307)

uow_lock_wait_time element (1584)

uow_log_space_used element (1535)

uow_start_time element (1303)

uow_status element (1312)

uow_stop_time element (1305)

UPDATE MONITOR SWITCHES (1978)

update/insert/delete SQL statements executed, monitor element (1665)

updating switch settings See setting switches

user authorization level, monitor element (1287)

user CPU time used by agent, monitor element (1761)

user CPU time used by statement, monitor element (1765)

user CPU time used by subsection, monitor element (1773)

user CPU time, monitor element (1769)

user login ID, monitor element (1271)

user_cpu_time element (1770)

version element (1798)

version of monitor data, monitor element (1797)

view, logical (1154)

waited for node on a tablequeue, monitor element (1731)

waited on node on a tablequeue, monitor element (1743)

waiting for any node to send on a tablequeue, monitor element (1729)

water mark (1193)

What's New (2008)

xid (1848)

x_lock_escals element (1552)

[ Top of Page | Previous Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]