Database Administrator definition

This table shows the options for processing messages from the transaction database.
Option Description
Recovery Database Processes messages in the recovery database.
Error Database Processes messages in the error database.

When this is selected, clicking Edit/Resend opens the Edit/Resend Error Database Message(s) dialog box.

After the necessary changes have been made, click Resend Current Message or Resend Marked Messages to open a dialog box. On the dialog box, select whether to resend to the Engine Queue or to a File.

Screen Sends output to a new dialog box.
File Saves the selected messages to a file for future processing. If a file is not listed, then output displays in a new dialog box.
Normal Format Click this when not saving messages to an output file. This provides basic message information. This option is available only when Screen is selected.
Long Format Click this when not saving messages to an output file. This adds details useful in sorting. This option is available only when Screen is selected.
Ultra-Long Format Click this when not saving messages to an output file. This is useful in debugging Tcl procs. This option is available only when Screen is selected.
Binary Length-Encoded Select this for resend operations. Binary length-encoded, the default, is the most portable file format because it does not use special characters to delimit records. End binary length-encoded file names with .bin. This option is available only when File is selected.
Newline Terminated Use this option when selecting a single message for manual editing, where each record is separated from adjoining records by a newline character. Do not use this format when the data within the message contains one or more newline characters. There are no restrictions on file names, except that they should not end in .bin. This option is available only when File is selected.
Filename Specify the file name in which to save selected messages. Click Folder to select an existing file from the file browser. To specify a new file that is binary length-encoded, specify the .bin extension; do not specify the .bin extension if the file is newline terminated. This option is available only when File is selected.
Overwrite Existing File Select to overwrite the output file. This option is available only when File is selected.
Database Order Click the arrow to open a list of sorting-order choices.
Map data Select to convert data through the named character data mapping table. Specify the table name in Filter. Most common mapping options are ASCII to EBCDIC, and EBCDIC to ASCII. There are four standard character maps that come with the system:
  • ibm_a2e
  • ibm_e2a
  • hci_a2e
  • hci_e2a

In addition, you can define your own character maps.

Destination Select to select the destination connection. Then, click the arrow for a list of connections that are defined in the current Network Configuration file.
Delete Selected Messages Removes unnecessary messages. Use this option to prevent messages from being resent through a another query.
Do Not Delete Selected Messages Resends messages.
Source Select to choose the source connection from a list of connections that are defined in the current Network Configuration file.
Owner Select to choose the connection that currently owns the message from a list of connections that are defined in the current Network Configuration file.

As messages move through various processing stages, other threads "own" the message. The thread that owns a message is responsible for the recovery of that message at system restart time.

This attribute should be used only at the direction of Support personnel.

Message Type Select to choose a message type, Data Type or Reply Type.
Message State Select to indicate the stage of processing for recovery messages or the reason for failure on error messages.
Message ID Select to list the internal system message ID, assigned by the engine as messages flow through the system. Use only the starting or ending message ID for an inclusive and open-ended message search.

For correct results, a database record is accessed by one of these methods:

  • Making one row of entries, Start or End, and leaving the other as 0.0.0 (or blank).
  • Making both rows of entries, Start and End, identical.

When making entries into the Start or End row:

  • Preceding fields of 0 or blank are stripped from the command-line argument:
    blank | blank | 1 == 1
    0       | 0       | 1 == 1
    0       | 2       | 1 == 2.1
    blank | 3       | 4 == 3.4
  • A non-zero field causes all subsequent fields to be interpreted as at least 0:
    1       | blank | blank  == 1.0.0
    1       | blank | 2        == 1.0.2
    1       | 0       | 3        == 1.0.3
    0       | 2       | 5        == 2.5
    blank | 3       | blank  == 3.0

    Use this only at the direction of Support personnel.

Date Range Specifies a date range in which to check or delete messages before/after a certain date in the error/recovery database.
Message Count Retrieves the message count of the error/recovery database.
Grep Filters the output. This is available when Error Database is selected.
Verbose Mode Select to enable verbose mode.
Show Error Details When Error Database is selected, selecting this check box shows details from the error database when you click Apply Command.
Show Readable Message Flags Shows an expanded readable view of the flags metadata field.
Wizard Opens the configuration wizard. Use the wizard as a guide through Database Administrator configuration. See Database Administration wizard.
Show Command Opens the Command dialog box. Use this dialog box to view the command that runs when Apply Command is selected.
Apply Command Click to check the requested selection. This opens the Result dialog box. If the request is correct, then the selection criteria creates the output file or shows the result.

Sometimes, when a command is applied and Ultra Long Format is selected, the output information might show output information longer than the dialog box. In these cases, there is a Word Wrap check box located at the bottom of the dialog box to aid in reading these messages.

Edit/Resend This function is available when Error Database is selected. This opens the Edit/Resend Error Database Message(s) dialog box. Click Resend Marked Messages to open a dialog box for configuring the resend parameters. Click Apply to resend the marked messages.