-
Title
Change target IP without downtime -
Description
export queue build up message, doesn't go any where after change host name or IP for the target
sp_ctrl (myacctpwdb:2200)> show
Process Source Target State PID
---------- ------------------------ ------------ -------------------- ------
Capture o.myacctpw Running 24688
Import myacct-pedb-myacctpedb myacctpwdb Idle
Post o.myacctpe-myacctpedb o.myacctpw Running 24690
Import myacctpedb myacctpwdb Running 28709
Read o.myacctpw Running 24689
Export myacctpwdb myacct-pedb Stopped by user
Export myacctpwdb myacctpedb Stopped by user -
Cause
becase there are two read processes for export, one for old target host name, another for new one
-
Resolution
Please delete reader process for old target IP
sp_ctrl > stop export
sp_ctrl > exit
qview -i
qview>list
The following queues exist:
myacctpedb+P+o.myacctpe-o.myacctpw
subqueues range from 0 to 276
WRITER +PI+myacctpedb+sp_mport+0x0aaa1c36 (10.170.28.54)
READER +PP+myacctpedb+sp_opst+o.myacctpe-o.myacctpw
WRITER +PI+myacctpedb+sp_mport+0x0aaa2420 (10.170.36.32)
o.myacctpw+C
WRITER +PA+o.myacctpw+sp_ocap+o.myacctpw
READER +PR+o.myacctpw+sp_ordr+o.myacctpw
myacctpwdb+X
WRITER +PR+o.myacctpw+sp_ordr+o.myacctpw
READER +PX+myacctpwdb+sp_xport+0x0aaa1c36 (10.170.28.54)
READER +PX+myacctpwdb+sp_xport+0x0aaa2420 (10.170.36.32)
qview>deluser myacctpwdb+X +PX+myacctpwdb+sp_xport+0x0aaa1c36
qview>exit
Go back to sp_ctrl on the source and set the following parameter to redirecte message to new target.
sp_ctrl > set param SP_XPT_ALTERNATE_HOST <new hostname>
sp_ctrl > start export
Please be aware of this new parameter is available after Shareplex 5.0.1