DB2 Application Performance and Tuning
|
Summary
|
|
|||||||||||
DB2 Application Performance and Tuning
Case Training DB2 Application Performance and Tuning
This course provides advanced DB2 training, and is aimed at staff requiring a detailed knowledge of the issues involved in writing, monitoring and tuning DB2 SQL queries and applications to perform efficiently. In addition, the course covers some wider areas that can affect application performance, such as Cursor Operations, Locking and Referential Integrity.
Suitability and application
The student should be familiar with writing SQL statements SELECT, INSERT, UPDATE and DELETE and should also have a working knowledge of Application Program construction.
Course Details
The course includes the following modules:
- Physical database performance issues
- DML performance review
- Identity columns and sequences
- Programming for performance
- Scrollable cursors
- Locking
- Materialized query tables
- Referential integrity
- Runstats
- Predicate processing
- Optimization
- Access paths
- Tuning
Course Format
Case Training DB2 Application Performance and Tuning
Practical database set-up and SQL explain sessions make up a large part of the course, allowing delegates to demonstrate and reinforce the lectures given. During these sessions the delegate will run many explains on example queries and programs. Delegates are also invited to bring along their own SQL statements to be used as case studies during the course The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course. The course runs in IBM Mainframe
Outcome / Qualification etc.
The course provides information relating to the coding of efficient SQL statements together with the wider issues that affect the performance of DB2 z/OS applications. The major part of the course focuses on ensuring that applications perform well in a production environment. The DB2 Explain facility is used extensively to demonstrate how SQL performance may be monitored and tuned. On completion of this course the student will be able to:
- understand the performance issues involved in constructing a system
- implement an efficient tablespace, table and index design
- understand DB2 locking issues
- choose the correct locking strategy
- design and use Referential Integrity
- design and use Materialized Query Tables
- understand how Cursors are processed
- understand and use Plans and Packages effectively
- understand the importance of RUNSTATS
- understand the process of optimisation
- use optimisation hints
- describe the various access path techniques that DB2 is able to use
- run and understand the Explain Facility
- use Indexable and Stage 1 predicates to write efficient SQL statements
Expenses
£1200 (+VAT)
Case Training
IT Training Courses for professionals from Case Training
Case Training offers both public and onsite professional IT Training.
Public courses are held at various locations. Many are held in London, Edinburgh and Bristol. Both mainframe and non-mainframe courses are available and courses not currently scheduled can be requested.
Onsite training can be held at your site for class sizes from 1 to 10 delegates. Courses may be tailored to incorporate your standards and requirements and fees are as low as £150 per student per day.
Courses that Case Training offer are:
- Computer And Software Education
- Hands-on training courses for IT professionals
- Highly skilled instructors
- Leading supplier of z/OS training including DB2, CICS, IMS, JCL, COBOL, REXX, C & PL1
- Leading supplier of E-Commerce training including Java, HTML, XML and XSLT
Show all courses with
Case Training
Request information - obligation free
Contact information for Case Training
Phone no: + 44 (0) 1275 859666 
To request information from DB2 Application Performance and Tuning, please fill out the following details:
