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!

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

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

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

Thanks!

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." <andys506@hotmail.com> wrote in message
news:1117039918.319121.204090@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!
>