What is a "stale transaction"?

Answer

What is meant by Capture message ASN8999D "Capture" : "ASN" : "WorkerThread" : A stale transaction with no rows, no signals has been deleted, transID = 0000:0a43:9f47:03e0:0000.

The Capture program keeps all transactions in memory until a commit record is found in the Db2 log. A stale transaction is one where the Capture program received a Begin-UR log record but no other log records are received for that UR id. After an hour, the Capture program will discard the begin-UR log record and post the ASN8999D message. No data is lost. If a log record is found afterwards, the Capture program will create a begin-UR transaction and store the data.

One cause of this condition is a table which has data capture changes enabled but is not registered with the Capture program in the IBMSNAP_REGISTER table. Another cause could be a long running transaction that takes over an hour to complete. Again, no data loss will take place. If the Capture program subsequently reads a insert/update/delete log record the Capture program will create a new begin-UR transaction object. This Capture-created transaction object will be missing the transaction authid.