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.
IMS/DB Performance Analysis & Tuning Workshop
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.
- define a performance strategy
- identify potential problems
- understand data sources
- analyse data
- predict and evaluate changes.
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
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
We have 1 courses available across 1 locations on 1 different dates
EastCall us on 0113 220 7150 to discuss availability in this region.Contact us
LondonCall us on 0113 220 7150 to discuss availability in this region.Contact us
MidlandsCall us on 0113 220 7150 to discuss availability in this region.Contact us
NorthCall us on 0113 220 7150 to discuss availability in this region.Contact us
ScotlandCall us on 0113 220 7150 to discuss availability in this region.Contact us
South1 Location / 1 courseView dates
Attend from AnywhereCall us on 0113 220 7150 to discuss availability in this region.Contact us
All locations1 Location / 1 courseView dates
Fully accredited to ensure we provide the highest possible standards in learning