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
 

 

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: 73
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: 6966
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: 1610
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: 73
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: 73
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: 641
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: 1610
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 Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts "DFSRRC00 vs IKJEFT01" for ... arunsoods All Other Mainframe Topics 5 Fri Aug 12, 2016 9:54 pm
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm


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