| COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
| BP_NAME |
✔ |
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| 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 |
|
| IN_DB_ALIA |
|
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| DB_NAME |
|
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| DB_PATH |
|
DB6: File Path |
DB6PATH |
CHAR |
255 |
|
| PL_D_LRS |
|
pool_data_l_reads: Pool Data Logical Reads |
|
DEC |
22 |
|
| PL_D_PRS |
|
pool_data_p_reads: Pool Data Physical Reads |
|
DEC |
22 |
|
| PL_D_WS |
|
pool_data_writes: Pool Data Writes |
|
DEC |
22 |
|
| PL_I_LRS |
|
pool_index_l_reads: Pool Index Logical Reads |
|
DEC |
22 |
|
| PL_I_PRS |
|
pool_index_p_reads: Pool Index Physical Reads |
|
DEC |
22 |
|
| PL_I_WS |
|
pool_index_writes: Pool Index Writes |
|
DEC |
22 |
|
| PL_RD_TM |
|
pool_read_time: Buffer Pool Read Time |
|
DEC |
22 |
|
| PL_WT_TM |
|
pool_write_time: Buffer Pool Write Time |
|
DEC |
22 |
|
| FLS_CLOSED |
|
files_closed: Files Closed for Buffer Pool |
|
DEC |
22 |
|
| PL_A_DRSI |
|
pool_async_data_readsi: Asynchronous Pool Data Reads |
|
DEC |
22 |
|
| PL_A_DWS |
|
pool_async_data_writes: Asynchronous Pool Data Writes |
|
DEC |
22 |
|
| PL_A_IWS |
|
pool_async_index_writes: Asynchronous Pool Index Writes |
|
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 |
|
DEC |
22 |
|
| DIRCT_WTS |
|
direct_writes: Direct Writes |
|
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 |
|
DEC |
22 |
|
| DIRCT_WTM |
|
direct_write_time: Direct Write Time |
|
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 |
|
| CURBUFFSZ |
|
bp_cur_buffsz |
|
DEC |
22 |
|
| NEWBUFFSZ |
|
bp_new_buffsz |
|
DEC |
22 |
|
| PGS_FROM_BLOCKIO |
|
pages_from_block_ios |
|
DEC |
22 |
|
| PGS_FROM_VECTRIO |
|
pages_from_vectored_ios |
|
DEC |
22 |
|
| PHYS_PAGE_MAPS |
|
physical_page_maps |
|
DEC |
22 |
|
| PL_ASYNC_XDA_RD |
|
pool_async_xda_reads |
|
DEC |
22 |
|
| PL_ASYNC_XDA_RRQ |
|
pool_async_xda_read_reqs |
|
DEC |
22 |
|
| PL_ASYNC_XDA_WRT |
|
pool_aysnc_xda_writes |
|
DEC |
22 |
|
| PL_NO_VICTIM_BUF |
|
pool_no_victim_buffer |
|
DEC |
22 |
|
| POOL_XDA_L_READS |
|
pool_xda_l_reads |
|
DEC |
22 |
|
| POOL_XDA_P_READS |
|
pool_xda_p_reads |
|
DEC |
22 |
|
| POOL_XDA_WRITES |
|
pool_xda_writes |
|
DEC |
22 |
|
| PL_TEMP_XDA_L_RD |
|
pool_temp_xda_l_reads |
|
DEC |
22 |
|
| PL_TEMP_XDA_P_RD |
|
pool_temp_xda_p_reads |
|
DEC |
22 |
|
| VECTORED_IOS |
|
vectored_ios |
|
DEC |
22 |
|
| BP_PAGES_LEFT |
|
bp_pages_left_to_remove |
|
DEC |
22 |
|
| BP_TBSP_USE_CNT |
|
bp_tbsp_use_count |
|
DEC |
22 |
|