System Monitor Guide and Reference
This section lists ways you can get more information from
IBM.
If you have a technical problem, please take the time to review and carry
out the actions suggested by the Troubleshooting
Guide before contacting DB2 Customer Support. Depending on the nature of your
problem or concern, this guide will suggest information you can gather to help
us to serve you better.
For information or to order any of the DB2 Universal Database products
contact an IBM representative at a local branch office or contact any
authorized IBM software remarketer.
Telephone
If you live in the U.S.A., call one of the following numbers:
- 1-800-237-5511 to learn about available service options.
- 1-800-IBM-CALL (1-800-426-2255) or 1-800-3IBM-OS2 (1-800-342-6672) to
order products or get general information.
- 1-800-879-2755 to order publications.
For information on how to contact IBM outside of the United States, see
Appendix A of the IBM Software Support Handbook. You can access this document
by selecting the "Roadmap to IBM Support" item at:
http://www.ibm.com/support/.
Note that in some countries, IBM-authorized dealers should contact
their dealer support structure instead of the IBM Support Center.
- World Wide Web
- http://www.software.ibm.com/data/
http://www.software.ibm.com/data/db2/library/
The DB2 World Wide Web pages provide current DB2 information about news,
product descriptions, education schedules, and more. The DB2 Product and
Service Technical Library provides access to frequently asked questions,
fixes, books, and up-to-date DB2 technical information. (Note
that this information may be in English only.)
- Anonymous FTP Sites
- ftp.software.ibm.com
Log on as anonymous. In the directory /ps/products/db2, you can find
demos, fixes, information, and tools concerning DB2 and many related products.
- Internet Newsgroups
- comp.databases.ibm-db2, bit.listserv.db2-l
These newsgroups are available for users to discuss their experiences with
DB2 products.
- CompuServe
- GO IBMDB2 to access the IBM DB2 Family forums
All DB2 products are supported through these forums.
To find out about the IBM Professional Certification Program for DB2
Universal Database, go to
http://www.software.ibm.com/data/db2/db2tech/db2cert.html
|
A
B
C
D
E
F
G
H
I
L
M
N
O
P
Q
R
S
T
U
V
W
X
A
B
binds/precompiles attempted, monitor element
(2756)
binds_precompiles element
(2757)
blocked event monitors
(2945)
bp_info element
(2303)
buffer overflows
pipe
(1636)
buffer pool
(2203)
buffer pool activity data elements
buffer pool asynchronous data reads
(2256)
buffer pool asynchronous data writes
(2261)
buffer pool asynchronous index reads
(2271)
buffer pool asynchronous index writes
(2266)
buffer pool asynchronous read requests
(2286)
buffer pool asynchronous read time
(2276)
buffer pool asynchronous write time
(2281)
buffer pool data logical reads
(2211)
buffer pool data physical reads
(2216)
buffer pool data writes
(2221)
buffer pool index logical reads
(2226)
buffer pool index physical reads
(2231)
buffer pool index writes
(2236)
buffer pool information
(2306)
buffer pool log space cleaners triggered
(2291)
buffer pool threshold cleaners triggered
(2301)
buffer pool victim page cleaners triggered
(2296)
database files closed
(2251)
time waited for prefetch
(2311)
total buffer pool physical read time
(2241)
total buffer pool physical write time
(2246)
buffer pool asynchronous data reads, monitor element
(2252)
buffer pool asynchronous data writes, monitor element
(2257)
buffer pool asynchronous index reads, monitor element
(2267)
buffer pool asynchronous index writes, monitor element
(2262)
buffer pool asynchronous read requests, monitor element
(2282)
buffer pool asynchronous read time, monitor element
(2272)
buffer pool asynchronous write time, monitor element
(2277)
buffer pool data logical reads, monitor element
(2207)
buffer pool data pages from extended storage, monitor element
(2323)
buffer pool data pages to extended storage, monitor element
(2313)
buffer pool data physical reads, monitor element
(2212)
buffer pool data writes, monitor element
(2217)
buffer pool event monitor
(1626)
buffer pool hit ratio
(2204)
buffer pool index logical reads, monitor element
(2222)
buffer pool index pages from extended storage, monitor element
(2328)
buffer pool index pages to extended storage, monitor element
(2318)
buffer pool index physical reads, monitor element
(2227)
buffer pool index writes, monitor element
(2232)
buffer pool information, monitor element
(2302)
buffer pool log space cleaners triggered, monitor element
(2287)
buffer pool snapshot
(1581)
buffer pool threshold cleaners triggered, monitor element
(2297)
buffer pool victim page cleaners triggered, monitor element
(2292)
buffering, event monitor
(2944)
buff_free element
(2132)
buff_free_bottom element
(2138)
C
cache
catalog
(2363)
package
(2384)
capabilities, monitoring
activity monitoring
(1544)
performance analysis
(1546)
problem determination
(1545)
system configuration
(1548)
catalog cache
See cache
catalog cache data elements
catalog cache heap full
(2383)
catalog cache inserts
(2373)
catalog cache lookups
(2368)
catalog cache overflows
(2378)
catalog cache heap full, monitor element
(2379)
catalog cache inserts, monitor element
(2369)
catalog cache lookups, monitor element
(2364)
catalog cache overflows, monitor element
(2374)
catalog node network name, monitor element
(1762)
catalog node number, monitor element
(1772)
catalog_node element
(1773)
catalog_node_name element
(1763)
cat_cache_heap_full element
(2380)
cat_cache_inserts element
(2370)
cat_cache_lookups element
(2365)
cat_cache_overflows element
(2375)
CE_free element
(2156)
CE_free_bottom element
(2162)
client communication protocol, monitor element
(1874)
client operating platform, monitor element
(1869)
client process ID, monitor element
(1864)
client product/version ID, monitor element
(1827)
client_db_alias element
(1833)
client_nname element
(1823)
client_pid element
(1865)
client_platform element
(1870)
client_prdid element
(1828)
client_protocol element
(1875)
codepage_id element
(1793)
commit statements attempted, monitor element
(2701)
committed private memory, monitor element
(2071)
commit_sql_stmts element
(2702)
comm_private_mem element
(2072)
component_id element
(1727)
configuration NNAME of client, monitor element
(1822)
configuration NNAME at monitoring (server) node, monitor element
(1686)
connection data elements
See application status data elements
connection entries currently free, monitor element
(2155)
connection for snapshot
(1590)
connection information
(1582)
connection request completion timestamp, monitor element
(1910)
connection request start timestamp, monitor element
(1904)
connection status, monitor element
(2185)
connections event monitor
(1627)
connections involved in deadlock, monitor element
(2499)
connection_status element
(2186)
connects since first database connect, monitor element
(1993)
conn_complete_time element
(1911)
con_local_dbases
(1988)
coordinating node, monitor element
(1899)
coordinator agent
(1665), (1959)
coord_agents_top element
(2055)
coord_node element
(1900)
corr_token element
(1858)
counters
(1637), (1675)
country_code element
(1880)
CPU time used, monitor element
(2906)
cpu usage data elements
CPU time used
(2917)
CREATE EVENT MONITOR statement
(2963)
creating an event monitor
(1608)
creator element
(2789)
current agents waiting on locks, monitor element
(2520)
current number of tablequeue buffers overflowed, monitor element
(2876)
cursor name, monitor element
(2783)
cursor_name element
(2784)
D
data definition language (DDL) SQL statements, monitor element
(2721)
data element
definition
(1670)
types
(1674)
data elements (by API element name)
(1862)
acc_curs_blk
(2673)
active_sorts
(2127)
agents_created_empty_pool
(2050)
agents_from_pool
(2044)
agents_registered
(2015)
agents_registered_top
(2027)
agents_stolen
(2061)
agents_top
(2898)
agents_waiting_on_token
(2021)
agents_waiting_top
(2033)
agent_id
(1784)
agent_id_holding_lock
(2538)
agent_pid
(1949)
agent_sys_cpu_time
(2909)
agent_usr_cpu_time
(2908)
appli_id_holding_lk
(2543)
appls_cur_con
(2002)
appls_in_db2
(2009)
appl_con_time
(1906)
appl_id
(1809)
appl_idle_time
(1944)
appl_name
(1804)
appl_priority
(1886)
appl_priority_type
(1891)
appl_section_inserts
(2402)
appl_section_lookups
(2397)
appl_status
(1789)
associated_agents_top
(2067)
authority_lvl
(1896)
auth_id
(1819)
binds_precompiles
(2758)
bp_info
(2304)
buff_free
(2133)
buff_free_bottom
(2139)
catalog_node
(1774)
catalog_node_name
(1764)
cat_cache_heap_full
(2381)
cat_cache_inserts
(2371)
cat_cache_lookups
(2366)
cat_cache_overflows
(2376)
CE_free
(2157)
CE_free_bot
(2163)
client_db_alias
(1834)
client_nname
(1824)
client_pid
(1866)
client_platform
(1871)
client_prdid
(1829)
client_protocol
(1876)
codepage_id
(1794)
commit_sql_stmts
(2703)
comm_private_mem
(2073)
component_id
(1728)
connection_status
(2187)
conn_complete_time
(1912)
conn_time
(1749)
con_local_dbases
(1989)
coord_agents_top
(2056)
coord_node
(1901)
corr_token
(1859)
country_code
(1881)
creator
(2790)
cursor_name
(2785)
db2start_time
(1683)
db2_status
(1733)
db_conn_time
(1748)
db_heap_top
(2407)
db_location
(1769)
db_name
(1738)
db_path
(1743)
db_status
(1759)
ddl_sql_stmts
(2723)
deadlocks
(2456)
degree_parallelism
(2903)
direct_reads
(2335)
direct_read_reqs
(2345)
direct_read_time
(2355)
direct_writes
(2340)
direct_write_reqs
(2350)
direct_write_time
(2360)
disconn_time
(1754)
dl_conns
(2501)
dynamic_sql_stmts
(2693)
execution_id
(1854)
failed_sql_stmts
(2698)
fetch_count
(2817)
files_closed
(2249)
host_prdid
(1839)
idle_agents
(2038)
input_db_alias
(2925)
int_auto_rebinds
(2728)
int_commits
(2733)
int_deadlock_rollbacks
(2743)
int_rollbacks
(2738)
int_rows_deleted
(2638)
int_rows_inserted
(2648)
int_rows_updated
(2643)
last_backup
(1779)
last_reset
(2920)
local_cons
(1977)
local_cons_in_exec
(1983)
locks_held
(2445)
locks_held_top
(2496)
locks_waiting
(2522)
lock_escals
(2461)
lock_list_in_use
(2451)
lock_mode
(2471)
lock_object_name
(2486)
lock_object_type
(2481)
lock_status
(2476)
lock_timeouts
(2491)
lock_waits
(2506)
lock_wait_start_time
(2533)
lock_wait_time
(2511)
log_reads
(2427)
log_space_used
(2439)
log_writes
(2432)
MA_free
(2145)
MA_free_bot
(2151)
number_nodes
(2181)
num_agents
(2893)
num_subagents
(2858)
open_loc_curs
(2678)
open_loc_curs_blk
(2683)
open_rem_curs
(2658)
open_rem_curs_blk
(2663)
operation
(2770)
outbound_appl_id
(1844)
outbound_sequence_no
(1849)
overflow_accesses
(2633)
package_name
(2775)
piped_sorts_accepted
(2103)
piped_sorts_requested
(2097)
pkg_cache_inserts
(2392)
pkg_cache_lookups
(2387)
pool_async_data_reads
(2254)
pool_async_data_read_reqs
(2284)
pool_async_data_writes
(2259)
pool_async_index_reads
(2269)
pool_async_index_writes
(2264)
pool_async_read_time
(2274)
pool_async_write_time
(2279)
pool_data_from_estore
(2325)
pool_data_l_reads
(2209)
pool_data_p_reads
(2214)
pool_data_to_estore
(2315)
pool_data_writes
(2219)
pool_drty_pg_steal_clns
(2294)
pool_drty_pg_thrsh_clns
(2299)
pool_index_from_estore
(2330)
pool_index_l_reads
(2224)
pool_index_p_reads
(2229)
pool_index_to_estore
(2320)
pool_index_writes
(2234)
pool_lsn_gap_clns
(2289)
pool_read_time
(2239)
pool_write_time
(2244)
post_threshold_sorts
(2091)
prefetch_wait_time
(2309)
prev_stop_time
(1939)
prev_uow_stop_time
(1917)
product_name
(1723)
query_card_estimate
(2827)
query_cost_estimate
(2832)
RB_free
(2169)
RB_free_bot
(2175)
rej_curs_blk
(2668)
rem_cons_in
(1965)
rem_cons_in_exec
(1971)
rf_log_num
(2573)
rf_num_tspaces
(2583)
rf_status
(2578)
rf_timestamp
(2558)
rf_type
(2568)
rollback_sql_stmts
(2708)
rolled_back_appl_id
(2553)
rows_deleted
(2603)
rows_inserted
(2608)
rows_read
(2628)
rows_selected
(2618)
rows_updated
(2613)
rows_written
(2623)
section_number
(2780)
sec_logs_allocated
(2422)
sec_log_used_top
(2412)
select_sql_stmts
(2713)
sequence_no
(1814)
sequence_no_holding_lk
(2548)
server_db2_type
(1698)
server_instance_name
(1693)
server_nname
(1688)
server_platform
(1718)
server_prdid
(1703)
server_version
(1708)
service_level
(1713)
sort_heap_allocated
(2085)
sort_overflows
(2121)
sqlca
(2822)
sql_reqs_since_commit
(2748)
ss_exec_time
(2853)
ss_node_number
(2843)
ss_number
(2838)
ss_status
(2848)
ss_sys_cpu_time
(2913)
ss_usr_cpu_time
(2912)
static_sql_stmts
(2688)
status
(1934)
status_change_time
(1799)
stmt_node_number
(2753)
stmt_operation
(2769)
stmt_sorts
(2812)
stmt_start
(2795)
stmt_stop
(2801)
stmt_sys_cpu_time
(2911)
stmt_text
(2807)
stmt_type
(2763)
stmt_usr_cpu_time
(2910)
stop_time
(2802)
system_cpu_time
(2915)
tablespace_name
(2516)
table_file_id
(2653)
table_name
(2593)
table_schema
(2598)
table_type
(2588)
time_stamp
(2930)
total_buffers_rcvd
(2199)
total_buffers_sent
(2193)
total_cons
(1995)
total_sec_cons
(2079)
total_sorts
(2109)
total_sort_time
(2115)
tot_log_used_top
(2417)
tq_cur_send_spills
(2878)
tq_node_waited_for
(2868)
tq_rows_read
(2883)
tq_rows_written
(2888)
tq_tot_send_spills
(2873)
tq_wait_for_any
(2863)
ts_name
(2563)
uid_sql_stmts
(2718)
uow_comp_status
(1933)
uow_lock_wait_time
(2528)
uow_log_space_used
(2438)
uow_start_time
(1922)
uow_stop_time
(1927)
user_cpu_time
(2914)
x_lock_escals
(2466)
data elements (by name)
(1863)
accepted block cursor requests
(2674)
accesses to overflowed records
(2634)
active sorts
(2128)
agent ID holding lock
(2539)
agents assigned from pool
(2045)
agents created due to empty agent pool
(2051)
agents registered
(2016)
agents waiting for a token
(2022)
application agent priority
(1887)
application creator
(2791)
application handle (agent ID)
(1785)
application ID
(1810)
application ID holding lock
(2544)
application idle time
(1945)
application name
(1805)
application priority type
(1892)
application status
(1790)
application status change time
(1800)
applications connected currently
(2003)
applications executing in the database currently
(2010)
authorization ID
(1820)
binds/precompiles attempted
(2759)
buffer pool asynchronous data reads
(2255)
buffer pool asynchronous data writes
(2260)
buffer pool asynchronous index reads
(2270)
buffer pool asynchronous index writes
(2265)
buffer pool asynchronous read requests
(2285)
buffer pool asynchronous read time
(2275)
buffer pool asynchronous write time
(2280)
buffer pool data logical reads
(2210)
buffer pool data pages from extended storage
(2326)
buffer pool data pages to extended storage
(2316)
buffer pool data physical reads
(2215)
buffer pool data writes
(2220)
buffer pool index logical reads
(2225)
buffer pool index pages from extended storage
(2331)
buffer pool index pages to extended storage
(2321)
buffer pool index physical reads
(2230)
buffer pool index writes
(2235)
buffer pool information
(2305)
buffer pool log space cleaners triggered
(2290)
buffer pool threshold cleaners triggered
(2300)
buffer pool victim page cleaners triggered
(2295)
catalog cache heap full
(2382)
catalog cache inserts
(2372)
catalog cache lookups
(2367)
catalog cache overflows
(2377)
catalog node network name
(1765)
catalog node number
(1775)
client communication protocol
(1877)
client operating platform
(1872)
client process ID
(1867)
client product/version ID
(1830)
commit statements attempted
(2704)
committed private memory
(2074)
configuration NNAME of client
(1825)
configuration NNAME at monitoring (server) node
(1689)
connection entries currently free
(2158)
connection request completion timestamp
(1913)
connection request start timestamp
(1907)
connection status
(2188)
connections involved in deadlock
(2502)
connects since first database connect
(1996)
coordinating node
(1902)
CPU time used
(2916)
current agents waiting on locks
(2523)
current number of tablequeue buffers overflowed
(2879)
cursor name
(2786)
data definition language (DDL) SQL statements
(2724)
database activation timestamp
(1750)
database alias used by application
(1835)
database country code
(1882)
database deactivation timestamp
(1755)
database files closed
(2250)
database location
(1770)
database manager type at monitored (server) node
(1699)
database name
(1739)
database path
(1744)
deadlocks detected
(2457)
degree of parallelism
(2904)
direct read requests
(2346)
direct read time
(2356)
direct reads from database
(2336)
direct write requests
(2351)
direct write time
(2361)
direct writes to database
(2341)
drda correlation token
(1860)
dynamic SQL statements attempted
(2694)
exclusive lock escalations
(2467)
execution elapsed time
(2854)
failed statement operations
(2699)
fcm buffers currently free
(2134)
host product/version ID
(1840)
ID of code page used by application
(1795)
input database alias
(2926)
internal automatic rebinds
(2729)
internal commits
(2734)
internal rollbacks
(2739)
internal rollbacks due to deadlock
(2744)
internal rows deleted
(2639)
internal rows inserted
(2649)
internal rows updated
(2644)
last backup timestamp
(1780)
last reset timestamp
(2921)
local connections
(1978)
local connections executing in the database manager
(1984)
local databases with current connects
(1990)
lock escalations
(2462)
lock mode
(2472)
lock object name
(2487)
lock object type waited on
(2482)
lock status
(2477)
lock wait start timestamp
(2534)
lock waits
(2507)
locks held
(2446)
log being rolled forward
(2574)
log phase
(2579)
maximum database heap allocated
(2408)
maximum number of agents registered
(2028)
maximum number of agents waiting
(2034)
maximum number of associated agents
(2068)
maximum number of coordinating agents
(2057)
maximum number of locks held
(2497)
maximum secondary log space used
(2413)
maximum total log space used
(2418)
message anchors currently free
(2146)
minimum connection entries
(2164)
minimum fcm buffers free
(2140)
minimum message anchors
(2152)
minimum request blocks
(2176)
number of agents created
(2899)
number of agents working on a statement
(2894)
number of agents working on a subsection
(2859)
number of idle agents
(2039)
number of lock timeouts
(2492)
number of log pages read
(2428)
number of log pages written
(2433)
number of nodes
(2182)
number of rollforward table spaces
(2584)
number of rows read from tablequeues
(2884)
number of rows written to tablequeues
(2889)
number of successful fetches
(2818)
open local cursors
(2679)
open local cursors with blocking
(2684)
open remote cursors
(2659)
open remote cursors with blocking
(2664)
outbound application ID
(1845)
outbound sequence number
(1850)
package cache inserts
(2393)
package cache lookups
(2388)
package name
(2776)
piped sorts accepted
(2104)
piped sorts requested
(2098)
post threshold sorts
(2092)
previous transaction stop time
(1940)
previous unit of work completion timestamp
(1918)
process or thread id
(1950)
product identification
(1729)
product name
(1724)
query cost estimate
(2833)
query number of rows estimate
(2828)
rejected block cursor requests
(2669)
remote connections executing in the database manager
(1972)
remote connections to database manager
(1966)
request blocks currently free
(2170)
rollback statements attempted
(2709)
rolled back application
(2554)
rollforward timestamp
(2559)
rollforward type
(2569)
rows deleted
(2604)
rows inserted
(2609)
rows read
(2629)
rows selected
(2619)
rows updated
(2614)
rows written
(2624)
secondary connections
(2080)
secondary logs allocated currently
(2423)
section inserts
(2403)
section lookups
(2398)
section number
(2781)
select SQL statements executed
(2714)
sequence number
(1815)
sequence number holding lock
(2549)
server instance name
(1694)
server operating system
(1719)
server product/version ID
(1704)
server version
(1709)
service level
(1714)
snapshot time
(2931)
sort overflows
(2122)
SQL communications area (SQLCA)
(2823)
SQL dynamic statement text
(2808)
SQL requests since last commit
(2749)
start database manager timestamp
(1684)
statement node
(2754)
statement operation
(2771)
statement operation start timestamp
(2796)
statement operation stop timestamp
(2803)
statement sorts
(2813)
statement type
(2764)
static SQL statements attempted
(2689)
status of database
(1760)
status of DB2 instance
(1734)
stolen agents
(2062)
subsection node number
(2844)
subsection number
(2839)
subsection status
(2849)
table file ID
(2654)
table name
(2594)
table schema name
(2599)
table space name
(2517)
table type
(2589)
tablespace being rolled forward
(2564)
time waited for prefetch
(2310)
time waited on locks
(2512)
total buffer pool physical read time
(2240)
total buffer pool physical write time
(2245)
total fcm buffers received
(2200)
total fcm buffers sent
(2194)
total lock list memory in use
(2452)
total number of tablequeue buffers overflowed
(2874)
total sort heap allocated
(2086)
total sort time
(2116)
total sorts
(2110)
total time unit of work waited on locks
(2529)
unit of work completion status
(1935)
Unit of Work log space used
(2440)
unit of work start timestamp
(1923)
unit of work stop timestamp
(1928)
update/insert/delete SQL statements executed
(2719)
user authorization level>
(1897)
user login ID
(1855)
waited for node on a tablequeue
(2869)
waiting for any node to send on a tablequeue
(2864)
database
information
(2992)
monitor, resetting
(2997)
database activation timestamp, monitor element
(1746)
database alias used by application, monitor element
(1832)
database connection
applications connected currently, monitor element
(1999)
applications executing in the database currently, monitor element
(2006)
connection request completion timestamp, monitor element
(1909)
database country code, monitor element
(1879)
database deactivation timestamp, monitor element
(1752)
database event monitor
(1625)
database files closed, monitor element
(2247)
database heap data elements
maximum database heap allocated
(2409)
database identification data elements
catalog node network name
(1766)
catalog node number
(1776)
database activation timestamp
(1751)
database deactivation timestamp
(1756)
database location
(1771)
database name
(1740)
database path
(1745)
last backup timestamp
(1781)
status of database
(1761)
database location, monitor element
(1767)
database manager
monitor switches, checking
(2982), (2986)
statistics
(2990)
database manager configuration data elements
active sorts
(2129)
agents assigned from pool
(2046)
agents registered
(2017)
agents waiting for a token
(2023)
applications connected currently
(2004)
applications executing in the database currently
(2011)
committed private memory
(2075)
connection entries currently free
(2159)
connection status
(2189)
connects since first database connect
(1997)
fcm buffers currently free
(2135)
local connections
(1979)
local connections executing in the database manager
(1985)
local databases with current connects
(1991)
maximum number of agents registered
(2029)
maximum number of agents waiting
(2035)
maximum number of associated agents
(2069)
maximum number of coordinating agents
(2052)
message anchors currently free
(2147)
minimum connection entries
(2165)
minimum fcm buffers free
(2141)
minimum message anchors
(2153)
minimum request blocks
(2177)
number of idle agents
(2040)
number of nodes
(2183)
piped sorts accepted
(2105)
piped sorts requested
(2099)
post threshold sorts
(2093)
remote connections executing in the database manager
(1973)
remote connections to database manager
(1967)
request blocks currently free
(2171)
secondary connections
(2081)
sort overflows
(2123)
stolen agents
(2063)
total fcm buffers received
(2201)
total fcm buffers sent
(2195)
total sort heap allocated
(2087)
total sort time
(2117)
total sorts
(2111)
database manager snapshot
(1575)
database manager type at monitored (server) node, monitor element
(1696)
database monitor
description
(3008)
database name, monitor element
(1736)
database path, monitor element
(1741)
database snapshot
(1576)
database status data elements
See database identification data elements
Database System Monitor
database system monitor
GET DATABASE MANAGER MONITOR SWITCHES
(2983)
GET MONITOR SWITCHES
(2987)
GET SNAPSHOT
(2991)
RESET MONITOR
(2998)
UPDATE MONITOR SWITCHES
(3009)
db2 explain
(1547)
db2batch
(1666)
db2eva
(1602), (1614), (2968)
db2evmon
(1615), (1668), (2970)
db2gov
(1667)
db2start_time element
(1681)
db2_status
(1732)
db_conn_time element
(1747)
db_heap_top element
(2406)
db_location element
(1768)
db_name element
(1737)
db_path element
(1742)
db_status element
(1758)
ddl_sql_stmts element
(2722)
deadlock event monitor
(1624)
deadlocks data elements
See locks and deadlocks data elements
deadlocks detected, monitor element
(2454)
deadlocks element
(2455)
degree of parallelism, monitor element
(2901)
degree_parallelism element
(2902)
direct read requests, monitor element
(2343)
direct read time, monitor element
(2353)
direct reads from database, monitor element
(2333)
direct write requests, monitor element
(2348)
direct write time, monitor element
(2358)
direct writes to database, monitor element
(2338)
direct_reads element
(2334)
direct_read_reqs element
(2344)
direct_read_time element
(2354)
direct_writes element
(2339)
direct_write_reqs element
(2349)
direct_write_time element
(2359)
disconn_time element
(1753)
dl_conns element
(2500)
drda correlation token, monitor element
(1857)
DROP statement
(2971), (2975)
dynamic SQL statements attempted, monitor element
(2691)
dynamic_sql_stmts element
(2692)
E
ESTIMATE SIZE REQUIRED FOR sqlmonss() OUTPUT BUFFER (sqlmonsz)
(3005)
event analyzer
(1669)
See also db2eva
event analyzer command
(2967)
event monitor
CREATE EVENT MONITOR statement
(2965)
DROP statement
(2973)
EVENT_MON_STATE function
(2978)
SET EVENT MONITOR STATE statement
(3001)
event monitor trace formatter
(2969)
event monitors
activating
(1609)
authority required
(1605)
autostarting
(1612)
blocked
(2946)
buffering
(2941)
creating
(1607)
definition
(1555), (1617)
disk space
(2951), (2960)
event types
(1621)
example of deadlock monitoring
(1599)
file event monitors
(2942)
information available
(1622)
matching to application
(2940)
non-blocked
(2947)
output
(2933)
partitioned databases
(1652)
pipe event monitors
(1633)
processing data
(2952)
reading the trace
(1613)
restarting
(2953)
target
(2949), (2954)
trace
(1598), (2934)
using
(1606)
when written
(1597), (1620)
event types
(1623)
EVENT_MON_STATE function
(2979)
exclusive lock escalations, monitor element
(2464)
execution elapsed time, monitor element
(2851)
execution_id element
(1853)
extended storage
(2312)
extended storage data elements
buffer pool data pages from extended storage
(2327)
buffer pool data pages to extended storage
(2317)
buffer pool index pages from extended storage
(2332)
buffer pool index pages to extended storage
(2322)
F
failed statement operations, monitor element
(2696)
failed_sql_stmts element
(2697)
fast communication manager data elements
connection entries currently free
(2160)
connection status
(2190)
fcm buffers currently free
(2136)
message anchors currently free
(2148)
minimum connection entries
(2166)
minimum fcm buffers free
(2142)
minimum message anchors
(2154)
minimum request blocks
(2178)
number of nodes
(2184)
request blocks currently free
(2172)
total fcm buffers received
(2202)
total fcm buffers sent
(2196)
fcm buffers currently free, monitor element
(2131)
fetch_count element
(2816)
file event monitors
(2943)
files_closed element
(2248)
function
EVENT_MON_STATE
(2977)
EVENT_MON_STATE, returning event monitor states
(2976)
G
gauges
(1676)
GET DATABASE MANAGER MONITOR SWITCHES
(2980)
GET MONITOR SWITCHES
(2984)
GET SNAPSHOT
(2988)
effect on UPDATE MONITOR SWITCHES
(3010)
GET SNAPSHOT (sqlmonss)
(3004)
GET/UPDATE MONITOR SWITCHES (sqlmon)
(3003)
H
host product/version ID, monitor element
(1837)
host_prdid element
(1838)
I
ID of code page used by application, monitor element
(1792)
idle agent
(1960)
idle_agents element
(2037)
information available
from snapshot monitoring
(1570)
information data elements
(1678)
input database alias, monitor element
(2923)
input_db_alias element
(2924)
instance connection
(1591)
interface, database system monitor
event monitor commands
(2959)
event monitor GUI
(1616)
snapshot monitoring APIs
(1567), (2957)
snapshot monitoring commands
(1568), (2958)
snapshot monitoring GUI
(1569)
internal automatic rebinds, monitor element
(2726)
internal commits, monitor element
(2731)
internal rollbacks due to deadlock, monitor element
(2741)
internal rollbacks, monitor element
(2736)
internal rows deleted, monitor element
(2636)
internal rows inserted, monitor element
(2646)
internal rows updated, monitor element
(2641)
intra-query parallelism data elements
degree of parallelism
(2905)
number of agents created
(2900)
number of agents working on a statement
(2895)
int_auto_rebinds element
(2727)
int_commits element
(2732)
int_deadlock_rollbacks element
(2742)
int_rollbacks element
(2737)
int_rows_deleted element
(2637)
int_rows_inserted element
(2647)
int_rows_updated element
(2642)
L
last backup timestamp, monitor element
(1777)
last reset timestamp, monitor element
(2918)
last_backup element
(1778)
last_reset element
(2919)
LIST ACTIVE DATABASES
(2993)
LIST APPLICATIONS
(2994)
LIST DCS APPLICATIONS
(2995)
local connections executing in the database manager, monitor element
(1981)
local connections, monitor element
(1975)
local databases with current connects, monitor element
(1987)
local_cons element
(1976)
local_cons_in_exec
(1982)
lock escalations, monitor element
(2459)
lock mode, monitor element
(2469)
lock object name, monitor element
(2484)
lock object type waited on, monitor element
(2479)
lock snapshot
(1580)
lock status, monitor element
(2474)
lock wait data elements
agent ID holding lock
(2540)
application ID holding lock
(2545)
current agents waiting on locks
(2524)
lock wait start timestamp
(2535)
lock waits
(2508)
rolled back application
(2555)
sequence number holding lock
(2550)
table space name
(2518)
time waited on locks
(2513)
total time unit of work waited on locks
(2530)
lock wait start timestamp, monitor element
(2531)
lock waits, monitor element
(2504)
locks
current agents waiting on locks, monitor element
(2519)
locks held, monitor element
(2442)
total lock list memory in use, monitor element
(2448)
total time unit of work waited on locks, monitor element
(2525)
locks and deadlocks data elements
connections involved in deadlock
(2503)
deadlocks detected
(2458)
exclusive lock escalations
(2468)
lock escalations
(2463)
lock mode
(2473)
lock object name
(2488)
lock object type waited on
(2483)
lock status
(2478)
locks held
(2447)
maximum number of locks held
(2498)
number of lock timeouts
(2493)
total lock list memory in use
(2453)
locks held, monitor element
(2443)
locks_held element
(2444)
locks_held_top element
(2495)
locks_waiting
(2521)
lock_escals element
(2460)
lock_mode element
(2470)
lock_object_name element
(2485)
lock_object_type element
(2480)
lock_status element
(2475)
lock_timeouts element
(2490)
lock_waits
(2505)
lock_wait_start_time element
(2532)
lock_wait_time element
(2510)
loc_list_in_use
(2450)
log being rolled forward, monitor element
(2571)
log phase, monitor element
(2576)
logging data elements
maximum secondary log space used
(2414)
maximum total log space used
(2419)
number of log pages read
(2429)
number of log pages written
(2434)
secondary logs allocated currently
(2424)
Unit of Work log space used
(2441)
logical view
(1642)
log_reads element
(2426)
log_space_used element
(2437)
log_writes element
(2431)
M
maximum database heap allocated, monitor element
(2405)
maximum number of agents registered, monitor element
(2025)
maximum number of agents waiting, monitor element
(2031)
maximum number of associated agents, monitor element
(2065)
maximum number of coordinating agents, monitor element
(2054)
maximum number of locks held, monitor element
(2494)
maximum secondary log space used, monitor element
(2410)
maximum total log space used, monitor element
(2415)
MA_free element
(2144)
MA_free_bottom element
(2150)
memory requirements
(1645)
message anchors currently free, monitor element
(2143)
minimum connection entries, monitor element
(2161)
minimum fcm buffers free, monitor element
(2137)
minimum message anchors, monitor element
(2149)
minimum request blocks, monitor element
(2173)
monitor switches
query database manager switch settings
(1552)
setting explicitly
(1550)
setting for a snapshot
(1558)
setting implicitly
(1551)
monitored level
(1671)
monitored object
(1672)
monitoring
levels
(1549)
monitoring application
(1673)
monitoring databases
(2981), (2985)
mon_heap_sz
(1644)
multiple partition databases
event monitors
(1650)
snapshot monitoring
(1647)
subsections
(1657)
tablequeue
(1658)
N
nodegroup
(1656)
non-buffer I/O activity data elements
direct read requests
(2347)
direct read time
(2357)
direct reads from database
(2337)
direct write requests
(2352)
direct write time
(2362)
direct writes to database
(2342)
number of agents created, monitor element
(2896)
number of agents working on a statement, monitor element
(2891)
number of agents working on a subsection, monitor element
(2856)
number of idle agents, monitor element
(2036)
number of lock timeouts, monitor element
(2489)
number of log pages read, monitor element
(2425)
number of log pages written, monitor element
(2430)
number of nodes, monitor element
(2179)
number of rollforward table spaces, monitor element
(2581)
number of rows read from tablequeues, monitor element
(2881)
number of rows written to tablequeues, monitor element
(2886)
number of successful fetches, monitor element
(2815)
number_nodes element
(2180)
num_agents element
(2892)
num_subagents element
(2857)
O
open local cursors with blocking, monitor element
(2681)
open local cursors, monitor element
(2676)
open remote cursors with blocking, monitor element
(2661)
open remote cursors, monitor element
(2656)
open_loc_curs element
(2677)
open_loc_curs_blk element
(2682)
open_rem_curs element
(2657)
open_rem_curs_blk element
(2662)
operation element
(2768)
outbound application ID, monitor element
(1842)
outbound sequence number, monitor element
(1847)
outbound_appl_id element
(1843)
outbound_sequence_no element
(1848)
overflows, event monitor
(2948)
overflow_accesses
(2632)
P
package cache
See cache
package cache data elements
package cache inserts
(2394)
package cache lookups
(2389)
section inserts
(2404)
section lookups
(2399)
package cache inserts, monitor element
(2390)
package cache lookups, monitor element
(2385)
package name, monitor element
(2773)
package_name element
(2774)
pipe event monitors
defining
(1634)
overflows
(1635)
using
(1632)
piped sorts accepted, monitor element
(2101)
piped sorts requested, monitor element
(2095)
piped_sorts_accepted element
(2102)
piped_sorts_requested element
(2096)
pkg_cache_inserts element
(2391)
pkg_cache_lookups
(2386)
pool_async_data_reads element
(2253)
pool_async_data_read_reqs element
(2283)
pool_async_data_writes element
(2258)
pool_async_index_reads element
(2268)
pool_async_index_writes element
(2263)
pool_async_read_time element
(2273)
pool_async_write_time element
(2278)
pool_data_from_estore element
(2324)
pool_data_l_reads element
(2208)
pool_data_p_reads element
(2213)
pool_data_to_estore element
(2314)
pool_data_writes element
(2218)
pool_drty_pg_steal_clns
(2293)
pool_drty_pg_thrsh_clns element
(2298)
pool_index_from_estore element
(2329)
pool_index_l_reads element
(2223)
pool_index_p_reads element
(2228)
pool_index_to_estore element
(2319)
pool_index_writes element
(2233)
pool_lsn_gap_clns element
(2288)
pool_read_time element
(2238)
pool_write_time element
(2243)
post threshold sorts, monitor element
(2089)
post_threshold_sorts element
(2090)
prefetchers
(2205), (2206)
prefetch_wait_time element
(2308)
previous transaction stop time, monitor element
(1937)
previous unit of work completion timestamp, monitor element
(1915)
prev_stop_time element
(1938)
prev_uow_stop_time element
(1916)
process or thread id, monitor element
(1947)
product identification, monitor element
(1726)
product name, monitor element
(1721)
product_name element
(1722)
Q
query
database manager monitor switch settings
(1553)
event monitor state
(1618)
query cost estimate, monitor element
(2830)
query number of rows estimate, monitor element
(2825)
query_card_estimate element
(2826)
query_cost_estimate element
(2831)
R
RB_free element
(2168)
RB_free_bottom element
(2174)
rejected block cursor requests, monitor element
(2666)
rej_curs_blk element
(2667)
remote connections executing in the database manager, monitor element
(1969)
remote connections to database manager, monitor element
(1963)
rem_cons_in element
(1964)
rem_cons_in_exec
(1970)
request blocks currently free, monitor element
(2167)
RESET MONITOR
(2996)
RESET MONITOR (sqlmrset)
(3006)
resetting monitor data
(1639)
rf_log_num element
(2572)
rf_num_tspaces element
(2582)
rf_status element
(2577)
rf_timestamp element
(2557)
rf_type element
(2567)
rollback statements attempted, monitor element
(2706)
rollback_sql_stmts
(2707)
rolled back application, monitor element
(2551)
rolled_back_appl_id element
(2552)
rollforward data elements
log being rolled forward
(2575)
log phase
(2580)
number of rollforward table spaces
(2585)
rollforward timestamp
(2560)
rollforward type
(2570)
tablespace being rolled forward
(2565)
rollforward timestamp, monitor element
(2556)
rollforward type, monitor element
(2566)
rows deleted, monitor element
(2601)
rows inserted, monitor element
(2606)
rows read, monitor element
(2626)
rows selected, monitor element
(2616)
rows updated, monitor element
(2611)
rows written, monitor element
(2621)
rows_deleted element
(2602)
rows_inserted element
(2607)
rows_read element
(2627)
rows_selected element
(2617)
rows_updated element
(2612)
rows_written element
(2622)
S
samples
event monitor trace
(1601), (2938)
event monitoring on partitioned databases
(1651)
lock snapshot
(1560)
monitoring deadlocks with a lock snapshot
(1595)
programming to read the data stream
(2956)
query event monitor state
(1619)
setting switches
(1638)
snapshots on partitioned databases
(1649)
secondary connections, monitor element
(2077)
secondary logs allocated currently, monitor element
(2420)
section inserts, monitor element
(2400)
section lookups, monitor element
(2395)
section number, monitor element
(2778)
section_number element
(2779)
sec_logs_allocated element
(2421)
sec_log_used_top element
(2411)
select SQL statements executed, monitor element
(2711)
select_sql_stmts element
(2712)
sequence number holding lock, monitor element
(2546)
sequence number, monitor element
(1812)
sequence_no element
(1813)
sequence_no_holding_lk element
(2547)
server identification data elements
configuration NNAME at monitoring (server) node
(1690)
database manager type at monitored (server) node
(1700)
product identification
(1730)
product name
(1725)
server instance name
(1695)
server operating system
(1720)
server product/version ID
(1705)
server version
(1710)
service level
(1715)
start database manager timestamp
(1685)
status of DB2 instance
(1735)
server instance name, monitor element
(1691)
server operating system, monitor element
(1716)
server product/version ID, monitor element
(1701)
server status data elements
See server identification data elements
server version, monitor element
(1706)
server_db2_type element
(1697)
server_instance_name element
(1692)
server_nname element
(1687)
server_platform element
(1717)
server_prdid element
(1702)
server_version element
(1707)
service level, monitor element
(1711)
service_level element
(1712)
SET EVENT MONITOR STATE statement
(2999)
setting switches
for a monitoring application
(1559)
snapshot monitoring
APIs
(2962)
authority required
(1564)
availability of data
(1594)
commands
(2961)
data element categories
(1556)
definition
(1554)
information available
(1571)
information returned
(1573)
interface
(1566)
partitioned databases
(1648)
request types
(1572)
required connection
(1592)
sample output
(1561), (1641)
setting switches
(1557), (1640)
snapshot types
(1574)
snapshot monitoring data elements
input database alias
(2927)
last reset timestamp
(2922)
snapshot time
(2932)
snapshot time, monitor element
(2928)
snapshot types
application
(1585)
buffer pool
(1589)
database
(1584)
database manager
(1583)
lock
(1587)
table
(1586)
table space
(1588)
sort overflows, monitor element
(2119)
sort_heap_allocated element
(2084)
sort_overflows element
(2120)
SQL communications area (SQLCA), monitor element
(2820)
SQL cursors data elements
accepted block cursor requests
(2675)
open local cursors
(2680)
open local cursors with blocking
(2685)
open remote cursors
(2660)
open remote cursors with blocking
(2665)
rejected block cursor requests
(2670)
SQL dynamic statement text, monitor element
(2805)
SQL requests since last commit, monitor element
(2746)
SQL statement
CREATE EVENT MONITOR
(2964), (2966)
DROP
(2972), (2974)
SET EVENT MONITOR STATE
(3000), (3002)
SQL statement activity data elements
binds/precompiles attempted
(2760)
commit statements attempted
(2705)
data definition language (DDL) SQL statements
(2725)
dynamic SQL statements attempted
(2695)
failed statement operations
(2700)
internal automatic rebinds
(2730)
internal commits
(2735)
internal rollbacks
(2740)
internal rollbacks due to deadlock
(2745)
rollback statements attempted
(2710)
select SQL statements executed
(2715)
SQL requests since last commit
(2750)
statement node
(2755)
static SQL statements attempted
(2690)
update/insert/delete SQL statements executed
(2720)
SQL statement details data elements
application creator
(2792)
cursor name
(2787)
number of successful fetches
(2819)
package name
(2777)
query cost estimate
(2834)
query number of rows estimate
(2829)
section number
(2782)
SQL communications area (SQLCA)
(2824)
SQL dynamic statement text
(2809)
statement operation
(2772)
statement operation start timestamp
(2797)
statement operation stop timestamp
(2804)
statement sorts
(2814)
statement type
(2765)
sqlca element
(2821)
sqlcode -973
(1646)
sqlmon.h header file
(2937)
sql_reqs_since_commit element
(2747)
ss_exec_time element
(2852)
ss_node_number element
(2842)
ss_number element
(2837)
ss_status element
(2847)
start database manager timestamp, monitor element
(1682)
statement event monitor
(1628)
statement node, monitor element
(2751)
statement operation start timestamp, monitor element
(2793)
statement operation stop timestamp, monitor element
(2798)
statement operation, monitor element
(2766)
statement sorts, monitor element
(2810)
statement type, monitor element
(2761)
static SQL statements attempted, monitor element
(2686)
static_sql_stmts
(2687)
statistics
database manager
(2989)
status element
(1932)
status of database, monitor element
(1757)
status of DB2 instance, monitor element
(1731)
status_change_time element
(1798)
stmt_node_number element
(2752)
stmt_operations element
(2767)
stmt_sorts element
(2811)
stmt_start element
(2794)
stmt_stop element
(2799)
stmt_text element
(2806)
stmt_type element
(2762)
stolen agent
(1961)
stolen agents, monitor element
(2059)
stop_time element
(2800)
subagent
(1962)
subagent information data elements
active sorts
(2130)
piped sorts accepted
(2106)
piped sorts requested
(2100)
post threshold sorts
(2094)
process or thread id
(1952)
sort overflows
(2124)
total sort heap allocated
(2088)
total sort time
(2118)
total sorts
(2112)
subsection details data elements
current number of tablequeue buffers overflowed
(2880)
execution elapsed time
(2855)
number of agents working on a subsection
(2860)
number of rows read from tablequeues
(2885)
number of rows written to tablequeues
(2890)
subsection node number
(2845)
subsection number
(2840)
subsection status
(2850)
total number of tablequeue buffers overflowed
(2875)
waited for node on a tablequeue
(2870)
waiting for any node to send on a tablequeue
(2865)
subsection node number, monitor element
(2841)
subsection number, monitor element
(2836)
subsection status, monitor element
(2846)
subsections
(2835)
definition
(1654)
monitoring
(1653)
tablequeue
(1655)
switches
See monitor switches
T
table activity data elements
accesses to overflowed records
(2635)
internal rows deleted
(2640)
internal rows inserted
(2650)
internal rows updated
(2645)
rows deleted
(2605)
rows inserted
(2610)
rows read
(2630)
rows selected
(2620)
rows updated
(2615)
rows written
(2625)
table file ID
(2655)
table name
(2595)
table schema name
(2600)
table type
(2590)
table event monitor
(1630)
table file ID, monitor element
(2651)
table name, monitor element
(2591)
table schema name, monitor element
(2596)
table snapshot
(1578)
table space event monitor
(1631)
table space name, monitor element
(2514)
table space snapshot
(1579)
table type, monitor element
(2586)
tablequeue
(1659)
tablespace being rolled forward, monitor element
(2561)
tablespace_name element
(2515)
table_file_id element
(2652)
table_name element
(2592)
table_schema element
(2597)
table_type element
(2587)
taking a snapshot
issuing get snapshot command
(1562)
sample output
(1563)
time
(1680)
time waited for prefetch, monitor element
(2307)
time waited on locks, monitor element
(2509)
timestamp
(1679)
time_stamp element
(2929)
tools
control center
(1663)
db2batch
(1660)
db2evmon
(1662)
db2gov
(1661)
event analyzer
(1664)
total buffer pool physical read time, monitor element
(2237)
total buffer pool physical write time, monitor element
(2242)
total fcm buffers received, monitor element
(2197)
total fcm buffers sent, monitor element
(2191)
total lock list memory in use, monitor element
(2449)
total number of tablequeue buffers overflowed, monitor element
(2871)
total sort heap allocated , monitor element
(2083)
total sort time, monitor element
(2113)
total sorts, monitor element
(2107)
total time unit of work waited on locks, monitor element
(2526)
total_buffers_rcvd element
(2198)
total_buffers_sent element
(2192)
total_cons element
(1994)
total_sec_cons element
(2078)
total_sorts element
(2108)
total_sort_time element
(2114)
tot_log_used_top element
(2416)
tq_cur_send_spills element
(2877)
tq_node_waited_for element
(2867)
tq_rows_read element
(2882)
tq_rows_written element
(2887)
tq_tot_send_spills element
(2872)
tq_wait_for_any element
(2862)
trace
event monitor
(1596)
format
(2935)
programming to read
(2955)
sample
(1600)
size
(2950)
viewing
(1603)
transaction event monitor
(1629)
ts_name element
(2562)
U
uid_sql_stmts element
(2717)
unit of work completion status, monitor element
(1930)
Unit of Work log space used, monitor element
(2435)
unit of work start timestamp, monitor element
(1920)
unit of work stop timestamp, monitor element
(1925)
uow_comp_status element
(1931)
uow_lock_wait_time element
(2527)
uow_log_space_used element
(2436)
uow_start_time element
(1921)
uow_stop_time element
(1926)
UPDATE MONITOR SWITCHES
(3007)
update/insert/delete SQL statements executed, monitor element
(2716)
updating switch settings
See setting switches
user authorization level, monitor element
(1894)
user login ID, monitor element
(1852)
V
view, logical
(1643)
W
waited for node on a tablequeue, monitor element
(2866)
waiting for any node to send on a tablequeue, monitor element
(2861)
water mark
(1677)
X
x_lock_escals element
(2465)
[ Top of Page | Previous Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]