DB2 LUW Performance Tuning and Monitoring for Single and Multiple Partitions DBs Training Onsite

Security Training & Consulting

Enterprise Applications

Wireless Communication

DoD 8570 Training

Bookstore

We are here to help...

With easy ways to get the answers you need:

Or call us at:
1-888-742-3214

IBM



Course Name:	DB2 LUW Performance Tuning and Monitoring for Single and Multiple Partitions DBs - CL441 Training

Deployment Options:	Onsite - Instructor-Led Training

Course Duration:	5 days depending on audience background and options

Related Courses

Introduction:

Learn how to tune for optimum performance the IBM DB2 9 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 9 for Linux, UNIX, and Windows in support of single partition and multiple partition (DPF) database environments.

Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning. Use tools in class that are common across the Linux, UNIX, and Windows operating systems environments. During labs running on DB2 9, develop your ability to use monitoring tools, explain tools, and DB2 utilities, such as RUNSTATS, REORG and db2batch, to tune a database running on your local LINUX workstation using single and multiple partition DB2 databases

Audience:

This is an advanced course for database designers, database administrators, and application developers working with DB2 9 for Linux, UNIX, and Windows who are concerned about performance in both single and multiple partition databases.

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
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.

Customize it:

This 5-day IBM course will be customized to your needs and specifications. Eno.com will assist you in identifying those needs and specifications. A word to the wise, there are many vendors of IBM training. They will typically have a broad and general course, one size fits all, already developed and just put your organization?s ame on the title slide. This minimizes their effort and time investment. At Eno.com, every course is made to your exact and exacting specifications. We help you ensure what you are getting is what you really need even if at the beginning you weren't too sure of what that was. We fit the class to your needs. We never fit you into our standard, one size fits all, class.

Objectives:

What You'll Learn

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
Application development process with respect to DB2 considerations
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

Course Outline

1. Components and Concepts
2. Getting Started with DB2
3. Installation
4. Creating Databases
5. Partitioning and Database Partition Groups
6. Data Placement on the Partition
7. Create Objects
8. Moving Data
9. Application Alternatives
10. Recovery
11. Scaling the Database
12. Performance and Application Concepts
13. Security
14. Monitoring and Problem Determination Tools
15. Locks and Concurrency

Agenda

Day 1