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
 

 

Db2 - 803

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

New User


Joined: 30 Apr 2014
Posts: 6
Location: USA

PostPosted: Thu May 01, 2014 12:20 am    Post subject: Db2 - 803
Reply with quote

I have a COBOL DB2 stored procedure XYZ to insert records into tables P (parent), C1 (child1) and C2 (child2). P has unique key index on seq_num_p. XYZ doesnt do a commit or rollback after inserts and expects the calling process to do it.

I have a batch cobol program ABC that reads an input file and for each record read it call XYZ. When I execute ABC thru a regular job, it abends with -803 on table P. But when I execute ABC thru xpediter, it doesnt abend and executes successfully.

I have a CICS cobol program EFG which calls XYZ for 1 record at a time (per transacation). This works fine too and no issues are encountered.

Could anyone, help me understand why I get a -803 when XYZ is called multiple times. The input file doesnt have any duplicates or any of that sort.

Thanks, Gopi
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1753
Location: Bloomington, IL

PostPosted: Thu May 01, 2014 1:17 am    Post subject:
Reply with quote

Make sure that the package(s) for your batch plan are bound to the same table(s) as for CICS and XPEDITOR.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1653
Location: NY,USA

PostPosted: Thu May 01, 2014 1:00 pm    Post subject:
Reply with quote

check the schema qualifiers
Back to top
View user's profile Send private message
kinatingopi

New User


Joined: 30 Apr 2014
Posts: 6
Location: USA

PostPosted: Sat May 03, 2014 2:34 am    Post subject:
Reply with quote

Thank you. It was a coding issue which was fixed.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:



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