CA Gen

Expand all | Collapse all

Exit for displaying SQLCA on abend (zOS)

Jump to Best Answer
  • 1.  Exit for displaying SQLCA on abend (zOS)

    Posted 06-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)

    Posted 06-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

    Posted 06-07-2016 11:48 PM