DB2 / CICS Interface

Course Number:  611-TF
Recommended Duration:  2 days

Intended 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.

Course Overview
This course presents the details of establishing and maintaining connections between CICS (a common teleprocessing monitor) and DB2.  The course includes a discussion of the interaction between data base access and pseudo-conversation programming techniques.  This course has recently been updated to reflect changes in the products.

Objectives
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.

Prerequisites
The student entering this course should have experience in using TSO/ISPF, CICS, DB2, SQL, and SPUFI.

Topics

• 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