|
 |
Test 706: Upgrade to 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 (20%) - Configure DB2 using online configuration parameters
- Prepare
database for exclusive mode for maintenance
- Use of Notify log for
system administration
- Configure DB2 Administration Server
Section 2 - Data Placement (13%) - Use snapshot
monitor to obtain information on table space state
- Maintain the DMS
table space by adding, dropping, or changing the size of a container
- Create and manipulate various DB2 objects (buffer pools, new indexing
and temporary tables)
Section 3 - Database Access (13%) - Create and
manage indexes to provide better concurrency
- Use informational
constraints in table definitions
Section 4 - Monitoring DB2 Activity (14%) - Use
SQL to access snapshot monitor data
- Create and activate event monitors
- Configure and use Health Monitor and Health Center to improve database
availability
Section 5 - DB2 Utilities (23%) - Use the LOAD
utility to insert data into a table online
- Use the REORG, REORGCHK,
REBIND and RUNSTATS utilities
- Knowledge of the functionality of the
DB2 Advisors
- Use the DB2 Control Center
- Use the inspect
utility to determine problems with database
Section 6 - Backup and Recovery (17%) - Configure system for new logging features
- Use the roll forward
recovery to different points of time
- Use incremental backups to
enhance recovery duration
- Use DB2 suspend I/O and resume I/O
capabilities to enhance recovery and high availability
|
|
|
|
| |
|
