DB2
认证考试目标
相关考试科目
730 DB2 9 Fundamentals
731 DB2 9 DBA for Linux, UNIX and Windows
734 DB2 9 for Linux, UNIX and Windows Advanced DBA
736 DB2 9 DBA for Linux, UNIX and Windows Upgrade
参加考试的步骤
1. 了解认证考试科目
2. 学习手册、网上资料或者参加相关培训，通过网络考试测验来测试自己的知识掌握程度
3. 注册，参加考试
DB2认证级别、认证结构
入门级 中级 高级
730——————>731——————>734
|———————>716（Designer）
|———————>733（Developer）
730考试知识点
第一部分计划（14%）
数据访问控制
DB2工具的特性和功能
DB2工作量相关知识（OLTP vs. DW）
非关系型数据的概念
XML数据
第二部分安全（11%）
DB2组件知识（客户端、服务器端等）
权限和特权
加密选项（数据、网络通信）
DDL语句（grant/revoke/connect）
第三部分数据库和数据库对象（17%）
识别并连接数据库服务器和数据库
识别数据库对象
DB2对象基本属性和特性
预测一给定DDL语句的执行结果（创建对象）
第四部分用SQL对数据进行操作（23.5%）
预测一个给定DML语句的执行结果
Select语句
SORT或者GROUP
Update，Delete和Insert
事务（提交、回滚和事务边界）
调用存储过程（call）和用户自定义函数（invoke）
预测一个给定XQuery语句的结果
第五部分 DB2表、视图和索引（23.5%）
能够辨别DB2数据类型的用法
根据某一类型建表
判断何时需要用参考完整性约束
数据完整性约束方法
表、视图和索引的特性
何时用到触发器
模式
存储XML数据的数据类型
第六部分数据并行性（11%）
影响锁的因素
列出与某一锁相关的对象
DB2锁特性
给出特定情景，确定应该使用何种隔离级别
731考试知识点
第一部分数据库服务器管理（20.5%）
配置管理DB2实例
获得并修改数据库管理器参数信息
获得并修改数据库参数信息
DB2 force命令
配置客户端、服务器连接
任务调度
使用自动维护（例如，runstats，backup，reorg等）
使用Discovery配置服务器客户端连接
解析notify日志的含义
获得并修改DB2注册变量信息
使用self-tuning memory management和autoconfig
使用throttling utilities
第二部分数据布局（17.5%）
创建一个数据库
讨论模式的用处
讨论表空间状态
创建和操纵DB2对象
创建SMS表空间，讨论其特性
创建自动管理表空间，讨论其特性
分区能力（表分区、HASH分区、MDC、Hybrid）
XML结构（为提高性能创建索引）
压缩数据
第三部分数据库访问（11.5%）
创建并管理索引
为表创建约束
创建视图
系统目录表的内容
使用图形工具进行管理
如何强制实施数据唯一性
第四部分分析DB2活动（13%）
捕获并分析EXPLAIN/VISUAL EXPLAIN信息
使用get snapshots或SQL函数捕获快照
创建并激活事件监视器
用健康中心配置健康监视器
问题定位工具（例如，db2bp、db2mtrk等）的作用
第五部分 DB2应用（14.5%）
使用export工具从表提取数据
使用import工具往表里插入数据
使用load工具往表里插入数据
判断何时使用load，何时使用import
使用reorg，reorgchk，rebind和runstats工具
使用DB2Move、DB2Look和DB2Batch
DB2 Advisors的功能
使用控制中心（db2cc）
第六部分高可用性（14.5%）
数据库级别和表空间级别备份和恢复
识别并为重建索引制订计划
数据库日志
崩溃恢复
版本恢复
前滚恢复
HADR
镜像日志
在线可配置参数
第七部分安全（8.5%）
DB2授权
DB2验证
未用户或组赋权
DB2安全基础（安全构件）
Jimmy版
2010-4-20
DB2认证考试目标（英文）
This appendix provides the test objectives for the following exams:
l DB2 9 Fundamentals (730)
l DB2 9 DBA for Linux, UNIX and Windows (731)
l DB2 9 for Linux, UNIX and Windows Advanced DBA (734)
l DB2 9 DBA for Linux, UNIX and Windows Upgrade (736)
How does one cerfify? There are three basic steps:
1. Understand certification test objective.
2. Review study guides, online tutorials, or take an education course. Then test your knowledge by taking an assessment exam at www.ibm.com/software/data/education/cert/assessment.html. There assessments are offered through Prime/Prometric at low nominal fee of $10 USD.
3. Register and take the certification exam.
For more information on IBM Data Management skills programs please visit:
www.ibm.com/software/data/education.html.
Detailed information on the IBM Professional Certification program, including the DB2 Database certification exams, can be found at:
www.ibm.com/certify.
Experience with DB2 is the best route to preparing for the DB2 certification exams, This certification guide is intended to be used alongside your day-to-day use of DB2 while preparing for the exams.
DB2 Certification Levels
There five job roles and three levels of certified solution expert associated with the DB2 product in the distributed environment. The following diagram lists the exam numbers and the corresponding certification level associated with it.
Entry Intermediate Advanced
730——————>731——————>734
|———————>716（Designer）
|———————>733（Developer）
Exam 736 (DB2 9 DBA for Linux, Unix, and Windows Upgrade) has only 38 questions and can be taken instead of Exam 731－if you earned the DBA certification for V8.
These certification levels are accurate at time of publication, but additional exams may be added to these over time. For more information on the certification levels, please refer to the IBM certification site: www.ibm.com/certify.
DB2 Fundamentals (730)
The Database Associate is an entry-level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 9 through either hands-on experience or formal and informal education. The database associate should bave an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 9 is packaged and installed, understand how to create database and database objects, and have a basic knowledge of database security and transaction isolation.
To attain the IBM Certified Database Associate－DB2 9 Fundamentals certification, candidates must pass one test.
Section 1－ Planning (14%)
l Knowledge of restricting data access
l Knowledge of the features of functions available in DB2 tools (just tools that come with product－ distributed space－ i.e., control center, configuration advisor, configuration assistant, command line processor)
l Knowledge database workloads (OLAP vs. warehousing)
l Knowledge of non-relational data concepts (extenders)
l Knowledge of XML data implications (non-shredding)
Section 2－ Security(11%)
l Knowledge of DB2 products (client, server, etc.)
l Knowledge of different privileges and authorities
l Knowledge of encryption option (data and network)
l Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statement)
Section 3－ Working with Database and Database objects (17%)
l Ability to identify and connect to DB2 servers and databases
l Ability to identify DB2 objects
l Knowledge of basic characteristics and properties of DB2 objects
l Given a DDL SQL statement, knowledge to identify results (ability to create objects)
Section 4－ Working with DB2 Data using SQL (23.5%)
l Given a DML SQL statement, knowledge to identify results
l Ability to use SQL to SELECT data from tables
l Ability to use SQL to SORT or GROUP data
l Ability to use SQL to UPDATE, DELETE or INSERT data
l Knowledge of transactions (i.e., commit/rollback and transcation boundaries)
l Ability to call a produre or invoke a user defined function
l Given an Xquery statement, knowledge to identify results
Section 5－ Working with DB2 Tables Views and Indexes (23.5%)
l Ability to demonstrate usage of DB2 data types
l Given a situation, ability to create table
l Knowledge to identify when referential integrity should be used
l Knowledge to identify methods of data constraint
l Knowledge to identify characteristics of a table, view or index
l Knowledge to identify when triggers should be used
l Knowledge of schemas
l Knowledge of data type options for shoring XML data
Section 6－ Data Concurrency (11%)
l Knowledge to identify factors that influence locking
l Ability to list objects on which locks can be obtained
l Knowledge to identify characteristics of DB2 locks
l Given a situation, knowledge to identify the isolation levels that should be used
DB2 for LUW Datavase Administration (731)
If you are knowledgeable with DB2 9 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
To attain the IBM Certified Database Administrator－ DB2 9 DBA for Linux, UNIX, and Windows certification, candidates must pass 2 tests: Test 730 (DB2 9 Fundamentals) and Test 731.
Candidates who have passed exam 700－ DB2 UDB V8.1 Family Fundamentals, or who have acquired the IBM Certified Database Administrator DB2 UDB V8.1 for Linux, UNIX and Windows certification (by passing both exams 700 and 701), obtain the Certified Database Administrator certification.
Section 1－DB2 Server Management (20.5%)
l Ability to configure/manage DB2 instances (e.g. scope)
l Ability to obtain/modify database manager configuration information
l Ability to obtain/modify database configuration information
l Knowledge of DB2 force command
l Ability to configure client/server connectivity
l Ability to schedule jobs
l Ability to use Automatic mantaince (i.e., RUNSTATES, BACHUP, REORG)
l Ability to configure client server connectivity using DISCOVERY
l Skill in interpreting the notify log
l Ability to obtain and modify DB2 registry varibles
l Ability to use self-tuning memory management and autoconfig
l Ability to use throttling utilities
Section 2－ Data Placement (17.5%)
l Ability to create a database
l Skill in discussing the use of schemas
l Skill in discussing the various tablespace states
l Ability to create and manipulate the various DB2 objects
l Ability to create and discuss the characteristics of an SMS tablespace
l Ability to create and discuss the characteristics of an automated managed tablespace
l Knowledge of partitioning capabilities (e.g., table partitioning, hash partitioning , MDC, Hybrid)
l Knowledge of XML structure (indexing for performance)
l Knowledge of compression data
Section 3－ Database Access (11.5%)
l Knowledge of the creation and management of indexes
l Ability to create constraints on tables (e.g., RI, informational, unique)
l Ability to create views on tables
l Skill in examining the contents of the System Catalog tables
l Ability to use the GUI Tools for administration
l Knowledge of how to enforce data uniqueness
Section 4－ Analyzing DB2 Activity (13%)
l Ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
l Ability to capture snapshots suing GET SNAPSHOTS or SQL functions
l Ability to create and activate event monitors
l Ability to configure Health Monitor using the Health Center
l Ability to identify the functions of Problem Determination tools (e.g., db2bp, db2mtrk)
Section 5－ DB2 Utilities (14.5%)
l Ability to use EXPORT utility to extract data from a table
l Ability to use IMPORT utility to insert data into table
l Ability to use the LOAD utility to insert data into table
l Knowledge to identify when to use IMPORT vs. LOAD
l Ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
l Ability to use DB2Move, DB2Look and DB2Batch
l Knowledge of the functionality of the DB2 Advisors (db2advis utility)
l Ability to use DB2 Control Center
Section 6－ High Availability (14.5%)
l Ability to perform database-level and tablespace level BACKUP & RESTORE
l Knowledge to identify and explain issues on index recreation
l Knowledge of database logging
l Knowledge of crash recovery
l Knowledge of version recovery
l Knowledge of Roll Forward recovery
l Knowledge of and ability to perform HADR
l Knowledge of and ability to perform Log Mirroring
l Knowledge of Configurable Online Parameters
Section 7－ Security (8.5%)
l Knowledge of DB2 authentication
l Knowledge of DB2 authorizations
l Ability to set user and/or group privileges
l Knowledge of the DB2 Security Infrastructure (e.g., LBAC and security plug-ins)
DB2 for LUW Advanced DBA (734)
All IBM Certified Advanced Database Administrator is lead DBA for DB2 products on one or more of the following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows. This individual has extensive experience as a DBA and extensive knowledge of DB2 9. This person is capable of performing the advanced tasks such as performance, high availability, security and networking that are required.
To earn an IBM Certified Advanced Database Administrator Certification for DB2 9, you must pass the following exams:
1. Exam 734 － DB2 9 for Linux, UNIX, and Windows Advanced Database Administrator
2. Either Exam 736－ Upgrade Exam for DB2 9 for Linux, UNIX, and Windows Database Administrator or Exam 731－ Full Exam for DB2 9 for Linux, UNIX and Windows Database Administrator
3. Either Exam 700－ DB2 V8 Family Fundamentals or Exam 730－ DB2 9 Fundamentals
The test contains six section with 51 multiple-choice questions. You must score 64% or greater to pass the exam. The percentages each section title reflect the approximate distribution of the total question set across the sections.
Section 1－Database Design (14%)
l Ability to design, create and manage tablespaces
l Ability to design, create and manage bufferpools
l Ability to design and configure federated database access
Section 2－ Data Partitioning and Clustering (15%)
l Ability to design, create and manage database partitioning
l Ability to design, create and manage multi-dimensional clustered tables
l Ability to design, create and manage table partitioning
l Knowledge of Balance Configuration Unit (BCU)
Section 3－ High Availability and Diagnostics (20%)
l Ability to manage database logs for recovery
l Ability to use advanced bachup features
l Ability to use advanced recovery features
l Ability to enhance database availability
l Ability to use diagnostic tools (db2bp, db2mtrk, inspect, db2dart, db2diag)
Section 4－ Performance and Scalability (33%)
l Identify and use DB2 registry varibles that affect database system performance
l Identify and use configuration parameters that affect database system performance
l Knowledge of query optimizer concepts
l Ability to manage and tune database, instance and application memory and I/O
l Ability to use data compression
l Ability to analyze performance problems
l Ability to manage a large number of users and connections
l Ability to determine the more appropriate index
l Ability to exploit parallelism
Section 5－ Security (8%)
l Knowledge of external authentication mechanisms
l Ability to implement data encryption
l Ability to implement Label Based Access Control (LBAC)
l Ability to use DB2 Audit
Section 6－ Connectivity and Networking (10%)
l Ability to configure client server connectivity (e.g., db2discovery)
l Ability to manage connections to host systems
l Ability to identify and resolve connection problems
IBM Certified DBA for DB2 9 for LUW, Upgrade (736)
If you are one of the many people who has earned an IBM Certified Database Administrator－ DB2 UDB V8.1 for Linux, NUIX and Windows Certification, the is an upgrade exam available.
As with Version 8, there are two different exams that you can take to upgrade to the V9 DBA Certification:
1. Exam 736 － IBM Certified Database Administrator for DB2 9 for Linux, UNIX and Windows, Upgrade Exam
2. Exam 731 － IBM Certified Database Administrator for DB2 9 for Linux, UNIX and Windows, Full Exam
The Upgrade Exam 736 is only an option for candidates who are already certified as an IBM Certified Database Administrator－ DB2 UDB V8.1 for Linux, UNIX and Windows. If you pass the exam you will earn you the same certificate that you’d earn from passing Exam 731.
Section 1－Server Management (29%)
l Understand the functionality of AUTOCONFIGURE
l Ability to manually configure communications (protocol image (IPV6))
l Ability to enable automatic maintenance
l Ability to enable Self-Tuning Memory Manger
l Ability to enable Utility Throttling
Section 2－ Data Placement (13%)
l Ability to CREATE DATABASE (new default behavior)
l Ability to create and manage Automatic Storage tablespaces
l Knowledge of Table Partitioning
l Knowledge of Data Row Compression
Section 3－ XML Concepts (13%)
l Ability to use XML data types
l Ability to create and manage XML indexes
l Ability to use basic XML functions (XML PARSE, XML SERIALIZE,XML VALIDATE, XML QUERY)
l Understanding Xquery fundamentals
l Using DB2 Utilities with XML data
Section 4－ Analyzing DB2 Activity (16%)
l Ability to use DB2 utilities (db2bfd, db2mtrk, db2pd)
l Ability to monitor deadlocks
l Ability to use administrative routines and SNAPSHOT functions
Section 5－ High Availability (10.5%)
l Ability to use RECOVER DATABASE command
l Knowledge of High Availability Disaster Recovery (HADR)
Section 6－ Security (10.5%)
l Understanding of Label Based Access Control (LBAC)
l Knowledge of new authentication types
Jimmy
2010-4-22
《DB2 9 for Linux, UNIX and Windows_DBA Guide, Reference, and Exam Prep Sixth Edition》
