DB2 / CICS Interface - Topical Outline

Introduction

Application Programming with DB2 in CICS
   Cursors
   Pseudo-conversational programming
   Unit of work / COMMIT / SYNCPOINT

Scrolling data
   Temporary storage
   Front-end intensive cursors

       Computer Exercise Program: Compile and Bind of Browse Program

Updating data
   Update techniques
   Cursors ... where current of ... and CICS pseudo-conversational
   Logging - CICS and DB2
   Referential integrity issues
   Two phase commit

       Computer Exercise Program: Compile and Bind of Update Program

Application plans and packages
   Plan strategies
   Packages
   Bind options - allocate, release, isolation
   Plan exits
   Combinations of strategies
   Plan maintenance

       Computer Exercise: Creation of Multiple DBRM Plan

The CICS-DB2 protocol
   Threads
   DB2 system parameters

CEDA and CEMT for DB2 Resources
    DB2CONN
    DB2ENTRY
    DB2TRAN
Resource Control Table
DSNC Command

   Computer Exercise: Using DSNC Commands

Administrative issues
   Operations
   Monitoring
   Problem detection/resolution
   Installing new versions of
        system software
        application software
   Security
   Network control/help desks

Concurrency with batch
   Bind parameters
   Commit frequency
   Scheduling
   Backup concerns

DB2 and CICS Security
   CICS security
   Plan security
   Table security
   Authorization Ids and exits

   Optional Computer Exercise: CICS Security

Course information: G-574 / 2 Days   These Materials © Copyright 2007 by Hunter Cobb     V4.x

Course Objectives
Course description
Home page

this page last updated: 08 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.