Overview

Designed and written by highly experienced IMS practicioners, this course teaches how to analyse IMS/DB performance and how to identify potential problems. Attendees will also learn effective tuning techniques that will help them to get the most out of their IMS/DB systems.<br><br>This course is also available 'on demand' (minimum 2 students) for public presentations or for one-company, on-site presentations.
Read more

Prerequisites

Course attendees should have a sound knowledge of IMS at a conceptual level and knowledge of the IMS environment (both batch & online) along with the IMS utilities, Familiarity with z/OS control programs and VSAM is also assumed.
Read more

Delegates will learn how to

  • define a performance strategy
  • identify potential problems
  • understand data sources
  • analyse data
  • predict and evaluate changes.
Read more

Outline

Introduction

A superset view of an IMS online system; Course objectives; Online System Structure; A day in the life of a full function message; Stages of Message Processing; Transaction Log records; Addressing IMS Performance Issues; Why Monitor; Establishing monitoring strategies; z/OS System Information; WorkLoad Manager priorities; Workload Manager settings; Monitoring Tools; VSAM LISTCAT output; Data gathering; Batch executions; DL/I Call Image Trace; Exercise 1.

Online Reporting

Log Transaction Analysis Utility (DFSILTA0); Statistical Analysis Utility (DFSISTS0); DC Monitor Reports; Statistic Log Record Analysis; Online Control Region/DFSPBxxx; IMS key performance indicators; IMS Monitor -Output Sequence and Information; Message Queue Pool Report; Message Format Pool Report; Region Summary Report; Region IWAIT Report; Programs by Region Report; Program Summary Report; Events that can be distributed & their default ranges; Program I/O Report; Transaction Queuing Report; DL/I Call Summary report; Deadlock Analysis Report; PI Trace Record; Program to Program switches.

Database Characteristics

Database performance choices; HISAM; HISAM VSAM Logical Record; Insert Root 4; Insert Root 5; Insert Dependents G22 and D24; HIDAM Indexed Access; HD Storage; Free Space Element; Physical Child First Pointers; Physical Twin Pointers; Physical Child Last Pointers; Pointer Options; (P)HIDAM; HDAM Direct Root Access; HDAM Storage; Randomiser Function; Randomiser Algorithm; Sequential Randomiser; HDAM DBD Parameters; The HDAM Variables; The Randomiser; How big is the RAA?; How many RASP; Randomisation Characteristics; What should Bytes be?; How big is SIZE?; HD free space; What about FRSPC?; HD Data Set Crawl; HD space search algorithm; How do you know well it is set up?; Rules of Thumb; DEDB; DEDB Unit Of Work; DEDB Storage; SDep Storage; Standard FP Buffer Pool specifications; Fld Call; Subset Pointers; Locking; High Speed Sequential Processing; OSAM vs VSAM; Database Buffer Pools; HALDB; HALDB Database; Self healing pointers; HALDB Data Sets; HALDB online reorganisation; Database design for performance.

Application Considerations

Application Design for Performance; Activating DFSSTAT; DFSSTAT VSAM Pool Statistics; DFSSTAT OSAM Pool Statistics; DFSSTAT Sequential Buffering Summary; DFSSTAT Sequential Buffering Page A; DFSSTAT Sequential Buffering Page B; DFSSTAT Sequential Buffering Page C; Exercise 2.

Putting the Factors into Practice

Logging Performance Considerations; Access Method Choices; Block, CI and Record Sizes; DB Monitor Reports; VSAM Buffer (Sub)Pool Statistics; VSAM Statistics; OSAM Buffer Pool Statistics; Program I/O Report; DL/I Call Summary Report; Utilities; HISAM Unload Statistics; HISAM Reload Statistics; HISAM Free Space; HD Unload Statistics; HD Reload Statistics; Image Copy and Recovery Optimisation; IMS - DB2 Subsystem Link; Each Dependent Region...Another DB2; Exploiting ODBA from DB2 Stored Procedures; Parallel Sysplex; Locking with IRLM; Shared SDeps; Resources

Read more

Why choose QA

Frequently asked questions

See all of our FAQs

How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

Learn more about our Virtual Classrooms.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

Learn more about QA’s online courses.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Contact Us

Please contact us for more information