Throughput - Members

Purpose

Show some basic statistics about individual members. Member specific memory and transaction log usage are found here.

Histograms and Summaries (Gauges)

(link TBD)

Metrics Shown in Grid

Partition Number

Source: mon_get_fcm_connection_list.member

Partition Status

Source: mon_get_fcm_connection_list.connection_status

Buffer LWM

Source: mon_get_fcm.buff_free_bottom

Delta BufSent/s

Source: mon_get_fcm_connection_list.total_buffers_sent

Delta BufRcvd/s

Source: mon_get_fcm_connection_list.total_buffers_rcvd

Pool CurrSize

Source: mon_get_memory_pool.mem_pool_used

Pool HWM

Source: mon_get_memory_pool.mem_pool_used_hwm

Channels Free

Source: mon_get_fcm.ch_free

Space Used

Source: mon_get_tablespace

sum(tbsp_used_pages * tbsp_page_size)

Total Space

Source: mon_get_tablespace

sum(tbsp_total_pages * tbsp_page_size)

Log Current

Source: mon_get_transaction_log.current_active_log

Log First

Source: mon_get_transaction_log.first_active_log

Log Last

Source: mon_get_transaction_log.last_active_log

Number of Pools

Count the number of memory application and database memory pools.

Source: mon_get_memory_pool

select member, count(*) from table(mon_get_memory_pool(...))

where memory_set_type in('APPLICATION','DATABASE')

group by member

Log Space Used

Source: mon_get_transaction_log.total_log_used

Percent of Log Used

Source: mon_get_transaction_log

total_log_used / (total_log_used + total_log_available)

Agent ID Holding 1st Log

Source: mon_get_transaction_log.applid_holding_oldest_xact

Default Sort Column

Partition number (Member): Ascending

Keyboard navigation: Vtp

Dedicated shortcut key: alt-p

Author: KevinLBeck

Sessions (connections)