Database Administrator
The Database Administrator processes messages from the transaction database. The transaction database is different than, and independent from, any saved message log file. Although each connection has its own saved message file, all connections use the same transaction database.
There are two types of transaction databases:
- Recovery database
The recovery database is used to recover messages that are in transit if any of these conditions exist:
- The engine is restarted
- The engine unexpectedly goes down
When the engine starts running after a failure, it automatically continues processing messages from the recovery database. If a connection does not have the recovery database option enabled, then messages in transit during an engine failure are lost.
Messages are only in the recovery database when they are in the system. They are removed as soon as they are successfully sent to the outbound connection.
Use Network Configurator during site configuration to enable recovery for specific threads.
- Error database
The transaction database also recovers messages from processing and translation errors. These errors happen when of these conditions exist:
- A message is formed incorrectly
- Some stage of message processing fails
When an error happens, the message that caused the error is saved in the error database. The state describing the cause of the failure is also saved.
The majority of messages in the error database are undeliverable due to an error condition.
Error messages remain in the error database until manually removed.
Database Administration wizard
The default is the Database Administrator Classic dialog box.
From this dialog box, there are two configuration choices:
- Use the Database Administrator dialog box for configuration.
- Click Database Administrator dialog box, to use the Wizard. , located at the bottom left of the
The Database Administration wizard is a configuration aid that guides you through the entire configuration process. When the wizard is running, it is shown as a modal dialog box.
After opening the wizard, click
and follow the prompts.