The steps involved in enabling horizontally partitioned replication (with named queues) for a table already in normal replication and no named queue but currently using default queue are:
- Create entries for the column conditions for the table in question and commit the DMLs involved in the SharePlex internal table SHAREPLEX_PARTITION table.
- Make a copy of the currently active config file, edit the copy so as to route the table(s) in question thru horizontal partitioning with named queues.
- Issue flush from source sp_ctrl to create a reference point:
sp_ctrl>flush o.SID (where SID is the Oracle SID of the source database)
- Activate the copy of the config file containing the entries for tables that are now to be routed via Horizontal partitioning.
- Issue “show” on target sp_ctrl and ensure that the original Post queue is “stopped due to flush”. As and when new named Post queues will be spawned due to activation, they will also be in “stopped due to flush” state.
- Manually start the original Post queue so that the messages belonging to the table are posted first. Once that queue drains, you can start the newly spawned Post queues manually. This will ensure that the order of posting of transactions for that table is not jumbled.
You may want to test it in a QA environment so as to be conversant with the steps involved.