Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 2269
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: 684
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: 2269
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 User key common area users - How to r... vasanthz All Other Mainframe Topics 0 Thu Oct 10, 2019 1:17 am
No new posts proc step return code to override in ... Aaryaa JCL & VSAM 3 Tue Aug 20, 2019 4:32 pm
No new posts How to DEBUG DB2 Stored Procedures Us... thesumitk DB2 0 Mon Jun 03, 2019 8:26 pm
No new posts Regarding mroe data to be processed i... vinu78 DB2 3 Mon May 27, 2019 7:31 pm
No new posts Can we pass cobol pointer to cobol-db... rohanthengal DB2 4 Tue Mar 19, 2019 1:04 pm

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