PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Db2 and the z/OS Environment
The concepts and terminology of Db2 database administration.
Instructor to provide examples.
Examine the concepts and terminology of database structures.
Instructor to provide examples.
Physical Database Design
Design and implement a system using physical design.
Develop a logical design of a system.
Develop the appropriate DDL for creating objects which will include views and indexes.
Loading and Managing Db2 Databases
Load tables in multiple ways.
Load a table using a program and the Db2 LOAD utility.
Table and View design
Design tables for performance and integrity.
Redesign tables for partitioning, clustering, indexing, column layout, tablespace type, and page.
Learn how to improve parallelism.
General Efficiency Techniques
Become familiar with the options which are available for tuning a Db2 SQL query including: changing the query, redesigning the database, and changing the application program.
Instructor presents examples and different scenarios: checking Db2 statistics, modifying sample SQL statements, and scenarios for changing table designs.
Factors Affecting Performance
Examine the cost in terms of maintenance associated with indexes.
Evaluate the benefits of a proposed index.
How and when a proposed index brings significant relief to a query, then the index can be justified.
Examine the trade-offs in query tuning and the impact of business decisions.
Analyze an approach where tuning focuses on reducing query I/O.
Recognize that a reduction in query I/O does not eliminate all of the I/O; some of the I/O is moved to index maintenance.
Instructor presents examples and different scenarios: reducing unnecessary I/O with a new index, index-only processing, and index costs.
When to Tune
Develop guidelines for determining when to tune and which components to tune.
Instructor presents examples and different scenarios for monitoring Db2 and identifying issues relating to performance.
Recovery and Security
Backup and restore a tablespace.
Backup a series of tablespaces.
Delete the tablespaces and then perform a restoration using logs and backups.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.