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
what is the option or command used in informix for finding which dbspace a database resides?
why do foreground writes decrease performance ?
what are the informix isolation levels and can you explain each one ?
what are the uses of key value locking in informix?
Name the sql joins that are available in informix.
what can be used to capture an isam error from an informix odbc program on unix?
explain about light scans in informix?
What is the role of binary large object in informix?
Explain about informix 4gl.
what is an informix instance?
how would you convert a secondary server into a primary server ?
what command would you use to move the physical log?
What is the use of key-value locking in informix?
what are the options/commands used which dbspace a database resides?
Can you explain pdq priority?