Download IBM Informix Migration Guide
Transcript
To determine how many pages were allocated and where they were allocated, run oncheck -pe and look for the word TBLSpace. This space must be available on the device where the root chunk will be located. For information about space requirements for Informix Version 12.10, see “Checking and configuring available space” on page 3-2. Related concepts: “Checking and configuring available space” on page 3-2 Save copies of the current configuration files Save copies of the ONCONFIG and concsm.cfg files for when you migrate to Informix Version 12.10 again. Informix uses the concsm.cfg file to configure CSMs. Save system catalog information If your current database server instance uses secure-auditing masks or external spaces, and you want to preserve the associated catalog information, you must unload these system catalog tables before you revert. Run the following command to unload the system catalog tables: $INFORMIXDIR/etc/smi_unld When the smi_unld utility finishes unloading the information, the utility displays instructions for reloading the information. Save these instructions. After you complete the reversion and bring up your database server, you can reload the data that you preserved. Follow the instructions given with the smi_unld utility for reloading the information. Typically, you run the following command: $INFORMIXDIR/etc/smi_load $INFORMIXDIR/etc/ Verify the integrity of the Version 12.10 data Verify the integrity of your Version 12.10 data, if you did not do this after you migrated. To verify the integrity of your data, run the following commands: oncheck oncheck oncheck oncheck -cI database_name -cD database_name -cr -cc database_name If the oncheck utility finds any problems, the utility prompts you to respond to corrective action that it can perform. If you respond Yes to the suggested corrective action, run the oncheck command again to make sure the problem has been fixed. The oncheck utility cannot fix data that has become corrupt. If the oncheck utility is unable to fix a corruption problem, you might need to contact Technical Support before your proceed. You will also need to verify the integrity of your data after you revert. Back up Informix Version 12.10 Before you begin the reversion, make a complete level-0 backup of Informix Version 12.10. Chapter 7. Reverting from Informix Version 12.10 7-9