Gen EDGE

 View Only

  • 1.  Exit for displaying SQLCA on abend (zOS)

    Posted Jun 07, 2016 07:24 PM

    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

     

     

    thanks heaps!!



  • 2.  Re: Exit for displaying SQLCA on abend (zOS)

    Broadcom Employee
    Posted Jun 07, 2016 10:36 PM

    Hi Aldred,

    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.

     

    Regards,

     

    Lynn



  • 3.  Re: Exit for displaying SQLCA on abend (zOS)
    Best Answer

    Broadcom Employee
    Posted Jun 07, 2016 11:48 PM

    Hi Aldred,

    CORRECTION:

    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

     

    Regards,

     

    Lynn