| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| AnyWayChecking DB connectivity of the DataflowEngine |
« View previous topic :: View next topic » |
| Author |
Message
|
| nik_iway |
 Posted: Fri Jul 23, 2010 7:00 am Post subject: AnyWayChecking DB connectivity of the DataflowEngine |
 |
|
Centurion
Joined: 21 Jul 2005
Posts: 115
|
Hi,
We having db2 as Database in production . Is there any way of checking the DataflowEngine running on one lpar successfully getting connected to Db2 existing on another lpar .
I used ping command to check the network connectivity ,
iam able to get the reponse, but when the message flow is trying to communicate the DB its throwing exception.
there was datatabase restart but the Message brokers werent restarted which had led to the issue. We had restarted the broker and the DB connectivity got solved.
To prevent this happening in future is there any way of finding out the Dataflowengines successfully connected to database.
Db2 Commands...???? Unix Commands ....???
regards
Nik |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Jul 23, 2010 7:36 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
which version of MB is this?
what i suggest is you should have a good error handling scenario in place.
when ever the db is not getting connected for some interval of time, you can design to stop your flow instead of going infinite loop of retrying or getting hanged.
running another couple of scrips or what ever, you're putting more burden to your OS again.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| nik_iway |
| Posted: Fri Jul 23, 2010 8:30 am Post subject: |
|
|
Centurion
Joined: 21 Jul 2005
Posts: 115
|
we already have our error service flows up and running and it gets routed . The only problem we have is that the message will be sent to queue for manual replay which inturn effects the daily stat report.
We now are sure that everytime database is restarted we restart the brokers.
After restarting the broker we want to check if all the connectivity is fine with message broker and database.
is there any command or menthods to check it??
i know that db2 :
db2 " list applications for database <datatbaseName> show detail "
will list all the applications connecting to database in terms of connection handles and PID
Is the information produced out of the db2 command can be correlated to
ps -ef | grep dataflowEngine
Any ideas?????? |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Fri Jul 23, 2010 8:43 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
you can use tnsping to check the db. i guess the same work for DB2 as well
I could see some shell scripts which are readily available in google, kindly search, i don't want to post those un-authorized link in this forum.
there is one command which helps to do the DB connectivity test, not remembering now...
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Last edited by Gaya3 on Fri Jul 23, 2010 9:53 am; edited 1 time in total |
|
| Back to top |
|
|
| SAFraser |
| Posted: Fri Jul 23, 2010 9:37 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
tnsping is an Oracle command.
I believe db2 has equivalent commands, but they are dependent on the version of db2. Mr Google might be able to help if you ask him about "ping db2". |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
