How to identify the thread using high CPU in DB2?

1. Find db2sys process id
# ps -ef|grep -i db2sys

2. List a processes that currently running under db2sys
# ps -Lp 'db2sys_process_ID' -o pid,ppid,pcpu,pmem,lwp

3. Identify DB2 thread
# db2pd -edus


Viet Luu has written 313 articles

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Buy Me A Coffee

We are thankful for your never ending support.

Leave a Reply