How to list db2 threads on DB2 V9.5
less process and much more memory available
If you are on Linux
ps -ef | grep -i db2syc
Output:
db2inst1 7215 7213 0 09:32 pts/0 00:00:02 db2sysc 0
ps -lLfp 7215
Output:
F S UID PID PPID LWP C NLWP PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
4 S db2inst1 7215 7213 7215 0 21 80 0 - 114548 futex_ 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7219 0 21 80 0 - 114548 msgrcv 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7220 0 21 80 0 - 114548 hrtime 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7221 0 21 80 0 - 114548 semtim 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7222 0 21 80 0 - 114548 hrtime 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7223 0 21 80 0 - 114548 msgrcv 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7228 0 21 80 0 - 114548 semtim 09:32 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7265 0 21 80 0 - 114548 semtim 09:33 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7266 0 21 80 0 - 114548 semtim 09:33 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7267 0 21 80 0 - 114548 semtim 09:33 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7268 0 21 80 0 - 114548 semtim 09:33 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7269 0 21 80 0 - 114548 semtim 09:33 pts/0 00:00:00 db2sysc 0
1 S db2inst1 7215 7213 7270 0 21 80 0 - 114548 semtim 09:33 pts/0 00:00:00 db2sysc 0
If you are on Aix:
ps -m -o THREAD -p 7215
Or, you can use a command whererer OS you are:
db2pd -edus
Output:
List of all EDUs for database partition 0
db2sysc PID: 7215
db2wdog PID: 7213
db2acd PID: 7230
EDU ID TID Kernel TID EDU Name USR SYS
=========================================================================================================
29 2950687632 7460 db2agntdp (CASE ) 0 0.020000 0.020000
28 2951736208 7459 db2agent (idle) 0 0.040000 0.000000
27 2952784784 7280 db2evmgi (DB2DETAILDEADLOCK) 0 0.140000 0.420000
26 2953833360 7279 db2wlmd (CASE) 0 0.220000 0.360000
25 2954881936 7278 db2taskd (CASE) 0 0.000000 0.000000
24 2955930512 7273 db2pfchr (CASE) 0 0.000000 0.000000
23 2956979088 7272 db2pfchr (CASE) 0 0.000000 0.000000
22 2958027664 7271 db2pfchr (CASE) 0 0.000000 0.000000
21 2959076240 7270 db2pclnr (CASE) 0 0.000000 0.000000
20 2960124816 7269 db2dlock (CASE) 0 0.020000 0.000000
19 2961173392 7268 db2lfr (CASE) 0 0.000000 0.000000
18 2962221968 7267 db2loggw (CASE) 0 0.100000 0.020000
17 2963270544 7266 db2loggr (CASE) 0 0.380000 0.380000
16 2964319120 7265 db2agent (CASE) 0 0.080000 0.180000
15 2965367696 7228 db2resync 0 0.000000 0.000000
14 2966416272 7223 db2ipccm 0 0.000000 0.000000
13 2967464848 7222 db2licc 0 0.000000 0.000000
12 2968513424 7221 db2thcln 0 0.000000 0.000000
11 2969562000 7220 db2alarm 0 0.000000 0.060000
1 2938104720 7219 db2sysc 0 0.340000 0.120000