|
|
|
|
|
NWDB3016 DB2 Administration for Distributed Platforms (LUW) for Experienced Users
DESCRIPTION
This 4 day course is designed to review the concepts and components of DB2 version 9.5 for LINUX, UNIX and Windows. This course has 2 major sections; basic administration and advanced topics. DB2 GUI tools, DB2 commands and SQL will be used to practice DB2 administration activities. Basic Administration involves creating objects that support a logical data model. Basic administration activities will also include backup and recovery, data movement and security. Advanced topics include using explain tools and analyzing results. Index design has a great effect on performance and the Design Advisor will be used to help. Health monitoring will also be used to identify performance problems. DB2 Utilities and system commands can be used to support problem resolution and will be used in workshops. Autonomic features of DB2 will also be reviewed.
AUDIENCE
Database administrators and technical specialists with experience of relational databases.
OBJECTIVES
After completing this course the student should be able to:
- Understand the basic concepts and facilities of DB2.
- Create instances, databases and relational objects to support applications
- Use automatic storage, row compression and range partitioning on tables.
- Use IMPORT, EXPORT and LOAD utilities to manipulate data.
- Perform database recovery operations, including redirected restores.
- Understand the basic security features of DB2.
- Understand and control the locking behavior of DB2.
- Know how index design can aid performance.
- Use EXPLAIN tools and techniques to improve SQL performance
- Manage log files for backup and recovery operations.
- Manage problem determination and use monitoring tools like the Health Center.
- Alter the configuration of DB2 to enable automatic maintenance of DB2 tables
TOPICS
- The DB2 Family
- Getting Started with DB2 (INSTANCES)
- DB2 and GUI
- Creating Databases and Tablespaces
- Creating Tables and other Objects
- DB2 LOCKING
- DB2 Security
- DB2 Data Management
- IMPORT/EXPORT/LOAD Utilities
- Database Recovery and log File Management
- Database and Tablespace Relocation
- Data Access Techniques and EXPLAIN
- Index Design and the Design Advisor
- Problem Determination and Resolution
- Configuring for Self Tuning of DB2 and Automatic Maintenance
PREREQUISITES
Relevant Operating Systems experience (UNIX, LINUX or Windows). Knowledge of relational databases and SQL. Previous experience of using DB2 or another relational database is assumed.
|
|
|
|
