Course Description

DB2 / CICS Interface

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

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 entering this course should have experience in using TSO/ISPF, CICS, DB2, SQL, and SPUFI.

Related IBM Materials

Classroom access to a set of DB2 reference manuals is desirable, but not essential.

• 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 paper exercise.