View previous topic :: View next topic
|
Author |
Message |
seema_285
New User
Joined: 14 Oct 2010 Posts: 13 Location: pune
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
seema_285
New User
Joined: 14 Oct 2010 Posts: 13 Location: pune
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|