increase cpu usage for a db2 process

[Andy S.]

Hi,

I'm running DB2 UDB v 7.2 FP 9 on WinXP and I'm new to DB2.

Currently, I have a Java program running on the DB2 server that is
executing a lot of stored procedueres that are doing a large number of
SELECT statements, doing computation on the data and then altering
every row of data.

The CPU usage of the db2syscs process however, is only 6-9%, with
SYSTEM IDLE taking up the remaing CPU percentage. Runstats and a reorg
have been very recently done on the tables and indexes that the stored
procs access.

I want to improve the performance of the stored procedures - can I
force DB2 to utilize more CPU % and if so, how should this be done?

Thanks!

[shenanwei]

db2set DB2NTPRICLASS=H
But the bottleneck of your system is not CPU, mostly it maybe memory
and HD.

[Jurgen Haan]

sh*******@gmail.com wrote:

db2set DB2NTPRICLASS=H
But the bottleneck of your system is not CPU, mostly it maybe memory
and HD.

Network connections are also very important.
And indeed memory and HD, check your swap, if it's being used often, you
lack memory, and for the disks check I/O settings (16/32 bits and DMA
settings).

-R-

[Andy S.]

Thanks for your replies! But how do I check these settings that you
mentioned above and how do I change them?

Thanks!

[Mark Yudkin]

As well as the DB2 monitopring tools, you could start with Start -> All
Programs -> Control Panel -> Administrative Tools -> Performance to see what
system bottlenecks you have.

"Andy S." <an******@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Thanks for your replies! But how do I check these settings that you
mentioned above and how do I change them?

Thanks!