Switching from Nonintegrated Replicat to Parallel Nonintegrated Replicat
The process for switching to parallel integrated or parallel nonintegrated Replicat is the same for all Replicat modes. This topic describes the process to switch from nonintegrated Replicat to parallel nonintegrated Replicat.
Before Starting the Switching Process
-
Create a parallel nonintegrated Replicat process, repe that reads from the exisiting trail file:
ADD REPLICAT repe, PARALLEL, EXTTRAIL ea, checkpointtable ggadmin.ggs_checkpoint1
In this command, repe is the name of the Replicat. ea is the trail name. The trail name supplied while creating this Replicat is the same as the other Replicat in nonintegrated mode.Note:
If the checkpoint table is configured in GLOBALS, then there is no need to include thecheckpointtable
option with this command. If not, then use this option to provide the checkpoint table name. -
Do not start the parallel nonintegrated Replicat (repe).
-
Stop the current nonintegrated Replicat, repea.
STOP REPLICAT repea
-
On the target side, access the Replicat report file (.rpt) to know the values of the following components:
-
Last applied CSN by the current nonintegrated Replicat process.
-
Trail sequence and RBA of the exisitng Replicat process.
To access the details of the Replicat, run the command:INFO REPLICAT repea DETAIL
The output for this command shows an output similar to the following:Replicat REPEA Last Started 2022-06-16 04:21 Status STOPPED Description eastt Checkpoint Lag 00:00:00 (updated 01:59:59 ago) Log Read Checkpoint File east/ea000000009 2022-06-14 04:38:34.084220 RBA 9382 Settings Profile Default Encryption Profile LocalWallet Current Log BSN value: (no data) Last Committed Transaction CSN value: 50698907 Extract Source Begin End east/ea000000009 2022-06-16 04:21 2022-06-14 04:38 east/ea000000000 * Initialized * 2022-06-16 04:21 east/ea000000009 2022-06-14 04:38 2022-06-14 04:38 east/ea000000009 2022-06-14 04:38 2022-06-14 04:38 east/ea000000009 2022-06-16 03:55 2022-06-14 04:38 east/ea000000000 * Initialized * 2022-06-16 03:55 east/ea000000000 * Initialized * First Record east/ea000000000 * Initialized * First Record east/ea000000000 * Initialized * First Record east/ea000000000 * Initialized * First Record Current directory /scratch/preeshuk/ggtest/install_ogg21.3_210725/bin Report file /scratch/oggoradep/var/lib/report/REPEA.rpt Parameter file /scratch/oggoradep/etc/conf/ogg/REPEA.prm Checkpoint file /scratch/oggoradep/var/lib/checkpt/REPEA.cpr Checkpoint table DBEAST.GGADMIN.GGS_CHECKPOINT Process file /scratch/oggoradep/var/run/REPEA.pcr Error log /scratch/oggoradep/var/log/ggserr.log
-
Start the Switching Process
To start using the nonintegrated parallel Replicat, you need to alter it to port the
content from the other Replicat. Use the following steps to perform this task:
-
Run the
ALTER REPLICAT
command as follows:ALTER REPLICAT replicat_name, EXTSEQNO extseqno, EXTRBA extrba
For example, for the Replicat repe, here's the command:ALTER REPLICAT repe, EXTSEQNO 9, EXTRBAm 9382
-
Start the newly created parallel nonintegrated Replicat process using the following command:
START REPLICAT repe AFTERCSN csn_value
For example:START REPLICAT repe AFTERCSN 50698907
This starts the Replicat at the specified CSN value in the trail file.