Duration
2 days
Prerequisites
You should be able to:
- Perform basic database administration tasks on a relational database system
- 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 joins
These skills can be developed by taking:
- OS Training:
- AIX Basics and Administration
- 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 or GUI tools
- Create and manage database storage for tables using Automatic Storage management, System Managed Storage (SMS) or Database Managed Storage (DMS) table spaces
- 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 DB2 utilities like RUNSTATS to collect table and index statistics and REORG to reorganize tables and indexes to improve access and storage efficiency
- Implement DB2 security
- Select indexes to support application performance requirements
- Explore the DB2 recovery facilities and database configuration options
Course Outline
- Overview of DB2 for Linux, UNIX and Windows
- Command Line Processor (CLP) and GUI tools
- The DB2 environment
- Creating databases and data placement
- Creating database objects
- Moving data
- Backup and recovery
- Locks and concurrency
- Problem determination
- Security
Programme scope, delivery arrangements and suitability are confirmed during enquiry.