Training Courses
| COURSE CODE |
AC13V7 |
AU14V11 |
CF21V8.3 |
| COURSE TITLES |
AIX 5L Basics |
AIX 5L System Administration I: Implementation |
DB2 9 Database Administration Workshop for UNIX |
| AUDIENCE |
This course is suitable for anyone who requires basic AIX user skills. This course is also a prerequisite for students who plan to attend the AIX System Administration courses. |
Anyone responsible for the system administrative duties implementing and managing AIX 5L V5.3 operating system on an IBM pSeries system. |
System administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases. |
| PURPOSE |
This course enabled students to perform everyday tasks using the AIX 5L operating system version 5.2. |
The purpose of this course is to enable students to install, customize, and administer the AIX 5L V5.3 operating system in a multiuser environment using pSeries systems. |
This course teaches you how to perform basic database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. |
| PREREQUISITES |
Students attending this course should be familiar with basic information technology (IT) concepts and the role of an operating system. |
The students attending this course should be able to:
AC13 Course OR
- Log in to an AIX system and set a user password
- Execute basic AIX commands
- Manage files and directories
- Use the vi editor
- Use redirection, pipes, and tees
- Use the utilities find and grep
- Use the command and variable substitution
- Set and change Korn shell variables
- Write simple shell scripts
These skills can be acquired by taking the AIX 5L Basics course or through equivalent AIX/UNIX knowledge. |
Before taking this course 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 joins
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
|
| OBJECTIVES |
After completing this course, students should be able to:
- Log in to an AIX system and set a user password
- Use AIX online documentation
- Manage AIX files and directories
- Describe the purpose of the shell
- Use the vi editor
- Execute common AIX commands and manage AIX processes
- Customize the working environment
- Use common AIX utilities
- Write simple shell scripts
|
On completion of this course, students should be able to:
- Install the AIX 5L V5.3 operating system, software bundles, and filesets
- Perform system startup and shutdown
- Understand and use the system management tools
- Manage physical and logical devices
- Perform file system management
- Create and manage user and group accounts
- Perform and restore system backups
- Utilize administrative subsystems, including cron to schedule system tasks, and security to implement customized access of files and directories
- Describe basic networking concepts
|
After completing this course, you should be able to:
- Administer a DB2 database system using commands and GUI tools
- Implement DB2 security
- Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
- 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
- Describe the application development process with respect to DB2 considerations
- Use autonomic features of DB2
|
| CONTENTS |
Introduction to AIX
- Using the System
- AIX Documentation
- Files and Directories
- Using Files
- File Permissions
- Shell Basics
- Using Shell Variables
- The vi Editor
- Processes
- Customizing the User Environment
- AIX Utilities
- AIX Utilities, Part II
- Additional Shell Features
|
Introduction (Overview of pSeries)
- System Management Tools - SMIT and the Web-based System Manager
- Software Installation and Management
- System Startup and Shutdown Devices
- Printers and Queues
- Managing Queues
- System Storage Overview
- Working with the Logical Volume Manager
- Working with File Systems
- Managing File Systems
- Paging Space
- Backup and Restore
- Security
- User Administration
- Scheduling
- Networking Overview
|
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
Locking and concurrency
Problem determination
Application issues and performance
Security |
| CURRICULUM RELATIONSHIP |
This course is the first course in the AIX curriculum and is a prerequisite for all the training paths. |
This course should follow the AIX 5L Basics course. A basic understanding of AIX environment and simple commands is recommended before taking this course. |
This course is part of an IBM DB2 Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. |
| DURATION |
3.0 days |
5.0 days |
4.0 days |
| DATES IN 2008 |
11-13 March |
9-13 June 2008 |
19-22 May 2008 |
| Price per person plus VAT |
1208 Euro |
1935 Euro |
1455 Euro |
