IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Calling Stored Proc with out holding GUI users


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 6967
Location: porcelain throne

PostPosted: Mon Nov 03, 2014 7:53 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2590
Location: NYC,USA

PostPosted: Tue Nov 04, 2014 2:54 am
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
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
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: 701
Location: Whitby, ON, Canada

PostPosted: Wed Nov 05, 2014 3:40 am
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2590
Location: NYC,USA

PostPosted: Wed Nov 05, 2014 4:37 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Any examples of calling FTP from REXX? CLIST & REXX 1
No new posts Calling Assembler from REXX PL/I & Assembler 5
No new posts Proc print in Mainframe All Other Mainframe Topics 4
No new posts Calling Rexx program from Cobol CLIST & REXX 12
No new posts use BPXWDYN after calling CEE3DMP for... COBOL Programming 1
Search our Forums:

Back to Top