Use this command on your IBM InfoSphere CDC target system to obtain the replication position (bookmark) in the stream of change data for a subscription. After generating the replication position information with this command, you can use the dmsetbookmark command on the source system to set the replication position for a subscription. More information on the IBM InfoSphere CDC stream of change data is provided in the following paragraphs.
IBM InfoSphere CDC parses the data from your database logs and creates a stream of change data to process on the source and eventually apply on the target. The stream of change data is sorted in the order in which the data was committed in the source database, whereas the data in your database logs is sorted in the order in which the individual action was done in the source database.
For example, two transactions named T1 and T2 may be ordered like this in your source database log:
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.
-s <SOURCE_ID>
Specifies the source ID of the subscription for which you want to obtain the replication position (bookmark).
-f <bookmark_file_name>
Specifies the name of the binary file that will be generated by this command. The generated file contains information about the replication position (bookmark) for the specified subscription.
You can specify an absolute path for the location where you want to create the file. If you do not specify an absolute path, the file is created in the IBM InfoSphere CDC installation directory.
Use the -f parameter in the dmsetbookmark command to read the binary file generated by this parameter.
-x <bookmark_file_name>
Specifies the name of the XML file that will be generated by this command. The generated file contains information about the replication position (bookmark) for the specified subscription.
You can specify an absolute path for the location where you want to create the file. If you do not specify an absolute path, the file is created in the IBM InfoSphere CDC installation directory.
Use the -f parameter in the dmsetbookmark command to read the XML file generated by this parameter.
[-v]
Displays verbose information about the replication position (bookmark), including a hexadecimal-encoded string. The amount of information displayed depends on the type and version of the source engine. The hexadecimal-encoded string is always displayed. It is a subset of what the dmdecodebookmark command displays. If not specified, only a hexadecimal-encoded sting is displayed.
-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.
IBM InfoSphere CDC obtains the replication position (bookmark) information for the specified instance and the MASTER source ID. Replication position (bookmark) information is contained in the bookmark binary file which will be placed in the IBM InfoSphere CDC installation directory since no absolute path has been specified.
IBM InfoSphere CDC obtains the replication position (bookmark) information for the specified instance and the FINANCE source ID. Replication position (bookmark) information is contained in the mybookmarks XML file which will be placed in the IBM InfoSphere CDC installation directory since no absolute path has been specified.