CECJ0009E (0x01240009) CECJ0009E Error accessing target log stream log-stream-name for subscription subscription-name attempting to locate block x'system-clock-value' - GMT time DB2-timestamp. The error message code is specific-return-code, with the specific return codes (rc1, rc2).

Explanation

During start of replication, the target server encountered an error accessing the target log stream to determine the correct restart timestamp for a subscription.

The contents of the message include the block header timestamp (in hexadecimal format and converted to a DB2 timestamp) that was being searched for when the error was reported. Also included is the specific return code reported by the API used to access the target log stream and the return and reason codes values from the failing IXGBRWSE request.

Start of replication fails for the subscription.

User response

The bookmark is inconsistent with the contents of the target log stream. Use the IXGBRWSE return and reason codes to assist in determining why the target log stream cannot be accessed.

You need to determine where processing should restart for the subscription and issue a SETLOGPOS command to set a new bookmark location before attempting to restart replication for the subscription.

Before restarting replication, resolve any issues with the target log stream that would cause replication to fail when trying to write data to the log stream.