We had this same condition at a client. We caught the exception and parsed the exception for certain database errors. What you have to watch out for is when the DB comes back online. The first message gets a different error that still implies the DB is unavailable. (WIERD) But WMQI throws an error. So you have messages of type:
1 - Database unavailable 2 - Connection unavailable 3 - All other Database errors
When we got 1 & 2 we wrote a message to a queue that triggered a script to GET DISABLE the queue. (Here I'm a little fuzzy). We had another script which reset the GET to EABLE. THis can be started by the Database Backup process.
bobbee
From: Jas Singh <[EMAIL PROTECTED]> Reply-To: MQSeries List <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Handling Database down period in WMQI Date: Fri, 10 Oct 2003 11:58:04 -0500
We are developing message flows in IBM Websphere MQ Integrator (WMQI), Message flows are using Databases for Lookup and Write operations extensively . The database is shutdown for backup every night for 2 hrs and we need to build a functionality that the messages remain in the INPUT queue until the database is up and running .
Option such as backout count or try catch do not suite our purpose as this a normal process we do not want to treat this as an error .
Is there any good way of achieving this in Message flow
Thanks -Jas
*****Internet Email Confidentiality*********
This communication may contain privileged or other confidential information. If you are not the intended recipient, or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received. In addition, you should not print, copy, retransmit, disseminate, or otherwise use the information contained in this communication. Thank you.
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
_________________________________________________________________ Surf and talk on the phone at the same time with broadband Internet access. Get high-speed for as low as $29.95/month (depending on the local service providers in your area). https://broadband.msn.com
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive