Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

[Sybase IQ 12.7] Multiplex into simplex

Hi,

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,

Kind regards,

Tags:
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.


Regards,

Tayeb.


0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question