htalogo2.gif

DB2/CICS Interface - Topical Outline

Introduction

Computer Exercise: Course Setup

Application Programming with DB2 in CICS

Program Preparation

Pseudo-conversational programming

SQL cursor review

Logical units of work

Browsing data in CICS

DB2 Cursors and browse logic

CICS temporary storage

Computer Exercise: Compile, Bind and Test a Browse Program

On-line Updating

Major Considerations

Dealing with the Concurrent Update Problem

Global Updates

Cursor Repositioning

Updating Read-only Cursors

Referential Integrity Issues

Update Granularity

Computer Exercise: Compile, Bind, and Test an Update Program

DB2 Logging

Log Contents

Log Processing

CICS Backup and Recovery

Dynamic Transaction Backout

Syncpoint

Two-Phase Commit

Application Plan Strategies

Dynamic Plan Selection

Packages and Plan Maintenance

Computer Exercise: A Multiple DBRM Application Plan

The DB2 / CICS Connection

Threads

DB2 / CICS Communication Protocols

DB2 System Parameters

CICS DB2 Resource Definition – CEDA

DB2CONN

DB2ENTRY

DB2TRAN

The DSNC Transaction

DB2 Commands

Attachment Facility Commands

The CEMT Transaction

Computer Exercise: Using DSNC, CEDA, and CEMT

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

 

These Materials © Copyright 2013 by Hunter Cobb

Materials version: V4.x

 

Course Objectives
Course Description
Home page