从Teradata迁移到DB2 EEE。 [英] Migrating from Teradata to DB2 EEE.
问题描述
有没有人知道有关
从Teradata迁移到DB2 UDB EEE的任何好的来源（白皮书等）？
我们在最初阶段的调查作为一个选项
用于目前Teradata的一些小项目。
提前感谢所有信息。
杰夫
应该相对容易，因为它们是建立在同一个上面
架构。显然技术细节是不同的，但
数据库设计通常会相似甚至相同。
和Teradata一样，最重要的是保留通过选择合适的分区键来最小化交叉
分区连接。
" jdokos" <济*********** @ nscorp.com>在消息中写道
news：11 ********************* @ g47g2000cwa.googlegro ups.com ...有没有人知道有关从Teradata迁移到DB2 UDB EEE的任何好的来源（白皮书等）？
我们正处于调查这个问题的最初阶段选项
对于目前要进入Teradata的一些小项目。
提前感谢任何和所有信息。
杰夫
还有一件事。我希望您使用带有DPF的DB2 ESE而不是DB2 EEE，因为IBM不再支持版本7，因此需要支持
。
Mark A写道：" jdokos" <济*********** @ nscorp.com>在消息中写道
新闻：11 ********************* @ g47g2000cwa.googlegro ups.com ...任何人都知道有关从Teradata迁移到DB2 UDB EEE的任何有用的资料（白皮书等）吗？
我们正处于调查此选项的最初阶段对于目前要去Teradata的一些较小项目。
提前感谢任何和所有信息。
杰夫
还有一个事情。我希望您将DB2 ESE与DPF而不是DB2 EEE一起使用，因为IBM不再支持版本7.
我听说IBM问世了在Linux上使用新的BCU for ICE但是我没有在网站上找到任何参考资料，而不是用于AIX信息的
BCU。 [ http://www-306.ibm.com / software / data / db2bi / bcu /]
有没有人有这方面的经验？知道如何在
~3TB数据仓库及其他数据库中执行该操作吗？
-J
blockquote>
Does anyone know of any good sources (white papers, etc.) regarding
migrating from Teradata to DB2 UDB EEE?
We are in the very beginning stages of investigating this as an option
for some of the smaller projects that are going to Teradata presently.
Thanks in advance for any and all information.
Jeff
解决方案Should be relatively easy since they are built on the same
architecture. Obviously the technical details are different, but the
database design would usually be similar or even the same.
As in Teradata, the main thing to keep in mind is to minimize cross
partition joins by choosing the proper partitioning key.
"jdokos" <Je***********@nscorp.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...Does anyone know of any good sources (white papers, etc.) regarding
migrating from Teradata to DB2 UDB EEE?
We are in the very beginning stages of investigating this as an option
for some of the smaller projects that are going to Teradata presently.
Thanks in advance for any and all information.
Jeff
One more thing. I hope you are using DB2 ESE with DPF instead of DB2 EEE,
since version 7 is no longer supported by IBM.
Mark A wrote:"jdokos" <Je***********@nscorp.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...Does anyone know of any good sources (white papers, etc.) regarding
migrating from Teradata to DB2 UDB EEE?
We are in the very beginning stages of investigating this as an option
for some of the smaller projects that are going to Teradata presently.
Thanks in advance for any and all information.
Jeff
One more thing. I hope you are using DB2 ESE with DPF instead of DB2 EEE,
since version 7 is no longer supported by IBM.
I heard that IBM came out with a new BCU for ICE on Linux but I
couldn''t find any reference for that on the website other than the
BCU for AIX info. [http://www-306.ibm.com/software/data/db2bi/bcu/]
Does anyone has experience with that ? Any idea how that performs on a
~3TB data warehouse and beyond ?
-J
这篇关于从Teradata迁移到DB2 EEE。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
