18 May, 2012
Text Size

DB2 for LUW SQL Performance & 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 up to DB2 9.7.

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 DB2 9.7
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

Upcoming Database Courses

Course Contact Form

Please complete the form to enquire about running a course at your premises or one of our training facilities

Name:

Email:

Telephone:

Organisation:


Comment: