Db2 for z/OS: Monitoring & Tuning Applications' Performance Training in New Zealand

  • Learn via: Classroom
  • Duration: 3 Days
  • Price: From €2,405+VAT
We can host this training at your preferred location. Contact us!

This course examines and explains the critical factors that affect Db2 for z/OS performance. The teaching of the effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course.<br>This course is appropriate for Db2 for z/OS environments up to and including Db2 11 for z/OS.<br><br>This course is also available for one-company, on-site presentations and for live presentation over the Internet, via the Virtual Classroom Environment service.

A sound understanding of Db2 and z/OS concepts is required.

  • plan for application monitoring and tuning
  • identify database design factors that affect performance
  • identify application design factors that affect performance
  • use EXPLAIN as a first step towards performance tuning
  • use Db2 traces to identify problem areas and identify tuning opportunities.

Performance Overview

What is 'performance'?; Performance objectives; Workload categories; Service Level Agreements; Performance factors; System parameters; EDM pool size; Buffer pool sizes; Bufferpool thresholds; Bufferpool development; Database design factors; Application design factors; Db2 traces.

Db2 Traces

Trace types; Trace destination; Accounting trace classes; Audit trace classes; Statistics trace classes; Performance trace classes; Monitor trace classes; Global trace classes; IFCID types; Other trace options; Controlling traces.

Db2 Optimizer & Access Path Selection

Db2 optimiser; Access path selection; Access paths - index usage; Access paths - direct row access; Access paths - matching index access; Access paths - non-matching index access; Access paths - table(space) scan; Input to the optimiser; Filter factors; Filter factor and: clustering, column cardinality, column correlation, column distribution; Influencing the optimiser; Influencing the optimiser: manually adjusting statistics, using optimisation hints, modelling production values; Catalog statistics; Updating catalog statistics using RUNSTATS; Statistics columns; RUNSTATS examples.

Db2 EXPLAIN

EXPLAIN; PLAN_TABLE; DSN_STATEMNT_TABLE; DSN_FUNCTION_TABLE; EXPLAIN examples: Access paths, Multi-index access, Nested queries.

Database Design Factors

Normalisation forms; De-normalisation considerations; Table creation; Null attributes; Variable length columns; Column considerations; Constraint and domain management; Tablespace considerations; Space allocation and free space; Work file considerations; Data set placement; Index structure; Creating indexes; When and when not to index; Indexes and clustering; non-key columns in unique indexes; Composite keys; Reorganising indexes.

Application Design Factors

Predicates; Access paths; Indexable and non-indexable predicates; SQL statement processing; Stage 1 and stage 2 predicates; Summary of predicate processing; Predicate evaluation sequence; Sequential prefetch; List prefetch; Index lookaside; Joins; Join transformation; Join method; Subqueries; Non-correlated vs. correlated subqueries; UNION; Case expressions; Union and case performance; Table expressions; Temporary tables; Table comparisons.

Locking & Concurrency

Locking overview; Reasons for locking; Lock compatibility - row and page locks; Lock compatibility - table and tablespace locks; Bind - ACQUIRE and RELEASE parameters; Bind - ISOLATION and CURRENTDATA parameters; Lock avoidance; Accessing currently committed data; Locking and concurrency recommendations.

Application Programs versus Db2 Utilities

Loading data; Online LOAD; Deleting data; Unloading data using the REORG utility; Unloading data using the UNLOAD utility; UNLOAD utility restrictions; Dynamic SQL in utility statements.

Monitoring Application Performance

Monitoring overview; Db2 Performance Expert; Db2PE reports and traces; accounting short report; accounting long report; time distribution reports; times, suspensions & highlights report; SQL activity report; dynamic SQL caching report; other processing activity report; locking activity report; parallelism report; buffer pool and group buffer pool activity reports; statistics long report.

Performance Analysis

EXPLAIN information; Db2PM reports; short accounting reports; long accounting reports; report usage summary; a general approach to problem analysis in Db2.



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
02 September 2024
Auckland, Wellington, Christchurch
3 Days
Classroom / Virtual Classroom
09 September 2024
Auckland, Wellington, Christchurch
€2,405 +VAT Book Now
Classroom / Virtual Classroom
14 September 2024
Auckland, Wellington, Christchurch
3 Days
Classroom / Virtual Classroom
18 September 2024
Auckland, Wellington, Christchurch
3 Days
Classroom / Virtual Classroom
27 September 2024
Auckland, Wellington, Christchurch
3 Days
Classroom / Virtual Classroom
13 October 2024
Auckland, Wellington, Christchurch
3 Days
Classroom / Virtual Classroom
08 November 2024
Auckland, Wellington, Christchurch
3 Days
Classroom / Virtual Classroom
10 November 2024
Auckland, Wellington, Christchurch
3 Days
Db2 for z/OS: Monitoring & Tuning Applications' Performance Training Course in New Zealand

New Zealand is an island country in the southwestern Pacific Ocean and it consists of two main islands and 700 smaller islands. Two main islands are the North Island and the South Island. The capital city of New Zealand is Wellington and the most popular city of the island country is Auckland. English, Māori and New Zealand Sign Language are the official languages of New Zealand. As of January 2022, the population of the country is about 5,138,120. 70% of the population are of European descent, 16.5% are indigenous Māori, 15.1% Asian and 8.1% non-Māori Pacific Islanders.

Since most of the country lies close to the coast, mild temperatures are observed year-round. January and February are the warmest months while July is the coldest month of the year. Fiordland, the first national park of New Zealand Tongariro

Unlock your potential in IT through our extensive selection of courses, which include programming, software development, data science, business skills, and cybersecurity. Our adept instructors will provide you with hands-on training and practical perspectives, all conveniently hosted at your desired location within New Zealand.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.