-
DB2pureScale_Practical_Design_Guide_2016-Feb-5.pptx下载
资源介绍
设计方向的最佳实践,内容有
1. Introduction
1-1 Preface
1-2 Recommended Pre-requisite and Reference Materials to Utilize with this Guide
1-3 Authors and Contributors
2.DB2 pureScale Cluster Configuration Steps
2-1 How to decide the number of DB2 members and CFs
2-2 Estimating the capacity
2-3 Determine the physical placement of DB2 members and CFs
2-4 Choose the correct DB2 pureScale network configuration
2-5 Eliminating SPOF within your network and storage configuration
2-6 Consider available virtualization technologies (System p)
2-7 Scaling up before scaling out in planning your DB2 pureScale cluster upgrade
2-8 Keep the Critical Network available
3. DB2 System Configuration
3-1 Balancing LBP and GBP sizes based on the application read-write ratio
3-2 Allocating a portion of the LBP size to LOCKLIST
3-3 Avoid lock escalation with GLM Size
3-4 PAGE_AGE_TRGT_GCR – Improve Performance but also Increases Recovery time
3-5 Setting the correct locations for DIAGPATH and CF_DIAGPATH on the local file systems
3-6 Performance tips for table space design
3-7 Large buffer pool may slow down LOAD and REORG
3-8 Consider multiple table space containers
4. Tables and Index Design
4-1 Considerations for SEQUENCE and IDENTITY columns
4-2 First column of index selection considerations
4-3 First accessing to a table with a large index may take long time
- 上一篇: 朴素贝叶斯分类器(Matlab代码)
- 下一篇: 朴素贝叶斯matlab源码--:--