登录 注册
当前位置:主页 > 资源下载 > 9 > DB2pureScale_Practical_Design_Guide_2016-Feb-5.pptx下载

DB2pureScale_Practical_Design_Guide_2016-Feb-5.pptx下载

  • 更新:2024-07-29 21:07:26
  • 大小:3.46MB
  • 推荐:★★★★★
  • 来源:网友上传分享
  • 类别:DB2 - 数据库
  • 格式: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