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

DB2 for LUW Performance and Tuning

DB2UPSQ      Course duration (days): 3
Talk to a Training Advisor
Tel. 0800 652 0202
Availability (sort by: location | date)
Request availability by clicking a date.
England
Somerset
Bath (BA1) 29/09/08 £ 1,150
Prices exc. VAT.  Courses are vendor approved.
Need help? Contact us now.

Also known as: DB2UPSQGB

About this class

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

Who will the lesson benefit?

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.

What prerequisites are required

A reasonable working knowledge of DB2 on the appropriate platform (ie. Linux, UNIX or Windows).

Contents of this class

Introduction to DB2

  • The DB2 family
  • The Big Picture
  • Basic Terms
  • DB2 System Catalog
  • Attributes
  • Consolidation of DDL with regard to efficiency up to and including DB2 9
  • Consolidation of operating system commands including db2look
  • Practical Exercise

Indexing

  • Cluster Ratio
  • Effect on sorting
  • MDC
  • Design Advisor
  • Practical Exercises

Volatile

  • RUNSTATS
  • REORG
  • Access Strategies
  • Practical Exercise

Explain

  • Visual Explain
  • Practical Exercise

Complex SQL with regard to efficiency

  • Table joins
  • EQ JOIN
  • SUBSELECT
  • CORRELATED SUBSELECT
  • UNION
  • Practical exercise

Left/Right/Full Joins

  • In Line Tables
  • CASE
  • Remainder of DML statements
  • UPDATE/DELETE/INSERT/MERGE
  • CTE's
  • Embedded SQL
  • Static and Dynamic SQL
  • Cursors
  • Development cycle
  • Precompile
  • DBRMs
  • BIND
  • PLANS/PACKAGES
  • Execution of executable program
  • Block Fetches

TRIGGERS

  • STORED PROCEDURES
  • Utilities
  • BACKUP
  • RESTORE
  • LOAD
  • IMPORT/EXPORT
  • Introduction to Automatic Computing
  • Configuration Parameters
  • Collecting Catalog Statistics
  • Activity Monitor
  • Memory Visualization
  • Health Center
  • Remote Administration
  • DB2 Administration Server
  • Configuration Assistant
  • Instance Attachment
  • Connection
(C) AquinasTraining.co.uk - Contact Us