DB2 for LUW SQL Performance and Tuning

DB2 for LUW SQL Performance and Tuning

Audience

The course is ideal for Systems Administrators, Developers, Database Administrators and technical personnel who are involved in all stages of designing, planning, implementing and maintaining a DB2 for LUW Database, but wish to ensure that they are using the language efficiently. The course is delivered at the latest release level, although previous releases can be covered on request.

Prerequisites

Delegates are expected to have a reasonable working knowledge of DB2 on the appropriate LUW platform (i.e. Linux, UNIX or Windows).

Duration

3 days. Hands on.

Course Objectives

The course is designed to instruct those delegates attending the course how to develop and implement DB2 applications in an efficient and effective manner.

Course Content

Introduction to DB2
The DB2 family.
The Big Picture.
Basic Terms.
DB2 System Catalog.
Tables and views.
Attributes Including XML.
Consolidation of DDL With Regard To Efficiency up to and Including the latest release level.
Consolidation Of Operating System Commands Including DB2LOOK.
Indexing.
Cluster Ratio.
Effect on sorting.
RUNSTATS.
REORG.
Reorgchk.
Access Strategies.

Explain
Db2expln.
Visual Explain.
Range Clustered Tables.
MDC.
Design Advisor.
SQL With Regard To Efficiency.
CTE’S.
Embedded SQL.
Static and Dynamic SQL.
Cursors.
Development Cycle.
Locking Strategy.
Logs.
Snapshot and Event Monitor.
Introduction to Automatic Computing.
Configuration Parameters.

XML
XML Layout.
Table Creation.
Indexes.
Xpath Functions.
Xquery.
Programming with XML.
XML utilities.

Public Courses

There are no up-coming events

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...