Database tab
Open the Message Manage Configuration Maintenance window with the Database tab selected. Open the window as described previously in this section. Refer to the following table for field descriptions.
This tab view also provides the Run Export button. For details see the Run Export .
Database Tab Field Descriptions
The Message Manager Configuration Maintenance window displays the fields described in the following table when the Database tab is selected.
Field | Description | ||
Use Stored Procedures |
When checked, stored procedures will be used for outbound control number generation and thread id generation on Oracle, SQL Server, Sybase, and DB2 (Non-z/OS). Not applicable for Access or DB2 running on z/OS. |
||
Sort TSV Files During Extract |
If this check box is enabled, Message Manager will re-sort the tables as they are being created in the export process. This is required when non-alphanumeric or lower/uppercase characters are used to uniquely identify Trading or Application Partners, and your database sort order does not match IBM's sort order. |
||
Current DB Vendor |
This is a read-only field used by Message Manager to generate SQL statements when they are database dependent. |
Run Export
The Run Export button allows you to trigger the Export process on demand, without having to cycle the Launcher. By default, Trading Manager is configured to run Export to synchronize the tsv files with the database at Launcher startup and every day at midnight. You can use the Run Export button if you want the tsv files to be synchronized immediately without having to wait for the scheduled time.
You can review the results of a successful export by viewing the Partner Manager log file.