IO / Table
Purpose
Table view shows the performance of I/O operations for each table including the number of rows read, inserted, updated, and deleted.
Screenshot
Metric shown
Gauge
Rows r+w/s
The percentage of rows read from the table.
= ROWS_READ / ROWS_TOTAL
Source:
ROWS_READ = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_READ)
ROWS_TOTAL = MON_GET_TABLE(NULL, NULL, #MEMBER#).(SUM(ROWS_READ) + SUM(ROWS_INSERTED) + SUM(ROWS_UPDATED) + SUM(ROWS_DELETED))
Grid
Rows read
The number of rows read from the table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_READ)
Rows written
The number of rows insertions, updates, and deletions attempted.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).(SUM(ROWS_INSERTED) + SUM(ROWS_UPDATED) + SUM(ROWS_DELETED))
Temp space
The total page size of system temporary data used on disk where TBSP_CONTENT_TYPE of table space equals to ‘SYSTEMP’.
= (DATA_OBJECT_L_PAGES + INDEX_OBJECT_L_PAGES) * TBSP_PAGE_SIZE
Source:
DATA_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(DATA_OBJECT_L_PAGES)
INDEX_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(INDEX_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE.TBSP_PAGE_SIZE
TBSP_CONTENT_TYPE = MON_GET_TABLESPACE.TBSP_CONTENT_TYPE
Active usr space
The total page size of non-system-temporary data used on disk where TBSP_CONTENT_TYPE of table space does not equal to ‘SYSTEMP’.
= (DATA_OBJECT_L_PAGES + INDEX_OBJECT_L_PAGES) * TBSP_PAGE_SIZE
DATA_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(DATA_OBJECT_L_PAGES)
INDEX_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(INDEX_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE.TBSP_PAGE_SIZE
TBSP_CONTENT_TYPE = MON_GET_TABLESPACE.TBSP_CONTENT_TYPE
Table
Table name
The name of the table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).TABNAME
Table type
The type of table for which information is returned.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).TAB_TYPE
Table scans
The number of scans on this table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(TABLE_SCANS)
Rows read
The number of rows read from the table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_READ)
Rows inserted
The number of row insertions attempted.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_INSERTED)
Rows updated
This is the number of row updates attempted.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_UPDATED)
Rows deleted
This is the number of row deletions attempted.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_DELETED)
Page reorgs
The number of page reorganizations executed for a table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(PAGE_REORGS)
Rows overflows
The number of accesses (reads and writes) to overflowed rows of this table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(OVERFLOW_ACCESSES)
Appl handle
The identifier for application.
If TAB_TYPE is ‘TEMP_TABLE’ and TABSCHEMA has ’.’, then the value is the string before ’.‘.
Source:
TAB_TYPE = MON_GET_TABLE(NULL, NULL, #MEMBER#).TAB_TYPE
TABSCHEMA = MON_GET_TABLE(NULL, NULL, #MEMBER#).TABSCHEMA
Db user
The db user.
If TAB_TYPE is ‘TEMP_TABLE’ and TABSCHEMA has ’.’, then the value is the string after ’.‘.
Source:
TAB_TYPE = MON_GET_TABLE(NULL, NULL, #MEMBER#).TAB_TYPE
TABSCHEMA = MON_GET_TABLE(NULL, NULL, #MEMBER#).TABSCHEMA
# of member
The number of members.
The value equals to the number of distinct MEMBER in MON_GET_TABLE.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).MEMBER
Rows read skew
The maximum number of rows read from the table skewed from average.
= 1 - AVG(ROWS_READ)/MAX(ROWS_READ)
Source:
ROWS_READ = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(ROWS_READ)