为何选择DPF？ [英] why DPF?
问题描述
嗨大师，我知道很多人都是非常高级的DBA和来自IBM的内部专家，所以我真的很想知道你对这个基本主题的建议。
为什么dpf？
通常有谣言，我相信这是谣言，DPF可以帮助你获得
更高的性能，所以即使只有一台服务器，许多IBM的预售也将销售DPF功能与性能故事。 DPF
许可证并不便宜:)
我相信DPF的可扩展性远远超过性能。
我相信只有当您的数据/表格大于非DPF才能发送时，或者您必须使用多台服务器，才能使用DPF。
你的意见怎么样？你能列出你使用DPF的原因吗？谢谢
你。
Hardy写道：
嗨大师，我知道很多人都是来自IBM的高级DBA和专家
内部，所以我真的很想知道你对这个基本主题的建议。
为什么dpf？
通常有谣言，我相信这是谣言，DPF可以提供帮助
你获得了更好的性能，所以即使只有一台服务器，很多IBM的售前，也会出售性能故事的DPF功能。 DPF
许可证并不便宜:)
我相信DPF的可扩展性远远超过性能。
我相信只有当您的数据/表格大于非DPF才能发送时，或者您必须使用多台服务器，才能使用DPF。
你的意见怎么样？你能列出你使用DPF的原因吗？感谢
你。
使用DB2 9和大型rowid，大型表空间和范围分区
可伸缩性很难并且发布了。
虽然在SMP盒子上，但是b
$ b有多个逻辑数据分区，而不是使用SMP并行性，这仍然是正确的。
长话短说需要多个CPU的仓库
你会看到DPF对性能的推荐。
我推荐的最佳实践调查平衡配置
单位（BCU）：
http://www.db2mag.com/story/showArti...leID=180206351
...哦..它这不是一个谣言......对于一个仓库来说，设计精良的DPF
系统将实现接近线性的可扩展性，与SMP方法相比
可以带来收益递减。 />
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
使用DB2 9和大型rowid，大型表空间和范围分区
可伸缩性很难和问题不再这样了。
虽然在SMP盒子上它仍然是正确的，但是
有多个逻辑数据分区，而不是使用SMP并行性。
长话短说需要多个CPU的仓库
你会看到DPF对性能的推荐。
对于我推荐的最佳实践平衡配置
单位（BCU）： http://www.db2mag.com/story/showArti...leID=180206351
..哦..而且这不是谣言。 ..为仓库设计精良的DPF 与BMP方法相比，
系统将实现接近线性的可扩展性
可带来收益递减。
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
是的，Serge。 DPF需要更有经验的专业人员来保持近乎线性的可扩展性。根据我的经验，每次客户抱怨时，每次DPF都会提供更差的性能，而且我总是告诉他们需要更多的设计和调整，然后做某事。实现他们的需求。
实际上，我们总是根据BCU方法提供系统
并获得良好的反馈。
但问题是，如果只有一台具有很多CPU和内存的服务器，如果数据/表格大小不是限制，那么什么是最好的解决方案？
5月8日上午10点36分，Hardy< wyh ... @ gmail.comwrote：
使用DB2 9和大型rowid，大型表空间和范围分区
可扩展性几乎不再存在问题。
尽管如此仍然是正确的在SMP盒子上，有价值的是
有多个逻辑数据分区，而不是使用SMP并行性。
长话短说需要多个CPU的仓库
你会看到DPF对性能的推荐。
对于最佳实践我建议考虑Balanc ed配置
单位（BCU）： http://www.db2mag.com/story/showArti...leID=180206351
..哦......它是'不是谣言......对于一个仓库来说，设计精良的DPF
系统与SMP方法相比将实现接近线性的可扩展性
可带来收益递减。
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
是的，Serge。 DPF需要更有经验的专业人员来保持近乎线性的可扩展性。根据我的经验，每次客户抱怨时，每次DPF都会提供更差的性能，而且我总是告诉他们需要更多的设计和调整，然后做某事。实现他们的需求。
实际上，我们总是根据BCU方法提供系统
并获得良好的反馈。
但问题是，如果只有一台具有许多CPU和内存的服务器，如果数据/表大小不是限制，那么什么是最佳解决方案？
保持简单，是多分区优于SMP的优势
并行（确定？，有没有直接数据或材料）是否值得为DPF设计付出巨大努力？特别是对于没有很强技能的公司。
Hi gurus, I know many of you are very senior DBAs and experts from IBM
internal, so I really want to know your advice on this basic topic.
"why dpf?"
usually there''s a rumor, em, I believe it''s a rumor, that DPF can help
you get greater performance, so even only one server, many IBM
presales will sell DPF feature with the performance story. DPF
license is not a cheap one:)
I believe DPF is much more for scalability than performance.
I believe that only when your data/table is larger than non-DPF can
serve, or you have to use more than one server, you use DPF.
how about your opinion? can you list the reasons you use DPF? Thank
you.
Hardy wrote:Hi gurus, I know many of you are very senior DBAs and experts from IBM
internal, so I really want to know your advice on this basic topic.
"why dpf?"
usually there''s a rumor, em, I believe it''s a rumor, that DPF can help
you get greater performance, so even only one server, many IBM
presales will sell DPF feature with the performance story. DPF
license is not a cheap one:)
I believe DPF is much more for scalability than performance.
I believe that only when your data/table is larger than non-DPF can
serve, or you have to use more than one server, you use DPF.
how about your opinion? can you list the reasons you use DPF? Thank
you.
With DB2 9 and large rowids, large tablespaces and range partitioning
scalability is hardly and issue anymore.
It is still correct though that on an SMP box it can be beneficial to
have multiple logical data partitions, rather than using SMP parallelism.
To make a long story short for a warehouse that requires multiple CPUs
you will see the recommendation of DPF for performance.
For the best practices I recommend looking into Balanced Configuration
Units (BCU):
http://www.db2mag.com/story/showArti...leID=180206351
... oh.. and it''s not a rumor... for a warehouse a well designed DPF
system will achieve near linear scalability compared to an SMP approach
which delivers diminishing returns.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
With DB2 9 and large rowids, large tablespaces and range partitioningscalability is hardly and issue anymore.
It is still correct though that on an SMP box it can be beneficial to
have multiple logical data partitions, rather than using SMP parallelism.
To make a long story short for a warehouse that requires multiple CPUs
you will see the recommendation of DPF for performance.
For the best practices I recommend looking into Balanced Configuration
Units (BCU):http://www.db2mag.com/story/showArti...leID=180206351
.. oh.. and it''s not a rumor... for a warehouse a well designed DPF
system will achieve near linear scalability compared to an SMP approach
which delivers diminishing returns.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Labyes, Serge. DPF need more experienced professional to keep the near
linear scalability. In my experience, every time customer complained
DPF delivers worse performance and I always tell them the need for
more design and tuning, then do sth. to fulfill their need.
Actually, we deliver system always according to the BCU methodology
and gain good feedback.
But the problem that if only one server with many CPU and memory, if
the data/table size is not a limit, then what''s the best solution?
On May 8, 10:36 am, Hardy <wyh...@gmail.comwrote:With DB2 9 and large rowids, large tablespaces and range partitioning
scalability is hardly and issue anymore.
It is still correct though that on an SMP box it can be beneficial to
have multiple logical data partitions, rather than using SMP parallelism.
To make a long story short for a warehouse that requires multiple CPUs
you will see the recommendation of DPF for performance.
For the best practices I recommend looking into Balanced Configuration
Units (BCU):http://www.db2mag.com/story/showArti...leID=180206351
.. oh.. and it''s not a rumor... for a warehouse a well designed DPF
system will achieve near linear scalability compared to an SMP approach
which delivers diminishing returns.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
yes, Serge. DPF need more experienced professional to keep the near
linear scalability. In my experience, every time customer complained
DPF delivers worse performance and I always tell them the need for
more design and tuning, then do sth. to fulfill their need.
Actually, we deliver system always according to the BCU methodology
and gain good feedback.
But the problem that if only one server with many CPU and memory, if
the data/table size is not a limit, then what''s the best solution?to keep simple, is the advantage for multi-partition over SMP
parallelism(sure?,is there any direct data or material) is worth the
big effort on DPF design? especially for a firm without strong skill.
这篇关于为何选择DPF？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
