Home About Courses Schedule Services Webinars Contact Search

IMS Database Performance and Tuning

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor-led. Hands-on workshops.

Price: $1920.00

Course Code: IM1095


Audience

Information Technology professionals (database administrators, system administrators, system programmers, and other technical support personnel) who want a detailed understanding of how to evaluate and improve the performance of their IMS databases.

Description

This course is designed to provide you with the skills necessary to evaluate and improve the performance of your IMS databases (full function and HALDB only). Comprehensive alternatives and their implications on performance are discussed. Classroom exercises plus using your installation examples reinforces the topics presented in the lectures.

Objectives

Upon successful completion of this course, the student will be able to:

  • Analyze and evaluate performance data about your IMS databases
  • Improve performance by a)choosing the best IMS access methods b)tuning your database buffer pools c)tuning the z/OS access methods (VSAM | OSAM) d)selecting the best options for your database implementation e)selecting the best implementation options for your secondary indexes f)selecting the best implementation options for your logical relationships
  • Improve performance of your data sharing environment

Prerequisites

A working knowledge of IMS database implementation as obtained by attending IMS Database Design & Implementation or equivalent on the job; application programming experience is not required.

Topics

  • I. Introduction to IMS DB Tuning Methodology
  • II. Measuring Performance
  • III. Review of IMS Databases
  • IV. What to Bring to Class?
    • HISAM
    • HIDAM/PHIDAM
    • HDAM/PHDAM
    • Secondary indexes
    • Logically related DBDs
    • VSAM / OSAM data set allocations
    • DFSVSAMP and DFSVSMxx with buffer specification
    • LISTCAT for HIDAM and INDEX databases
    • Reports from DB Monitor and/or IMS Monitor
    • Reports for any Pointer Checker product you may have run against #1, #2, and #3 above
  • V. Tuning Buffers
  • VI. Tuning Data Sets
  • VII. Tuning HISAM
  • VIII. Tuning HIDAM/PHIDAM
  • IX. Tuning HDAM/PHDAM
  • X. Tuning Secondary Indexes
  • XI. Tuning Logical Relationships
  • XII. Other Tuning Considerations
  • XIII. Tuning Summary
  • XIV. Daily Schedule
    • Day 1
      • Intro to IMS DB Tuning
      • Measuring Performance
      • Review of HISAM, HIDAM/PHIDAM, HDAM/PHDAM
      • Bring your own DBDs for analysis
    • Day 2
      • Tuning Buffers: VSAM & OSAM
      • Data Set Tuning: VSAM & OSAM
      • Tuning HISAM
      • Tuning HIDAM/PHIDAM
      • Tuning HDAM/PHDAM
    • Day 3
      • Tuning Secondary Indexes
      • Tuning Logical Relationships
      • Other Tuning Considerations
      • Tuning Summary