Oninit cdi / Archive
Talk to an expert →

Does IDS replication require transactions?

Posted in 2007

Topics: General Discussion

timnels@gmail.com — — source: Usenet: comp.databases.informix

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.

↪ replying to timnels@gmail.com
scottishpoet — — source: Usenet: comp.databases.informix

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@gmail.com 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.

↪ replying to scottishpoet
Superboer — — source: Usenet: comp.databases.informix

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@gmail.com 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.

Glossary