Configuring solidDB® for IBM InfoSphere CDC replication
To be able to use the solidDB® server with the IBM InfoSphere CDC technology, you need modify configuration settings so that the IBM InfoSphere CDC for solidDB® can connect to and replicate data from your solidDB® database.
Before you begin
This section assumes that you are familiar with solidDB® administration and have read, for example, the “Administering solidDB®” and “Configuring solidDB®” in the solidDB® Administrator Guide.
Procedure
1 Set up your database environment by creating a working directory, your solidDB® database, and user accounts.
For instructions, see “Creating a new database” in the solidDB® Administrator Guide.
Tip: After you have installed the solidDB® server, you can find the following directories in the installation directory:
You can use the eval_kit/cdc directory in the solidDB® server installation directory as your working directory; it contains a sample solid.ini file for using solidDB® with the Universal Cache capability or IBM InfoSphere CDC replication.
2 Configure the Log Reader by modifying the configuration parameters in the LogReader section of the solid.iniconfiguration file.
Set the LogReader.LogReaderEnabled parameter to yes.
[LogReader] LogReaderEnabled=yes
You must enable the Log Reader to be able to use the solidDB® database as a source database in IBM InfoSphere CDC replication. The factory value of the LogReader.LogReaderEnabled parameter is no.
Set the transaction log retention space size with the LogReader.MaxLogSize parameter.
[LogReader] MaxLogSize=<MB>
The LogReader.MaxLogSize parameter sets the amount (size) of log files that are available for performing a catchup. The maximum size of log file depends on the available disk space and the expected downtime after which a catchup is needed. The factory value is 10 240 (10 GB).
If the log reader is enabled, the specified log file retention space is always used fully. Also, the log files can use even more space, if backups are not performed or the parameter General.CheckpointDeleteLog is set to no.
Set the in-memory buffer size for log records with the LogReader.MaxSpace parameter.
[LogReader] MaxSpace=<number of log records>
The MaxSpace parameter sets the size (in number of log records) of the in-memory log reader buffer used in throttling. The maximum number of log records depends on the expected size of load bursts. The factory value is 100000 log records.
The size of a log record is that of the (binary) row size, plus a few bytes of additional metadata overhead. When the buffer fills up, throughput throttling is applied; the operations are blocked until there is room in the log reader buffer.
3 Modify other performance and database-setup-related configuration parameters as necessary.
Logging.DurabilityLevel
By default, the solidDB® server durability level is set to relaxed (Logging.DurabilityLevel=1). Relaxed durability means that most recent transactions can be lost if the server fails unexpectedly.
To prevent loss of data, set the durability level to strict with the following setting in the solid.ini file:
[Logging] DurabilityLevel=3
Strict durability setting induces a performance penalty when compared to relaxed durability. Relaxed durability can be used without the risk of data loss if solidDB® HA (HotStandby) configuration is applied with the 2-Safe replication protocol (default).
General.DefaultStoreIsMemory
By default, the solidDB® table storage type is set to M-table (General.DefaultStoreIsMemory=yes).
Sql.IsolationLevel
By default, the solidDB® isolation level is set to Read Committed (Sql.IsolationLevel=1).