By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

increase cpu usage for a db2 process

P: n/a
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!

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


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

Nov 12 '05 #2

P: n/a
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-
Nov 12 '05 #3

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

Thanks!

Nov 12 '05 #4

P: n/a
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!

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.