G574 DB2 / CICS Interface

Course Code: G-574
Recommended Duration: 2 Days

Benefits

Students who complete this course will be able to code SQL statements to access DB2 objects in CICS pseudo-conversational programs. The student also learns the performance tradeoffs inherent in specific design alternatives, and how to administer the DB2 / CICS attachment facility.

Audience

Experienced CICS or DB2 application programmers who need to work with DB2 data in CICS, or technical support staff who need to understand the ways in which DB2 and CICS work together.

Prerequisites

The student should have experience in using ISPF/PDF, CICS, DB2, SQL, and SPUFI.

Related IBM Materials

Classroom access to a set of DB2 and CICS Reference manuals is desirable, but not required.

Major Topics Include

Cursors
Pseudo-conversational programming
Units of work
Scrolling data
Updating data
DB2 and CICS logging
Referential integrity issues
Two-phase commit
Application plans
BIND options
Plan exits
Plan maintenance
Threads
DB2CONN, DB2ENTRY, and DB2TRAN definition
DSNC command
Administrative issues
Batch concurrency
DB2 and CICS security
Authorization exits

Exercises

There are four machine exercises and one optional machine exercise.

Course Objectives
Topical Outline
DB2 curriculum
Complete topics list
Home page

Course Description

DB2 / CICS Interface