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
A
  • accepted block cursor requests, monitor element (1743)
  • accesses to overflowed records, monitor element (1725)
  • acc_curs_blk element (1744)
  • activating an event monitor (1212)
  • active sorts, monitor element (1491)
  • active_sorts element (1492)
  • add database wizard (2167)
  • agent ID holding lock, monitor element (1683)
  • agent pool (1422)
  • agents
  • associated (1419)
  • coordinator (1417)
  • idle (1420)
  • subagent (1418)
  • agents assigned from pool, monitor element (1455)
  • agents created due to empty agent pool, monitor element (1457)
  • agents registered, monitor element (1445)
  • agents waiting for a token, monitor element (1447)
  • agents_created_empty_pool element (1458)
  • agents_from_pool element (1456)
  • agents_registered element (1446)
  • agents_registered_top element (1450)
  • agents_stolen element (1462)
  • agents_top element (1854)
  • agents_waiting_on_token element (1448)
  • agents_waiting_top element (1452)
  • agent_id (2015)
  • agent_id element (1336)
  • agent_id_holding_lock element (1684)
  • agent_pid element (1414)
  • agent_status element (1928)
  • agent_sys_cpu_time element (1860)
  • agent_usr_cpu_time element (1858)
  • application agent priority, monitor element (1379)
  • application creator, monitor element (1790)
  • application handle See agent_id
  • application handle (agent ID), monitor element (1335)
  • application ID holding lock, monitor element (1685)
  • application ID, monitor element (1349)
  • application identification, monitor element (1973)
  • application idle time, monitor element (1411)
  • application name, monitor element (1347)
  • application priority type, monitor element (1381)
  • application snapshot (1174)
  • application status change time, monitor element (1341)
  • application status, monitor element (1337)
  • application with oldest transaction, monitor element (1343)
  • applications connected currently, monitor element (1440)
  • applications executing in the database currently, monitor element (1443)
  • appls_cur_cons (1441)
  • appls_in_db2 element (1444)
  • appl_con_time element (1390)
  • appl_id element (1350)
  • appl_idle_time element (1412)
  • appl_id_holding_lk element (1686)
  • appl_id_oldest_xact element (1344)
  • appl_name element (1348)
  • appl_priority element (1380)
  • appl_priority_type element (1382)
  • appl_section_inserts element (1617)
  • appl_section_lookups element (1615)
  • appl_status element (1338)
  • associated agent (1421)
  • associated_agents_top element (1464)
  • authority required
  • for event monitors (1206), (2012)
  • for snapshot monitoring (1162)
  • authority_lvl element (1384)
  • authorization ID, monitor element (1353)
  • auth_id element (1354)
  • autostarting an event monitor (1213)
  • availability of data
  • snapshot monitoring (1195)
    • B
  • back up database wizard (2169)
  • binds/precompiles attempted, monitor element (1777)
  • binds_precompiles element (1778)
  • blocked event monitors (2021)
  • blocking cursor, monitor element (1957)
  • blocking_cursor element (1958)
  • books (2139), (2152)
  • bp_info element (1570)
  • bp_name element (1572)
  • buffer overflows
  • pipe (1238)
  • buffer pool (1527)
  • buffer pool asynchronous data reads, monitor element (1549)
  • buffer pool asynchronous data writes, monitor element (1551)
  • buffer pool asynchronous index reads, monitor element (1555)
  • buffer pool asynchronous index writes, monitor element (1553)
  • buffer pool asynchronous read requests, monitor element (1561)
  • buffer pool asynchronous read time, monitor element (1557)
  • buffer pool asynchronous write time, monitor element (1559)
  • buffer pool data logical reads, monitor element (1531)
  • buffer pool data pages from extended storage, monitor element (1580)
  • buffer pool data pages to extended storage, monitor element (1576)
  • buffer pool data physical reads, monitor element (1533)
  • buffer pool data writes, monitor element (1535)
  • buffer pool event monitor (1228)
  • buffer pool hit ratio (1528)
  • buffer pool index logical reads, monitor element (1537)
  • buffer pool index pages from extended storage, monitor element (1582)
  • buffer pool index pages to extended storage, monitor element (1578)
  • buffer pool index physical reads, monitor element (1539)
  • buffer pool index writes, monitor element (1541)
  • buffer pool information, monitor element (1569)
  • buffer pool log space cleaners triggered, monitor element (1563)
  • buffer pool snapshot (1178)
  • buffer pool threshold cleaners triggered, monitor element (1567)
  • buffer pool victim page cleaners triggered, monitor element (1565)
  • buffering, event monitor (2020)
  • bufferpool name, monitor element (1571)
  • buff_free element (1504)
  • buff_free_bottom element (1506)
  • byte order of event data, monitor element (1891)
  • byte_order element (1892)
    • C
  • cache
  • catalog (1596)
  • package (1605)
  • capabilities, monitoring
  • activity monitoring (1139)
  • performance analysis (1141)
  • problem determination (1140)
  • system configuration (1143)
  • catalog cache See cache
  • catalog cache heap full, monitor element (1603)
  • catalog cache inserts, monitor element (1599)
  • catalog cache lookups, monitor element (1597)
  • catalog cache overflows, monitor element (1601)
  • catalog node network name, monitor element (1327)
  • catalog node number, monitor element (1331)
  • catalog_node element (1332)
  • catalog_node_name element (1328)
  • cat_cache_heap_full element (1604)
  • cat_cache_inserts element (1600)
  • cat_cache_lookups element (1598)
  • cat_cache_overflows element (1602)
  • CE_free element (1512)
  • CE_free_bottom element (1514)
  • client communication protocol, monitor element (1375)
  • client operating platform, monitor element (1373)
  • client process ID, monitor element (1371)
  • client product/version ID, monitor element (1357)
  • client_db_alias element (1360)
  • client_nname element (1356)
  • client_pid element (1372)
  • client_platform element (1374)
  • client_prdid element (1358)
  • client_protocol element (1376)
  • codepage_id element (1340)
  • commit statements attempted, monitor element (1755)
  • committed private memory, monitor element (1465)
  • commit_sql_stmts element (1756)
  • communication error time, monitor element (1955)
  • communication errors, monitor element (1953)
  • comm_private_mem element (1466)
  • component_id element (1310)
  • configuration NNAME of client, monitor element (1355)
  • configuration NNAME at monitoring (server) node, monitor element (1293)
  • configure multisite update wizard (2171)
  • connection entries currently free, monitor element (1511)
  • connection for snapshot (1187)
  • connection information (1179)
  • connection request completion timestamp, monitor element (1394)
  • connection request start timestamp, monitor element (1389)
  • connection status, monitor element (1521)
  • connection switches, monitor element (1475)
  • connections event monitor (1229)
  • connections involved in deadlock, monitor element (1663)
  • connections_top element (1392)
  • connection_status element (1522)
  • connects since database activation, monitor element (1437)
  • conn_complete_time element (1395)
  • conn_time (1322)
  • con_elapsed_time element (1952)
  • con_local_dbases (1436)
  • con_response_time element (1950)
  • coordinating node, monitor element (1387)
  • coordinator agent (1278), (1423)
  • coordinator agent, monitor element (1415)
  • coord_agents_top element (1460)
  • coord_agent_pid element (1416)
  • coord_node element (1388)
  • corr_token element (1370)
  • count element (1886)
  • counters (1239), (1285)
  • country_code element (1378)
  • create database wizard (2173)
  • CREATE EVENT MONITOR statement (2064), (2067)
  • create nickname response time, monitor element (2001)
  • create nicknames, monitor element (1983)
  • create table space wizard (2177)
  • create table wizard (2175)
  • create_nickname element (1984)
  • create_nickname_time element (2002)
  • creating an event monitor (1210)
  • creator element (1791)
  • current agents waiting on locks, monitor element (1676)
  • current number of connections for DB2 Connect, monitor element (1913)
  • current number of tablequeue buffers overflowed, monitor element (1831)
  • cursor name, monitor element (1788)
  • cursor_name element (1789)
    • D
  • data definition language (DDL) SQL statements, monitor element (1763)
  • data element
  • types (1284)
  • data elements, event (2135)
  • data elements, snapshot (2131)
  • data source name, monitor element (1971)
  • data stream (1265)
  • data stream hierarchy, snapshot (2041)
  • data stream, event logical data groupings (2136)
  • data stream, event monitor (2032)
  • data stream, reading event monitor (2037)
  • data stream, snapshot (2049), (2057)
  • data stream, snapshot logical data groupings (2132)
  • data stream, snapshot monitor (2044)
  • data, output (1271)
  • database
  • information (2108)
  • monitor, resetting (2113)
  • database activation timestamp, monitor element (1319)
  • database alias at the gateway, monitor element (1905)
  • database alias used by application, monitor element (1359)
  • database connection
  • applications connected currently, monitor element (1439)
  • applications executing in the database currently, monitor element (1442)
  • connection request completion timestamp, monitor element (1393)
  • database country code, monitor element (1377)
  • database deactivation timestamp, monitor element (1323)
  • database event monitor (1227)
  • database files closed, monitor element (1547)
  • database location, monitor element (1329)
  • database manager
  • monitor switches, checking (2098), (2102)
  • statistics (2106)
  • database manager snapshot (1172)
  • database manager type at monitored (server) node, monitor element (1297)
  • database monitor
  • description (2125)
  • database name, monitor element (1315)
  • database path, monitor element (1317)
  • database snapshot (1173)
  • Database System Monitor
  • database system monitor
  • GET DATABASE MANAGER MONITOR SWITCHES (2099)
  • GET MONITOR SWITCHES (2103)
  • GET SNAPSHOT (2107)
  • RESET MONITOR (2114)
  • UPDATE MONITOR SWITCHES (2126)
  • datasource_name element (1972)
  • DB2 Connect gateway first connect initiated, monitor element (1907)
  • db2 explain (1142)
  • DB2 library
  • books (2138)
  • Information Center (2160)
  • language identifier for books (2143)
  • late-breaking information (2145)
  • online help (2153)
  • ordering printed books (2151)
  • printing PDF books (2148)
  • searching online information (2186)
  • setting up document server (2184)
  • structure of (2137)
  • viewing online information (2155)
  • wizards (2163)
  • db2batch (1279)
  • db2ConvMonStream (2069)
  • db2eva (1204), (1216), (2071)
  • db2evmon (1217), (1281), (2073)
  • db2GetSnapshot - Get Snapshot (2075)
  • db2GetSnapshotSize - Estimate Size Required for db2GetSnapshot() Output Buffer (2077)
  • db2gov (1280)
  • db2MonitorSwitches - Get/Update Monitor Switches (2079)
  • db2ResetMonitor - Reset Monitor (2081)
  • db2start_time element (1291)
  • db2_status (1312)
  • db_conn_time element (1320)
  • db_heap_top element (1619)
  • db_location element (1330)
  • db_name element (1316)
  • db_path element (1318)
  • db_status element (1326)
  • DCS application agents, monitor element (1927)
  • DCS application status, monitor element (1925)
  • DCS database name, monitor element (1901)
  • dcs_appl_status element (1926)
  • dcs_db_name element (1902)
  • ddl_sql_stmts element (1764)
  • deadlock event monitor (1226)
  • deadlocks detected, monitor element (1643)
  • deadlocks element (1644)
  • degree of parallelism, monitor element (1855)
  • degree_parallelism element (1856)
  • delete response time, monitor element (1999)
  • deletes, monitor element (1981)
  • delete_sql_stmts element (1982)
  • delete_time element (2000)
  • diconnects element (1976)
  • direct read requests, monitor element (1588)
  • direct read time, monitor element (1592)
  • direct reads from database, monitor element (1584)
  • direct write requests, monitor element (1590)
  • direct write time, monitor element (1594)
  • direct writes to database, monitor element (1586)
  • direct_reads element (1585)
  • direct_read_reqs element (1589)
  • direct_read_time element (1593)
  • direct_writes element (1587)
  • direct_write_reqs element (1591)
  • direct_write_time element (1595)
  • disconnects, monitor element (1975)
  • disconn_time element (1324)
  • dl_conns element (1664)
  • drda correlation token, monitor element (1369)
  • DROP statement (2082), (2086)
  • dynamic SQL snapshot (1190)
  • dynamic SQL statements attempted, monitor element (1751)
  • dynamic_sql_stmts element (1752)
    • E
  • elapsed statement execution time, monitor element (1849)
  • elapsed time spent on DB2 Connect gateway processing, monitor element (1919)
  • elapsed_exec_time element (1962)
  • element, output (1270)
  • ESTIMATE SIZE REQUIRED FOR db2GetSnapshot() OUTPUT BUFFER (db2GetSnapshotSize) (2076)
  • Event Analyzer (2070)
  • event analyzer (1282) See also db2eva
  • event data elements (2134)
  • event logical data groupings (2133)
  • event monitor
  • CREATE EVENT MONITOR statement (2066)
  • DROP statement (2084)
  • EVENT_MON_STATE function (2089)
  • FLUSH EVENT MONITOR statement (2093)
  • SET EVENT MONITOR STATE statement (2117)
  • event monitor data stream (2033), (2038)
  • event monitor name, monitor element (1895)
  • Event Monitor Productivity Tool (2072)
  • event monitor trace (2030)
  • event monitors
  • activating (1211)
  • authority required (1207)
  • autostarting (1214)
  • blocked (2022)
  • buffering (2017)
  • creating (1209)
  • definition (1152), (1219)
  • disk space (2027), (2061)
  • event types (1223)
  • example of deadlock monitoring (1201)
  • file event monitors (2018)
  • information available (1224)
  • matching to application (2016)
  • non-blocked (2023)
  • output (2009)
  • partitioned databases (1257)
  • pipe event monitors (1235)
  • processing data (2028)
  • reading the trace (1215)
  • restarting (2029)
  • target (2025)
  • trace (1200), (2010)
  • using (1208)
  • when written (1199), (1222)
  • event start time, monitor element (1798)
  • event stop time, monitor element (1796)
  • event time, monitor element (1899)
  • event types (1225)
  • event_monitor_name element (1896)
  • EVENT_MON_STATE function (2090)
  • event_time element (1900)
  • exclusive lock escalations, monitor element (1647)
  • execution_id element (1368)
  • extended storage (1575)
    • F
  • failed statement operations, monitor element (1753)
  • failed_sql_stmts element (1754)
  • fcm buffers currently free, monitor element (1503)
  • fetch_count element (1807)
  • file event monitors (2019)
  • files_closed element (1548)
  • first_overflow_time element (1888)
  • fixed structure, snapshot (2050)
  • FLUSH EVENT MONITOR statement (2091), (2094)
  • function
  • scalar
  • EVENT_MON_STATE (2088)
  • EVENT_MON_STATE, returning event monitor states (2087)
  • table
  • SQLCACHE_SNAPSHOT (2121)
  • SQLCACHE_SNAPSHOT, options and results (2120)
    • G
  • gauges (1286)
  • GET DATABASE MANAGER MONITOR SWITCHES (2096)
  • GET MONITOR SWITCHES (2100)
  • GET SNAPSHOT (2104)
  • effect on UPDATE MONITOR SWITCHES (2127)
  • GET SNAPSHOT (db2GetSnapshot) (2074)
  • GET/UPDATE MONITOR SWITCHES (db2MonitorSwitches) (2078)
  • global snapshot (1193), (1254)
  • gw_comm_errors element (1954)
  • gw_comm_error_time element (1956)
  • gw_connections_top element (1910)
  • gw_cons_wait_client element (1918)
  • gw_cons_wait_host element (1916)
  • gw_con_time element (1908)
  • gw_cur_cons element (1914)
  • gw_db_alias element (1906)
  • gw_exec_time element (1920)
  • gw_total_cons element (1912)
    • H
  • hash join overflows, monitor element (1499)
  • hash join small overflows, monitor element (1501)
  • hash join threshold, monitor element (1495)
  • hash_join_overflows element (1500)
  • hash_join_small_overflows element (1502)
  • host coded character set ID, monitor element (1929)
  • host database name, monitor element (1903)
  • host product/version ID, monitor element (1361)
  • host response time, monitor element (1947)
  • host_ccsid element (1930)
  • host_db_name element (1904)
  • host_prdid element (1362)
  • host_response_time element (1948)
  • HTML
  • sample programs (2142)
    • I
  • ID of code page used by application, monitor element (1339)
  • idle agent (1424)
  • idle_agents element (1454)
  • id_info element (1974)
  • inactive_gw_agents element (1474)
  • inbound communication address, monitor element (1935)
  • inbound number of bytes received, monitor element (1937)
  • inbound number of bytes sent, monitor element (1943)
  • inbound_bytes_received element (1938)
  • inbound_bytes_sent element (1944)
  • inbound_comm_address element (1936)
  • index wizard (2179)
  • information available
  • from snapshot monitoring (1167)
  • Information Center (2161)
  • information data elements (1288)
  • input database alias, monitor element (1879)
  • input_db_alias element (1880)
  • insert response time, monitor element (1995)
  • inserts, monitor element (1977)
  • insert_sql_stmts element (1978)
  • insert_time element (1996)
  • installing
  • Netscape browser (2158)
  • instance connection (1188)
  • interface, database system monitor
  • event monitor commands (2060)
  • event monitor GUI (1218)
  • snapshot monitoring APIs (1164), (2058)
  • snapshot monitoring commands (1165), (2059)
  • snapshot monitoring GUI (1166)
  • internal automatic rebinds, monitor element (1765)
  • internal commits, monitor element (1767)
  • internal rollbacks due to deadlock, monitor element (1771)
  • internal rollbacks, monitor element (1769)
  • internal rows deleted, monitor element (1727)
  • internal rows inserted, monitor element (1731)
  • internal rows updated, monitor element (1729)
  • int_auto_rebinds element (1766)
  • int_commits element (1768)
  • int_deadlock_rollbacks element (1772)
  • int_rollbacks element (1770)
  • int_rows_deleted element (1728)
  • int_rows_inserted element (1732)
  • int_rows_updated element (1730)
  • iStoreResult (1192)
    • L
  • language identifier
  • books (2144)
  • last backup timestamp, monitor element (1333)
  • last reset timestamp, monitor element (1877)
  • last_backup element (1334)
  • last_over_flow time (1890)
  • last_reset element (1878)
  • late-breaking information (2146)
  • LIST ACTIVE DATABASES (2109)
  • LIST APPLICATIONS (2110)
  • LIST DCS APPLICATIONS (2111)
  • local connections executing in the database manager, monitor element (1433)
  • local connections, monitor element (1431)
  • local databases with current connects, monitor element (1435)
  • local_cons element (1432)
  • local_cons_in_exec (1434)
  • lock escalation, monitor element (1665)
  • lock mode requested, monitor element (1667)
  • lock mode, monitor element (1649)
  • lock node, monitor element (1657)
  • lock object name, monitor element (1655)
  • lock object type waited on, monitor element (1653)
  • lock snapshot (1177)
  • lock status, monitor element (1651)
  • lock wait start timestamp, monitor element (1681)
  • lock waits, monitor element (1669)
  • locks
  • current agents waiting on locks, monitor element (1675)
  • locks held, monitor element (1637)
  • total lock list memory in use, monitor element (1640)
  • total time unit of work waited on locks, monitor element (1678)
  • locks held, monitor element (1638)
  • locks_held element (1639)
  • locks_held_top element (1662)
  • locks_waiting (1677)
  • lock_escalation element (1666)
  • lock_escals element (1646)
  • lock_mode element (1650)
  • lock_mode_requested element (1668)
  • lock_node element (1658)
  • lock_object_name element (1656)
  • lock_object_type element (1654)
  • lock_status element (1652)
  • lock_timeouts element (1660)
  • lock_waits (1670)
  • lock_wait_start_time element (1682)
  • lock_wait_time element (1672)
  • loc_list_in_use (1642)
  • log being rolled forward, monitor element (1701)
  • log header, reading (2036)
  • log phase, monitor element (1703)
  • log stream header, reading (2035)
  • logical data groupings (2128)
  • logical view (1244)
  • log_reads element (1627)
  • log_space_used element (1632)
  • log_writes element (1629)
    • M
  • maximum agent overflows, monitor element (1471)
  • maximum database heap allocated, monitor element (1618)
  • maximum number of agents registered, monitor element (1449)
  • maximum number of agents waiting, monitor element (1451)
  • maximum number of associated agents, monitor element (1463)
  • maximum number of concurrent connections, monitor element (1391), (1909)
  • maximum number of coordinating agents, monitor element (1459)
  • maximum number of locks held, monitor element (1661)
  • maximum number of tablequeue buffers overflows, monitor element (1837)
  • maximum package cache size, monitor element (1612)
  • maximum secondary log space used, monitor element (1620)
  • maximum total log space used, monitor element (1622)
  • max_agent_overflows element (1472)
  • MA_free element (1508)
  • MA_free_bottom element (1510)
  • memory requirements (1247)
  • message anchors currently free, monitor element (1507)
  • minimum connection entries, monitor element (1513)
  • minimum fcm buffers free, monitor element (1505)
  • minimum message anchors, monitor element (1509)
  • minimum request blocks, monitor element (1517)
  • monitor switches
  • control data collected by the database manager (1146)
  • query database manager switch settings (1149)
  • setting explicitly (1147)
  • setting for a snapshot (1155)
  • setting implicitly (1148)
  • monitoring
  • levels (1144)
  • monitoring databases (2097), (2101)
  • mon_heap_sz (1246)
  • most recent connection elapsed time, monitor element (1951)
  • most recent response time for connect, monitor element (1949)
  • most recent statement elapsed time, monitor element (1800)
  • most recent unit of work elapsed time monitor element (1402)
  • multiple partition databases
  • event monitors (1255)
  • global snapshot (1252)
  • snapshot monitoring (1249)
  • subsections (1262)
  • tablequeue (1263)
    • N
  • Netscape browser
  • installing (2159)
  • node number, monitor element (1385)
  • node snapshot (1194)
  • node with least available log space, monitor element (1345)
  • nodegroup (1261)
  • node_number element (1386)
  • number of agents created, monitor element (1853)
  • number of agents working on a statement, monitor element (1851)
  • number of agents working on a subsection, monitor element (1823)
  • number of associated agents, monitor element (1469)
  • number of connections waiting for the client to send request, monitor element (1917)
  • number of connections waiting for the host to reply, monitor element (1915)
  • number of event monitor overflows, monitor element (1885)
  • number of idle agents, monitor element (1453)
  • number of lock escalations, monitor element (1645)
  • number of lock timeouts, monitor element (1659)
  • number of log pages read, monitor element (1626)
  • number of log pages written, monitor element (1628)
  • number of nodes in partition, monitor element (1883)
  • number of nodes, monitor element (1519)
  • number of open cursors, monitor element (1923)
  • number of rollforward table spaces, monitor element (1705)
  • number of rows read from tablequeues, monitor element (1833)
  • number of rows written to tablequeues, monitor element (1835)
  • number of SQL statements attempted, monitor element (1921)
  • number of successful fetches, monitor element (1806)
  • number_nodes element (1520)
  • num_agents element (1852)
  • num_assoc_agents element (1470)
  • num_compilation element (1844)
  • num_executions element (1842)
  • num_gw_conn_switches element (1476)
  • num_nodes_in_db2_instance element (1884)
  • num_subagents element (1824)
    • O
  • online help (2154)
  • online information
  • searching (2188)
  • viewing (2157)
  • open local cursors with blocking, monitor element (1747)
  • open local cursors, monitor element (1745)
  • open remote cursors with blocking, monitor element (1739)
  • open remote cursors, monitor element (1737)
  • open_cursors element (1924)
  • open_loc_curs element (1746)
  • open_loc_curs_blk element (1748)
  • open_rem_curs element (1738)
  • open_rem_curs_blk element (1740)
  • operation element (1783)
  • outbound application ID, monitor element (1363)
  • outbound blocking cursor, monitor element (1959)
  • outbound communication address, monitor element (1933)
  • outbound communication protocol, monitor element (1931)
  • outbound number of bytes received, monitor element (1941)
  • outbound number of bytes sent, monitor element (1939)
  • outbound sequence number, monitor element (1365)
  • outbound_appl_id element (1364)
  • outbound_blocking_cursor element (1960)
  • outbound_bytes_received element (1942)
  • outbound_bytes_sent element (1940)
  • outbound_comm_address element (1934)
  • outbound_comm_protocol element (1932)
  • outbound_sequence_no element (1366)
  • output format (1267)
  • output, snapshot (2056)
  • output, snapshot monitor (2043)
  • overflows, event monitor (2024)
  • overflow_accesses (1726)
    • P
  • package cache See cache
  • package cache inserts, monitor element (1608)
  • package cache lookups, monitor element (1606)
  • package cache overflows, monitor element (1610)
  • package name, monitor element (1784)
  • package_name element (1785)
  • page reorganizations, monitor element (1735)
  • page_reorgs element (1736)
  • parsing, snapshot (2051)
  • partial record, monitor element (1897)
  • partial_record element (1898)
  • pass-through time, monitor element (2003)
  • pass-through, monitor element (1985)
  • passthrus element (1986)
  • passthru_time element (2004)
  • PDF (2149)
  • performance configuration wizard (2181)
  • performance monitor, Windows NT (1283)
  • pipe event monitors
  • defining (1236)
  • overflows (1237)
  • using (1234)
  • piped sorts accepted, monitor element (1483)
  • piped sorts requested, monitor element (1481)
  • piped_sorts_accepted element (1484)
  • piped_sorts_requested element (1482)
  • pkg_cache_inserts element (1609)
  • pkg_cache_lookups (1607)
  • pkg_cache_num_overflow element (1611)
  • pkg_cache_size_top element (1613)
  • pool_async_data_reads element (1550)
  • pool_async_data_read_reqs element (1562)
  • pool_async_data_writes element (1552)
  • pool_async_index_reads element (1556)
  • pool_async_index_writes element (1554)
  • pool_async_read_time element (1558)
  • pool_async_write_time element (1560)
  • pool_data_from_estore element (1581)
  • pool_data_l_reads element (1532)
  • pool_data_p_reads element (1534)
  • pool_data_to_estore element (1577)
  • pool_data_writes element (1536)
  • pool_drty_pg_steal_clns (1566)
  • pool_drty_pg_thrsh_clns element (1568)
  • pool_index_from_estore element (1583)
  • pool_index_l_reads element (1538)
  • pool_index_p_reads element (1540)
  • pool_index_to_estore element (1579)
  • pool_index_writes element (1542)
  • pool_lsn_gap_clns element (1564)
  • pool_read_time element (1544)
  • pool_write_time element (1546)
  • post threshold sorts, monitor element (1479)
  • post_threshold_hash_joins element (1496)
  • post_threshold_sorts element (1480)
  • prefetchers (1529), (1530)
  • prefetch_wait_time element (1574)
  • prep_time_best element (1848)
  • prep_time_worst element (1846)
  • previous transaction stop time, monitor element (1409)
  • previous unit of work completion timestamp, monitor element (1396)
  • prev_stop_time element (1410)
  • prev_uow_stop_time element (1397)
  • printing PDF books (2150)
  • process or thread id, monitor element (1413)
  • product identification, monitor element (1309)
  • product name, monitor element (1307)
  • product_name element (1308)
    • Q
  • query
  • database manager monitor switch settings (1150)
  • event monitor state (1220)
  • query cost estimate, monitor element (1812)
  • query number of rows estimate, monitor element (1810)
  • query response time, monitor element (1993)
  • query_card_estimate element (1811)
  • query_cost_estimate element (1813)
    • R
  • RB_free element (1516)
  • RB_free_bottom element (1518)
  • rejected block cursor requests, monitor element (1741)
  • rej_curs_blk element (1742)
  • release notes (2147)
  • remote connections executing in the database manager, monitor element (1429)
  • remote connections to database manager, monitor element (1427)
  • remote lock time, monitor element (2007)
  • remote locks, monitor element (1989)
  • remote_locks element (1990)
  • remote_lock_time element (2008)
  • rem_cons_in element (1428)
  • rem_cons_in_exec (1430)
  • request blocks currently free, monitor element (1515)
  • RESET MONITOR (2112)
  • RESET MONITOR (sqlmrset) (2080)
  • resetting monitor data (1241)
  • restore wizard (2183)
  • rf_log_num element (1702)
  • rf_num_tspaces element (1706)
  • rf_status element (1704)
  • rf_timestamp element (1696)
  • rf_type element (1700)
  • rollback statements attempted, monitor element (1757)
  • rollback_sql_stmts (1758)
  • rolled back agent, monitor element (1691)
  • rolled back application, monitor element (1689)
  • rolled back sequence number, monitor element (1693)
  • rolled_back_agent_id element (1692)
  • rolled_back_appl_id element (1690)
  • rolled_back_sequence_no element (1694)
  • rollforward timestamp, monitor element (1695)
  • rollforward type, monitor element (1699)
  • rows deleted, monitor element (1713)
  • rows inserted, monitor element (1715)
  • rows read, monitor element (1723)
  • rows returned by stored procedures, monitor element (1991)
  • rows selected, monitor element (1719)
  • rows updated, monitor element (1717)
  • rows written, monitor element (1721)
  • rows_deleted element (1714)
  • rows_inserted element (1716)
  • rows_read element (1724)
  • rows_selected element (1720)
  • rows_updated element (1718)
  • rows_written element (1722)
    • S
  • sample programs
  • cross-platform (2141)
  • HTML (2140)
  • samples
  • event monitor trace (1203), (2014)
  • event monitoring on partitioned databases (1256)
  • lock snapshot (1157)
  • monitoring deadlocks with a lock snapshot (1197)
  • query event monitor state (1221)
  • setting switches (1240)
  • snapshots on partitioned databases (1251)
  • searching
  • online information (2162), (2187)
  • secondary connections, monitor element (1467)
  • secondary logs allocated currently, monitor element (1624)
  • section inserts, monitor element (1616)
  • section lookups, monitor element (1614)
  • section number, monitor element (1786)
  • section_number element (1787)
  • sec_logs_allocated element (1625)
  • sec_log_used_top element (1621)
  • select SQL statements executed, monitor element (1759)
  • select_sql_stmts element (1760)
  • select_time element (1994)
  • self-describing data stream (1266)
  • sequence number holding lock, monitor element (1687)
  • sequence number, monitor element (1351)
  • sequence_no element (1352)
  • sequence_no_holding_lk element (1688)
  • server instance name, monitor element (1295)
  • server operating system, monitor element (1305)
  • server product/version ID, monitor element (1299)
  • server version, monitor element (1301)
  • server_db2_type element (1298)
  • server_instance_name element (1296)
  • server_nname element (1294)
  • server_platform element (1306)
  • server_prdid element (1300)
  • server_version element (1302)
  • service level, monitor element (1303)
  • service_level element (1304)
  • SET EVENT MONITOR STATE statement (2115), (2118)
  • setting switches
  • for a monitoring application (1156)
  • setting up document server (2185)
  • size, output (1268)
  • smallest_log_avail_node element (1346)
  • SmartGuides
  • wizards (2164)
  • snapshot data elements (2130)
  • snapshot logical data groupings (2129)
  • snapshot monitor data stream (2045)
  • snapshot monitor output (2042)
  • snapshot monitoring
  • APIs (2063)
  • authority required (1161)
  • availability of data (1196)
  • commands (2062)
  • data element categories (1153)
  • definition (1151)
  • information available (1168)
  • information returned (1170)
  • interface (1163)
  • partitioned databases (1250)
  • request types (1169)
  • required connection (1189)
  • sample output (1158), (1243)
  • setting switches (1154), (1242)
  • snapshot types (1171)
  • snapshot output (2040)
  • snapshot parsing (2052)
  • snapshot request (2053)
  • snapshot request types (2039)
  • snapshot scenarios (2047)
  • snapshot time, monitor element (1881)
  • snapshot types
  • application (1182)
  • buffer pool (1186)
  • database (1181)
  • database manager (1180)
  • lock (1184)
  • table (1183)
  • table space (1185)
  • snapshot, global (1253)
  • snapshot, reading output (2055)
  • snapshots by version (2048)
  • sort overflows, monitor element (1489)
  • sort_heap_allocated element (1478)
  • sort_overflows element (1490)
  • sp_rows_selected element (1992)
  • SQL activity (1191)
  • SQL communications area (SQLCA), monitor element (1808)
  • SQL dynamic statement text, monitor element (1802)
  • SQL requests since last commit, monitor element (1773)
  • SQL statement
  • CREATE EVENT MONITOR (2065), (2068)
  • DROP (2083), (2085)
  • FLUSH EVENT MONITOR (2092), (2095)
  • SET EVENT MONITOR STATE (2116), (2119)
  • SQL syntax
  • SQLCACHE_SNAPSHOT function, results on set number pairs (2122)
  • sqlca element (1809)
  • SQLCACHE_SNAPSHOT function, detailed description (2123)
  • SQLCODE +1627W (1272)
  • sqlcode -973 (1248)
  • sqlmon.h header file (2013)
  • SQLM_ELM (2034), (2046)
  • sql_reqs_since_commit element (1774)
  • sql_stmts element (1922)
  • ss_exec_time element (1822)
  • ss_node_number element (1818)
  • ss_number element (1816)
  • ss_status element (1820)
  • ss_sys_cpu_time element (1872)
  • ss_usr_cpu_time element (1870)
  • start database manager timestamp, monitor element (1292)
  • start_time element (1799)
  • statement best preparation time, monitor element (1847)
  • statement compilations, monitor element (1843)
  • statement event monitor (1230)
  • statement execution elapsed time, monitor element (1961)
  • statement executions, monitor element (1841)
  • statement node, monitor element (1775)
  • statement operation start timestamp, monitor element (1792)
  • statement operation stop timestamp, monitor element (1794)
  • statement operation, monitor element (1781)
  • statement sorts, monitor element (1804)
  • statement type, monitor element (1779)
  • statement worst preparation time, monitor element (1845)
  • static SQL statements attempted, monitor element (1749)
  • static_sql_stmts (1750)
  • statistics
  • database manager (2105)
  • status element (1406)
  • status of database, monitor element (1325)
  • status of DB2 instance, monitor element (1311)
  • status_change_time element (1342)
  • stmt_elapsed_time element (1801)
  • stmt_node_number element (1776)
  • stmt_operations element (1782)
  • stmt_sorts element (1805)
  • stmt_start element (1793)
  • stmt_stop element (1795)
  • stmt_sys_cpu_time element (1864)
  • stmt_text element (1803)
  • stmt_type element (1780)
  • stmt_usr_cpu_time element (1862)
  • stolen agent (1425)
  • stolen agents, monitor element (1461)
  • stop_time element (1797)
  • stored procedure time, monitor element (2005)
  • stored procedures, monitor element (1987)
  • stored_procs element (1988)
  • stored_proc_time element (2006)
  • subagent (1426)
  • subsection execution elapsed time, monitor element (1821)
  • subsection node number, monitor element (1817)
  • subsection number, monitor element (1815)
  • subsection status, monitor element (1819)
  • subsections (1814)
  • definition (1259)
  • monitoring (1258)
  • tablequeue (1260)
  • switches (1145)
  • system CPU time used by agent, monitor element (1859)
  • system CPU time used by statement, monitor element (1863)
  • system CPU time used by subsection, monitor element (1871)
  • system CPU time, monitor element (1867)
  • system_cpu_time element (1868)
    • T
  • table event monitor (1232)
  • table file ID, monitor element (1733)
  • table name, monitor element (1709)
  • table schema name, monitor element (1711)
  • table snapshot (1175)
  • table space event monitor (1233)
  • table space name, monitor element (1673)
  • table space snapshot (1176)
  • table type, monitor element (1707)
  • tablequeue (1264)
  • tablespace being rolled forward, monitor element (1697)
  • tablespace_name element (1674)
  • table_file_id element (1734)
  • table_name element (1710)
  • table_schema element (1712)
  • table_type element (1708)
  • taking a snapshot (2054)
  • issuing get snapshot command (1159)
  • sample output (1160)
  • time (1290)
  • time of database connection, monitor element (1321)
  • time of first event overflow, monitor element (1887)
  • time of last event overflow, monitor element (1889)
  • time waited for prefetch, monitor element (1573)
  • time waited on locks, monitor element (1671)
  • time zone displacement, monitor element (1313)
  • timestamp (1289)
  • time_stamp element (1882)
  • time_zone_disp element (1314)
  • tools
  • control center (1276)
  • db2batch (1273)
  • db2evmon (1275)
  • db2gov (1274)
  • event analyzer (1277)
  • total buffer pool physical read time, monitor element (1543)
  • total buffer pool physical write time, monitor element (1545)
  • total fcm buffers received, monitor element (1525)
  • total fcm buffers sent, monitor element (1523)
  • total hash joins, monitor element (1493)
  • total hash loops, monitor element (1497)
  • total inactive DRDA agents, monitor element (1473)
  • total lock list memory in use, monitor element (1641)
  • total log available, monitor element (1635)
  • total log space used, monitor element (1633)
  • total number of attempted connections for DB2 Connect, monitor element (1911)
  • total number of tablequeue buffers overflowed, monitor element (1829)
  • total sort heap allocated , monitor element (1477)
  • total sort time, monitor element (1487)
  • total sorts, monitor element (1485)
  • total system CPU for a statement, monitor element (1873)
  • total time unit of work waited on locks, monitor element (1679)
  • total user CPU for a statement, monitor element (1875)
  • total_buffers_rcvd element (1526)
  • total_buffers_sent element (1524)
  • total_cons element (1438)
  • total_exec_time element (1850)
  • total_hash_joins element (1494)
  • total_hash_loops element (1498)
  • total_log_available element (1636)
  • total_log_used element (1634)
  • total_sec_cons element (1468)
  • total_sorts element (1486)
  • total_sort_time element (1488)
  • tot_log_used_top element (1623)
  • tot_s_cpu_time element (1874)
  • tot_u_cpu_time element (1876)
  • TP monitor client accounting string, monitor element (1969)
  • TP monitor client application name, monitor element (1967)
  • TP monitor client user ID, monitor element (1963)
  • TP monitor client workstation name, monitor element (1965)
  • tpmon_acc_str element (1970)
  • tpmon_client_app element (1968)
  • tpmon_client_userid element (1964)
  • tpmon_client_wkstn element (1966)
  • tq_cur_send_spills element (1832)
  • tq_id_waiting_on element (1840)
  • tq_max_send_spills element (1838)
  • tq_node_waited_for element (1828)
  • tq_rows_read element (1834)
  • tq_rows_written element (1836)
  • tq_tot_send_spills element (1830)
  • tq_wait_for_any element (1826)
  • trace
  • event monitor (1198)
  • format (2011)
  • sample (1202)
  • size (2026)
  • viewing (1205)
  • trace, event monitor (2031)
  • transaction event monitor (1231)
  • transaction ID, monitor element (1945)
  • ts_name element (1698)
  • type, output (1269)
    • U
  • uid_sql_stmts element (1762)
  • unit of work completion status, monitor element (1404)
  • unit of work log space used, monitor element (1630)
  • unit of work start timestamp, monitor element (1398)
  • unit of work status, monitor element (1407)
  • unit of work stop timestamp, monitor element (1400)
  • uow_comp_status element (1405)
  • uow_elapsed_time element (1403)
  • uow_lock_wait_time element (1680)
  • uow_log_space_used element (1631)
  • uow_start_time element (1399)
  • uow_status element (1408)
  • uow_stop_time element (1401)
  • UPDATE MONITOR SWITCHES (2124)
  • update response time, monitor element (1997)
  • update/insert/delete SQL statements executed, monitor element (1761)
  • updates, monitor element (1979)
  • update_sql_stmts element (1980)
  • update_time element (1998)
  • updating switch settings See setting switches
  • user authorization level, monitor element (1383)
  • user CPU time used by agent, monitor element (1857)
  • user CPU time used by statement, monitor element (1861)
  • user CPU time used by subsection, monitor element (1869)
  • user CPU time, monitor element (1865)
  • user login ID, monitor element (1367)
  • user_cpu_time element (1866)
    • V
  • version element (1894)
  • version of monitor data, monitor element (1893)
  • view, logical (1245)
  • viewing
  • online information (2156)
    • W
  • waited for node on a tablequeue, monitor element (1827)
  • waited on node on a tablequeue, monitor element (1839)
  • waiting for any node to send on a tablequeue, monitor element (1825)
  • water mark (1287)
  • wizard
  • restore database (2182)
  • wizards
  • add database (2166)
  • back up database (2168)
  • completing tasks (2165)
  • configure multisite update (2170)
  • create database (2172)
  • create table (2174)
  • create table space (2176)
  • index (2178)
  • performance configuration (2180)
    • X
  • xid (1946)
  • x_lock_escals element (1648)

    • [ Top of Page | Previous Page ]