Answer / Vineet Kumar Rai

Informix provides several server modes. Here are some of them: 1) OnLine mode (OL): This is the default mode where the server operates in a fully online, non-recoverable state. 2) Recovery mode (RC): This mode recovers the database from a backup or crash. 3) Maintenance mode (MA): This mode performs maintenance operations like checkpointing and reorganizing tables. 4) Backup mode (BA): This mode backs up the database.

What is a light scan in informix?

1 Answers  

---

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

1 Answers   IBM,

---

Explain about informix 4gl.

1 Answers  

---

What is the use of key-value locking in informix?

1 Answers  

---

mention the database server operating modes available for informix?

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 informix-list@iiug.org mailing list?

1 Answers   IBM,

---

what is informix universal server?

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,

---

Explain the informix instance.

1 Answers  

---

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

1 Answers   IBM,

---

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

1 Answers   IBM,

---