|
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的作用
|
