MQSeries.net :: View topic - Stored procedure update and connector bounce

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Stored procedure update and connector bounce

Stored procedure update and connector bounce

« View previous topic :: View next topic »

Author

Message

pr3st00

Posted: Thu May 31, 2007 6:30 am Post subject: Stored procedure update and connector bounce

Newbie

Joined: 28 Mar 2007
Posts: 3
Location: Brazil

Hi,

Do I need to bounce any ICS components (connector, agents, etc.) after updating a stored procedure on a backend database? Sometimes we got the request from development team to bounce components after updating sps, and I'm not sure if this is really necessary.

Thanks.

Gaya3

Posted: Thu May 31, 2007 7:16 pm Post subject:

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

Hi

Hope you are not changing the stored procedure's name, which is being called from the connector.

Following could the reason why they are asking you to bounce.

1. Assume Adapter(connector) is running and you updated the stored procedure. in this case, you must have to bounce the connector. as it will be having the old SPS in its cache so it wont reflect the new changes.

It is better to stop the adapter(connector) and update the sps and restart it.

Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Stored procedure update and connector bounce

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP