The following list helps you to identify the competency areas covered in this test. The percentage indicates the portion of the test dedicated to a particular competency area.
| Competency |
Importance |
| |
Way(s) to attain |
| Topic |
Primary |
Alternative |
Other |
|
| Database Architecture in the R/3 Environment |
11-20% |
| DB2 instances |
TADM10, TADM12, TADM56_03 |
|
|
| Configuring DB2 databases and DB2 database managers |
TADM10, TADM12, TADM56_03 |
|
|
| Database processes and files |
TADM10, TADM12, TADM56_03 |
|
|
| Database startup and shutdown procedures |
TADM10, TADM12, TADM56_03 |
|
|
| Logging using DB2’s soft checkpoints |
TADM10, TADM12, TADM56_03 |
|
|
| Networked database environments and server communication setup |
TADM10, TADM12, TADM56_03 |
|
|
| R/3 and database users and implicit and explicit user authorizat |
TADM10, TADM12, TADM56_03 |
|
|
| R/3 naming conventions for database files |
TADM10, TADM12, TADM56_03 |
|
|
| R/3 System interfaces to DB2 on UNIX and Windows NT |
TADM10, TADM12, TADM56_03 |
|
|
| Table spaces and DB2 types of containers (SMS, DMS) |
TADM10, TADM12, TADM56_03 |
|
|
|
| Database Backup Strategy |
11-20% |
| CCMS for backup scheduling and monitoring |
TADM10, TADM12, TADM56_03 |
|
|
| Database and table space backups including the recovery implicat |
TADM10, TADM12, TADM56_03 |
|
|
| Database objects which are backed up by DB2 |
TADM10, TADM12, TADM56_03 |
|
|
| DB2 database backup tools and their process architecture |
TADM10, TADM12, TADM56_03 |
|
|
| Tuning DB2 backups for optimal performance |
TADM10, TADM12, TADM56_03 |
|
|
| Verifying a backup image for consistency |
TADM10, TADM12, TADM56_03 |
|
|
|
| Database Maintenance and Administration |
11-20% |
| Administrative tasks using the DB2 CLP and DB2 Control Center |
TADM10, TADM12, TADM56_03 |
|
|
| Database backups and table space backups |
TADM10, TADM12, TADM56_03 |
|
|
| Database diagnostic log |
TADM10, TADM12, TADM56_03 |
|
|
| R/3 System database administration tasks |
TADM10, TADM12, TADM56_03 |
|
|
| R/3 System security aspects |
TADM10, TADM12, TADM56_03 |
|
|
| Restoring a database so it may be used to install another R/3 Sy |
TADM10, TADM12, TADM56_03 |
|
|
| Updating DB2 database statistics |
TADM10, TADM12, TADM56_03 |
|
|
|
| Database Restore and Recovery |
11-20% |
| Database recovery types, mechanisms, phases, and consequences |
TADM10, TADM12, TADM56_03 |
|
|
| Database structure changes with a redirected restore |
TADM10, TADM12, TADM56_03 |
|
|
| Recovery of a database |
TADM10, TADM12, TADM56_03 |
|
|
| Restore of database backups |
TADM10, TADM12, TADM56_03 |
|
|
|
| Recognizing and resolving problem situations |
11-20% |
| Handling disk crashes |
TADM10, TADM12, TADM56_03 |
|
|
| Handling R/3 DB2 password management and error situations |
TADM10, TADM12, TADM56_03 |
|
|
| Handling table space overflows |
TADM10, TADM12, TADM56_03 |
|
|
| Identifying and responding to a log full or database full condit |
TADM10, TADM12, TADM56_03 |
|
|
| Location, contents, and analysis of DB2 diagnostic log files |
TADM10, TADM12, TADM56_03 |
|
|
| Resolving situations where DB2 cannot offload the online files |
TADM10, TADM12, TADM56_03 |
|
|
| Restoring the database after the loss of a table space |
TADM10, TADM12, TADM56_03 |
|
|
| Restoring the database using a offline backup |
TADM10, TADM12, TADM56_03 |
|
|
| Restoring the database using a online backup |
TADM10, TADM12, TADM56_03 |
|
|
| Retrieving the DB2 database and fix pack level |
TADM10, TADM12, TADM56_03 |
|
|
|
| Storage Management Administration |
11-20% |
| Analyzing, planning and scheduling table reorganization |
TADM10, TADM12, TADM56_03 |
|
|
| Database limits in storage management |
TADM10, TADM12, TADM56_03 |
|
|
| Database storage monitoring |
TADM10, TADM12, TADM56_03 |
|
|
| Disk space requirements |
TADM10, TADM12, TADM56_03 |
|
|
| Extending table spaces and implications of storage rebalancing |
TADM10, TADM12, TADM56_03 |
|
|
| Setting up databases running on multiple page sizes |
TADM10, TADM12, TADM56_03 |
|
|
| Table space and container administration |
TADM10, TADM12, TADM56_03 |
|
|
|