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 ??
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.