課程名稱：IBM Certified Database Administrator-DB2 9 DBA for Linux Unix and Windows 國際認可證書課程 (C2090-731)
- 簡稱：IBM Administrator DB2 Training Course |
Exam C2090-731
DB2 9 DBA for Linux UNIX and Windows
1. DB2 Instances
1.1 Creating and Dropping an instance
1.2 Migrating and Updating a DB2 instance
1.3 Setting up the DB2 environment
1.4 Setting Profile Registries
1.5 Setting system environment variables
1.6 Setting Configuration Parameters
1.7 Setting Configuration Parameters online
1.8 Forcing an instance and a database
2. DB2 Client/Server Connectivity
2.1 Preparing your DB2 Server for remote application connections
2.2 Configuring database connectivity automatically by searching the network
2.3 Configuring database connectivity manually
2.4 Attaching to an instance and connecting to a database
3. DB2 Security
3.1 DB2 Security Overview
3.2 Authentication Types
3.3 “SERVER” authentication type
3.4 “KERBEROS” authentication type
3.5 “CLIENT” authentication type
3.6 DB2 Authority Levels
3.7 Managing DB2 Instance level Authorities
3.8 Managing DB2 Database Privileges
3.9 Managing DB2 Schema Privileges
3.9 (cont.) Managing DB2 Table and View Privileges
3.10 Granting implicit and indirect privileges
3.11 Label Based Access Control
4. Database and Storage Management
4.1 Creating a new database
4.2 Database directories and files
4.3 Buffer Pools
4.4 Table Space
4.5 System Managed Space (SMS) Tablespace
4.6 Database Managed Space (DMS) Tablespace
4.7 Automatic Storage tablespace
4.8 Comparing SMS, DMS and Automatic Storage Tablespace
5. Planning Data Recovery
5.1 Recovery Scenarios
5.2 Recovery Strategies
5.3 Transactions
5.4 Types of Recovery
6. DB2 Transaction Logs
6.1 The purpose of DB2 Transaction Logs
6.2 Primary Logs and Secondary Logs
6.3 Types of Logs
6.4 Types of Logging
6.5 Recovery History File
6.6 Recovering a damaged tablespace
6.7 Managing Recovery objects
6.8 Incremental Backup and Recovery
6.9 Redirected Restore
6.10 Generating Script for Redirected Restore
7. High Availability Disaster Recovery (HADR)
7.1 Overview of HADR
7.2 HADR Database States
7.3 HADR Synchronization Mode
7.4 Initializing HADR environment
7.5 Switching Database Role
7.6 Enabling Automatic Client Reroute feature
7.7 Initializaing a Standby Database using Split Mirror
7.8 Performing Data Load operation in an HADR environment
7.9 Stopping HADR
8. Performance Tuning
8.1 Performance Tuning Overview
8.2 Benchmark testing
8.3 Operational Monitoring
8.4 Factors that affects performance
8.5 DB2 system architecture and process overview
8.6 Intra Partition Parallelism and Parallel Processing
8.7 Database Agents and its management
8.8 Table Reorganization
8.9 Explaining Query Execution Plan
9. Memory Tuning
9.1 Memory allocation of DB2 Instances and Databases
9.2 Database Manager Shared Memory
9.3 Self Tuning Memory
9.4 Tuning Sort Performance and Memory consumption
9.5 Configuration Advisor
9.6 DB2 Memory Tracker
|
