Skip to Content

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

IQ Multiplex Synch Process

Hey guys,

I'm looking for information regarding how the SAP IQ MPX  16.0 synchronization process works  between the coordinator and the writer/reader.

I recall that on version 12.7 , SQLRemote was used for this, but now I'm not sure  how it works now.

How does this work ?

Also manuals only mention via SCC or manually.  If a manual synch is required, this reference form the docs say:

Back up the catalog store to the directory where the secondary server runs

dbbackup -y -d -c "uid=dba;pwd=sql;links=tcpip{port=2763};eng=mpxnode_c" /host1/mpx/

So how does dbbackup copies the coordinator catalog to the secondary node. ? I'm confused here

Thank you




Hi Jose,

1- In IQ15.x and 16, Automatic synchronization is processed via INC: inter-node communication:

Communication Infrastructure

2- Regarding manual synchronization, the path specified is expected to be the location of the catalog (.db and .log) of Secondary node to be synchronized. Dbbackup will copy the .db to that directory.

In example you mentioned,  /host1/mpx/ is catalog directory of the secondary node in machine host1.

Dbbackup can be executed as utility client from the secondary node machine (host1), connected remotely to coordinator node. So in this case, the copy is local to secondary node (hos1 in the example).

It can also be executed from coordinator machine if /host1/mpx/ is network shared.



0 View this answer in context

Helpful Answer

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