| COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
| 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 |
|
| LCKS_HELD |
|
locks_held: Locks Currently Held |
|
DEC |
22 |
|
| LCK_WAITS |
|
lock_waits: Lock Waits Since First Connect |
|
DEC |
22 |
|
| LCK_W_TM |
|
lock_wait_time: Total Time Database Waited for Locks |
|
DEC |
22 |
|
| LCK_LSTIU |
|
lock_list_in_use: Total Lock List Memory in Use |
|
DEC |
22 |
|
| DEADLOCKS |
|
deadlocks: Deadlocks Since First DB Connect |
|
DEC |
22 |
|
| LCK_ESCALS |
|
lock_escals: Lock Escalations Since First DB Connect |
|
DEC |
22 |
|
| X_LCK_ESCA |
|
x_lock_escals: X Lock Escalations Since First DB Connect |
|
DEC |
22 |
|
| LCK_WTING |
|
locks_waiting: Agents Currently Waiting for Locks |
|
DEC |
22 |
|
| SRT_HP_ALO |
|
sort_heap_allocated: Total Sort Heap Allocated |
|
DEC |
22 |
|
| TOT_SORTS |
|
total_sorts: Number of Sorts Since First Connect |
|
DEC |
22 |
|
| TOT_SRT_TM |
|
total_sort_time: Elapsed Time Spent in Sorts |
|
DEC |
22 |
|
| SRT_OF |
|
sort_overflows: Number of Sort Overflows |
|
DEC |
22 |
|
| ACTIV_SORT |
|
active_sorts: Sorts Currently Active |
|
DEC |
22 |
|
| PL_D_LRS |
|
pool_data_l_reads: Pool Data Logical Reads Since Connect |
|
DEC |
22 |
|
| PL_D_PRS |
|
pool_data_p_reads: Pool Data Reads Since First Connect |
|
DEC |
22 |
|
| PL_D_WS |
|
pool_data_writes: Pool Data Writes Since First Connect |
|
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 Reads Since First Connect |
|
DEC |
22 |
|
| PL_I_WS |
|
pool_index_writes: Pool Index Writes Since First Connect |
|
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 |
|
| FLS_CLOSED |
|
files_closed: Files Closed Since First DB Connect |
|
DEC |
22 |
|
| CMMT_SQLST |
|
commit_sql_stmts: Number of COMMIT SQL Statements Since Conn |
|
DEC |
22 |
|
| RBCK_SQLST |
|
rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect |
|
DEC |
22 |
|
| DYN_SQLST |
|
dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect |
|
DEC |
22 |
|
| STC_SQLST |
|
static_sql_stmts: Number of Static SQL Statements Since Conn |
|
DEC |
22 |
|
| FAIL_SQLST |
|
failed_sql_stmts: Number of Failed SQL Stmts Since Connect |
|
DEC |
22 |
|
| SELC_SQLST |
|
select_sql_stmts: Number of SQL SELECT Stmts Since Connect |
|
DEC |
22 |
|
| DDL_SQLST |
|
ddl_sql_stmts: Number of Data Definition Language Statements |
|
DEC |
22 |
|
| UID_SQLST |
|
uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements |
|
DEC |
22 |
|
| INT_ATRBND |
|
int_auto_rebinds: Number of Auto Rebinds Since First Connect |
|
DEC |
22 |
|
| INT_RW_DEL |
|
int_rows_deleted: No. of Casc. Deletes Since First Connect |
|
DEC |
22 |
|
| INT_RW_UPD |
|
int_rows_updated: Number of Set Null Deletes Since Connect |
|
DEC |
22 |
|
| INT_CMMTS |
|
int_commits: Number of Int. COMMITs Since First Connect |
|
DEC |
22 |
|
| INT_RB |
|
int_rollbacks: Number of Int. ROLLBACKs Since First Connect |
|
DEC |
22 |
|
| INT_DL_RB |
|
int_deadlock_rollbacks: # of ROLLBACKs due to Deadlock Since |
|
DEC |
22 |
|
| RW_DELETED |
|
rows_deleted: Number of Rows Deleted Since Connect |
|
DEC |
22 |
|
| RW_INSRTED |
|
rows_inserted: Number of Rows Inserted Since Connect |
|
DEC |
22 |
|
| RW_UPDATED |
|
rows_updated: Number of Rows Updated Since Connect |
|
DEC |
22 |
|
| RW_SELECED |
|
rows_selected: Number of Rows Selected Since Connect |
|
DEC |
22 |
|
| BIND_PRECC |
|
binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn. |
|
DEC |
22 |
|
| DB_CN_TM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| LAST_RESET |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| LAST_BKUP |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| TOTAL_CONS |
|
total_cons: Connects Since First DB Connect |
|
DEC |
22 |
|
| APL_CUR_CO |
|
appls_cur_cons: Applications Currently Connected |
|
DEC |
22 |
|
| APL_IN_DB2 |
|
appls_in_db2: Applications Executing in DB2 |
|
DEC |
22 |
|
| SEC_LGUSTP |
|
sec_log_used_top: Maximum Secondary Log Space Used |
|
DEC |
22 |
|
| TOT_LGUTOP |
|
tot_log_used_top: Maximum Total Log Space Used |
|
DEC |
22 |
|
| SEC_LGALLO |
|
sec_logs_allocated: Number of Secondary Logs Allocated |
|
DEC |
22 |
|
| NUM_SCDBS |
|
num_sec_dbase_structs: Secondary Database Information |
|
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_FEI |
|
pool_data_from_estorei: No of Pages Copied from ExStor to BP |
|
DEC |
22 |
|
| DB_STATUS |
|
db_status: Status of the Database |
|
CHAR |
25 |
|
| LCK_TMOUT |
|
lock_timeouts: Number of Lock Timeouts Since First Connect |
|
DEC |
22 |
|
| CN_TOP |
|
connections_top: High Water Mark for Current Connections |
|
DEC |
22 |
|
| DB_HP_TOP |
|
db_heap_top: High Water Mark for Database Heap (Bytes) |
|
DEC |
22 |
|
| PL_A_DRS |
|
pool_async_data_reads: 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: Total Asynchronous Read Time |
|
DEC |
22 |
|
| PL_A_WTM |
|
pool_async_write_time: Total Asynchronous Write Time |
|
DEC |
22 |
|
| PL_A_DRRQ |
|
pool_async_data_read_reqs: No. of Asynchronous Read Requests |
|
DEC |
22 |
|
| PL_LSNGCL |
|
pool_lsn_gap_clns: LSN Gap Cleaner Triggers |
|
DEC |
22 |
|
| PL_DPSCL |
|
pool_drty_pg_steal_clns: Dirty Page Steal Cleaner Trig. |
|
DEC |
22 |
|
| PL_DPTCL |
|
pool_drty_pg_thrsh_clns: Dirty List Threshold Cleaner Trig. |
|
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 |
|
| INT_RW_INS |
|
int_rows_inserted: Number of Rows Inserted for Trigger |
|
DEC |
22 |
|
| LOG_READS |
|
log_reads: Number of Log Pages Read Since First Connect |
|
DEC |
22 |
|
| LOG_WRITES |
|
log_writes: Number of Log Pages Read Since First Connect |
|
DEC |
22 |
|
| PKG_CA_LKU |
|
pkg_cache_lookups: Number of Section Lookups |
|
DEC |
22 |
|
| PKG_CA_INS |
|
pkg_cache_inserts: Number of Sections Inserted into Cache |
|
DEC |
22 |
|
| CATCA_LKU |
|
cat_cache_lookups: Number of Table Descriptor Lookups |
|
DEC |
22 |
|
| CATCA_INS |
|
cat_cache_inserts: Number of Table Descriptors Inserted |
|
DEC |
22 |
|
| CATCA_OF |
|
cat_cache_overflows: Number of Catalog Cache Overflows |
|
DEC |
22 |
|
| CATCA_HPFL |
|
cat_cache_heap_full: Number of Overflows due to DB Heap Full |
|
DEC |
22 |
|
| CAT_NODE |
|
catalog_node: Catalog Node Number |
|
DEC |
22 |
|
| TOT_SEC_CN |
|
total_sec_cons: Secondary Connects Since First Connect |
|
DEC |
22 |
|
| NUM_ASS_AG |
|
num_assoc_agents: Current Number of Agents Associated |
|
DEC |
22 |
|
| AGENTS_TOP |
|
agents_top: Maximum Number of Agents Associated at Once |
|
DEC |
22 |
|
| CRD_AG_TOP |
|
coord_agents_top: Max. No. of Coord. Agents Connected to DB |
|
DEC |
22 |
|
| DB_LOCAT |
|
db_location: Local or Remote to Application Snapshot |
|
CHAR |
25 |
|
| SERV_PLATF |
|
server_platform: Operating System on Which DBM Runs |
|
CHAR |
25 |
|
| CAT_ND_NME |
|
DB6: Long identifier |
DB6LONGID |
CHAR |
32 |
|
| PF_WTTM |
|
prefetch_wait_time: Time Waited for Prefetch (ms) |
|
DEC |
22 |
|
| AP_SEC_LKU |
|
appl_section_lookups: Number of Section Lookups |
|
DEC |
22 |
|
| AP_SEC_INS |
|
appl_section_inserts: Number of Sections Inserted |
|
DEC |
22 |
|
| TOT_HAJN |
|
total_hash_joins: Number of Hash Joins |
|
DEC |
22 |
|
| TOT_HALOOP |
|
total_hash_loops: Number of Hash Loops |
|
DEC |
22 |
|
| HAJN_OF |
|
hash_join_overflows: Number of Hash Join Overflows |
|
DEC |
22 |
|
| HAJN_SM_OF |
|
hash_join_small_overflows: Small Hash Join Overflows |
|
DEC |
22 |
|
| TOT_LGUSED |
|
total_log_used: Log Space Used by Database |
|
DEC |
22 |
|
| TOT_LGAVL |
|
total_log_available: Log Space Available in Database |
|
DEC |
22 |
|
| UNREADPFPG |
|
unread_prefetch_pages: Unread prefetched pages |
|
DEC |
22 |
|
| PKG_NUM_OV |
|
pkg_cache_num_overflows: Package Cache Number Overflows |
|
DEC |
22 |
|
| PKG_SZ_TOP |
|
pkg_cache_size_top: Package Cache Size Top |
|
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_indec_read_reqs |
|
DEC |
22 |
|
| CATCASZTOP |
|
cat_cache_size_top |
|
DEC |
22 |
|
| LOGREADTS |
|
|
|
DEC |
22 |
|
| LOGREADTNS |
|
|
|
DEC |
22 |
|
| LOGWRITS |
|
log_writes: Number of Log Pages Read Since First Connect |
|
DEC |
22 |
|
| LOGWRITNS |
|
|
|
DEC |
22 |
|
| NUMLOGWRIO |
|
|
|
DEC |
22 |
|
| NUMLOGRDIO |
|
|
|
DEC |
22 |
|
| NUMLOGPPIO |
|
|
|
DEC |
22 |
|
| NUMLOGBFUL |
|
|
|
DEC |
22 |
|
| NUMLOGDFND |
|
|
|
DEC |
22 |
|
| LOGREDOREC |
|
|
|
DEC |
22 |
|
| LOGHELDDTY |
|
|
|
DEC |
22 |
|
| ACTIVE_HASH_JOIN |
|
|
|
DEC |
22 |
|
| DBNAME |
|
|
|
CHAR |
100 |
|
| 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 |
|
| POST_SHRTHRS_HAJ |
|
|
|
DEC |
22 |
|
| POST_SHRTHRS_SRT |
|
|
|
DEC |
22 |
|
| SMALLEST_LOG_AVL |
|
|
|
DEC |
22 |
|
| APPL_ID_OLDEST_X |
|
appl_id_oldest_xact |
|
DEC |
22 |
|
| ELPSD_EXC_TIM_MS |
|
elapsed_exec_time_ms |
|
DEC |
22 |
|
| ELPSD_EXC_TIM_S |
|
elapsed_exec_time_s |
|
DEC |
22 |
|
| NUM_DB_STORPATHS |
|
num_db_storage_paths |
|
DEC |
22 |
|
| NUM_INDOUBT_TRAN |
|
num_indoubt_trans |
|
DEC |
22 |
|
| PL_NO_VICTIM_BUF |
|
pool_no_victim_buffer |
|
DEC |
22 |
|
| ROWS_READ |
|
rows_read |
|
DEC |
22 |
|
| PRV_WS_NUM_OVFL |
|
priv_workspace_num_overflows |
|
DEC |
22 |
|
| PRV_WS_SCT_INSRT |
|
priv_workspace_section_inserts |
|
DEC |
22 |
|
| PRV_WS_SCT_LKUP |
|
priv_workspace_section_lookups |
|
DEC |
22 |
|
| PRV_WS_SIZE_TOP |
|
priv_workspace_size_top |
|
DEC |
22 |
|
| SHR_WS_NUM_OVFL |
|
shr_workspace_num_overflows |
|
DEC |
22 |
|
| SHR_WS_SCT_INSRT |
|
shr_workspace_section_inserts |
|
DEC |
22 |
|
| SHR_WS_SCT_LKUP |
|
shr_workspace_section_lookups |
|
DEC |
22 |
|
| SHR_WS_SIZE_TOP |
|
shr_workspace_size_top |
|
DEC |
22 |
|
| SORT_SHRHEAP_ALL |
|
sort_shrheap_allocated |
|
DEC |
22 |
|
| SORT_SHRHEAP_TOP |
|
sort_shrheap_top |
|
DEC |
22 |
|
| ACTIVE_OLAP_FUNCS |
|
|
|
DEC |
22 |
|
| ASYNC_RUNSTATS |
|
|
|
DEC |
22 |
|
| NUM_THRESHOLD_VIOLATIONS |
|
|
|
DEC |
22 |
|
| OLAP_FUNC_OVERFLOWS |
|
|
|
DEC |
22 |
|
| STATS_CACHE_SIZE |
|
|
|
DEC |
22 |
|
| STATS_FABRICATE_TIME |
|
|
|
DEC |
22 |
|
| STATS_FABRICATIONS |
|
|
|
DEC |
22 |
|
| SYNC_RUNSTATS |
|
|
|
DEC |
22 |
|
| SYNC_RUNSTATS_TIME |
|
|
|
DEC |
22 |
|
| POOL_COL_L_READS |
|
|
|
DEC |
22 |
|
| POOL_COL_P_READS |
|
|
|
DEC |
22 |
|
| POOL_TEMP_COL_L_READS |
|
|
|
DEC |
22 |
|
| POOL_TEMP_COL_P_READS |
|
|
|
DEC |
22 |
|
| POOL_COL_WRITES |
|
|
|
DEC |
22 |
|