Skip to Content

[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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 31, 2016 at 03:47 PM

    Hi Miguel,

    The official procedure is using Sybase Central to manage MPX 12.7.

    Sybase Central should do the necessary clean-up using background admin scripts.

    Deleting the last query server converts automatically the server to Simplex :

    Deleting query servers

    Regards,

    Tayeb.

    Add comment
    10|10000 characters needed characters exceeded