Book your CV96GB DB2 9 for z/OS Application Performance and Tuning Training Course
This five day course is being run one times on Monday 21st of May 2012 in London,
Book this course with us today from as little as £2,000.00 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
See all courses by the manufacturer IBMSee all courses provided by IBM
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Monday 21 May 2012 | London |  | £2,000.00+VAT |
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineSummary:
This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications.
CV96 was previously known as CF96. CV96 is an updated and enhanced version of CF96.
PreRequisites:
Familiarity with DB2 application programming
Audience:
- DB2 for z/OS application developers
- DB2 for z/OS DBAs
Objectives:
After completing this course, you should be able to:
- Design better indexes
- Determine how to live with the optimizer (avoid pitfalls, help when necessary)
- Avoid locking problems
- Use accounting traces to find significant performance problems in an operational application
Overview of application performance issues and performance management methods
Towards better indexes
- From data model to database version 0
- Detecting inadequate indexing with VQUBE
- Three-star index: deriving the best possible index for a SELECT
- Estimating the cost of an index
- Restrictions and limitations
Towards better tables
- Clustering
- Denormalization
Learning to live with the optimizer
- Predicting index matching and screening
- Indexable predicates
- Boolean term predicates
- REOPT(ALWAYS) and the alternatives
- Joins
- Subqueries
- Union, Except, Intersect
Unpredictable transactions
- Unpredictable predicates
- Many criteria, few provided
- Star join
- Materialized query tables (MQTs)
Massive batch
- Random disk I/O
- Estimating and minimizing disk I/O time
- Manual and automatic parallelism
- Massive deletes
CPU time estimates
- Worksheet for rough CPU time estimates
Preventing long lock waits
- Lock life cycle
- Recommendations
Tuning operational applications
- Analyzing slow transactions with accounting traces
- Detecting inadequate indexing
- Detecting optimizer problems
- Detecting long lock waits
- Detecting tables which should be denormalized
Optimizer Service Center (OSC) and Optimizer Expert (OE)
Description:
This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications. CV96 was previously known as CF96. CV96 is an updated and enhanced version of CF96.
IBM
IBM Training Courses offer comprehensive training designed for individuals, companies and public organisations. IBM courses are worldwide so delegates don’t have to travel far to get the training they require.
IBM training courses are both dynamic and exciting, concentrating on theoretical and practical management training to help delegates meet their objectives and goals. With IBM courses being available worldwide delegates don’t have to travel far to get the training they require.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.