on 06-16-2016 5:47 PM
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
Regards
Jose
Hi Jose,
1- In IQ15.x and 16, Automatic synchronization is processed via INC: inter-node communication:
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.
Regards,
Tayeb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Tayeb!
Regards
Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Tayeb,
Thank you very much. Just a last couple of questions regarding dbbackup.
Currently we have the MPX on Windows 2008R2.
-If in the need of a manual synchronization executed form the coordinator
we would need to have a network share at the coordinator pointing to the location of the secondary node .db and .log files?
-If in the need of manual synchronization from the secondary , we just execute dbbackup as the example shown in the manuals without a network share?
Regards
Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Forgot the 1st method as it is less secure.
Use only 2nd method, that is execute dbbackup from the secondary.
IQ 16 Manual instructs to connect from Secondary server machine:
Synchronizing Servers - Administration: Multiplex - SAP Library
Prerequisites
Log in as a user with the BACKUP DATABASE privilege and perform the following steps on the computer where the secondary server runs.
....
Regards,
Tayeb.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.