Use this command to display information about the database logs that are used by IBM InfoSphere CDC and are required for replication. Use this command to implement a log retention policy. With this command you can display the following information:
▪A list of all the database logs that are required for the specified instance.
▪The earliest open transaction in the database log for the specified instance.
▪The database log that the specified instance of IBM InfoSphere CDC is currently reading on the source.
▪The database log for the subscription that the specified instance of IBM InfoSphere CDC is currently applying on the target.
You must issue this command on your IBM InfoSphere CDC source system.
The name of the IBM InfoSphere CDC instance. You can set the TSINSTANCE environment variable to the name of your IBM InfoSphere CDC instance. After this is complete, you no longer have to specify the instance when issuing commands.
-c
Considers the current position instead of the restart position.
-t
Displays the current database log for a subscription that the specified IBM InfoSphere CDC instance is currently reading. This is the log containing the current position confirmed by the target.
-l
Displays the current source database log that the specified IBM InfoSphere CDC instance is currently reading. This is the log containing the current scraping position.
-s <SUBSCRIPTION_NAME>
Specifies the name of the subscription for which you want to display the database log that IBM InfoSphere CDC is currently reading. Use this parameter in conjunction with the -t parameter to display the database log.
-A
Specifies all subscriptions in the specified IBM InfoSphere CDC instance.
-v
Specifies verbose output (otherwise, the output is formatted for scripting).
-L <locale>
The name of the locale used for the IBM InfoSphere CDC instance. The default is the locale of the machine where IBM InfoSphere CDC is installed.
Result
This command returns a value of 0 if the command was successful and a non-zero value if the command fails.