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 the checkpointtable 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.

Parent topic: Quickstarts