The THL Command
The thl command provides an interface to the THL data, including the ability to view the list of available files, details of the
enclosed event information, and the ability to purge THL files to reclaim space on disk beyond the configured log retention policy.
Usage
thl [options] [sub-command]
The command supports two command-line options that are applicable to all operations, as shown below:
| Option | Description |
|---|---|
-conf [path] | Path to the static services properties file. |
-service [servicename] | Name of the service to be used when looking for THL information. |
For example, to execute a command on a specific service:
shell> thl index -service alpha
Individual operations are selected by use of a specific command to the thl command. Supported commands are:
| Option | Description | Version |
|---|---|---|
apply | Apply thl to a remote database, or filesystem outside of normal Replication operations. | 8.0.0 |
dsctl | Obtain syntax that can be used with the dsctl command to assist in positioning of the replicator. | 7.0.2 |
help | Show the command help. | |
index | Obtain a list of available THL files. | |
info | Obtain summary information about the available THL data. | |
list | List one or more THL events. | |
purge | Purge THL data. | |
stats | Produce statistics of DML and DDL operations contained within THL. | 8.0.4 |
tail | Live tail of THL files. | 7.0.3 |
Further information on each of these operations is provided in the following sections.