Prerequisites
You should be able to:
Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
Discuss basic relational database concepts and objects such as tables, indexes, views, and join
These skills can be developed by taking:
OS Training:
AIX 5L Basics
Linux Basics and Administration
Windows Systems Administration
Or by having equivalent HP-UX or Solaris administration experience
DB2 SQL Workshop
DB2 Fundamentals
Skills taught
- Administer a DB2 database system using commands and GUI tools
- Compare DMS, SMS, and Automatic storage management for table space storage
- Implement a given logical database design using DB2 to support integrity and concurrency requirements
- List and describe the components of DB2
- Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
- Use autonomic features of DB2
- Examine Explain output to determine access strategy chosen by Optimizer
- Investigate current application activity that might indicate performance problems using SQL statements
- Implement DB2 security
Course outline
- Overview of DB2 on Linux, UNIX and Windows
- Command Line Processor (CLP) and GUI usage
- The DB2 environment
- Creating databases and data placement
- Creating database objects
- Moving data
- Backup and recovery
- Database Maintenance, Monitoring, and Problem Determination
- Locking and concurrency
- Security
Agenda
Day 1
- Welcome
- Exercise 1: Create a New DB2 Instance
- Exercise 2: Creating databases and data placement
Day 2
- Exercise 3: Create objects
- Exercise 4: Moving data
Day 3
- Exercise 5: Backup and recovery
- Exercise 6: Using DB2 Tools for Performance
Day 4
- Exercise 7: Investigating DB2 Locking
- Exercise 8: Database Security e Security
Programme scope, delivery arrangements and suitability are confirmed during enquiry.