- 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
English LVC are organised from 3pm to 11pm.
- 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
This intermediate course is for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.
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
