Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption

The invention discloses a quick positioning method of a DB2 process/ thread with high CPU (Central Processing Unit) consumption. The quick positioning method comprises the following steps: a) firstly, checking a process which operates at present and the CPU use rate situation of the process, and judging whether a high CPU consumption process in a system is the DB2 process or not; b) if a DB2 process is determined as the high CPU consumption process, monitoring a DB2 database, and positioning an agent which causes the high CPU consumption; and c) finally, positioning a database operation with the high CPU consumption in the agent. An operating system monitoring command and a database monitoring tool are subjected to combined use, the associated agent is found via the DB2 process which causes the high CPU consumption, finally, the database operation which causes the associated agent to use more CPU is positioned, and therefore, the DB2 process/ thread with the high CPU consumption and the associated database op