DB2 UDB Administration

Course Overview

To provide students with the knowledge and skills they need to perform the routine tasks of a DB2 Universal Database Systems Administrator.

Audience

Application developers, database and systems administrators, technical support personnel. This course gives practical guidance on the administration of DB2 and is particularly suitable for people needing to configure and maintain DB2 as part of their job. Application developers often need to set up the DB2 database and this course covers these aspects and topics like Authorisation and Performance which have an impact on Client software.

Skills Gained

This course will enable delegates to:

• Configure and maintain DB2 instances.
• Manipulate databases and database objects.
• Optimize placement of data.
• Control user access to instances and databases.
• Implement security on instances and databases.
• Use DB2 activity monitoring utilities.
• Use DB2 data movement and reorganization utilities.
• Develop and implement Database recovery strategy.
• Interpret basic information in the DB2DIAG.LOG file.

Prerequisites

Introduction to SQL ( SQL ) or equivalent knowledge. Introduction to Relational Databases ( IRD ) or a knowledge of relational database design concepts. Ability to use the Windows interface. Examinations

IBM certification Test 701 : DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Additional Notes This course is an official IBM course using IBM courseware.

Course Outline

• Overview of DB2 Major Components
• DB2 Product Family. DB2 Object Architecture. Introduction to GUI Tools
• Information Centre, Control Centre, Configuration Assistant, Command Centre. Task Centre, Health Centre. Development Centre. Visual Explain. Data Placement
• Table Spaces (SMS and DMS) Containers. Extents. Bufferpools. Creating Databases. Performance. Creating an Instance
• Database Tables and Views
• Creating Indexes
• Clustered and Unique. Bidirectional. Design Advisor. Using Constraints
• Data Movement Utilities
• Export, Import and Load. Data Maintenance Utilities
• Locking and Concurrency
• Types of Locks. Lock Conversion and escalation. Isolation Levels. Deadlocks. Backup and Recovery
• Backup and Restore Utilities. Circular and Dual Logging. Table Space Recovery. Dropped Table Recovery. Performance Monitoring
• Snapshot Monitor. Event Monitor. Query Optimisation
• Problem Determination
• Security
• Authentication. Privileges.