更多CPU ??? [英] More CPU???

问题描述

我在具有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.

推荐答案

Jason Gyetko写道：

Jason Gyetko wrote:

我正在运行具有2个物理处理器（4个虚拟）的服务器上的DB2 v8.1 FP5
我想知道是否有办法配置DB2以使用更多处理器。


是的，尝试设置未记录的注册表变量DB2_GO_FAST = YES。如果

还不够好，那么还有DB2_GO_FASTER。


（开玩笑）

现在我'正在运行删除查询以删除大约400万条记录。它仅使用5％ - 25％的处理器（主要是低端有一些
峰值）。这个系统在很大程度上被严格地用作数据库服务器，所以我希望能够设置它以便DB2可以使用至少50％的处理器，但是更好然而高达80％会很棒。有谁知道
如何或如果我能做到这一点？

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.
Yes, try setting the undocumented registry variable DB2_GO_FAST=YES. If
that''s not good enough, there is also DB2_GO_FASTER.

(Just kidding)
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 / 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.

通过在相应的表上执行删除，你是否试图

实现截断!!!

By the performing delete on the respective table(s), are u trying to
acheive a truncate!!!

我不确定你截断的意思。截断是否与没有数据库日志记录的

删除相同？你可以使用

标准来截断表格，还是全有或全无？我在特定日期之前删除了

表中的所有记录。这个特殊的表有700万条记录，

我的删除声明将删除其中的400万条。删除时需要1:10才能完成

。在删除之前，我执行了我要删除的数据的导出，因此我可以将其导入单独的存档数据库。


Shyam围" < PE ******* @ gmail.com>在消息中写道

news：11 ********************** @ o13g2000cwo.googlegr oups.com ...

I''m not real sure on what you mean by truncate. Is truncate the same as a
delete without the database logging? Can you truncate a table using
criteria or is it an all or nothing deal? I am deleting all records in a
table prior to a certain date. This particular table has 7 million records,
my delete statement will delete 4 million of them. It took 1:10 to complete
the delete. Prior to the delete I performed an export of the data that I
was to delete so I can import it into a seperate archive database.

"Shyam Peri" <pe*******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

通过在各个表上执行删除，你是否试图实现截断!!!

By the performing delete on the respective table(s), are u trying to
acheive a truncate!!!

这篇关于更多CPU ???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！