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,
86explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
64how 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,
102Post New IBM Informix Questions
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?
how would you convert a secondary server into a primary server ?
what command would you use to move the physical log?
Can you explain pdq priority?
What is the use of key-value locking in informix?
who developed informix?
explain the concept of fragment elimination in informix ?
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?
what can be used to capture an isam error from an informix odbc program on unix?
why is update statistics important to a database?
What is a light scan in informix?
what are the database server operating modes available for informix? Explain each.
what is informix binary large object?
what are the uses of key value locking in informix?
What is a database object in ibm informix?