We can use below query to find out object’s physical size:
Query to give table size for T1 table in DB2INST1 schema:
db2 => select data_object_p_size, available from table(sysproc.admin_get_tab_info_v97(‘DB2INST1’, ‘T1’)) AS T
1 record(s) selected.
Physical size meaning – Amount of disk space physically allocated for the table in Kilobytes.
The space reported by (DATA_OBJECT_P_SIZE) represents the physical size of the base table only. Space consumed by LOB data, Long Data, Indexes and XML objects are reported by other columns such as INDEX_OBJECT_P_SIZE, LONG_OBJECT_P_SIZE, XML_OBJECT_P_SIZE.
AVAILABLE: This columns specifies the state of the table.
N: Table is unavailable. If the table is unavailable, all other output columns relating to the size and state will be NULL.
Y: table is available.