设为首页 加入收藏

TOP

IBM DB2 734认证考试准备指南
2011-05-12 15:16:43 来源: 作者: 【 】 浏览:34276次 评论:0

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


IBM官网734考试准备 是两部分:DB2的几个高阶培训 ,一本书(DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide)。
培训都参加不现实,书呢国内没有出版,网上也找不到电子版。
反正考试不是目的,学习DB2最重要,那么就结合手头能用的材料和734的大纲自己准备好了。


现有资料
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的作用

Tags:734 责任编辑:admin
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇DB2认证考试经验谈(700&&701) 下一篇DB2技术支持资源交叉演示表

最新文章

热门文章

推荐文章

相关文章