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
This topic is locked: you cannot edit posts or make replies. Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
This topic is locked: you cannot edit posts or make replies. COBOL Software Development Lead at Fi... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:21 am
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm


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