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

IBM CICS Interface for Teradata® Reference

prodname
IBM CICS Interface for Teradata
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2448-220K

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