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,
62explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
52how 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,
90Post New IBM Informix Questions
what is a chunk in informix ?
can I ask about perl, dbi and dbd informix? Other products?
explain about light scans in informix?
What is the role of binary large object in informix?
Explain the informix instance.
What is a database object in ibm informix?
how could you increase the speed of ontape/onbar backups ?
I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?
explain the purpose of optimizer directives and how/why you would use them
explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
what is extent in informix?
why a foreground write in informix decrease performance?state the reason for the same?
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 is the option or command used in informix for finding which dbspace a database resides?
What is the use of extent in informix?