COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
TBS_NAME |
✔ |
DB6: Tablespace Name |
DB6TSPNAME |
CHAR |
30 |
|
CALLERFLAG |
✔ |
Who Has Called this Program |
|
CHAR |
1 |
|
DBMSTRTTME |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
PRGVERS |
|
Version of Program Inserted this Row |
|
CHAR |
20 |
|
PL_D_LRS |
|
pool_data_l_reads: Pool Data Logical Reads Since Connect |
|
DEC |
22 |
|
PL_D_PRS |
|
pool_data_p_reads: Pool Data Physical Reads Since Connect |
|
DEC |
22 |
|
PL_A_DRS |
|
pool_async_data_reads: Asynchronous Pool Data Reads |
|
DEC |
22 |
|
PL_D_WS |
|
pool_data_writes: Pool Data Writes Since Connect |
|
DEC |
22 |
|
PL_A_DWS |
|
pool_async_data_writes: Asynchronous Pool Data Writes |
|
DEC |
22 |
|
PL_I_LRS |
|
pool_index_l_reads: Pool Index Logical Reads Since Connect |
|
DEC |
22 |
|
PL_I_PRS |
|
pool_index_p_reads: Pool Index Physical Reads Since Connect |
|
DEC |
22 |
|
PL_I_WS |
|
pool_index_writes: Pool Index Writes Since Connect |
|
DEC |
22 |
|
PL_A_IWS |
|
pool_async_index_writes: Asynchronous Pool Index Writes |
|
DEC |
22 |
|
PL_RD_TM |
|
pool_read_time: Buffer Pool Read Time Since First Connect |
|
DEC |
22 |
|
PL_WT_TM |
|
pool_write_time: Buffer Pool Write Time Since First Connect |
|
DEC |
22 |
|
PL_A_RTM |
|
pool_async_read_time: Asynchronous Read Time |
|
DEC |
22 |
|
PL_A_WTM |
|
pool_async_write_time: Asynchronous Write Time |
|
DEC |
22 |
|
PL_A_DRRQ |
|
pool_async_data_read_reqs: No. of Asynchronous Read Requests |
|
DEC |
22 |
|
DIRCT_RDS |
|
direct_reads: Direct Reads Since First Connect |
|
DEC |
22 |
|
DIRCT_WTS |
|
direct_writes: Direct Writes Since First Connect |
|
DEC |
22 |
|
DIRCT_RRQS |
|
direct_read_reqs: Direct Read Requests |
|
DEC |
22 |
|
DIRCT_WRQS |
|
direct_write_reqs: Direct Write Requests |
|
DEC |
22 |
|
DIRCT_RTM |
|
direct_read_time: Direct Read Time Since First Connect |
|
DEC |
22 |
|
DIRCT_WTM |
|
direct_write_time: Direct Write Time Since First Connect |
|
DEC |
22 |
|
FLS_CLOSED |
|
files_closed: Files Closed for Tablespace |
|
DEC |
22 |
|
PL_A_IRS |
|
pool_async_index_reads: Asynchronous Pool Index Reads |
|
DEC |
22 |
|
PL_D_TE |
|
pool_data_to_estore: No. of Pages Copied from BP to ExStor. |
|
DEC |
22 |
|
PL_I_TE |
|
pool_index_to_estore: No. of Pages Copied from BP to ExStor. |
|
DEC |
22 |
|
PL_I_FE |
|
pool_index_from_estore: No of Pages Copied from ExStor to BP |
|
DEC |
22 |
|
PL_D_FE |
|
pool_data_from_estore: No. of Pages Copied from ExStor to BP |
|
DEC |
22 |
|
UNREADPFPG |
|
unread_prefetch_pages: Unread prefetched pages |
|
DEC |
22 |
|
PL_TD_LRS |
|
pool_temp_data_l_reads |
|
DEC |
22 |
|
PL_TD_PRS |
|
pool_temp_data_p_reads |
|
DEC |
22 |
|
PL_TI_LRS |
|
pool_temp_index_l_reads |
|
DEC |
22 |
|
PL_TI_PRS |
|
pool_temp_index_p_reads |
|
DEC |
22 |
|
PL_A_IRRQ |
|
pool_async_index_read_reqs |
|
DEC |
22 |
|
PL_ASYNC_XDA_RDS |
|
|
|
DEC |
22 |
|
PL_ASYNC_XDA_RRQ |
|
|
|
DEC |
22 |
|
PL_ASYNC_XDA_WRT |
|
|
|
DEC |
22 |
|
PL_TEMP_XDA_L_RD |
|
|
|
DEC |
22 |
|
PL_TEMP_XDA_P_RD |
|
|
|
DEC |
22 |
|
POOL_XDA_L_READS |
|
|
|
DEC |
22 |
|
POOL_XDA_P_READS |
|
|
|
DEC |
22 |
|
POOL_XDA_WRITES |
|
|
|
DEC |
22 |
|
PL_NO_VICTIM_BUF |
|
pool_no_victim_buffer |
|
DEC |
22 |
|