IBM DB2: Performance and Tuning for LUW (Linux, Unix, Windows)

Show more IBM Training Courses

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.

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

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.

Examination details

This course will prepare you for the following exams and certification tracks shown. Please note that the exam may not be included in the price shown: please contact us to check.

IBM® Certification Tracks  »
    IBM® Exams  »
       Path 2 (IBM® Certified Advanced Database Administrator : DB2 9 for Linux® UNIX and Windows)
       Path 1 (IBM® Certified Advanced Database Administrator : DB2 9 for Linux® UNIX and Windows)
       Exam 734: DB2 9 Advanced Database Administrator for Linux® UNIX and Windows
       Path 1 (IBM® Certified Advanced Database Administrator : DB2 9 for Linux® UNIX and Windows)
       Path 2 (IBM® Certified Advanced Database Administrator : DB2 9 for Linux® UNIX and Windows)
       Path 1 (IBM® Certified Advanced Database Administrator - DB2 9 for Linux® UNIX and Windows)  »
          Exam 734: DB2 9 Advanced Database Administrator for Linux® UNIX and Windows
       Path 2 (IBM® Certified Advanced Database Administrator - DB2 9 for Linux® UNIX and Windows)  »
          Exam 734: DB2 9 Advanced Database Administrator for Linux® UNIX and Windows

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
• The Governor and Audit

IBM DB2: Performance and Tuning for LUW (Linux, Unix, Windows) / DB2UPSQ (DB2UPSQGB)

(C) AquinasTraining.co.uk - Contact Us