Storage / Table Utilization
Purpose
Table utilization view shows the utilization for each table including size of different types of pages used in the table.
Screenshot
Metric shown
Table name
The name of the table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).TABNAME
Table scans
The number of scans on this table.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(TABLE_SCANS)
Table type
The type of table for which information is returned.
Source: MON_GET_TABLE(NULL, NULL, #MEMBER#).TAB_TYPE
Tablespace name
The name of a table space.
Source: MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_NAME
# of member
The number of distinct member in the table.
Table size
The size of logical pages used in this table.
= SUM((DATA_OBJECT_L_PAGES + COL_OBJEC_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)
COL_OBJEC_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(COL_OBJECT_L_PAGES)
INDEX_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(INDEX_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_PAGE_SIZE
Table size skew
The size skew of logical pages used in this table.
= 1 - AVG((DATA_OBJECT_L_PAGES + COL_OBJEC_L_PAGES + INDEX_OBJECT_L_PAGES) TBSP_PAGE_SIZE) / MAX((DATA_OBJECT_L_PAGES + COL_OBJEC_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)
COL_OBJEC_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(COL_OBJECT_L_PAGES)
INDEX_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(INDEX_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_PAGE_SIZE
Data size
The size of logical pages used on disk by data contained in this table.
= SUM((DATA_OBJECT_L_PAGES + COL_OBJEC_L_PAGES) * TBSP_PAGE_SIZE)
Source:
DATA_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(DATA_OBJECT_L_PAGES)
COL_OBJEC_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(COL_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_PAGE_SIZE
Lob+long size
The size of logical pages used on disk by long data contained in this table or LOBs associated with this table.
= SUM((LOB_OBJECT_L_PAGES + LONG_OBJECT_L_PAGES) * TBSP_PAGE_SIZE)
Source:
LOB_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(LOB_OBJECT_L_PAGES)
LONG_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(LONG_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_PAGE_SIZE
Index size
The size of logical pages used on disk by all indexes associated with this table.
= SUM(INDEX_OBJECT_L_PAGES * TBSP_PAGE_SIZE)
Source:
INDEX_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(INDEX_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_PAGE_SIZE
Xda size
The size of logical pages used on disk by XML storage object (XDA) data.
= SUM(INDEX_OBJECT_L_PAGES * TBSP_PAGE_SIZE)
Source:
INDEX_OBJECT_L_PAGES = MON_GET_TABLE(NULL, NULL, #MEMBER#).SUM(XDA_OBJECT_L_PAGES)
TBSP_PAGE_SIZE = MON_GET_TABLESPACE(NULL, #MEMBER#).TBSP_PAGE_SIZE
Page reclaims (exclusive)
The number of times a page related to the object was reclaimed by another member in the Db2® pureScale® instance before its planned release, where the member that reclaimed the page required exclusive access.
Source: MON_GET_PAGE_ACCESS_INFO.SUM(PAGE_RECLAIMS_X)
Page reclaims (shared)
The number of times a page related to the object was reclaimed by another member in the Db2 pureScale instance before its planned release, where the member that reclaimed the page required shared access.
Source: MON_GET_PAGE_ACCESS_INFO.SUM(PAGE_RECLAIMS_S)