You create an application to capture transactions on your IBM Informix Server. Your application is built using the Informix CDC (Change Data Capture) API. You note that transaction data returned by the application lags significantly behind the actual data changes.
The data recorded by a CDC application returns transactions after they enter the transaction log files and in the order they enter the files. The data will not be visible to the CDC application until it is flushed from the logical log buffer.
Note: You can see this behavior using the cdcapi.ec demonstration program found in the $INFORMIXDIR/demo/cdc directory with 11.7 and 12.1 engines.
Resolving the problem
Two ways to observe the log data more quickly:
- Use unbuffered logging.
- Force a checkpoint to flush the log buffers.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.