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
 
Calling Stored Proc with out holding GUI users

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

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Mon Nov 03, 2014 7:20 pm    Post subject: Calling Stored Proc with out holding GUI users
Reply with quote

Hello Everyone,

Can any one, please throw some light on the following?

There is a requirement in which GUI will call SP but should not wait until SP is executed as SP will run for an hour. SP will update the output in the tables directly and that users can see it later. But, users should not be hold back until SP runs. Is there a way to run SP without holding back GUI users?

Thanks in advance for your help.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Mon Nov 03, 2014 7:53 pm    Post subject:
Reply with quote

Quote:
will call SP


therein lies your problem. a CALL or LINK ALWAYS keeps the connection open.

you need to start a task to run the sp inorder to release your GUI/user.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Tue Nov 04, 2014 2:54 am    Post subject:
Reply with quote

Quote:
SP will run for an hour.


Thats too much , how at first place this design is approved by you DBA?
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Tue Nov 04, 2014 9:49 am    Post subject: Reply to: Calling Stored Proc with out holding GUI users
Reply with quote

Quote:
Thats too much , how at first place this design is approved by you DBA?


The module is complex and performs numerous calculations. Btw, that's the average time. It can run from 1-120 mins based on the amount of input from users. That's the reason, we are checking whether users can be disconnected from the process, so that they can navigate to other tasks. [/quote]
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Tue Nov 04, 2014 9:51 am    Post subject: Reply to: Calling Stored Proc with out holding GUI users
Reply with quote

Quote:
you need to start a task to run the sp inorder to release your GUI/user.


Thanks for your input. We do checking other options. Pls let us know if you come across any other ideas.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 671
Location: Whitby, ON, Canada

PostPosted: Wed Nov 05, 2014 3:40 am    Post subject:
Reply with quote

120 minutes? The GUI user might as well be submitting a batch job. icon_smile.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Wed Nov 05, 2014 4:37 am    Post subject:
Reply with quote

Why don't you trigger a batch job instead of a SP?
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:

Similar Topics
Topic Author Forum Replies Posted
No new posts SAS Webinar - PROC REPORT: Getting St... vasanthz All Other Mainframe Topics 0 Wed Jan 30, 2019 11:38 pm
No new posts Array in Cobol Db2 Stored Procedure Ashishpanpaliya DB2 4 Wed Jan 09, 2019 3:06 pm
No new posts calling java code(on mainframe from c... elixir1986 COBOL Programming 1 Fri Nov 30, 2018 1:57 am
No new posts Need advise in calling DFSORT from REXX ajithajt CLIST & REXX 9 Thu Nov 29, 2018 10:50 am
No new posts Calling and updating SAS Macro variab... Yogesh Jaiswal All Other Mainframe Topics 7 Thu Oct 11, 2018 12:37 pm

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