在AIX环境下,可以用ps -mo THREAD -p db2processid查看db2进程的线程
/home/db2inst1$ ps -mo THREAD -p 8912986
USER PID PPID TID S CP PRI SC WCHAN F TT BND COMMAND
db2inst1 8912986 10289202 - A 0 41 102 * 40401 - - db2sysc 0
- - - 12583143 S 0 60 1 - 410400 - - -
- - - 13500481 S 0 60 1 f1000e00005348c8 410400 - - -
- - - 25297149 S 0 60 1 f1000e000019b0c8 410400 - - -
- - - 25624651 S 0 60 1 f1000a00e0204518 410400 - - -
- - - 28115189 S 0 60 1 - 410400 - - -
- - - 30605475 S 0 60 1 f1000e00002f08c8 410400 - - -
- - - 31129833 S 0 60 1 - 410400 - - -
- - - 32178193 S 0 60 1 - 418400 - - -
- - - 32309255 S 0 60 1 - 410400 - - -
- - - 33292529 S 0 60 1 - 410400 - - -
- - - 33357951 S 0 60 1 f1000a00e0206b18 410400 - - -
- - - 34013247 S 0 41 1 f1000a00e022bfb0 410400 - - -
- - - 34078757 S 0 60 1 f1000a00e0d9cdb0 410400 - - -
- - - 34275501 S 0 60 1 - 410400 - - -
- - - 34406623 S 0 60 1 - 410400 - - -
- - - 34472037 S 0 60 1 - 410400 - - -
- - - 34537497 S 0 60 1 - 410400 - - -
- - - 34734283 S 0 60 1 f1000e00002bd8c8 410400 - - -
- - - 34799855 S 0 60 1 - 410400 - - -
- - - 35127333 S 0 60 1 - 410400 - - -
- - - 35192925 S 0 41 1 f1000a00e0d981b0 410400 - - -
- - - 35913979 S 0 60 1 - 410400 - - -
- - - 36110499 S 0 60 1 - 410400 - - -
- - - 36372633 S 0 60 1 f1000e00002bc0c8 410400 - - -
- - - 36569185 S 0 60 1 - 418400 - - -
线程TID是和db2pd -edus输出中的kernal TID对应的
/home/db2inst1$ db2pd -edus
Database Member 0 -- Active -- Up 9 days 01:01:15 -- Date 2017-08-16-02.09.46.652135
List of all EDUs for database member 0
db2sysc PID: 8912986
db2wdog PID: 10289202
db2acd PID: 7012556
EDU ID TID Kernel TID EDU Name USR (s) SYS (s)
========================================================================================================================================
26182 26182 59703369 db2agntdp (TXDB ) 0 1.375273 0.103658
25925 25925 53084333 db2agntdp (TXDB ) 0 1.269920 0.098693
25668 25668 28115189 db2agntdp (TXDB ) 0 1.325134 0.101984
25411 25411 54919185 db2agntdp (TXDB ) 0 1.320503 0.099623
24642 24642 49479889 db2agntdp (TXDB ) 0 1.281890 0.100879
17217 17217 57147597 db2agntdp (TXDB ) 0 1.314996 0.099963
25095 25095 56164431 db2agntdp (TXDB ) 0 0.018330 0.003432
24838 24838 57999497 db2agntdp (TXDB ) 0 0.153398 0.051114
24324 24324 59900035 db2agntdp (TXDB ) 0 8.347388 4.064667
24067 24067 51642493 db2agntdp (TXDB ) 0 0.037297 0.038547
23810 23810 59310239 db2agntdp (TXDB ) 0 0.023531 0.033115