-
Title
How to move a table from one post queue to a new or existing post queue -
Description
General Procedure. -
Cause
N/A -
Resolution
Important Note:
If the table that you want to move has the parent/child relationship to other replicated table(s) , please put those related tables into the new post queue or the new destination post queue as well.
1. On the source, make a copy of the current config file first.
In the copy of the config file, change the post queue name for the table you want to move to the new post queue name or existing one for new destination of the table.
If table(s) being isolated in named queue is listed in a wildcard specification in the configure file, use the NOT clause Example: not (spo%, gen%, product) to exclude the table from current line in the config file and then add new line for the table like below:
owner.source_table owner.target_name targethost:NewPost@o.targetSID
Note: with above line, a new post queue with name of "NewPost" will be created for the table.
2. On target, sp_ctrl>stop post -- wait all post queues stopped by user
3. On source, find a quiet time, and then activate new config file with the copy of the config file you made from step 1 above.
4. On target, start all existing post queues one by one except the new post queue ( or new destination post queue for the table).
Please make sure do not start the new post queue at this point:
Sp_ctrl> start post queue5. Wait until the existing post queues are current with the new Activation Id (ACTID) . From following command, you will see “Activation Id” there
sp_ctrl> show post detail queue
Or wait backlog of the existing post queues are cleared out (once the backlog is cleared out, the “Activation Id” from “show post detail” should be same as current ACTID.6. Start new post queue