ER Problem
Posted in 2006
Topics: High Availability & Replication, Transactions, Locking & Isolation, Platform-Specific Issues, Versions, Editions & End-of-Life
All
ER on AIX 5.3 IDS 9.40.FC6 replicating (source to target) selected tables
to Solaris 5.8 IDS 7.31.FD6X1.
After running out of locks on the target box (due to a massive delete
independent of ER on a table outside of the ER environment) and a long
transaction rollback (due to a second attempt at the same delete but with
lock table exclusive) I'm getting error "The Datasync is not present."
when running 'onstat -g dss' on the target box.
Replay and Snoopy are still moving forward on the Source Server but no
transactions are being written nor are ats/ris files being generated.
Obviously I will have to re-sync data, but what do I need to do to
restart the datasync? cdr stop, cdr start on the source ?
Keith Simmons
office2office UK plc.
***********************************************************************************************
This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission.
This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems.
***********************************************************************************************
what threads are on the target? (onstat -g ath).
"Simmons, Keith" <keith.simmons@office2office.biz> wrote in message
news:mailman.190.1148985278.19084.informix-list@iiug.org...
All
ER on AIX 5.3 IDS 9.40.FC6 replicating (source to target) selected tables
to Solaris 5.8 IDS 7.31.FD6X1.
After running out of locks on the target box (due to a massive delete
independent of ER on a table outside of the ER environment) and a long
transaction rollback (due to a second attempt at the same delete but with
lock table exclusive) I'm getting error "The Datasync is not present."
when running 'onstat -g dss' on the target box.
Replay and Snoopy are still moving forward on the Source Server but no
transactions are being written nor are ats/ris files being generated.
Obviously I will have to re-sync data, but what do I need to do to
restart the datasync? cdr stop, cdr start on the source ?
Keith Simmons
office2office UK plc.
****************************************************************************
*******************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be
disclosed to anyone other than the addressee. Unauthorised recipients are
requested to preserve this confidentiality and to advise the sender
immediately of any error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
****************************************************************************
*******************
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g