Home About Courses Schedule Services Webinars Contact Search

Xpediter for Db2


Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: XP1010


COBOL Db2 application developers, mainframe support staff, and systems programmers.


Xpediter is designed for programmers who want assistance in discovering the cause of an abend, a loop or logic error in a program. This course covers how to use Xpediter to debug batch Db2 COBOL programs in TSO. The student will use Xpediter to follow the logic of a program, look at the contents of a field, watch how it changes as the program executes, and change a field’s contents to see the effect. In addition the student learns how to alter program logic, trap and recover from program errors, set statement execution counts and resume execution from any point in the program. This course focuses on the specific setup and debug ging required by Db2 batch COBOL programs.XPEDITER is a debugging and abend intercept tool that runs interactively in full screen mode as well as in a batch environment. You will learn to interactively allocate files, maintain multiple test profiles, interrupt and restart execution at any point, trace logic flow, bypass undesired program code, and monitor, display and modify program variable contents. You will be able to temporarily insert XPEDITER/TSO debugging statements, and view the log that XPEDITER maintains of all user activity during test sessions.This course uses programs with a variety of typical abend and logic errors to illustrate each command. Students debug a variety of actual abends and program failures in this extensively hands-on course. This course is a prerequisite to our XPEDITER/CICS course.

SETUP: Site must have TSO logons with XPEDITER/TSO installed. Each student needs a PC or terminal with mainframe access. Access to Db2 from TSO must be available. Each student needs a TSO logon, package for Db2, and access to the Db2 sample tables: EMP and DEPT.OVERVIEW OF TOPICS:• General overview of Xpediter• Creating the test environment• Setup: Allocating libraries, creating FLISTs for I/O• Compiling with Xpediter• Setting break points• Accessing and modifying data, including table entries• Controlling execution, intercepting abends• Db2 debugging tips• Static and dynamically linked subprograms• Debugging approaches


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

  • Setup the environment needed debug
  • COBOL Db2.batch programs in the XPEDITER/TSO environment.
  • Define and create DDIO files and test profiles.
  • Compile and link Db2 programs for testing in XPEDITER/TSO.
  • Create and maintain file allocation lists, user profiles, and test scripts.
  • Setup a basic test session.
  • Trap and recover from program errors.
  • Effectively use the primary and line commands to debug programs, including setting breakpoints, examining and modifying data, counting execution of lines, altering execution logic, resume execution, etc.
  • Access the log and script files.


Knowledge of COBOL and Db2 Programming, TSO, and basic JCL.


  • I. Primary Option Menu
  • II. Defaults (Option Ø)
    • Defaults Primary Menu
    • Terminal Characteristics
    • PF Key Definitions
    • User Profiles
    • ISPF Color Defaults
    • Source Color Defaults
    • Other Defaults
  • III. Utilities (Option 5)
    • Utilities Primary Menu
    • Region Size Message
    • List Allocates Screen
    • DDIO File Facility
      • DDIO Create/Format Facility
      • DDIO Create/Format Setup
      • DDIO Options Facility Screen
  • IV. Prepare (Option 1)
    • Highlights of COBOL Versus COBOL/Db2 Batch Setup
    • Program Preparation Menu
    • Convert Compile JCL
      • Compile JCL Before Conversion
      • Compile JCL After Conversion
    • Precompile/Compile Facility
      • General Settings
      • Db2 Precompile Setup, Db2 DSNLOAD Libs
      • Compile Setup
      • Linkedit Setup
    • Bind Facility
      • DBRM Libraries Screen
    • Edit Allocation List
  • V. TSO (Option 2)
    • Standard Test Screen
    • Session Setup Screen
      • Environments Menu Screen
      • Load Module Library Override Screen
      • DDIO Files Override Screen
      • Test Script Library Override Screen
      • Log Dataset Override Screen
      • Log Dataset Disposition Screen
      • DSN Load Library Override Screen
    • Allocate Test Session Files
      • Copy File Allocation or JCL
      • Allocate from JCL
      • Select DD Name Results
      • Save Life Allocation List
      • Space and Catalog Allocation
      • DCB Parameter Allocation
      • File Parameters Menu
      • Dataset Allocation Parms
      • Dataset DCB Parameters
      • Sysout Parameters
  • VI. Entering a Debugging Session
    • Entering a Test Session
    • After a Test has Completed
    • Returning From a Test Session
      • Log Dataset Browse Screen
      • Log Dataset Disposition Screen
      • Test Script Dataset Edit Screen
      • Script Dataset Disposition Screen
  • VII. Break Point and Logic Commands
    • BEFORE
    • AFTER
    • WHEN
    • COUNT
    • GO
    • SKIP
    • TRACE
    • RETEST
  • VIII. Inserting Instructions
    • INSERT
    • PAUSE
    • GOTO
  • IX. Program Variable Commands
    • Monitoring and Altering Data
    • SET KEEP
    • KEEP
    • KEEPE
    • KEEPH
    • PEEK
    • PEEKE
    • PEEKH
    • MOVE
  • X. UTILITY Commands
    • HELP
    • LOG
    • SET
    • SHOW
    • TSO
  • XI. Scripts
    • Designing and Writing Scripts
    • Typical Script Uses
  • XII. Summary
    • Steps to Solve an Abend or Program Failure
    • Handling Different Types of Abends
    • Use to Log to Remember What you Did