|
 |
Test 000-731: DB2 9 DBA for Linux UNIX and Windows
|  |
 |
 |
 |
|
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. Section 1 - DB2 Server Management (22%) - 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 (16%) - 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 (12%) - 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 (13%) - 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 (14%) - 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 (14%) - 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 (9%) - 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)
|
 |
|
 |
| |
|