Posts

Showing posts from May, 2011

InfoSphere Change Data Capture Vs Mixed mode of log shipping

Although InfoSphere Change Data Capture does not allow mixed mode as of today, it has a flexibility to accomplish the mixed mode of log shipping by enabling the manual mode with a simple script. Automatic Mode : In automatic mode, ISCDC automatically reads the appropriate archived log files and replicates Manual Mode : In this mode, ISCDC allows user to register the available log file via the backend command " dmarchivelogavailable ". Such manually registered log files can be unregistered using " dmarchivelogremoved " command. This comes very handy when the user environment needs to ship the archived log files via Oracle Data Guard or by manually copying the files and ISCDC is expected to read and replicates the data. A simple ever running shell/perl script or any program can be written to keep monitoring for the new completed files and can keep registering the log files using the back-end command. For more information refer infocenter