问题描述
我在具有2个物理处理器（4个虚拟）的服务器上运行DB2 v8.1 FP5
我想知道是否有办法配置DB2以使用更多处理器。 />
现在我正在运行删除查询来删除大约400万条记录。它只需要5％ - 25％的处理器（大多数是低端有一些
尖峰）。这个系统在很大程度上被严格地用作数据库
服务器所以我希望能够设置它以便DB2可以使用至少50％的
处理器，但更好，但高达80％将是伟大的。有谁知道
如何或如果我能做到这一点？我假设你不能把重点放在
多个处理器上，它可能是由系统处理的，但是如果有一个
的方法可以做那，我非常感谢您提供的任何信息。谢谢
advance。
I''m running DB2 v8.1 FP5 on a Server with 2 physical processors (4 virtual)
and am wondering if there is a way to configure DB2 to use more processor.
Right now I''m running a delete query to delete around 4 million records. It
is only using 5% - 25% of the processor (mostly the lower end with some
spikes). This system, for the most part, is strictly used as a database
server so I''d like to be able to set it so that DB2 can use at least 50% of
the processor, but better yet up to 80% would be great. Does anyone know
how or if I can accomplish this? I''m assuming you can''t dedicate loads over
multiple processors, it''s probably handled by the system, but if there is a
way to do that, I''d greatly appreciate any info you could offer. Thanks in
advance.
推荐答案
很可能这是一个I / O系统限制，而不是CPU
限制。您的CPU可能正在等待IO完成。
您要写什么样的磁盘，以及它们是如何配置的？
（RAID5，RAID1等）？从数据库的角度来看，您可能会因为数据库日志记录性能不佳而导致性能不佳，或者数据库中的async / b $ b写入性能不佳。
Chances are very good that this is a I/O system limitation, not a CPU
limitation. Your CPUs are likely waiting for IO to complete.
What kind of disks are you writing to, and how are they configured
(RAID5, RAID1, etc)? From a database perspective, you may be getting
poor performance with database logging, or poor performance for async
writes in the database.
这篇关于更多CPU ???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！