explain the purpose of optimizer directives and how/why you would use them
Explain the informix instance.
what are the database server operating modes available for informix? Explain each.
what is chunk in informix?
explain the concept of fragment elimination in informix ?
what are the sql joins available in informix?
how would you convert a secondary server into a primary server ?
I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?
What is a light scan in informix?
what is an informix instance?
somehow informix fails to go online. Is there a way to view what oninit is doing?
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?
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?
what is a chunk in informix ?
what are the options/commands used which dbspace a database resides?