| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Test connection |
« View previous topic :: View next topic » |
| Author |
Message
|
| Suresh Gupta |
 Posted: Mon Sep 01, 2008 12:04 pm Post subject: Database Test connection |
 |
|
Apprentice
Joined: 29 Jun 2005
Posts: 46
Location: India
|
Hi, Can we test the db connectivity using ESQL, basically I don't want retrieve or update the Database table, just I want to test the connectivity from the broker to database using ESQL
_________________
regards,
Suresh |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Mon Sep 01, 2008 2:51 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Start the broker and look at the logs. If there is no complaint about the broker's database all is well. Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Suresh Gupta |
| Posted: Mon Sep 01, 2008 4:43 pm Post subject: |
|
|
Apprentice
Joined: 29 Jun 2005
Posts: 46
Location: India
|
Hi, first let me explain about my requirement, we have one user data base where we will retrieve some records, we have one constraint like we should change the database password every month, so in-order to make sure message flow is connecting properly to the database with the new password we are trying to built to new flow , in this flow we are not going to retrieve any data, just connection testing, so is there are any built-in variable exit s in ESQL that returns some return codes from database
_________________
regards,
Suresh |
|
| Back to top |
|
|
| sridhsri |
| Posted: Mon Sep 01, 2008 5:54 pm Post subject: |
|
|
Master
Joined: 19 Jun 2008
Posts: 297
|
| I wouldn't recommend the approach you are using to check DB connectivity. Message flows aren't meant to be used to check for DB Connections. I believe the command you need is 'mqsisetdbparms'. If you still wish to explore using nodes/flows to test connectotvity, you might want to consider using a Java Compute node with some JDBC code in it to do so. Although I am pretty sure this will not prevent other flows from throwing DB Errors - if there is any problem. |
|
| Back to top |
|
|
| jeeth_m |
| Posted: Tue Sep 02, 2008 2:57 am Post subject: |
|
|
Voyager
Joined: 21 Jan 2002
Posts: 93
|
Broker will always connect if password is correct.
mqsisetdbparms can be only after bringing down broker. Once the broker is started after setting the dbparms, you should check error logs to see if there are any errors. If broker is unable to connect to its database, it will throw error.
If its a user database it will be good to check the sqlcode <> 0 in your code. May be you can call the same service and if you are getting any exception.
Jeeth |
|
| 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
|
|
|
|
