本文只是连接开个头,很多东西还有待深入研究。细信息
环境
- Ubuntu 22.04
- Db2 v11.5.0.0
- SQuirreL SQL Client snapshot-20220916_2347
背景
程序运行时,连接发现有长时间的细信息Db2连接,一直没有释放。连接
想要查看某个Db2连接的细信息详细信息,一般有两种方法。连接
list applications
命令mon_get_connection
表函数
list applications
命令
详见 https://www.ibm.com/docs/en/db2/11.5?细信息topic=commands-list-applications
。
可以加上 show detail
,连接例如:
➜ ~ db2 list applications show detailCONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating Coordinator Status Status Change Time DB Name DB Path Handle Agents member number pid/thread-------------------------------------------------------------------------------------------------------------------------------- -------------------- ---------- -------------------------------------------------------------- ----- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------DB2INST1 db2bp 32 *LOCAL.db2inst1.220919104401 00002 1 0 69 UOW Waiting Not Collected SAMPLE /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/DB2INST1 db2bp 47 *LOCAL.db2inst1.220919105513 00003 1 0 67 Lock-wait Not Collected SAMPLE /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/DB2INST1 db2jcc_application 93 127.0.0.1.41034.220919112857 00013 1 0 72 UOW Waiting Not Collected SAMPLE /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/DB2INST1 db2bp 33 *LOCAL.db2inst1.220919104539 00005 1 0 23 UOW Waiting Not Collected SAMPLE /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/DB2INST1 db2fw0 13 *LOCAL.DB2.220919104202 00001 1 0 54 Connect Completed Not Collected SAMPLE /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/DB2INST1 db2fw6 19 *LOCAL.DB2.220919104208 00001 1 0 60 Connect Completed Not Collected SAMPLE /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/......
Application Name
- Db2命令行,细信息是连接
db2bp
; - Squirrel,是细信息
db2jcc_application
; - 在代码中可以给session命名;
Application Handle
可用 db2 "values mon_get_application_handle()"
命令查看当前连接的handle值,以便对照。连接
Status
常见的细信息status有:
- UOW Waiting
- UOW Executing
- Lock-wait
- Connect Completed
- …
下面来具体看一下。
UOW Waiting
- 只要连接上DB,连接比如在命令行下
db2 connect to sample
,或者在Squirrel图形界面下连接到DB,不做任何操作; - 运行一个事务(不提交),比如
db2 +c "update t1 set c2 = 333 where c1 = 1"
(运行非常快); - 结束一个事务,比如
db2 rollback
或者直接db2 "select * from t1"
(运行非常快);
可见, UOW Waiting
是最常见的状态。
UOW Executing
顾名思义,表示当前SQL正在运行,比如 db2 "WITH TEMP1 (NUM,TS1,TS2) AS (VALUES (INT(1) ,TIMESTAMP(GENERATE_UNIQUE()) ,TIMESTAMP(GENERATE_UNIQUE())) UNION ALL SELECT NUM + 1 ,TS1 ,TIMESTAMP(GENERATE_UNIQUE()) FROM TEMP1 WHERE TIMESTAMPDIFF(2,CHAR(TS2-TS1)) < 300) SELECT MAX(NUM) AS #LOOPS ,MIN(TS2) AS BGN_TIMESTAMP ,MAX(TS2) AS END_TIMESTAMP FROM TEMP1 "
。该SQL会运行300秒,在运行期间,其所在连接的状态就是 UOW Executing
。
Lock-wait
顾名思义,如果当前正在运行的SQL在等待锁,则状态就是 Lock-wait
。
Connect Completed
这个状态我不知道怎么搞出来的。网上说是“The application is successfully connected to the library”,但是前面提到,只要连接上DB,不做任何操作,其状态是 UOW Waiting
。该状态还有待研究。
mon_get_connection
表函数
详见 https://www.ibm.com/docs/en/db2/11.5?topic=functions-mon-get-connection-get-connection-metrics
。
比如:
➜ ~ db2 "select * from table(mon_get_connection(null, -2))"APPLICATION_HANDLE APPLICATION_NAME APPLICATION_ID MEMBER CLIENT_WRKSTNNAME CLIENT_ACCTNG CLIENT_USERID CLIENT_APPLNAME CLIENT_PID CLIENT_PRDID CLIENT_PLATFORM CLIENT_PROTOCOL SYSTEM_AUTH_ID SESSION_AUTH_ID COORD_MEMBER CONNECTION_START_TIME ACT_ABORTED_TOTAL ACT_COMPLETED_TOTAL ACT_REJECTED_TOTAL AGENT_WAIT_TIME AGENT_WAITS_TOTAL POOL_DATA_L_READS POOL_INDEX_L_READS POOL_TEMP_DATA_L_READS POOL_TEMP_INDEX_L_READS POOL_TEMP_XDA_L_READS POOL_XDA_L_READS POOL_DATA_P_READS POOL_INDEX_P_READS POOL_TEMP_DATA_P_READS POOL_TEMP_INDEX_P_READS POOL_TEMP_XDA_P_READS POOL_XDA_P_READS POOL_DATA_WRITES POOL_INDEX_WRITES POOL_XDA_WRITES POOL_READ_TIME POOL_WRITE_TIME CLIENT_IDLE_WAIT_TIME DEADLOCKS DIRECT_READS DIRECT_READ_TIME DIRECT_WRITES DIRECT_WRITE_TIME DIRECT_READ_REQS DIRECT_WRITE_REQS FCM_RECV_VOLUME FCM_RECVS_TOTAL FCM_SEND_VOLUME FCM_SENDS_TOTAL FCM_RECV_WAIT_TIME FCM_SEND_WAIT_TIME IPC_RECV_VOLUME IPC_RECV_WAIT_TIME IPC_RECVS_TOTAL IPC_SEND_VOLUME IPC_SEND_WAIT_TIME IPC_SENDS_TOTAL LOCK_ESCALS LOCK_TIMEOUTS LOCK_WAIT_TIME LOCK_WAITS LOG_BUFFER_WAIT_TIME NUM_LOG_BUFFER_FULL LOG_DISK_WAIT_TIME LOG_DISK_WAITS_TOTAL NUM_LOCKS_HELD RQSTS_COMPLETED_TOTAL ROWS_MODIFIED ROWS_READ ROWS_RETURNED TCPIP_RECV_VOLUME TCPIP_SEND_VOLUME TCPIP_RECV_WAIT_TIME TCPIP_RECVS_TOTAL TCPIP_SEND_WAIT_TIME TCPIP_SENDS_TOTAL TOTAL_APP_RQST_TIME TOTAL_RQST_TIME WLM_QUEUE_TIME_TOTAL WLM_QUEUE_ASSIGNMENTS_TOTAL TOTAL_CPU_TIME TOTAL_WAIT_TIME APP_RQSTS_COMPLETED_TOTAL TOTAL_SECTION_SORT_TIME TOTAL_SECTION_SORT_PROC_TIME TOTAL_SECTION_SORTS TOTAL_SORTS POST_THRESHOLD_SORTS POST_SHRTHRESHOLD_SORTS SORT_OVERFLOWS TOTAL_COMPILE_TIME TOTAL_COMPILE_PROC_TIME TOTAL_COMPILATIONS TOTAL_IMPLICIT_COMPILE_TIME TOTAL_IMPLICIT_COMPILE_PROC_TIME TOTAL_IMPLICIT_COMPILATIONS TOTAL_SECTION_TIME TOTAL_SECTION_PROC_TIME TOTAL_APP_SECTION_EXECUTIONS TOTAL_ACT_TIME TOTAL_ACT_WAIT_TIME ACT_RQSTS_TOTAL TOTAL_ROUTINE_TIME TOTAL_ROUTINE_INVOCATIONS TOTAL_COMMIT_TIME TOTAL_COMMIT_PROC_TIME TOTAL_APP_COMMITS INT_COMMITS TOTAL_ROLLBACK_TIME TOTAL_ROLLBACK_PROC_TIME TOTAL_APP_ROLLBACKS INT_ROLLBACKS TOTAL_RUNSTATS_TIME TOTAL_RUNSTATS_PROC_TIME TOTAL_RUNSTATS TOTAL_REORG_TIME TOTAL_REORG_PROC_TIME TOTAL_REORGS TOTAL_LOAD_TIME TOTAL_LOAD_PROC_TIME TOTAL_LOADS CAT_CACHE_INSERTS CAT_CACHE_LOOKUPS PKG_CACHE_INSERTS PKG_CACHE_LOOKUPS THRESH_VIOLATIONS NUM_LW_THRESH_EXCEEDED LOCK_WAITS_GLOBAL LOCK_WAIT_TIME_GLOBAL LOCK_TIMEOUTS_GLOBAL LOCK_ESCALS_MAXLOCKS LOCK_ESCALS_LOCKLIST LOCK_ESCALS_GLOBAL RECLAIM_WAIT_TIME SPACEMAPPAGE_RECLAIM_WAIT_TIME CF_WAITS CF_WAIT_TIME POOL_DATA_GBP_L_READS POOL_DATA_GBP_P_READS POOL_DATA_LBP_PAGES_FOUND POOL_DATA_GBP_INVALID_PAGES POOL_INDEX_GBP_L_READS POOL_INDEX_GBP_P_READS POOL_INDEX_LBP_PAGES_FOUND POOL_INDEX_GBP_INVALID_PAGES POOL_XDA_GBP_L_READS POOL_XDA_GBP_P_READS POOL_XDA_LBP_PAGES_FOUND POOL_XDA_GBP_INVALID_PAGES AUDIT_EVENTS_TOTAL AUDIT_FILE_WRITES_TOTAL AUDIT_FILE_WRITE_WAIT_TIME AUDIT_SUBSYSTEM_WAITS_TOTAL AUDIT_SUBSYSTEM_WAIT_TIME CLIENT_HOSTNAME CLIENT_PORT_NUMBER DIAGLOG_WRITES_TOTAL DIAGLOG_WRITE_WAIT_TIME FCM_MESSAGE_RECVS_TOTAL FCM_MESSAGE_RECV_VOLUME FCM_MESSAGE_RECV_WAIT_TIME FCM_MESSAGE_SENDS_TOTAL FCM_MESSAGE_SEND_VOLUME FCM_MESSAGE_SEND_WAIT_TIME FCM_TQ_RECVS_TOTAL FCM_TQ_RECV_VOLUME FCM_TQ_RECV_WAIT_TIME FCM_TQ_SENDS_TOTAL FCM_TQ_SEND_VOLUME FCM_TQ_SEND_WAIT_TIME LAST_EXECUTABLE_ID LAST_REQUEST_TYPE TOTAL_ROUTINE_USER_CODE_PROC_TIME TOTAL_ROUTINE_USER_CODE_TIME TQ_TOT_SEND_SPILLS EVMON_WAIT_TIME EVMON_WAITS_TOTAL TOTAL_EXTENDED_LATCH_WAIT_TIME TOTAL_EXTENDED_LATCH_WAITS INTRA_PARALLEL_STATE TOTAL_STATS_FABRICATION_TIME TOTAL_STATS_FABRICATION_PROC_TIME TOTAL_STATS_FABRICATIONS TOTAL_SYNC_RUNSTATS_TIME TOTAL_SYNC_RUNSTATS_PROC_TIME TOTAL_SYNC_RUNSTATS TOTAL_DISP_RUN_QUEUE_TIME TOTAL_PEDS DISABLED_PEDS POST_THRESHOLD_PEDS TOTAL_PEAS POST_THRESHOLD_PEAS TQ_SORT_HEAP_REQUESTS TQ_SORT_HEAP_REJECTIONS POOL_QUEUED_ASYNC_DATA_REQS POOL_QUEUED_ASYNC_INDEX_REQS POOL_QUEUED_ASYNC_XDA_REQS POOL_QUEUED_ASYNC_TEMP_DATA_REQS POOL_QUEUED_ASYNC_TEMP_INDEX_REQS POOL_QUEUED_ASYNC_TEMP_XDA_REQS POOL_QUEUED_ASYNC_OTHER_REQS POOL_QUEUED_ASYNC_DATA_PAGES POOL_QUEUED_ASYNC_INDEX_PAGES POOL_QUEUED_ASYNC_XDA_PAGES POOL_QUEUED_ASYNC_TEMP_DATA_PAGES POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES POOL_QUEUED_ASYNC_TEMP_XDA_PAGES POOL_FAILED_ASYNC_DATA_REQS POOL_FAILED_ASYNC_INDEX_REQS POOL_FAILED_ASYNC_XDA_REQS POOL_FAILED_ASYNC_TEMP_DATA_REQS POOL_FAILED_ASYNC_TEMP_INDEX_REQS POOL_FAILED_ASYNC_TEMP_XDA_REQS POOL_FAILED_ASYNC_OTHER_REQS PREFETCH_WAIT_TIME PREFETCH_WAITS APP_ACT_COMPLETED_TOTAL APP_ACT_ABORTED_TOTAL APP_ACT_REJECTED_TOTAL TOTAL_CONNECT_REQUEST_TIME TOTAL_CONNECT_REQUEST_PROC_TIME TOTAL_CONNECT_REQUESTS TOTAL_CONNECT_AUTHENTICATION_TIME TOTAL_CONNECT_AUTHENTICATION_PROC_TIME TOTAL_CONNECT_AUTHENTICATIONS POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP COMM_EXIT_WAIT_TIME COMM_EXIT_WAITS IDA_SEND_WAIT_TIME IDA_SENDS_TOTAL IDA_SEND_VOLUME IDA_RECV_WAIT_TIME IDA_RECVS_TOTAL IDA_RECV_VOLUME MEMBER_SUBSET_ID IS_SYSTEM_APPL LOCK_TIMEOUT_VAL CURRENT_ISOLATION NUM_LOCKS_WAITING UOW_CLIENT_IDLE_WAIT_TIME ROWS_DELETED ROWS_INSERTED ROWS_UPDATED TOTAL_HASH_JOINS TOTAL_HASH_LOOPS HASH_JOIN_OVERFLOWS HASH_JOIN_SMALL_OVERFLOWS POST_SHRTHRESHOLD_HASH_JOINS TOTAL_OLAP_FUNCS OLAP_FUNC_OVERFLOWS DYNAMIC_SQL_STMTS STATIC_SQL_STMTS FAILED_SQL_STMTS SELECT_SQL_STMTS UID_SQL_STMTS DDL_SQL_STMTS MERGE_SQL_STMTS XQUERY_STMTS IMPLICIT_REBINDS BINDS_PRECOMPILES INT_ROWS_DELETED INT_ROWS_INSERTED INT_ROWS_UPDATED CALL_SQL_STMTS POOL_COL_L_READS POOL_TEMP_COL_L_READS POOL_COL_P_READS POOL_TEMP_COL_P_READS POOL_COL_LBP_PAGES_FOUND POOL_COL_WRITES POOL_COL_GBP_L_READS POOL_COL_GBP_P_READS POOL_COL_GBP_INVALID_PAGES POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP POOL_QUEUED_ASYNC_COL_REQS POOL_QUEUED_ASYNC_TEMP_COL_REQS POOL_QUEUED_ASYNC_COL_PAGES POOL_QUEUED_ASYNC_TEMP_COL_PAGES POOL_FAILED_ASYNC_COL_REQS POOL_FAILED_ASYNC_TEMP_COL_REQS TOTAL_COL_TIME TOTAL_COL_PROC_TIME TOTAL_COL_EXECUTIONS CLIENT_IPADDR SQL_REQS_SINCE_COMMIT UOW_START_TIME UOW_STOP_TIME PREV_UOW_STOP_TIME UOW_COMP_STATUS NUM_ASSOC_AGENTS ASSOCIATED_AGENTS_TOP WORKLOAD_OCCURRENCE_STATE POST_THRESHOLD_HASH_JOINS POOL_DATA_CACHING_TIER_L_READS POOL_INDEX_CACHING_TIER_L_READS POOL_XDA_CACHING_TIER_L_READS POOL_COL_CACHING_TIER_L_READS POOL_DATA_CACHING_TIER_PAGE_WRITES POOL_INDEX_CACHING_TIER_PAGE_WRITES POOL_XDA_CACHING_TIER_PAGE_WRITES POOL_COL_CACHING_TIER_PAGE_WRITES POOL_DATA_CACHING_TIER_PAGE_UPDATES POOL_INDEX_CACHING_TIER_PAGE_UPDATES POOL_XDA_CACHING_TIER_PAGE_UPDATES POOL_COL_CACHING_TIER_PAGE_UPDATES POOL_CACHING_TIER_PAGE_READ_TIME POOL_CACHING_TIER_PAGE_WRITE_TIME POOL_DATA_CACHING_TIER_PAGES_FOUND POOL_INDEX_CACHING_TIER_PAGES_FOUND POOL_XDA_CACHING_TIER_PAGES_FOUND POOL_COL_CACHING_TIER_PAGES_FOUND POOL_DATA_CACHING_TIER_GBP_INVALID_PAGES POOL_INDEX_CACHING_TIER_GBP_INVALID_PAGES POOL_XDA_CACHING_TIER_GBP_INVALID_PAGES POOL_COL_CACHING_TIER_GBP_INVALID_PAGES POOL_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND POOL_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND POOL_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND POOL_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND TOTAL_HASH_GRPBYS HASH_GRPBY_OVERFLOWS POST_THRESHOLD_HASH_GRPBYS EXECUTION_ID POST_THRESHOLD_OLAP_FUNCS EXT_TABLE_RECV_WAIT_TIME EXT_TABLE_RECVS_TOTAL EXT_TABLE_RECV_VOLUME EXT_TABLE_READ_VOLUME EXT_TABLE_SEND_WAIT_TIME EXT_TABLE_SENDS_TOTAL EXT_TABLE_SEND_VOLUME EXT_TABLE_WRITE_VOLUME POST_THRESHOLD_COL_VECTOR_CONSUMERS TOTAL_COL_VECTOR_CONSUMERS ACTIVE_HASH_GRPBYS ACTIVE_HASH_JOINS ACTIVE_OLAP_FUNCS ACTIVE_PEAS ACTIVE_PEDS ACTIVE_SORT_CONSUMERS ACTIVE_SORTS ACTIVE_COL_VECTOR_CONSUMERS SORT_HEAP_ALLOCATED SORT_SHRHEAP_ALLOCATED TOTAL_BACKUP_TIME TOTAL_BACKUP_PROC_TIME TOTAL_BACKUPS TOTAL_INDEX_BUILD_TIME TOTAL_INDEX_BUILD_PROC_TIME TOTAL_INDEXES_BUILT FCM_TQ_RECV_WAITS_TOTAL FCM_MESSAGE_RECV_WAITS_TOTAL FCM_TQ_SEND_WAITS_TOTAL FCM_MESSAGE_SEND_WAITS_TOTAL FCM_SEND_WAITS_TOTAL FCM_RECV_WAITS_TOTAL COL_VECTOR_CONSUMER_OVERFLOWS TOTAL_COL_SYNOPSIS_TIME TOTAL_COL_SYNOPSIS_PROC_TIME TOTAL_COL_SYNOPSIS_EXECUTIONS COL_SYNOPSIS_ROWS_INSERTED CONNECTION_REUSABILITY_STATUS REUSABILITY_STATUS_REASON APPL_SECTION_INSERTS APPL_SECTION_LOOKUPS LOB_PREFETCH_WAIT_TIME LOB_PREFETCH_REQS FED_ROWS_DELETED FED_ROWS_INSERTED FED_ROWS_UPDATED FED_ROWS_READ FED_WAIT_TIME FED_WAITS_TOTAL ADM_OVERFLOWS ADM_BYPASS_ACT_TOTAL-------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------- --------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------ -------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ----------------------- --------------------- -------------------- -------------------- -------------------- ---------------------- ----------------------- --------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------------- -------------------- -------------------- ------------------------- ----------------------- ---------------------------- -------------------- -------------------- -------------------- ----------------------- -------------------- -------------------- ----------------------- -------------------- --------------------------- -------------------------------- --------------------------- -------------------- ----------------------- ---------------------------- -------------------- -------------------- -------------------- -------------------- ------------------------- -------------------- ---------------------- -------------------- -------------------- -------------------- ------------------------ -------------------- -------------------- -------------------- ------------------------ -------------------- -------------------- --------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- -------------------- --------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ------------------------------ -------------------- -------------------- --------------------- --------------------- ------------------------- --------------------------- ---------------------- ---------------------- -------------------------- ---------------------------- -------------------- -------------------- ------------------------ -------------------------- -------------------- ----------------------- -------------------------- --------------------------- ------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------ -------------------- ----------------------- ----------------------- ----------------------- -------------------------- ----------------------- ----------------------- -------------------------- -------------------- -------------------- --------------------- -------------------- -------------------- --------------------- ------------------------------------------------------------------- -------------------------------- --------------------------------- ---------------------------- -------------------- -------------------- -------------------- ------------------------------ -------------------------- -------------------- ---------------------------- --------------------------------- ------------------------ ------------------------ ----------------------------- -------------------- ------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- ----------------------- --------------------------- ---------------------------- -------------------------- -------------------------------- --------------------------------- ------------------------------- ---------------------------- ---------------------------- ----------------------------- --------------------------- --------------------------------- ---------------------------------- -------------------------------- --------------------------- ---------------------------- -------------------------- -------------------------------- --------------------------------- ------------------------------- ---------------------------- -------------------- -------------------- ----------------------- --------------------- ---------------------- -------------------------- ------------------------------- ---------------------- --------------------------------- -------------------------------------- ----------------------------- -------------------------------------- --------------------------------------- ------------------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------- -------------- -------------------- ----------------- -------------------- ------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ------------------------- ---------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- -------------------- --------------------- ------------------------ -------------------- -------------------- -------------------- -------------------------- ------------------------------------- -------------------------- ------------------------------- --------------------------- -------------------------------- -------------------------- ------------------------------- -------------------- -------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- -------------------------- -------------------------- -------------------------- --------------- -------------------- --------------------- -------------------------------- ------------------------- ------------------------------ ------------------------------- ----------------------------- ----------------------------- ---------------------------------- ----------------------------------- --------------------------------- --------------------------------- ----------------------------------- ------------------------------------ ---------------------------------- ---------------------------------- -------------------------------- --------------------------------- ---------------------------------- ----------------------------------- --------------------------------- --------------------------------- ---------------------------------------- ----------------------------------------- --------------------------------------- --------------------------------------- -------------------------------------------- --------------------------------------------- ------------------------------------------- ------------------------------------------- -------------------- -------------------- -------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------- ------------------------ --------------------- --------------------- --------------------- ------------------------ --------------------- --------------------- ---------------------- ----------------------------------- -------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- -------------------- --------------------------- -------------------- ---------------------- -------------------- ---------------------- -------------------- ---------------------- --------------------------- -------------------- ----------------------- ---------------------------- ----------------------- ---------------------------- -------------------- -------------------- ----------------------------- ----------------------- ---------------------------- ----------------------------- -------------------------- ----------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- -------------------- ---------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- 32 db2bp *LOCAL.db2inst1.220919104401 0 - - - - 48001 SQL11050 LINUXX8664 LOCAL DB2INST1 DB2INST1 0 2022-09-19-18.44.01.361629 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5180594 0 0 0 0 0 0 0 0 0 0 0 0 0 845 0 7 997 0 7 0 0 0 0 0 0 0 0 2 9 0 2 2 0 0 0 0 0 0 3 3 0 0 54312 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ding-ubuntu - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x'01000000000000001A0000000000000000000000020020220919185519690814' OPEN 0 0 0 0 0 0 3 NO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 2 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 -2 0 -1 0 1 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 2 2022-09-19-20.10.27.066041 - 2022-09-19-18.55.22.912504 - 1 1 UOWEXEC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 db2inst1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - 0 4 0 0 0 0 0 0 0 0 0 1 47 db2bp *LOCAL.db2inst1.220919105513 0 - - - - 47821 SQL11050 LINUXX8664 LOCAL DB2INST1 DB2INST1 0 2022-09-19-18.55.13.769519 0 3 0 0 0 8 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 791860 0 12 1 0 0 2 0 0 0 0 0 0 0 1434 0 14 1573 0 14 0 0 3714341 1 0 0 2 1 0 16 1 6 3 0 0 0 0 0 0 3714392 3714392 0 0 2613435 3714344 16 0 0 0 0 0 0 0 24 23 3 0 0 0 3714361 20 3 3714361 3714341 5 0 1 2 0 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 44 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 5 0 0 0 0 0 0 0 0 0 0 ding-ubuntu - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x'0100000000000000260000000000000000000000020020220919190410803651' COMMIT 0 0 0 0 0 0 5 NO 19 19 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 3 3 1 2 2 1 8 5 0 0 0 0 0 0 0 0 0 -2 0 -1 0 2 0 0 1 0 0 0 0 0 0 0 3 3 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 2022-09-19-19.04.10.802117 2022-09-19-20.06.05.167000 2022-09-19-18.55.40.059273 UOWCOMMIT 1 1 UOWWAIT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 db2inst1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - 3 9 0 0 0 0 0 0 0 0 0 3 93 db2jcc_application 127.0.0.1.41034.220919112857 0 127.0.1.1 - - - - JCC04210 DRDA TCPIP4 DB2INST1 DB2INST1 0 2022-09-19-19.28.57.299266 0 22 0 0 0 763 467 20 0 0 0 40 168 0 0 0 0 0 0 0 295 0 2484501 0 786 105 0 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 481 7623 1743 4943 163468 1 27 2 27 839 839 0 0 271389 485 40 6 6 12 12 0 0 1 586 179 17 0 0 0 113 110 22 730 440 33 617 17 1 1 12 1 0 0 0 0 0 0 0 0 0 0 0 0 0 27 289 17 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 743 0 0 0 299 0 0 0 0 0 0 0 0 0 0 127.0.1.1 41034 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x'0100000000000000490000000000000000000000020020220919193252828056' COMMIT 20 92 0 0 0 0 25 NO 0 0 0 381 109 4 0 0 0 0 0 0 0 0 123 0 0 0 0 0 1 494 0 0 0 0 0 0 0 0 0 0 0 0 81 22 12 0 0 29 28 1 28 28 1 743 299 0 0 0 0 0 0 0 0 0 0 0 -1 0 942 0 0 0 1 0 0 0 0 0 0 18 16 0 12 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 127.0.0.1 0 2022-09-19-19.32.52.808705 2022-09-19-19.32.52.909890 2022-09-19-19.28.59.830871 UOWCOMMIT 1 1 UOWWAIT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 DB2INST1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - 18 51 0 0 0 0 0 0 0 0 0 22 33 db2bp *LOCAL.db2inst1.220919104539 0 - - - - 47483 SQL11050 LINUXX8664 LOCAL DB2INST1 DB2INST1 0 2022-09-19-18.45.39.482893 1 5 0 0 0 31 65 12041947 0 0 0 11 32 0 0 0 0 2646 0 0 68 76 5064922 0 16 27 0 0 3 0 0 0 0 0 0 0 2624 0 24 2720 1 24 0 0 0 0 0 0 0 1 0 26 11857501 23741034 5 0 0 0 0 0 0 15546 15546 0 0 15497250 174 26 0 0 0 0 0 0 0 210 115 4 0 0 0 15318 15239 6 15318 79 9 0 1 0 0 2 1 10 10 3 0 0 0 0 0 0 0 0 0 0 0 43 4 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12041967 0 0 0 33 0 0 0 0 0 0 0 0 0 0 ding-ubuntu - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x'0100000000000000590000000000000000000000020020220919200551675715' ROLLBACK 0 0 0 0 0 2 8 NO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 1 0 2 2 1 1 1 1 12041967 33 0 0 0 0 0 0 0 0 0 -2 0 -1 0 4731419 0 0 2 0 0 0 0 0 0 0 6 5 1 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 2022-09-19-19.03.47.464913 2022-09-19-20.06.05.164619 2022-09-19-19.03.10.208068 UOWROLLBACK 1 1 UOWWAIT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 db2inst1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - 4 17 0 0 0 0 0 0 0 0 0 6 4 record(s) selected.
APPLICATION_HANDLE
同上。
APPLICATION_NAME
同上。
XXX_TIME
有无数的 XXX_TIME
,比如 CLIENT_IDLE_WAIT_TIME
、 LOCK_WAIT_TIME
、 TOTAL_WAIT_TIME
等等。
LAST_EXECUTABLE_ID
LAST_REQUEST_TYPE
UOW_START_TIME 和 UOW_STOP_TIME
UOW_COMP_STATUS
WORKLOAD_OCCURRENCE_STATE
参考
https://topic.alibabacloud.com/a/the-most-common-state-of-db2-applications_8_8_30007447.html
https://blog.karthisoftek.com/a?ID=00500-8874ce84-6c08-4d48-86a7-435a6ab31210