Before you can start using the Change Data Capture API,
you must prepare the database and the database server.
About this task
Perform the following tasks to prepare for using the Change Data Capture API:
Procedure
-
Turn on logging for all databases from which you intend to
capture data changes by running the cdc_set_fullrowlogging() function with the
logging argument set to 1.
- Run the following script as user informix from the $ONEDB_HOME/etc directory:
syscdcv1.sql
- Verify that the syscdcv1 database exists by creating
a connection to it, as user informix.
For example,
you can use DB-Access to connect to the syscdcv1 database.
- Set the DB_LOCALE environment variable
to be the same as the locale of the database from which you want to
capture data.