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