how to see abended transactions in spool

vardhan0007 · Posted: Thu Aug 09, 2007 11:44 pm

Hi,

Can anyone tell me how to see the unsuccessful/abended transactions for a particular program.

Iam getting some feilds from java application to one of my CICS program it will take the values from java ppliaction and CICS program will insert those values into db2 table. Here we are getting some error from db2. So i want to see the transaction or actual record on spool which is getting error while inserting.

Please advice.

Thanks,
Harsha

dick scherrer · Posted: Fri Aug 10, 2007 12:19 am

Hello,

If the info is being presented by a CICS application, you need to look in the sysouts for the CICS environment where the transaction ran. One place to look would be MSGUSR, but looking at the other sysouts for that CICS may be helpful as well.

Many organizations have a common routine to log errors by inserting info into a db2 "error" table so that they can be later reviewed. You might ask if your site uses a common table to log such errors in addition to whatever you find in the CICS jes output.

vardhan0007 · Posted: Fri Aug 10, 2007 12:40 am

Hi Dick,

Thank you for reply.

We dont have any error table. And also I am not aware how to see the MSGUSR. As it is an online program , when ever a member tryies to register to site the information is passed to CICS program from some mercator calls or from java application. Then CICS will insert those member details to db2 tables. But here we are getting some exception while inserting the record and we are setting the return code to 901
( which is an 88 lever variable in the code ).

Please advice.

Thanks,
Harsha.

dick scherrer · Posted: Fri Aug 10, 2007 1:14 am

Hello,

Go into SDSF and display the CICS job that processed your problem transaction. One of the sysout datasets should look something like "CICSA1.CICS.MSGUSR" - you want to look for the MSGUSR dataset. You may find info in other sysout datasets as well.

Earl · Posted: Sun Aug 12, 2007 9:03 am

I'm assuming your java application is a client application invoking CICS program.

why not run through debugger software, intertest, xpeditor ?

you could also try using IBM's CEDX for debug.
OR
temp change the CICS application. If its returning you a DB2 error code, then it should be able to return you the data record it failed to insert.

ALso, there is an expensive little product called CICSNotify/Abend Email,

it can intercept CICS program abends and deliver an email
message to designated recipients, if/when the abend occurs,

go to Use [URL] BBCode for External Links >>> cics tools >> other

and no, I don't work for the vendor.