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
 
Controling execution of stored procedur on particular LPAR

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

New User


Joined: 14 Oct 2010
Posts: 13
Location: pune

PostPosted: Sat Jul 21, 2012 10:12 am    Post subject: Controling execution of stored procedur on particular LPAR
Reply with quote

Hi,

I wanted to know, whether it is possible or is there any way to control the execution of DB2 Stored Procedure on particular LPAR of mainframes ??

Thanks in advance !!
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jul 21, 2012 10:35 am    Post subject:
Reply with quote

Hello,

Suggest you provide some detail about what you are trying to accomplish (rather than asking about some way to do it).
Back to top
View user's profile Send private message
seema_285

New User


Joined: 14 Oct 2010
Posts: 13
Location: pune

PostPosted: Sat Jul 21, 2012 10:55 am    Post subject: Reply to: Controling execution of stored procedur on particu
Reply with quote

Hi ,

I am invoking a Stored Procedure(SP) which in turn putting the request in message queue (MQ).

In my SP I am fetching Queue manager name based on LPAR name under which SP is executing at run time.
There are total four LPARs lets say L1, L2, L3 and L4. All these LPAR have Q manager M1, M2, M3 and M4 respectively asscociated with them.

The Q-manager M4 of L4 is not used in our application. To integrate the M4 for our application will is going to be additional work effort like
to create channels on M4 Queue Manager, Turnover Meeting wit IBM etc which are so time consuming and we have strict time lines to rollout this change.

So, there is possibility of this SP getting executed under L4 then MQ messages will be routed to M4 which will get failed with 2058 error.

So, I wanted to know, whether is it possible to control the execution of stored Procedure on particular LPAR ? Can we define some parameters in stored procedure definition ??

Any help / reference will be highly appreciated.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jul 22, 2012 1:37 am    Post subject:
Reply with quote

Hello,

So this isn't really about usng a Stored Procedure on another lpar, but is about how to process messages queued to L4/M4?

Suggest you talk with someone experienced using MQ (i'm not), but i believe there is a way for an arrival to cause activity on the system where the message was received. I wouldn't think it had to be an 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 Route a product's job to specific lpar vasanthz All Other Mainframe Topics 9 Thu Mar 02, 2017 2:22 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
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 6 Thu Oct 27, 2016 10:20 am

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