Answer / Priya Agarwal

"Informix supports four transaction isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. Each level represents a trade-off between concurrency and consistency. Here is a brief explanation of each:nn1. READ UNCOMMITTED (U): This is the least restrictive isolation level, allowing uncommitted data changes to be visible to other transactions. Data can potentially be read in an inconsistent state.nn2. READ COMMITTED (RC): A transaction cannot see data that has not been committed by another transaction; however, a transaction can still see its own dirty reads, meaning it can see changes made by the transaction itself even before those changes are committed.nn3. REPEATABLE READ (RR): This level guarantees that a transaction will always see the same data for repeated reads, except for changes made by the transaction itself. It prevents dirty reads but allows phantom reads and non-repeatable reads.nn4. SERIALIZABLE (S): This is the highest isolation level, ensuring each transaction appears to execute serially, with no interference from other transactions. It completely eliminates phantom reads, non-repeatable reads, and dirty reads."

why a foreground write in informix decrease performance?state the reason for the same?

1 Answers   IBM,

---

somehow informix fails to go online. Is there a way to view what oninit is doing?

1 Answers   IBM,

---

What is the use of extent in informix?

1 Answers  

---

can I install informix on a non-english version of windows nt?

1 Answers   IBM,

---

List down the features of informix 4gl.

1 Answers  

---

what is the informix-list@iiug.org mailing list?

1 Answers   IBM,

---

how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?

1 Answers   IBM,

---

how could you increase the speed of ontape/onbar backups ?

1 Answers   IBM,

---

explain the purpose of optimizer directives and how/why you would use them

1 Answers   IBM,

---

what are the uses of key value locking in informix?

1 Answers   IBM,

---

how would you convert a secondary server into a primary server ?

1 Answers   IBM,

---

What is the role of binary large object in informix?

1 Answers  

---