Home About Courses Schedule Services Webinars Contact Search

IMS with Db2

SEE SCHEDULE

Duration: 2.0 days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: IM2020


Audience

Application personnel, DBAs, support staff or any personnel working in the IMS-Db2 environment.

Description

This course is designed for application programmers and support staff requiring a detailed understanding of the use of Db2 with IMS applications.

Objectives

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

  • Design IMS applications using Db2 resources
  • Code and test IMS applications using Db2 resources
  • Implement recovery for IMS applications using Db2 resources
  • Utilize the Db2 catalog for problem resolution and information gathering
  • Use Db2 facilities to monitor and improve Db2 performance

Prerequisites

COBOL, TSO, MVS JCL, working knowledge of IMS, working knowledge of Db2, SQL and SPUFI.

Topics

  • I. Synchronization and Commit Processing
  • II. Coding for Improved Performance
  • III. PSB, Package and Plan Use
  • IV. Scrolling/Paging through Tables
  • V. BMP, MPP, IFP and IMS Batch Processing with Db2
  • VI. Enqueue and Deadlock
  • VII. Issuing Db2 Operator Commands
  • VIII. Checkpoint/Restart
  • IX. Db2 Attachment and Thread Usage
  • X. Db2 Catalog Tables
  • XI. Use of Runstats, EXPLAIN and the Accounting Trace