- Overview
- Canceling the operations performed on a transaction file
- Canceling the operations performed on a transaction file
- Freeing records from a transaction
- Delete the records in transaction
WDOptimizer: Canceling/Freeing records in transaction
 Available only with this kind of connection
WDOptimizer is used to: - Cancel a transaction.
- Free records from a transaction.
Reminder: A transaction is used to make sure that the updates performed on one or more data files have successfully completed. If an error or an incident (power outage for example) occurs during transaction operations, WDOptimizer automatically restores the files to their initial status (before the beginning of transaction). Remark: WDTrans can also be used to cancel a transaction and/or to free the records from a transaction. Canceling the operations performed on a transaction file When canceling the operations performed on a transaction file: - If a transaction is in progress, WDOptimizer cancels all the operations performed on the files in transaction since the beginning of the transaction. In this case, the transaction is canceled without interrupting the program execution.
- If no transaction is in progress, WDOptimizer restores the integrity of the database and cancels the unsuccessful transaction (power failure for example).
Canceling the operations performed on a transaction file To cancel the operations performed on a transaction file: - Start WDOptimizer.
- Select "Cancel a transaction..." then "Cancel the operations performed on a transaction file".
 - Select the transaction file. The list of data files (with their full path) currently in transaction is displayed. For each file, the identifier of the computer that performs an operation in transaction is displayed.
- If some data files are password protected, specify the password. Indeed, this password is required to cancel the transaction.
- Click the "Cancel the transaction" button. The transaction is canceled.
Freeing records from a transaction Freeing records from a transaction is used to transform all the records "in transaction" into "standard" records (if these records do not belong to the transaction in progress). If a record found in the specified data file is considered as being in transaction but does not belong to a transaction in progress, it is automatically freed. Caution: This feature is an advanced feature. This feature must be used when it is not possible to cancel the transactions that have failed (deleted transaction files for example). Delete the records in transaction To free the records in transaction: - Start WDOptimizer.
- Select "Cancel a transaction" then "Free all the records in transaction".
- Select the directory containing the data file currently in transaction.
Caution: No transaction file must be found in this directory. The list of data files found in the directory is displayed.
Remark: Check "Include the files found in all the sub-directories" if data files are located in the sub-directories. - If some data files are password protected, specify the password. Indeed, this password is required to free the records in transaction.
- Click the "Free all the records in transaction" button. The records are freed.
|
|
|
|