IBM 595双核CPU数据库分区问题 [英] IBM 595 dual core CPU DB partitioning question

问题描述

我开始在IBM 595 AIX机箱中配置64位DB2，带有2个双b / b
内核CPU，我想为一个db分配一个''处理器'

分区。我应该将其配置为4节点或2节点实例吗？怎么

关于其他设置如IO清除程序，默认程度等？

解决方案

3月30日， 15：32，Woody Ling < woodyl ... @ gmail.comwrote：

我开始在IBM 595 AIX框中配置64位DB2，带有2个双

核心CPU我想为一个db

分区分配一个''处理器''。我应该将其配置为4节点或2节点实例吗？关于其他设置如IO清除程序，默认程度等，如何获得
？

没有经验法则。这取决于您正在使用的数据库的预期容量和

性质。


有一个配置顾问。在控制中心，如果你得到绝望

绝望

3月30日上午11:12，james_。 .. @ hotmail.com写道：

3月30日15:32，Woody Ling < woodyl ... @ gmail.comwrote：

我开始在IBM 595 AIX框中配置64位DB2，其中包含2个双$

核心CPU我想为一个db

分区分配一个''处理器''。我应该将其配置为4节点或2节点实例吗？关于其他设置如IO清除程序，默认程度等，如何获得
？

没有经验法则。这取决于您正在使用的数据库的预期容量和

性质。


有一个配置顾问。在控制中心，如果你得到

绝望

嗨伍迪，


任何特殊原因为什么你想要一个分区实例？每个

数据库分区都会耗尽一些固定资源（CPU和内存） -

你机器上的分区越多，资源越少

可用于您的实际工作量。就机器尺寸而言，我可能不建议为4-CPU
机器使用多个分区，除非你打算扩展和在未来添加更多机器

。单个分区可以充分利用你的
机器上的所有CPU。


干杯，

利亚姆。

" Liam Finnie" < lf ***** @ ca.ibm.com写信息

新闻：11 ********************** @ p77g2000hsh.googlegr oups.com ...

嗨Woody，


你想要一个分区实例的任何特殊原因？每个

数据库分区都会耗尽一些固定资源（CPU和内存） -

你机器上的分区越多，资源越少

可用于您的实际工作量。就机器尺寸而言，我可能不建议为4-CPU
机器使用多个分区，除非你打算扩展和在未来添加更多机器

。单个分区可以充分利用你的
机器上的所有CPU。


干杯，

利亚姆。

对表进行分区可以实现查询并行性。如果这是一个带有大量表扫描的数据仓库

应用程序，那么它将有助于提高性能。如果它是一个OLTP应用程序或者访问通常是通过

索引访问返回一个小答案集，那么它可能不是一个好主意。


CPU的数量并不决定是否进行分区，但是你需要每个分区至少有一个CPU（双核可以算作

2 CPU''）。如果你有一个数据仓库应用程序使用很多表

扫描并且服务器有一个双核CPU，那么对表进行分区可能是一个好主意。

I am starting to config a 64 bits DB2 in IBM 595 AIX box with 2 dual
core CPU and I would like to assigned one ''processor'' for one db
partition. Should I config it as a 4 nodes or 2 nodes instances? How
about other setting such as IO cleaner, Default degree etc?

解决方案

On 30 Mar, 15:32, "Woody Ling" <[e-mail]:

I am starting to config a 64 bits DB2 in IBM 595 AIX box with 2 dual
core CPU and I would like to assigned one ''processor'' for one db
partition. Should I config it as a 4 nodes or 2 nodes instances? How
about other setting such as IO cleaner, Default degree etc?

There''s no rules of thumb. It depends on expected volumetrics and the
nature of the database that you''re working with.

There''s a "configuration advisor" in Control Center, if you get
desperate

On Mar 30, 11:12 am, [e-mail] wrote:

On 30 Mar, 15:32, "Woody Ling" <[e-mail]:

I am starting to config a 64 bits DB2 in IBM 595 AIX box with 2 dual
core CPU and I would like to assigned one ''processor'' for one db
partition. Should I config it as a 4 nodes or 2 nodes instances? How
about other setting such as IO cleaner, Default degree etc?

There''s no rules of thumb. It depends on expected volumetrics and the
nature of the database that you''re working with.

There''s a "configuration advisor" in Control Center, if you get
desperate

Hi Woody,

Any particular reason why you want a partitioned instance here? Each
database partition will use up some fixed resources (CPU and memory) -
the more partitions you have on a machine, the less resources are
available for your actual workload. As far as machine sizes go, I
probably wouldn''t recommend using multiple partitions for a 4-CPU
machine, unless you''re planning to scale out and add more machines in
the future. A single partition can fully utilize all the CPUs on your
machine.

Cheers,
Liam.

"Liam Finnie" <lf*****@ca.ibm.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...

Hi Woody,

Any particular reason why you want a partitioned instance here? Each
database partition will use up some fixed resources (CPU and memory) -
the more partitions you have on a machine, the less resources are
available for your actual workload. As far as machine sizes go, I
probably wouldn''t recommend using multiple partitions for a 4-CPU
machine, unless you''re planning to scale out and add more machines in
the future. A single partition can fully utilize all the CPUs on your
machine.

Cheers,
Liam.

Partitioning a table enables query parallelism. If this is a data warehouse
application with a lot of table scans, then it will help performance. If it
is an OLTP application or access is usually returning a small answer set via
index access, then it is probably not a good idea.

The number of CPU''s is not a determinant as to whether to partition, but you
generally should have at least one CPU per partition (dual core can count as
2 CPU''s). If you have a data warehouse application using a lot of table
scans and the server has one dual core CPU, partitioning the table is
probably a good idea.

这篇关于IBM 595双核CPU数据库分区问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！