IMS/DB Performance Analysis & Tuning Workshop

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.

This course is available for public presentations and for one-company presentations, live over the Internet, via RSM's Virtual Classroom Environment service..

Virtual Classroom Environment dates - click to book!

UK Start Times

20 May 2024

What is a 'Virtual Classroom Environment'?

What do I need?

webcam
headphones with microphone
sufficient bandwidth, at least 1.5 Mb/s in each direction.

What you will learn

On successful completion of this course you will be able to:

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

Who Should Attend

This course is designed for IMS DBAs and System Administrators responsible for IMS performance evaluation & tuning. The course will also benefit z/OS Systems Programmers and Senior Developers working in an IMS environment.

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.

Duration

4 days

Fee (per attendee)

£2350 (ex VAT)

This includes free online 24/7 access to course notes.

Hard copy course notes are available on request from rsmshop@rsm.co.uk

at £50.00 plus carriage per set.

Course Code

DIPT

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 System 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; Application accounting report.

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; ODBA exploitation.

Parallel Sysplex

Parallel Sysplex; Locking with IRLM; SDEP sharing; Shared SDEP Management without QUITCI; Shared SDEP Management with QUITCI; Course summary.