An index is reaching a limitation on the number of pages it has, can you explain why this limitation exists and what work you would do to get around it?
IBM,
50explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
42how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?
IBM,
81Post New IBM Informix Questions
List down the features of informix 4gl.
what rules exist regarding format, content, flame wars, etc
explain the purpose of optimizer directives and how/why you would use them
why a foreground write in informix decrease performance?state the reason for the same?
how could you increase the speed of ontape/onbar backups ?
what are the informix isolation levels and can you explain each one ?
What is the use of key-value locking in informix?
what is a binary large object ?
Explain the informix instance.
what are the database server operating modes available for informix? Explain each.
What is the role of binary large object in informix?
what is informix instance?
what is an extent in informix?
what command would you use to move the physical log?
somehow informix fails to go online. Is there a way to view what oninit is doing?