Configuring messaging engine and server behavior when a data store connection is lost

If the connection between a running messaging engine and its data store is lost, either due to a failure or because you stop the database for maintenance, you can ensure that the messaging engine functions correctly after the connection is restored, by configuring the server to restart automatically.

About this task

The behavior described in this topic occurs only if the messaging engine is running and has established exclusive locks on its data store.

By setting the sib.msgstore.jdbcFailoverOnDBConnectionLoss custom property on a messaging engine, you can determine the behavior of the messaging engine and its hosting server in the event that the connection to the data store is lost.
Table 1. The behavior that is determined by the sib.msgstore.jdbcFailoverOnDBConnectionLoss custom property.. The first column of the table lists the sib.msgstore.jdbcFailoverOnDBConnectionLoss custom property values. The second column explains the behavior of the messaging engine when the data store connection is lost.
Property value Behavior when the data store connection is lost
true (default)

The server shuts down and must be manually restarted.

false

The messaging engine continues to run and accept work, and periodically attempts to regain the connection to the data store. If work continues to be submitted to the messaging engine while the data store is unavailable, the results can be unpredictable, and the messaging engine can be in an inconsistent state when the data store connection is restored.

Note: If work continues to be submitted to the messaging engine, even nonpersistent messaging can fail because the messaging engine might need to use the data store, for example to allocate a unique ID to a message, or to move nonpersistent messages out of memory.

Procedure

  1. Click Service integration -> Buses -> bus_name -> [Topology] Messaging engines -> engine_name -> [Additional Properties] Custom properties to navigate to the custom properties panel for the messaging engine.
  2. Click New.
  3. Type sib.msgstore.jdbcFailoverOnDBConnectionLoss in the Name field and true in the Value field.
  4. Click OK.
  5. Save your changes to the master configuration.
  6. Restart the application server.

Results

If the connection between the messaging engine and its data store is lost, the application server that is hosting the messaging engine shuts down.

What to do next

After a server restart, click Service integration -> Buses -> bus_name -> [Topology] Messaging engines to view the status of the messaging engine. Check that the messaging engine has been restarted and is running.

You might want to tune your system so that the loss of the database connection is detected quickly, and the messaging engine waits for a reasonable amount of time for the data store to become available again before attempting to start on another server.




In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms of Use | Feedback

Last updatedLast updated: Sep 19, 2011 6:15:55 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=matt&product=was-express-dist&topic=tjm_dsconnloss
File name: tjm_dsconnloss.html