Hi all ... haven't had much time lately so asking a quick query to the Gen community.
We haven't adjusted the TIRTERMA exit for a while (set to option 2). We recently upgraded to DB2 v11 and are getting some positive SQLCODES (not +100) which abend and are harder to track. Should I be customising TIRTERMA to show the SQLCA or is there another exit to show more information from DB2 errors?
Anyone have an skeleton example?
Currently running CICS transactions through the multi-socket listener (CA Gen 8.5 runtimes)
This is what we current get for a positive SQLCODE (negative SQLCODES like -805 are ok)
TIRM030E: APPLICATION FAILED - UPDATES HAVE BEEN BACKED OUT
TIRM031E: FAILING PROCEDURE EXIT DATA FOLLOWS
TIRM032E: LAST OR CURRENT ACTION BLOCK ID = 1984863421
TIRM033E: LAST OR CURRENT ACTION BLOCK NAME = DCGM1852_ACR_MWB_ADT_LIST
TIRM034E: LAST OR CURRENT DATABASE STATEMENT = 0000000128
TIRM035E: CURRENT STATEMENT BEING PROCESSED = 0000000128
TIRM038E: ** FATAL DATABASE ERROR WAS ENCOUNTERED **
TIRM039E: DB LAST STATUS = DB
TIRM046E: *** TRANSACTION PROCESSING TERMINATED RG02
TIRM602E: REMOTE COOPERATIVE PROCESSING WAS ACTIVE
TIRM670E: FROM PROCEDURE STEP RGPSAC02_ACR_LIST
TIRM671E: TO PROCEDURE STEP CI_DPC_FROM_PSTEP
TIRM603E: PRESS ANY KEY TO EXIT
It is my understanding that TIRTERMA should be the exit to be modified
TIRTERMA - Termination User Exit - CA Gen - 8.5 - CA Technologies Documentation
I don't have any examples myself but will check with colleagues.
TIRTERMA is Gen block mode only and TIRTIARX is the corresponding exit for Gen servers
TIRTIARX - DB2 Message Exits - CA Gen - 8.5 - CA Technologies Documentation https://docops.ca.com/ca-gen/8-5/en/reference/user-exits/z-os-user-exits/z-os-blockmode-user-exits-tso/tirtiarx-db2-message-user-exit