我怎样才能让DB2使用更多的CPU [英] How can I let DB2 to use more CPU
问题描述
我们在Windows 2003服务器上安装DB2 V8.1.5有2个intel cpu。
我注意到无论我的应用程序多忙，CPU和磁盘使用率都非常低。
我们怎样才能让DB2在Windows 2003上充分利用系统资源？
提前致谢。
Richard
ri ********* @ canada .com 写道：
我们在Windows 2003服务器上安装DB2 V8.1.5有2个intel cpu。
我注意到CPU和磁盘使用率非常高无论我的应用程序有多忙，都可以使用。
我们怎样才能让DB2在Windows 2003上充分利用系统资源？
先谢谢。
Richard
DB2没有内置限制（除非你配置了调控器，
但我不认为你会如果你有问题，可以问这个问题。
如果CPU和磁盘不是'在您的服务器上出现问题，这是一件好事。
如果应用程序性能有问题，那么您需要查看
应用程序才能看到这是怎么回事。它可能是应用程序的问题，
或它与数据库的交互（即并发 - 锁定问题）。
祝你好运，
----- =通过Newsfeeds.Com发布，未经审查的Usenet新闻= -----
http://www.newsfeeds.com - 世界排名第一的新闻组服务！
----- ==超过100,000个新闻组 - 19种不同的服务器= -----
ri ***** **** @ canada.com 写道：我们在Windows 2003服务器上安装DB2 V8.1.5有2个intel cpu。
我注意到CPU和磁盘的使用情况无论我的应用程序有多忙，都非常低。
我们怎样才能让DB2在Windows 2003上充分利用系统资源？
提前谢谢。
Richard
我不再运行Windows了，从不在其上运行DB2。
我在RHEL 3 ES上运行DB2 V8.1.5 ，带两个XEON处理器4 Ultra / 320
我曾经在一台带有两个10,000rpm Ultra-2 LVD硬件
Pentium IIIs），IO也不受限制（通常为1兆字节/秒IO），但它是
$ b即使没有其他进程使用CPU，$ b仍然很慢。但是你可以通过所有点击来告诉
这个过程是有限的。因此
新机器上的所有硬盘驱动器。
我不需要所有6个主轴的所有存储容量，而是通过划分
更好的东西和使用DMS容器（在RHL 7.3上无法做到这一点），
新机器比以前快10到20倍。它仍然运行在大约
320％等待状态（2个超线程XEON处理器可能达到400％），
这令人沮丧。我正在运行7页取件器和7页清洁器，
但是页面清洁器都处于状态D（等待IO）很多时间。
时间。现在也许在表空间上更明智地分配表格
会有所帮助。我不能轻易判断它是否有限，因为新的
磁盘驱动器是静音的。
我所拥有的是三个硬盘上的主要数据，和第四个上的那些
数据的索引。这些是快速的SCSI驱动器。
一些中等大小的东西（对我而言）：总共3260页，是一个
IDE驱动器上的短信和另一个IDE驱动器中有44页很小的无聊东西
（日志文件也在这里）。我已经研究了它，所以当我运行时，
寻求应该被最小化。
因为它比旧机器快20倍（a> 10个小时的工作时间大约35分钟，我不会出汗，但是我希望我可以减少IO
等待时间，因为我只跑了大约40一个CPU的百分比和另一个3.6几美元的CPU几乎无关。
一个坏主意是运行setiathome（完全由计算限制）。我运行它
nice 19这使得它最不可能在处理器上获得一个机会，但是它将bb的速度降低了一半。我目前的猜测是处理器缓存正在加扰。
-
.~。 Jean-David Beyer已注册Linux用户85642.
/ V \注册机器241939.
/（）\ Shrewsbury，New Jersey http://counter.li.org
^^ - ^^ 14:05:00 up 8天，21：20,3位用户，平均负载：3.23,3.21,3.03
< ri ********* @ canada.com>在消息中写道
news：7c ************************** @ posting.google.c om ...我们在Windows 2003服务器上安装DB2 V8.1.5有2个intel cpu。
我注意到无论我的
应用程序多忙，CPU和磁盘使用率都很低。
我们怎样才能让DB2在Windows 2003上充分利用系统资源？
提前谢谢。
Richard
你获得Daniel Morgan的许可，可以在Windows上安装DB2吗？
We are having DB2 V8.1.5 installed on windows 2003 server has 2 intel cpu.
I notice the CPU and Disk usage is very low no matter how busy is my application.
How can we let DB2 make full use of system resource on Windows 2003?
Thanks in advance.
Richard
ri*********@canada.com wrote:
We are having DB2 V8.1.5 installed on windows 2003 server has 2 intel cpu.
I notice the CPU and Disk usage is very low no matter how busy is my application.
How can we let DB2 make full use of system resource on Windows 2003?
Thanks in advance.
Richard
DB2 doesn''t have a built in limit (unless you''ve configured the governor,
but I don''t think you''d be asking this question if you had).
If CPU and disk aren''t problems on your server, that''s a _good_ thing.
If application performance is an issue, then you need to look at the
application to see what''s going on. It could be problems with the app,
or its interaction with the database (i.e. concurrency - locking issues).
Good luck,
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
ri*********@canada.com wrote:We are having DB2 V8.1.5 installed on windows 2003 server has 2 intel cpu.
I notice the CPU and Disk usage is very low no matter how busy is my application.
How can we let DB2 make full use of system resource on Windows 2003?
Thanks in advance.
Richard
I do not run Windows anymore, and never ran DB2 on it.
I do run DB2 V8.1.5 on RHEL 3 ES, with two XEON processors 4 Ultra/320
SCSI 10,000rpm hard drives and two 100MHz ATA/EIDE hard drives (for the
little stuff in SMS tablespaces).
I used to run DB2 V6.1 on a machine with two 10,000rpm Ultra-2 LVD hard
drives and noticed that the machine was not compute limited (two 550 MHz
Pentium IIIs), nor was it IO limited (usually 1 megabyte/sec IO), but it
was slow anyway even when no other processes were using CPU. But you could
tell from all the clicking that the process(es) was seek limited. Hence
all the hard drives on the new machine.
I did not need all the storage capacity of all 6 spindles, but by dividing
things up better and using DMS containers (could not do that on RHL 7.3),
the new machine is 10x to 20x faster than before. It still runs at about
320% wait state (2 hyperthreaded XEON processors could go up to 400%),
which is frustrating. I am running 7 page fetchers and 7 page cleaners,
but the page cleaners all sit in state D (waiting for IO) a lot of the
time. Now maybe a wiser distribution of the tables over the tablespaces
would help. I cannot easily tell if it is seek limited, because the new
disk drives are silent.
What I have is the main data on three hard drives, and the index for those
data on the fourth. These are the fast SCSI drives.
Some medium sized stuff (for me): 3260 pages, total, are SMS on one of the
IDE drives and the tiny boring stuff 44 pages is on the other IDE drive
(where the log files also reside). I have studied it so that as I run it
the seeks should be minimized.
Since it is about 20x faster than the old machine (a >10-hour job runs in
about 35 minutes), I am not sweating it, but I wish I could cut the IO
wait time down since I run only about 40% of one CPU and the other 3.6
CPUs have little to do.
One bad idea is to run setiathome (entirely compute-limited). I run it
nice 19 which makes it least likely to get a shot at a processor, yet it
cuts the speed of DB2 in half. My present guess is that it is scrambling
the processor caches.
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 14:05:00 up 8 days, 21:20, 3 users, load average: 3.23, 3.21, 3.03
<ri*********@canada.com> wrote in message
news:7c**************************@posting.google.c om...We are having DB2 V8.1.5 installed on windows 2003 server has 2 intel cpu.
I notice the CPU and Disk usage is very low no matter how busy is my application.
How can we let DB2 make full use of system resource on Windows 2003?
Thanks in advance.
Richard
Did you get Daniel Morgan''s permission to install DB2 on Windows?
这篇关于我怎样才能让DB2使用更多的CPU的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
