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