IDS 10 Replication Logs
Posted in 2007
Topics: High Availability & Replication
Hi All, I am using IDS-10 on two servers and configured enterprise replication on it. Replication is working perfectly fine. If I want to see the SQL processed on primary server which will initiate data to be replicated on target site, please advice where and how can I find these SQL queries. Is there any kind of log which Enterprise replication is maintaining? Regards, Navaid Arif
Not sure I understand the question. Are you asking what user SQL was processed on the primary to cause data on the replicant to be modified or what SQL was generated by the primary internally to update the data on the replicant? Either way, the answer, I think, is the same. ER doesn't replicate by reissuing SQL or by issuing any SQL at all on the replicant. Logical log records are processed and sent to the replicant and reprocessed there. The preimage of the modified record is used to locate the record(s) to be updated on the replicant and the recorded transformations are performed there. The process is described in more detail in the manuals. Art S. Kagel ----- Original Message ----- From: Navaid Arif <ids@iiug.org> To: ids@iiug.org At: 10/03 2:50:06 Hi All, I am using IDS-10 on two servers and configured enterprise replication on it. Replication is working perfectly fine. If I want to see the SQL processed on primary server which will initiate data to be replicated on target site, please advice where and how can I find these SQL queries. Is there any kind of log which Enterprise replication is maintaining? Regards, Navaid Arif ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.