AquinasTraining.co.uk - training courses. Home  -  FAQ  -  Corporate Plans

IBM DB2: SQL Performance and Tuning for z/OS

DB2PSQ      Course duration (days): 3
Talk to a Training Advisor
Tel. 0800 652 0202
Availability (sort by: location | date)
Request availability by clicking a date.
Europe / International
Bath
TBA (BA1) 11/10/10 £ 1,150
Prices exc. VAT.  Courses are vendor approved.
Need help? Contact us now.

Also known as: DB2PSQGB

About this class

The course has been designed, to consolidate on the students knowledge of SQL, understand all aspects of EXPLAIN, be aware of efficiency, and to understand the new facilities available up to UDB/390 version 8. The course will contain numerous practical exercises to consolidate the theory.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

IT personnel and developers who have been exposed to using DB2 under z/OS and wish to understand more of the SQL performance and tuning aspects of the product.

What prerequisites are required

Those attending the course should have used DB2 in the past, and preferably attended our DB2 SQL Programming course.

Contents of this class

System architecture

  • DBA
  • EDM pool

Data transfer

Storage

  • Tablespace
  • Global Tables
  • Tables

Log Manager

  • Traces
  • Catalog and History Tables
  • Directory

Advanced SQL

  • Coding efficient SQL
  • Scalar functions
  • DATE/TIME functions
  • Column functions
  • Special registers
  • FETCH only
  • CASE
  • Table joins
  • SUBSELECTS
  • Correlated SUBSELECTS
  • UNIONS
  • Joins
  • Nested tables

Indexes and performance

  • Page
  • Record identifier
  • Indexes
  • Type1/2
  • Splits

Explain & Filter factor

  • Optimizer
  • EXPLAIN

DSN_STATEMNT_TABLE

  • Catalog statistics
  • Single column/ Multiple columns
  • Filter factor

Access paths

  • Single table access
  • Multiple table access
  • Types of access paths

Coding efficient SQL

  • Data Handling
  • Modification of SQL by DB2
  • Coding additional predicates
  • Using indexes
  • Coding efficient Joins
  • SUBQUERIES
  • VIEWS

PLAN analysis

  • Influencing Access Paths

Online Performance Guidelines

  • Coding techniques
  • Efficient Browse
  • Multiple columns indexes
  • Online updates

Batch performance guidelines

  • Locking & Performance
  • Understanding locking
  • Contention
  • Locking in a shared environment
  • Global deadlocks

Packages/Plans

  • Terms/terminology
  • BIND OPTIONS
  • Data structures

Triggers

Stored Procedures
(C) AquinasTraining.co.uk - Contact Us