DB2 9 for LUW Multiple Partition DBA Workshop

M/UX
Atlanta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' After completing this course, you should be able to:

Describe the steps to install and customize DB2 in a partitioned environment
Use GUI and Command Line tools to administer the database
Create objects and load data into DB2 databases
Define a DB2 partitioned recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations
Identify how a database should be designed to take advantage of the parallel architecture
Use DB2 utilities to manage data and maintain your database
Implement DB2 security
Note: Actual installation of DB2 will not be performed in this workshop. A pre-installed system is used to exercise various administrative functions.


Course outline

--------------------------------------------------------------------------------

Components and Concepts
Getting Started with DB2
Installation
Creating Databases
Partitioning and Database Partition Groups
Data Placement on the Partition
Create Objects
Moving Data
Application Alternatives
Recovery
Scaling the Database
Performance and Application Concepts
Security
Monitoring and Problem Determination Tools
Locks and Concurrency
Agenda

Day 1

Welcome
Unit 1 - Components and Concepts
Paper Lab
Unit 2 - Getting Started with DB2
Unit 3 - Installation
Installation Lab
Unit 4 - Creating Databases
Day 2

Creating Database Lab
Unit 5 - Partitioning and Database Partition Groups
Partitioning Keys and Database Partition Groups Lab
Unit 6 - Data Placement on the Partition
Creating Table Spaces Lab
Unit 7 - Create Objects
Day 3

Creating Objects Lab
Unit 8 - Moving Data (Import and Load)
Moving Data Lab - import and Load
Unit 8 Continued - Moving Data (Partitioned Load)
Moving Data Lab - Partitioned Load
Unit 9 - Application Alternatives
Application Basics Lab
Day 4

Unit 10 - Backup and Recovery
Backup and Recovery Lab
Unit 11 - Scaling the Database
Scaling Lab
Unit 12 - Performance and Application Concepts
Application Performance Tools Lab
Day 5

Unit 13 - Security
Security Lab
Unit 14 - Monitoring and Problem Determination Tools
Unit 15 - Locking and Concurrency
Locking and Concurrency Lab


Prerequisites

--------------------------------------------------------------------------------

Before taking this course, you should be able to:

Use basic Linux/UNIX functions such as utilities, file permissions, hierarchical file system, commands, and the vi editor
State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
Discuss basic relational concepts and objects such as tables, indexes, views, and joins
These skills can be developed by taking:

Linux/UNIX basics (for example, Linux Basics)
DB2 SQL Workshop
DB2 Family Fundamentals
The student will be using a Linux environment in a VMware image for the lab exercises.

It will be helpful for students running DB2 on other operating systems and platforms - such as DB2 on an AIX - to have experience with using and administering their operating system environment.

...''

Phone:866-700-9811

School Address:

pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537

CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511

DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533

M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA

Jobs & Resumes: Atlanta
Houses & Roommates: Atlanta

CICSPlex System Manager, Administration
CICS V3.2 Fundamentals
DB2 SQL Workshop
Relational Database Design
Using Rational Data Architect
DB2 9 Database Administration Workshop for Linux/UNIX/Windows
DB2 Universal Database Administration Workshop for Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 UDB for z/OS and OS/390 Data Sharing Implementation
DB2 for z/OS and OS/390 Data Sharing Recovery and Restart
DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
DB2 9 for LUW Advanced Database Recovery
DB2 Stored Procedures Programming Workshop
DB2 UDB Application Programming Workshop
DB2 UDB for z/OS System/Disaster Recovery Workshop
Query and Manage XML data with DB2 9
DB2 UDB for z/OS Stored Procedures using COBOL

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.