IBM证书的七个技术方向
IBM(国际商业机器公司)或万国商业机器公司，简称IBM(International Business Machines Corporation)。总公司在纽约州阿蒙克市。下面是小编整理的.关于IBM证书的七个技术方向，欢迎大家参考!
Exam 000-730 DB2 9 Family Fundamentals
1. IBM DB2 Overview1.1 Introduction to IBM DB2 Servers and Clients1.3 Different Editions IBM DB2 of Various Platforms
2. Deploying IBM DB2 for Windows2.1 Installation requirements for DB2 servers2.2 IBM DB2 Disk and Memory Requirements2.3 Configuring OS settings2.4 Installing IBM DB2 Database Server Enterprise Edition2.5 Installing IBM DB2 Database Server Enterprise Edition (Cont.)
3. DB2 Tools3.1 Tools Overview3.2 The Control Center3.3 The Journal3.4 The Task Center3.5 Health Center3.6 Command Editor
4. DB2 Command Line Processor (CLP)4.1 Using the DB2 Command Window4.2 Using the DB2 Command Line Processor CLP
5. Basic Concept of IBM DB2 Database5.1 Components of an IBM DB2 Database5.2 Creating a DB2 Database5.3 Installing DB2 Client5.4 Connecting a client to DB25.5 Data Types5.6 Schema5.7 Table5.8 Referential Integrity - Creating Relationships Between Tables5.9 Altering a table5.10 Constraints5.11 Understanding Views
6. Index6.1 Purpose of an Index6.1 Creating an Index (Cont.)6.2 Non-clustered and Clustered Index6.3 Non-Clustered Index with Included Columns6.4 Improving Update performance6.5 Composite Index (组合索引)6.6 Design Advisor6.7 Materialized Query Table (MQT)
7. SQL7.1 Limit the amount of data returned by a query7.2 Sorting Results7.3 Retrieving data from multiple tables
8. Sequence8.1 Introducing Sequence object8.2 Creating and Altering a Sequence8.3 Rolling back a transaction with sequence
9. Understanding Transactions9.1 Understanding data consistency9.2 Understanding Unit of Work9.3 Effects of Commit and Rollback operations9.4 Using SAVEPOINT
10. Understanding Concurrency and Isolation10.1 Phenomena that may occur when multiple users access a database10.2 Concurrency and Isolation Levels10.3 Repeatable Read
Exam 000-731 DB2 9 DBA for Linux UNIX and WindowsSection 1 - DB2 Server Management
Ability to configure/manage DB2 instances (e.g. scope)
Ability to obtain/modify database manager configuration information
Ability to obtain/modify database configuration information
Knowledge of the DB2 force command
Ability to configure client/server connectivity
Ability to schedule jobs
Ability to use Automatic Maintenance (i.e., RUNSTAT, Backup, REORG)
Ability to configure client server connectivity using DISCOVERY
Skill in interpreting the Notify log
Ability to obtain and modify DB2 registry variables
Ability to use Self-tuning memory managemer and autoconfig
Ability to use Throttling utilities
Section 2 - Data Placement
Ability to create a database
Skill in discussing the use of schemas
Skill in discussing the various table space states
Ability to create and manipulate the various DB2 objects
Ability to create and discuss the characteristics of an SMS tablespace
Ability to create and discuss the characteristics of an automated managed tablespace
Knowledge of partitioning capabilities (e.g., Table partitioning, Hash partitioning, MDC, Hybrid)
Knowledge of XML structure (indexing for performance)
Knowledge of compression data
Section 3 - Database Access
Knowledge of the creation and management of indexes
Ability to create constraints on tables (e.g., RI, Informational, Unique)
Ability to create views on tables
Skill in examining the contents of the System Catalog tables
Ability to use the GUI Tools for administration
Knowledge of how to enforce data uniqueness
Section 4 - Analyzing DB2 Activity
Ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Ability to capture snapshots using Get Snapshots or SQL functions
Ability to create and activate event monitors
Ability to configure Health Monitor using the Health Center
Ability to identify the functions of Problem Determination Tools (e.g, db2pd, db2mtrk)
Section 5 - Utilities
Ability to use EXPORT utility to extract data from a table
Ability to use IMPORT utility to insert data into a table
Ability to use the LOAD utility to insert data into a table
Knowledge to identify when to use IMPORT vs. LOAD
Ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
Ability to use DB2Move, DB2Look and DB2Batch
Knowledge of the functionality of the DB2 Advisors (db2advis utility)
Ability to use the DB2 Control Center
Section 6 - High Availability
Ability to perform database-level and table space level BACKUP & RESTORE
Knowledge to identify and explain issues on index recreation
Knowledge of database logging
Knowledge of crash recovery
Knowledge of version recovery
Knowledge of Roll Forward recovery
Knowledge of and ability to perform HADR
Knowledge of and ability to perform Log Mirroring
Knowledge of Configurable Online Parameters
Section 7 - Security
Knowledge of DB2 authentication
Knowledge of DB2 authorizations
Ability to set user and/or group privileges
Knowledge of the DB2 Security Infrastructure (e.g. LBAC and Security Plug-ins)
