跨LPAR的DB2实例联合 [英] Federation of DB2 Instances Across LPAR's

问题描述

我的客户正在经历一个大项目来替换现有数据

仓库物理基础架构，它运行DB2 8.1.6。在

过去，我们有一个更加分散的环境，我们在物理上不同的服务器上有一定数量的数据仓库部分。我们

使用联邦来允许在单独的

实例上加入表格。我们发现这种方法在表格

不大于100,000行的情况下工作正常。我们现在需要

能够在超过3000万行/ b $ b行的单独实例上连接表。虽然它在当前环境下工作，但是它需要很长的时间来运送行，因此它已经成为我们的瓶颈。


在我们新的物理基础设施中我们的数据库实例在相同的物理硬件上都将是

，但它们将存在于不同的LPAR中。

我们看到使用联合加入

数据库实例时性能有所提高？我的想法是，我们会看到很大的改善，因为数据不需要通过网络发送。

任何人都可以提供任何关于我的想法的确认是否正确？


Spencer

My client is going through a large project to replace existing data
warehouse physical infastructure which is running DB2 8.1.6. In the
past we had a much more distributed environment where we had certain
portions of the data warehouse on a physically different server. We
utilized federation to allow the joining of tables on seperate
instances. We found that this worked ok in situations where the tables
were not that large say under 100,000 rows. We now have the need to be
able to join tables on seperate instances with more then 30 Million
rows. While it works in the current environment it takes a very long
time to ship the rows and thus it has become our bottleneck.

In our new physical infrastructure our database instances will all be
on the same physical hardware but will exist in different LPAR''s. Will
we see improved performance when using federation to join across the
database instances? My thoughts are that we would see a vast
improvement as the data doesn''t need to be shipped across the network.
Can anyone offer any confirmation on if my thoughts are correct or not?

Spencer

推荐答案

< sp **** *@tabbert.net>在消息中写道

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

<sp*****@tabbert.net> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

我的客户正在通过一个大型项目来替换正在运行DB2 8.1.6的现有数据仓库物理基础架构。在过去，我们有一个更加分散的环境，我们在物理上不同的服务器上拥有数据仓库的某些部分。我们使用联合来允许在单独的
实例上加入表。我们发现，在表格数量不超过100,000行的情况下，这种方法可以正常工作。我们现在需要能够在超过3000万行的单独实例上连接表。虽然它在当前环境中工作，但是需要很长的时间来运送行，因此它已经成为我们的瓶颈。

在我们新的物理基础设施中，我们的数据库实例都将是
在相同的物理硬件上，但将存在于不同的LPAR中。当使用联合来跨数据库实例加入时，我们会看到改进的性能吗？我的想法是，我们会看到一个巨大的改进，因为数据不需要通过网络发送。
任何人都可以提供任何关于我的想法是否正确的确认？

Spencer

My client is going through a large project to replace existing data
warehouse physical infastructure which is running DB2 8.1.6. In the
past we had a much more distributed environment where we had certain
portions of the data warehouse on a physically different server. We
utilized federation to allow the joining of tables on seperate
instances. We found that this worked ok in situations where the tables
were not that large say under 100,000 rows. We now have the need to be
able to join tables on seperate instances with more then 30 Million
rows. While it works in the current environment it takes a very long
time to ship the rows and thus it has become our bottleneck.

In our new physical infrastructure our database instances will all be
on the same physical hardware but will exist in different LPAR''s. Will
we see improved performance when using federation to join across the
database instances? My thoughts are that we would see a vast
improvement as the data doesn''t need to be shipped across the network.
Can anyone offer any confirmation on if my thoughts are correct or not?

Spencer

取决于您的旧网络接口有多快，以及网络上有多少其他

流量。例如，如果你在这两台机器之间有一个私有的千兆以太网连接，我认为它会非常快。


使用LPAR，每个逻辑机器都有自己的IP地址，所以我不确定机器之间的实际路径是什么。例如，LPAR之间的所有

通信都会直接进入网络并再次返回？

我自己真的不知道答案。您可能需要在

AIX论坛中询问某人（我假设使用AIX）。

Depends on how fast your old network interface was, and how much other
traffic was on the network. For example, if you had a private gigabit
Ethernet connection between the two machines, I would think it would pretty
fast.

With LPAR, each logical machine has its own IP address, so I am not sure
what the actual path between the machines would be. For example, would all
communications between the LPAR''s just go out to the network and back again?
I really don''t know the answer myself. You might need to ask someone in an
AIX forum (I am assuming that use AIX).

实际上它将在HP上-UX硬件，我相信这两台机器之间只有100亿美元。

Spencer

Actually it is going to be on HP-UX hardware and I believe we only had
a 100MB between the two machines.
Spencer

< SP ***** @ tabbert.net>在消息中写道

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

<sp*****@tabbert.net> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

实际上它将出现在HP-UX硬件上，我相信这两台机器之间只有100MB。
Spencer

Actually it is going to be on HP-UX hardware and I believe we only had
a 100MB between the two machines.
Spencer

I会尝试HP / UX论坛。 LPAR之间的通信是通过TCP / IP进行的。

I would try a HP/UX forum. The communication between LPAR''s is via TCP/IP.

这篇关于跨LPAR的DB2实例联合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！