Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to see abended transactions in spool

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
vardhan0007

New User


Joined: 05 Jun 2006
Posts: 51
Location: Bangalore,India

PostPosted: Thu Aug 09, 2007 11:44 pm    Post subject: how to see abended transactions in spool
Reply with quote

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
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 10, 2007 12:19 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
vardhan0007

New User


Joined: 05 Jun 2006
Posts: 51
Location: Bangalore,India

PostPosted: Fri Aug 10, 2007 12:40 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 10, 2007 1:14 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Earl

Active User


Joined: 17 Jun 2007
Posts: 148
Location: oklahoma

PostPosted: Sun Aug 12, 2007 9:03 am    Post subject:
Reply with quote

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 www.pcs305.com >>> cics tools >> other

and no, I don't work for the vendor.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDMS DC027007 T58 TASK:ADS2 PROG:ADSO... gpowell382 IDMS/ADSO 2 Fri Jun 30, 2017 11:52 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts REXX cdoe to purge a JOB from spool a... Sulabh Agrawal CLIST & REXX 11 Thu Mar 09, 2017 11:36 am
No new posts CICS SOCKET shared between two transa... akont CICS 3 Mon Jun 27, 2016 1:27 pm
No new posts Report output in Spool amitc23 JCL & VSAM 4 Tue Apr 26, 2016 4:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us