为何选择DPF？

本文介绍了为何选择DPF？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 嗨大师，我知道很多人都是非常高级的DBA和来自IBM的内部专家，所以我真的很想知道你对这个基本主题的建议。 为什么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多伦多实验室 是的，Serge。 DPF需要更有经验的专业人员来保持近乎线性的可扩展性。根据我的经验，每次客户抱怨时，每次DPF都会提供更差的性能，而且我总是告诉他们需要更多的设计和调整，然后做某事。实现他们的需求。 实际上，我们总是根据BCU方法提供系统 并获得良好的反馈。 但问题是，如果只有一台具有许多CPU和内存的服务器，如果数据/表大小不是限制，那么什么是最佳解决方案？ 保持简单，是多分区优于SMP的优势 并行（确定？，有没有直接数据或材料）是否值得为DPF设计付出巨大努力？特别是对于没有很强技能的公司。 Hi gurus, I know many of you are very senior DBAs and experts from IBMinternal, 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 helpyou get greater performance, so even only one server, many IBMpresales will sell DPF feature with the performance story. DPFlicense 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 canserve, or you have to use more than one server, you use DPF. how about your opinion? can you list the reasons you use DPF? Thankyou. 解决方案 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 tohave multiple logical data partitions, rather than using SMP parallelism.To make a long story short for a warehouse that requires multiple CPUsyou will see the recommendation of DPF for performance.For the best practices I recommend looking into Balanced ConfigurationUnits (BCU): http://www.db2mag.com/story/showArti...leID=180206351 ... oh.. and it''s not a rumor... for a warehouse a well designed DPFsystem will achieve near linear scalability compared to an SMP approachwhich delivers diminishing returns.CheersSerge--Serge RielauDB2 Solutions DevelopmentIBM Toronto Labyes, Serge. DPF need more experienced professional to keep the nearlinear scalability. In my experience, every time customer complainedDPF delivers worse performance and I always tell them the need formore design and tuning, then do sth. to fulfill their need. Actually, we deliver system always according to the BCU methodologyand gain good feedback. But the problem that if only one server with many CPU and memory, ifthe data/table size is not a limit, then what''s the best solution? yes, Serge. DPF need more experienced professional to keep the nearlinear scalability. In my experience, every time customer complainedDPF delivers worse performance and I always tell them the need formore design and tuning, then do sth. to fulfill their need.Actually, we deliver system always according to the BCU methodologyand gain good feedback.But the problem that if only one server with many CPU and memory, ifthe data/table size is not a limit, then what''s the best solution?to keep simple, is the advantage for multi-partition over SMPparallelism(sure?,is there any direct data or material) is worth thebig effort on DPF design? especially for a firm without strong skill. 这篇关于为何选择DPF？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！