[Sybase IQ 12.7] Multiplex into simplex
We need to turn Multiplex ASIQ 12.7 (Sybase IQ/12.7.0/110225/P/ESD 11/Sun_Sparc/OS 5.9/64bit) with one writer and one query server into simplex.
Are these steps correct?
1) Stop the Query Node
2) Run the stored procedure dbo.sp_iqmpxdropqueryserver on the writer to drop a query node entirely from a Multiplex.
3) Run sp_iqendmpx to make sure the Writer is returned to a Simplex system
4) Check iq_mpx_versionlist, iq_mpx_status,iq_mpx_info
I haven't found any official documentation about this.
Thank you in advance,
Tayeb HADJOU replied
Then, you can go ahead with steps you mentioned AFTER adjustments below:
Add step 0 : Backup your database (if not already done)
In step 1: Stop the query node. Check the process is gone AND that the dbremote for this node is down also.
Add step 5 : Restart the now simplex writer node to make sure it shuts down cleanly and restarts cleanly.