Diagnose problems with the data store configuration

Find out how to diagnose problems that are caused by the data store configuration and possible solutions to these problems.

The following problems depend on the database that we use with the data store configuration and the level of that database:

Tasks

• Examine this section if our messaging engine uses a Sybase database for its data store. When we create your Sybase server:

  • Create the database server with a page size of at least 4 KB.

  • Set the lock scheme property on the server to the value datarows. This avoids the possibility of a deadlock on the data store tables.

• Examine this section if our messaging engine uses an Informix database for its data store and the messaging engine is unable to access its data store. When we configure our messaging engine to use an Informix database, specify the schema name in lowercase letters. For a full description of the configuring procedure, see Configure a messaging engine data store to use a data source.