|Course code||1W322||Skill level||Intermediate|
|Duration||16.0 hours||Delivery type||Web Based Training|
|Course type||Public only|
|Public price||USD $600.00 plus tax|
Note: This is a self-paced online course. This course usually requires 16 hours to complete. Once you receive your access information, you will have access to this course for 1 year.
This course is designed to teach the DB2 DBA how to administer DB2 Workload Manager. Each of the components are covered. The course first covers how to use service classes to control resources and how to use DB2 workloads to group DB2 work activities and assign the workloads to service classes. Next we discuss thresholds and how you can be applied to service classes, workloads or the database. Then the course presents how work classes are used to differentiate the types of work activities, that is, DML, DDL, stored procedures and utilities, and work actions are used to apply thresholds to the work classes. The monitoring component is shown how it plays a critical role in performance tuning and problem determination. The course finishes with a unit on best practices for using DB2 WLM.
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course materials.
The course materials address the Workload Manager feature available as part of InfoSphere Warehouse 9.5 or as part of the DB2 Performance Optimization Feature.
Lab exercises will be provided to give you experience working with Workload Manager.
Training Paths that reference this course are:
This intermediate course is for DB2 DBA responsible for implementing DB2 Workload Manager.
This course is also appropriate for customers who have acquired the IBM Smart Analytics System.
Introduction to DB2 Workload Manager
DB2 WLM workloads
Work Classes and Work Actions
Monitoring and Control
Special Note for IBM Business Partners authorized to remarket IBM IT Education Services public classes and on-site classes: This course is excluded from the IBM Technical Training Services for Public Education Program and the IBM Training Services for Enterprise - on-site Education Program for IBM Business Partners.
The minimum hardware and software required to launch the course are:
Network Speed Test
For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.
High-speed broadband internet access is the recommended configuration for this course.
If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.