Re: Does IDS replication require transactions?

you may need to look at cursor behaviour, a commit may close it.


Superboer.

scottishpoet schreef:
For replication you need to create a logged database

if you turn transaction logging on but don't code begin and commit
works within your application then each SQL statement will be treated
as a discrete transaction and logged as such

You may need to make some modifications to your application for
concurrency as the default isolation level for a logged database is I
thinkcommited read which may give some locking issues. If you SET
ISOLATION TO DIRTY READ at the beginning of your application then this
should minimise the impact of that.




timnels@xxxxxxxxx wrote:
We've got a legacy application using Informix SE that doesn't use
transactions. A client is requesting that we port to IDS to get
replication capabilities. Are we going to have to enable transactions
or will IDS replication work without it?
Thanks.

.