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

Controling execution of stored procedur on particular LPAR


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Sat Jul 21, 2012 10:35 am
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
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

Moderator Emeritus


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

PostPosted: Sun Jul 22, 2012 1:37 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Routing command Address SDSF to other... TSO/ISPF 2
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
This topic is locked: you cannot edit posts or make replies. Internal Autonomous Stored Procedure ... DB2 6
Search our Forums:

Back to Top