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 143 articles

Leave a Reply