Log Table (Batch Level) (daxch0508s000)
Use this session to view the log table that contains the results of the exchange process on batch level.
Field Information
- Type of Exchange
-
Specifies the type of exchange process.
- Exchange Scheme
-
Specifies the code of the exchange scheme.
- Description
-
The description of the Exchange scheme.
- Run Number
-
Specifies the run number of the export or import run.
For logging purposes, each new run for a particular Type of Exchange will get a unique number.
- Try Number
-
Specifies the try number.
This sequence number is used for identification in case of multiple tries per run. The try number is required for logging purposes.
A new try number will be created if an export or import is run using one of the following options:
- Restart previous run
- Reprocess rejected rec's
- Continue interrupted run
- Batch
-
Specifies the code of the batch.
- Batch Sequence Number
-
The sequence number of the batch in an exchange process.
Batches are processed in a sequential order. Batches with identical sequence numbers are processed in alphabetical order.
- Processing Type
-
Specifies the type of exchange process.
Allowed values
- New run
-
Use this option to start a new exchange program
- Restart previous run
-
Use this option to restart the previous runnumber
- Reprocess rejected rec's
-
Use this option to reprocess rejected records. LN stores the rejected records in additional files:
- Rejected Due to Error. This file contains records that are rejected because of database related problems such as index or domain errors.
- Rejected Due to condition. This file contains records that are rejected because return values of conditions return as false.
This option can not be used if the exchange is based on an audit procedure.
Note: The option Reprocess rejected records can only be used during an import procedure. - Continue interrupted run
-
Use this option to continue an interrupted exchange program. The program starts at the beginning of the table relation that was not completed. You can only restart the import if more than one batch line exists. The restart can begin at the start of an incomplete batch line. If only one batch line exists, this option is the same as a complete restart.
- Control Type
-
The Control Type depends on the exchange scheme as it was at the moment the export or import was run.
Allowed values
- Full exchange
-
The data exchange is performed regardless of the use of indicators or audits files. The export is done from the tables and during an import every record is treated like an insert.
- Based on indicators
-
The data exchange is based on the indicators insert, update, and delete. During an export, every record is marked with with an i, (for insert). The import depends on the indicator if the record is inserted(i), updated(u), or deleted(d).
- Based on audit
-
The export uses the audit files for the data exchange. During the import the inserts, updates and deletes are done based on the transactions in the audit files.
- User Name
-
Specifies the user that ran the export or import.
- Processing Company
-
Specifies the number of the LN company involved in the exchange process.
During an export process, it represents the LN company that exports data. During an import process, it represents the LN company that receives data.
- Batch Start Date
-
Specifies the current system date and time, according to Coordinated Universal Time (UTC), at the moment the batch was started.
- Batch End Date
-
Specifies , according to Coordinated Universal Time (UTC), the system date and time at the moment the batch is ended.
- Latest Batch Line Completed
-
Specifies the last table relation of the batch that has been carried out completely during an import or export process.
- Highest Transaction Number Completed
-
Specifies the number of the last transaction that has been imported during an import based on audit.
- Audit Date From
-
Specifies, according to Coordinated Universal Time (UTC), the start date and time of the audit range during an export.
Note: Only database transactions within the specified audit range are exported. - Audit Date To
-
Specifies, according to Coordinated Universal Time (UTC), the end date and time of the audit range during an export.
Note: Only database transactions within the specified audit range are exported. - Exchange Link
-
Specifies the code of the exchange link.
- Source System
-
Specifies the source system.
- Source Run
-
Specifies the number of the source run.
- Source Try
-
Specifies the number of the source try.
- Subscription Used
-
If this check box is selected, a subscription is used during a regular export. This is to notify the source system that the target system wants to import its data.
This is necessary to trace the source of the data. For example, if multiple sources per target are used.
- Control Character
-
If this check box is selected, a character is used in the ASCII files to separate the ASCII file fields.
- Separator Character
-
Specifies the character that is used in the ASCII files to separate the ASCII file fields.
- Enclosing Character
-
Specifies the characters that are used to enclose strings in the ASCII file.
- Compressed Files
-
If this check box is selected, the ASCII files are compressed during the exchange process.
The ASCII files are compressed after they are created and before they are exported to the target system. They are decompressed at the target system after they have been imported.