Skip to main content

pSeries Curriculum

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

Minimum requirements: 4 participants per classroom

To acquire more information, you can e-mail us at: training@cy.ibm.com