Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Using COBOL Stored Procedures with JAVA

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Woodehh

New User


Joined: 27 Aug 2010
Posts: 1
Location: Ontario, Canada

PostPosted: Tue Sep 14, 2010 12:20 am    Post subject: Using COBOL Stored Procedures with JAVA
Reply with quote

Hello

I work on a project that uses COBOL Stored Procedures to access DB2 Tables called within JAVA code. The project is in production; however, we have one canned report that retrieves data from 3 tables (not very large mind you, maybe max 20,000 rows for the one table). Anyhow the problem is that this report is hanging and as it turns out this report is now retrieving about 8000 records and as mentioned it is hanging. Now if we change the SQL to retireve say 1000-2000 records it comes back fairly quickly but anything over 2000 hangs the system. Now to solve the problem we just moved the SQL into the JAVA code for a str8 JDBC SQL call and didn;t use the Stored procedure and this solved the problem, now the question is why is the Stored Proc causing this issue or at least the communication between the java and the sp causing this issue. If anyone has experienced this issue and solved the issue or no why this is causing an issue it would be much appreciated

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

rpuhlman

New User


Joined: 11 Jun 2007
Posts: 80
Location: Columbus, Ohio

PostPosted: Fri Sep 17, 2010 12:51 am    Post subject:
Reply with quote

Woodehh,

Odds are the stored procedure has abended on the mainframe side. Your app appears (to you) to be hanging because it is waiting for a return response of some kind and is not receiving anything back. Call your DB2 DBA support team. They should be able to help you.

Rick
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Sep 17, 2010 7:15 pm    Post subject:
Reply with quote

If memeory serves well, we solved it by requesting a dedicated-WLM region for our store-proceudres but ours were IMS-DB2 SP and our SPs were used to run under that WLM. I know, I'm not talking very correctly, from the technical per se. But in the schema we had mentioned about that WLM region. I'll check if I can find some documentation on this.

Hope this helps....
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us