Replication Agent connectivity  Informix trigger limitations

Chapter 2: Replication Agent for Informix

Transaction isolation

The default Informix database transaction isolation must be Committed Read. It cannot be Uncommitted Read or Transactions not supported.

This is ANSI standard behavior that guarantees that user2 will see the data only after user1 has committed the changes. If a change is in progress, user2 will be locked out until the change is either committed or rolled back. This is only possible if the database is logged.





Copyright © 2005. Sybase Inc. All rights reserved. Informix trigger limitations

View this book as PDF