High CPU on DB2 production servers

palchuri · #1 (**permalink**) 02-13-06, 09:52

We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.

Shri

JAYANTA_DATTA · #2 (**permalink**) 02-13-06, 10:01

Quote:

Originally Posted by palchuri

We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.

Shri

Hi Dear,

TO know the CPU usage by different processes: please run the following..

prstat -a

But make it sure first that prstat is installed and given proper privilege to the user by the System Admin.

Thanks,
Jay (Delhi NCR), India

J Petruk · #3 (**permalink**) 02-13-06, 10:24

Quote:

Originally Posted by palchuri

We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.

Shri

What OS? What version of DB2?

bala_e · #4 (**permalink**) 02-13-06, 11:46

Quote:

Originally Posted by palchuri

We are having db2 server in production. Most of the times it is showing the CPU is 100%. How can I find who is cause for this high cpu Is it related to application or db2 instance or space.

Are there any monitors or utilites avialble for db2 to find out the culprit of the high cpu.

Shri

Use 'topas' it will give full details.

Internet Services

Web Development

Digital Marketing

Consumer Tech