Q
Problem solve Get help with specific problems with your technologies, process and projects.

If I am executing a CICS program which calls DB2 SPs in a WLM environment, can CICS and the SPs join

If you are running CICS TS and DB2 (SPs via WLM) transaction management under RRS, are UOW commands in both languages...

equivalent as far as CICS SYNCPOINT ROLLBACK or COMMIT and DB2 ROLLBACK or COMMIT?

In other words, if I am executing a CICS program which calls DB2 SPs in a WLM environment, can CICS and the SPs jointly control the UOW?


If a CICS transaction calls a DB2 stored procedure the stored procedure is not allowed to issue a ROLLBACK or COMMIT. There is a master-slave relationship between the CICS transaction and the DB2 stored procedure. The CICS transaction determines when the Unit of Work is to be committed or rolled back. In this scenario if a DB2 stored procedure issues a COMMIT or ROLLBACK a negative SQL response code is returned to the invoking CICS program which is expected to issue an EXEC CICS SYNCPOINT ROLLBACK command.


This was last published in July 2002

Dig Deeper on IBM system z and mainframe systems

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close