|
Installation and Configuration
|
|
- Develop Configuration Plan
- Prepare the Operating System for Installation
- Backup the Previous Installation (upgrade only)
- Set Up the Database Server Environment
- Install the DB2 Server
- Configure DB2
- Configure DB2 DRDA
- Set Up and Test Database Connectivity
|
|
Database Administration
|
|
- Logical Database Design
- Physical Database Design
- Create the Physical Databases
- Administration of Tables, Clusters and Indexes
- Administration of Views, Aliases and Synonyms
- Administration of Database and Triggers
- Administration of Stored Procedures
- Set Up Database Security and Auditing Processes
- Administration of DB2 Users
- Set Up Backup and Recovery Procedures
|
|
Performance and Tuning
|
|
- Identification of Problems with Design and Development
- Identification of Problems with System Resources
- Identify Problems and Tune Memory, Disk I/O and CPU
- Identify and Create Indexes as needed for Performance
- Tune Storage and Buffer Pools
- Tune the SQL Code
- Tune the Archive Logs
- Tune for Long Running Jobs
- Tune for the Client Server Environment
|
|
|
