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: 6968
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: 1788
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: 658
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: 1788
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 LIBDEF not working in called proc packerm CLIST & REXX 0 Fri Sep 15, 2017 7:22 pm
No new posts Calling CLIST through job and REXX Sahasra K CLIST & REXX 19 Tue Aug 01, 2017 10:25 am
No new posts REXX to view the PGM or PROC jackzhang75 CLIST & REXX 11 Tue Jun 20, 2017 1:20 am
No new posts Jcl pram vs proc parms ashek15 JCL & VSAM 3 Thu Mar 30, 2017 6:50 pm
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm

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