SYNCPOINT ROLLBACK vs EXEC SQL ROLLBACK in CICS

Updating 3 DB2 tables in one CICS transaction. Spec says if any insert fails, undo all three.

I put EXEC SQL ROLLBACK in the error para and got weird abends. Someone on the team said use EXEC CICS SYNCPOINT ROLLBACK instead.

Is SQL ROLLBACK just wrong under CICS attach?

Under CICS, use CICS SYNCPOINT / SYNCPOINT ROLLBACK for the LUW. Do not issue DB2 COMMIT/ROLLBACK yourself. CICS owns the unit of work with the attachment.

And issue a successful SYNCPOINT between logical groups if you only want the last group rolled back. Easy to undo more than you meant.

Switched to SYNCPOINT ROLLBACK. Error path behaves. Leaving this here so I remember.