| PARTITN |
|
dbpartitionnum |
|
INT4 |
10 |
|
| AGENT_ID |
|
|
|
DEC |
22 |
|
| AP_STATUS |
|
application status |
|
CHAR |
50 |
|
| CODEPG_ID |
|
codepage ID |
|
DEC |
22 |
|
| NUM_ASS_AG |
|
number of associated agents |
|
DEC |
22 |
|
| CRD_NODE |
|
coordinator node number |
|
DEC |
22 |
|
| AUTHORITY_LEVEL |
|
|
|
CHAR |
512 |
|
| CLI_PID |
|
client pid |
|
DEC |
22 |
|
| CRD_AG_PID |
|
coordinator agent pid |
|
DEC |
22 |
|
| STAT_CHGTM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| CLI_PLATFO |
|
client_platform: Platform of Client Application |
|
CHAR |
25 |
|
| CLI_PRTC |
|
client_protocol: Communications Protocol of Client |
|
CHAR |
25 |
|
| COUNTRY_CD |
|
territory code |
|
INT4 |
10 |
|
| APPL_NAME |
|
|
|
CHAR |
256 |
|
| APPL_ID |
|
|
|
CHAR |
128 |
|
| SEQU_NO |
|
|
|
CHAR |
5 |
|
| AUTH_ID |
|
primary auth. ID |
|
CHAR |
128 |
|
| SESSION_AUTH_ID |
|
session auth. ID |
|
CHAR |
128 |
|
| CLI_NAME |
|
client_nname |
|
CHAR |
128 |
|
| CLI_PRDID |
|
client_prdID |
|
CHAR |
128 |
|
| IN_DB_ALIA |
|
input DB alias |
|
CHAR |
128 |
|
| CLI_DBALIA |
|
client DB alias |
|
CHAR |
128 |
|
| DB_NAME |
|
|
|
CHAR |
128 |
|
| DB_PATH |
|
|
|
CHAR |
1024 |
|
| EXEC_ID |
|
execution ID |
|
CHAR |
128 |
|
| CORR_TOKEN |
|
|
|
CHAR |
128 |
|
| TPMON_ACC_STR |
|
|
|
CHAR |
200 |
|
| TPMON_CLIENT_APP |
|
|
|
CHAR |
256 |
|
| TPMON_CLIENT_UID |
|
|
|
CHAR |
256 |
|
| TPMON_CLIENT_WKS |
|
|
|
CHAR |
256 |
|
| WORKLOAD_ID |
|
|
|
INT4 |
10 |
|
| IS_SYSTEM_APPL |
|
|
|
INT2 |
5 |
|
| COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| 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 |
|
| IPADDRESS |
|
IP Address |
NI_NODEADDR |
CHAR |
45 |
|
| LCKS_HELD |
|
locks_held: Locks Currently Held by Application |
|
DEC |
22 |
|
| LCK_WAITS |
|
lock_waits: Lock Waits Since Application Connect |
|
DEC |
22 |
|
| LCK_W_TM |
|
lock_wait_time: Total Time Application Waited for Locks |
|
DEC |
22 |
|
| LCK_ESCALS |
|
lock_escals: Lock Escalations Since Application Connect |
|
DEC |
22 |
|
| X_LCK_ESCA |
|
x_lock_escals: X Lock Escalations Since Application Connect |
|
DEC |
22 |
|
| DEADLOCKS |
|
deadlocks: Deadlocks Since Application Connect |
|
DEC |
22 |
|
| UOW_LWTM |
|
uow_lock_wait_time: Time UOW Waited for Locks (ms) |
|
DEC |
22 |
|
| TOT_SORTS |
|
total_sorts: Total Sorts Since 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 |
|
| 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 |
|
| 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 Deadlck S. Con |
|
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 |
|
| UOW_LGSPUD |
|
uow_log_space_used: Log Space Used in Most Recent UOW |
|
DEC |
22 |
|
| UOW_CMPSTA |
|
uow_comp_status: Previous UOW Completion Status |
|
CHAR |
50 |
|
| PR_UOW_STM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| UOW_STRTTM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| UOW_STOPTM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| OPN_RM_CR |
|
open_rem_curs: Remote Cursors Currently Open |
|
DEC |
22 |
|
| OPN_RM_CRB |
|
open_rem_curs_blk: Remote Cursors Curr. Open Within Block |
|
DEC |
22 |
|
| REJ_CR_BLK |
|
rej_curs_blk: Rejected Block Remote Cursor Requests |
|
DEC |
22 |
|
| ACC_CU_BLK |
|
acc_curs_blk: Acc. Block Remote Cursor Requests |
|
DEC |
22 |
|
| AP_CON_TM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| CN_CMPL_TM |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| LAST_RESET |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| AP_IDLE_TM |
|
appl_idle_time: Application Idle Time (Seconds) |
|
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 |
|
| AUTHO_LVL |
|
authority_lvl: User Authorizations |
|
DEC |
22 |
|
| SQL_RSCMMT |
|
sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT |
|
DEC |
22 |
|
| NUM_SCAPS |
|
num_sec_appl_structs: Secondary Application Information |
|
DEC |
22 |
|
| LCK_TMOUT |
|
lock_timeouts: Number of Lock Timeouts Since Connect |
|
DEC |
22 |
|
| AGT_UCP_S |
|
agent_usr_cpu_time.seconds: Total User CPU Time of Appl. |
|
DEC |
22 |
|
| AGT_UPT_MS |
|
agent_usr_cpu_time.microsec: Total User CPU Time of Appl. |
|
DEC |
22 |
|
| AGT_SCT_S |
|
agent_sys_cpu_time.seconds: Total Application System CPU Tim |
|
DEC |
22 |
|
| AGT_SPT_MS |
|
agent_sys_cpu_time.microsec: Total Appl. System CPU Time |
|
DEC |
22 |
|
| INT_RW_INS |
|
int_rows_inserted: Number of Rows Inserted for Trigger |
|
DEC |
22 |
|
| RW_READ |
|
rows_read: Number of Rows Read Since Connection |
|
DEC |
22 |
|
| RW_WRITTEN |
|
rows_written: Number of Rows Written Since Connection |
|
DEC |
22 |
|
| DIRCT_RDS |
|
direct_reads: Direct Reads Since Connect |
|
DEC |
22 |
|
| DIRCT_WTS |
|
direct_writes: Direct Writes Since Connect |
|
DEC |
22 |
|
| DIRCT_RRQS |
|
direct_read_reqs: Direct Read Requests Since Connect |
|
DEC |
22 |
|
| DIRCT_WRQS |
|
direct_write_reqs: Direct Write Requests Since Connect |
|
DEC |
22 |
|
| DIRCT_RTM |
|
direct_read_time: Direct Read Time Since Connect |
|
DEC |
22 |
|
| DIRCT_WTM |
|
direct_write_time: Direct Write Time Since Connect |
|
DEC |
22 |
|
| OPN_LC_CR |
|
open_loc_curs: Local Cursors Currently Open |
|
DEC |
22 |
|
| OPN_LC_CRB |
|
open_loc_curs_blk: Local Cursors Currently Open Within Block |
|
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 |
|
| NUM_AGENTS |
|
num_agents: Number of Agents Currently Active |
|
DEC |
22 |
|
| AGT_STOLEN |
|
agents_stolen: Total Number of Agents Stolen from Appl. |
|
DEC |
22 |
|
| ASS_AGT_TP |
|
associated_agents_top: # of Agents Associated with this Appl |
|
DEC |
22 |
|
| AP_PRIO |
|
appl_priority: Priority with Which Application Agents Work |
|
DEC |
22 |
|
| AP_PRIO_TY |
|
appl_priority_type: Dynamic or Static |
|
CHAR |
25 |
|
| 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 |
|
| LCK_WTING |
|
locks_waiting: Number of Agents Currently Waiting for Locks |
|
DEC |
22 |
|
| OB_CN_ADDR |
|
DB6: Long identifier |
DB6LONGID |
CHAR |
32 |
|
| INBND_CNAD |
|
DB6: Long identifier |
DB6LONGID |
CHAR |
32 |
|
| OB_CN_PRTC |
|
outbound_comm_protocol: Outbound Communications Protocol |
|
INT4 |
10 |
|
| 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 |
|
| UOW_ELA_S |
|
uow_elapsed_time_s: Unit of Work elapse time sec |
|
DEC |
22 |
|
| UOW_ELA_MS |
|
uow_elapsed_time_ms: Unit of Work elapse time ms |
|
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 |
|
| POOL_XDA_L_READS |
|
|
|
DEC |
22 |
|
| POOL_XDA_P_READS |
|
|
|
DEC |
22 |
|
| POOL_XDA_WRITES |
|
|
|
DEC |
22 |
|
| PL_TEMP_XDA_L_RD |
|
|
|
DEC |
22 |
|
| PL_TEMP_XDA_P_RD |
|
|
|
DEC |
22 |
|
| ELPSD_EXC_TIM_MS |
|
|
|
DEC |
22 |
|
| ELPSD_EXC_TIM_S |
|
|
|
DEC |
22 |
|
| INACT_STMTHISTSZ |
|
|
|
DEC |
22 |
|
| LOCK_TIMEOUT_VAL |
|
|
|
DEC |
22 |
|
| PRV_WS_NUM_OVFL |
|
|
|
DEC |
22 |
|
| PRV_WS_SCT_INSRT |
|
|
|
DEC |
22 |
|
| PRV_WS_SCT_LKUP |
|
|
|
DEC |
22 |
|
| PRV_WS_SIZE_TOP |
|
|
|
DEC |
22 |
|
| SHR_WS_NUM_OVFL |
|
|
|
DEC |
22 |
|
| SHR_WS_SCT_INSRT |
|
|
|
DEC |
22 |
|
| SHR_WS_SCT_LKUP |
|
|
|
DEC |
22 |
|
| SHR_WS_SIZE_TOP |
|
|
|
DEC |
22 |
|
| OLAP_FUNC_OVERFLOWS |
|
|
|
DEC |
22 |
|
| TOTAL_OLAP_FUNCS |
|
|
|
DEC |
22 |
|