Synchronizing Resources for Non-2PC Applications - IBM CICS Interface for Teradata

IBM CICS Interface for Teradata® Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
IBM CICS Interface for Teradata
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
nmw1695364801820.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
axu1470436513048
Product Category
Teradata Tools and Utilities

Often CICS and database resources need to be synchronized.

When they do, the applications programmer must use appropriate CICS facilities to synchronize updating multiple recoverable resources.

It is the application programmer’s responsibility to coordinate these updates.

Synchronization of these resources requires separate commands to CICS and to the database as follows:
  • Whenever a program changes a database and modifies CICS resources for recovery.
  • When a program changes a database and specifies Dynamic Transaction Backout (DTB=YES).

Under these conditions, Teradata SQL statements to commit or roll back resources may be required.

Use the following CICS commands with the Teradata SQL statements to synchronize database resources:

CICS Command Description
EXEC CICS RETURN Triggers a CICS synchronization point
EXEC CICS SYNCPOINT Triggers CICS to commit all changes completed to this point; insert at each logical completion point in the application
EXEC CICS SYNCPOINT ROLLBACK Backs out all changes to this point (use in case of error)
EXEC CICS ABEND Terminates program execution