|
 |
Test 701: DB2 V8.1 for Linux UNIX and Windows Database Administration
|  |
 |
 |
 |
|
If you are knowledgeable with DB2 Universal Database V8.1 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 (19%) - Ability to configure/manage DB2 instances (e.g. scope)
- Knowledge of DB2 authentication
- Knowledge of DB2 authorizations
- Ability to set user and/or group privileges
- Knowledge of the DB2 force command
- Ability to configure client/server connectivity
- Ability to schedule jobs
- Ability to configure client server connectivity using DISCOVERY
- Skill in interpreting the Notify log
Section 2 - Data Placement (17%) - 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 a DMS tablespace
Section 3 - Database Access (17%) - Ability to create DB2 Tasks using the GUI tools
- 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 GUI Tools to access DB objects
- Knowledge of how to enforce data uniqueness
Section 4 - Monitoring DB2 Activity (16%) - Ability to obtain/modify database manager configuration information
- Ability to obtain/modify database configuration information
- Ability to capture EXPLAIN/VISUAL EXPLAIN information
- Skill in analyzing EXPLAIN/VISUAL EXPLAIN information (sortheap, buffpage, degree)
- Ability to identify the functions of the DB2 Governor and Query Patroller
- Ability to obtain and modify DB2 registry variables
- Ability to capture snapshots
- Ability to create and activate event monitors
- Ability to Identify output from the Health Center
Section 5 - DB2 Utilities (17%) - 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 and DB2Look
- Knowledge of the functionality of the DB2 Advisors
- Ability to use the DB2 Control Center
Section 6 - Backup and Recovery (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
|
 |
|
 |
| |
|