刚考完DB2 734，把自己的一些考试心得总结总结，供后来者参考。也算抛砖引玉，有问题敬请留言指正。

IBM官网734考试准备是两部分：DB2的几个高阶培训，一本书（DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide）。
培训都参加不现实，书呢国内没有出版，网上也找不到电子版。
反正考试不是目的，学习DB2最重要，那么就结合手头能用的材料和734的大纲自己准备好了。通过对这些材料的深入学习，相信对DB2的理解和使用都能再上一个层次。

现有资料
1. Understanding DB2： Learning Visually with Example 2nd Edition
这本书包含了V9.5的最新内容。网上有电子版（IBM-Understanding DB2 2008.pdf）

后面简称为《Understanding DB2》
2. Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
这是V8的704的官方准备材料，虽然有些老，但不少仍很有借鉴意义，734就是704的V9升级版。网上能找到chm的电子版（Advanced.DBA.chm）

后面简称为《Advanced.DBA》
3. IBM developerworks上DB2 LUW相关的文章

文章一般都是针对性的讲解某个概念，并加上试验步骤和例子帮助理解。
4. DB2 V9.5的信息中心
734目前只包含到v9.5。V9.7的内容还没加进来。

   Infocenter主要用于细节的校正。书和文章都不包含的内容，最后还得找到这里。
5. 样题
    ITPUB下载的帖子：http://www.itpub.net/thread-1127222-1-1.html
    这个程序（000-734.exe）看似小，题都不错。真题率挺高。估计是直接连考试官网Prometric拿的题。
    不过使用时还是要小心，有些题是V8的，有些答案不准，一定要自己理解了最好。

资料如何用？

咱就依照734的考试大纲，关注最有用的部分。考点是自己体会总结，仅供参考。考过的朋友请留言补充，表的内容也会相应不断完善。

734大纲	复习材料	考点
Section 1 - Database Design (14%)
1. Ability to design, create and manage table spaces 2. Ability to design, create and manage buffer pools	《Understanding DB2》 Chapter 8 The DB2 Storage Model.	tablespace和buffer pool的page size大小要匹配。使用db2pd tablespace 诊断问题 * 如何关闭DMS tablespace的文件的cache
3. Ability to design and configure federated database access	《Advanced.DBA》： Chapter 7 Federated Database Access	WRAPPER,SERVER,NICKNAME的概念和对应关系 NICKNAME的统计信息如何收集注意《Advanced.DBA》中这个topic的内容老了，最新的参考Retrieving nickname statistics
Section 2 - Data Partitioning and Clustering (15%)
1. Ability to design, create, and manage database partitioning	*《Understanding DB2》 Chapter 2.6 DATABASE PARTITIONING FEATURE Chapter 8.3 DATABASE PARTITION GROUPS	如何增加一个新的Partition 到DPF环境，并加入到一个Partition Group Distribution Key的选择 *db2_all的使用
2. Ability to design, create and manage multi-dimensional clustered tables	《Advanced.DBA》：Chapter 5. Multi-Dimensional Clustering	*MDC Demesion的选择
3. Ability to design, create, and manage table partitioning	Table partitioning in DB2 9	Partition Table如何创建 Partition Table数据的Roll-in，Roll-out
4. Knowledge of Balance Configuration Unit (BCU)	*《Understanding DB2》 Chapter 2.8 IBM BALANCED WAREHOUSE	*一个BCU上有几个Partition
Section 3 - High Availability and Diagnostics (20%)
1. Ability to manage database logs for recovery	《Understanding DB2 》 Chapter 14.2 DB2 TRANSACTION LOGS	LOGPRIMARY，LOGSECOND的使用 LOGARMETH1的配置使用mirrorlogpath实现双LOG 增加LOGBUFSZ提高COMMIT性能
2. Ability to use advanced backup features 3. Ability to use advanced recovery features	《Understanding DB2 》 14.Developing Database Backup and Recovery Solutions	RECOVER damaged database 使用RECOVER 重建database DPF环境下的backup和restore INCREMETAL和DELTA backup及RECOVERY
4. Ability to enhance database availability	《Understanding DB2》 14.12 MAINTAINING HIGH AVAILABILITY WITH DB2	HADR的原理，那些操作能被送到standby server 理解HADR三种HADR_SYNCMODE的差异 *HADR_TIMEOUT的配置
5. Ability to use diagnostic tools (db2pd, db2mtrk, inspect, db2dart, db2diag)	The db2pd tool db2mtrk db2dart 和 inspect db2diag
Section 4 - Performance and Scalability (33%)
1. Identify and use DB2 registry variables that affect database system performance 2. Identify and use configuration parameters that affect database system performance	《Advanced.DBA》 Chapter 8. Performance Tuning 《Understanding DB2》 Chapter 17 Database Performance Considerations	*《Advanced.DBA》Chapter 8提的变量都可能是考点，但因为是V8，有些变量在V9中已经过时了，所以要参考《Understanding DB2》和信息中心
3. Knowledge of query optimizer concepts	《Advanced.DBA》 Chapter 6. The DB2 Optimizer The SQL and XQuery compiler process	*理解Access Plan，能识别Index Anding， Index ORing，List Prefetch和三种JOIN的方法：NLJOIN，HSJOIN，MSJOIN
4. Ability to manage and tune database, instance and application memory and I/O	《Understanding DB2》 Chapter 16 The DB2 Memory Model	* Self Tuning Memory Management配置和Memory使用的行为 * Sort memory的使用
5. Ability to use Data Compression	* Data compression in DB2 9 *《Understanding DB2》 7.8.10 Row Compression 7.8.11 Table Compression	*Compression Dictionary什么时候创建
6. Ability to analyze performance problems	《Advanced.DBA》 Chapter 10. Performance Tuning Examples Influence query optimization with optimization profiles and statistical views in DB2 9	* statistic view的概念
7. Ability to manage a large number of users and connections	《Understanding DB2》 Chapter 15. The DB2 Process Model	coordination agent的名字如何 eable “connection concentrator”
8. Ability to determine the more appropriate index	Essential Facts about Index Covering in DB2 Universal Database	如何建Index可以加速query db2advis
9. Ability to exploit parallelism	-Inter-partition parallelism 《Understanding DB2》 Chapter 17.4.2 Intra-Partition Parallelism Example two: single-partition plan with intra-partition parallelism -Intra-partition parallelism 《Advanced.DBA》 Chapter 6.1 Joining in a Partitioned Database Join methods in partitioned database environments *Join methods in partitioned database environments	* 配置INTRA_PARALLEL * BTQ,DTQ,LTQ的作用 * TQ的类型
Section 5 - Security (8%)
1. Knowledge of external authentication mechanisms	Understand the DB2 Universal Database security plug-ins Kerberos authentication details	*KRB_SERVER_ENCRYPT的使用
2. Ability to implement data encryption	Encrypting Data Values in DB2 Universal Database 这个文章是针对DB2 V7的。结合信息中心看	* Encrypt函数的Password哪里来 * Encypt的结果要用VARCHAR FOR BIT来存储
3. Ability to implement Label Based Access Control (LBAC)	DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2 DB2 label-based access control: A practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAC	*Inserting of LBAC protected data 时的default值
4. Ability to use DB2 Audit	Understand the DB2 audit facility
Section 6 - Connectivity and Networking (10%)
1. Ability to configure client server connectivity (e.g., db2discovery) 2. Ability to manage connections to host systems 3. Ability to identify and resolve connection problems	《Understanding DB2》Chapter 6. Configuring Client and Server Connectivity	catalog DB的作用 catalog DCS DB的用途和用法 *DISCOVER _INST和DISCOVER_DB的作用

ITPub博客

IBM DB2 734认证考试准备指南

最新文章