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
 

 

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 XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm


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