1 2 3 4 5 6 7 8 | > db2pd -latches: Address Holder Waiter Filename LOC LatchType HoldCount 0x0A00020001DA22A8 511780 69051 /view/db2_v97fp10_aix64_s141015/vbs/engn/sqp/inc/sqlpLockInternal.h 513 SQLO_LT_SQLP_LHSH__xhshlatch 1 0x0A00020001DA22A8 511780 261703 /view/db2_v97fp10_aix64_s141015/vbs/engn/sqp/inc/sqlpLockInternal.h 513 SQLO_LT_SQLP_LHSH__xhshlatch 1 …… |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | -------Frame------ ------Function + Offset------ 0x090000002104B258 thread_waitlock@glue881 + 0x8C 0x090000002104AFE0 sqloXlatchConflict + 0x1E8 0x090000002104AD3C sqloXlatchConflict@glue1AB + 0x78 0x0900000020F3D3C4 sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x24 0x0900000020F85FBC sqlrr_get_lock__FP8sqlrr_cbP14SQLP_LOCK_INFOUiPUi + 0x100 0x0900000020F85DD0 sqlra_pkg_lock__FP8sqlrr_cbPUcsT2T3T2iUiT7P14SQLP_LOCK_INFO + 0xB8 0x0900000020F852C4 sqlra_find_pkg__FP8sqlrr_cbPUcsT2T3T2T3iT8P14SQLP_LOCK_INFOPP20sqlra_cached_package + 0x190 0x0900000020F84ADC sqlra_revalidate_pkg__FP8sqlrr_cb + 0xA0 0x0900000020F84E24 .sqlra_load_pkg.fdpr.clone.2194__FP8sqlrr_cbPUcsT2T3T2b + 0x190 0x0900000020F7DB3C sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP15db2UCCursorInfo + 0x1678 0x0900000021093F54 sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP15db2UCCursorInfo + 0x9C |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | # 默认 APM_PERFORMANCE 为 OFF 的 trace | | | | | sqlra_get_section entry | | | | | | sqlra_load_pkg entry | | | | | | | sqlra_revalidate_pkg entry | | | | | | | | sqlra_find_pkg entry | | | | | | | | | sqlra_pkg_lock entry | | | | | | | | | | sqlra_fmt_pkg_lock entry | | | | | | | | | | sqlrr_get_lock entry | | | | | | | | | | | sqlplrq entry …… | | | | | | sqlra_load_pkg exit | | | | | | sqlra_set_stmt_authid_dynrules entry | | | | | | sqlra_set_stmt_authid_dynrules exit | | | | | sqlra_get_section exit # APM_PERFORMANCE为ON的trace | | | | | sqlra_get_section entry | | | | | | sqlra_set_stmt_authid_dynrules entry | | | | | | sqlra_set_stmt_authid_dynrules exit | | | | | sqlra_get_section exit |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |