Assume that prior to migration, the directory W:\iq-i5\unload\127\db\* contains:
iq127db.db
iq127db.iq
iq127db.iqmsg
iq127db.iqtmp
iq127db.log
After migration, the directory W:\iq-15\unload\127\db\* contains the following:
iq127db.db – the new IQ catalog store
iq127db.db.before_schema_reload – the original 12.6 or 12.7 database. If you need to go back to Sybase IQ 12.6 or 12.7, and you have not started Sybase IQ 15.2 in writeable mode, you may copy this file to the original catalog store name (iq127db.db in this example).
iq127db.iq – the original IQ main store. The file and its data are unchanged during migration. Starting Sybase IQ 15.2 in writeable mode flags this file as upgraded, after which it cannot be used in earlier versions.
iq127db.iqmsg.before_schema_reload – the original 12.6 or 12.7 message file. This file is left intact in its premigration state in case you need messages issued during migration while using the 12.7 unload utility embedded in Sybase IQ 15.2.
iq127db.iqtmp – the Sybase IQ 15.2 temporary store.
iq127db.lmp – the Sybase IQ 15.2 license manager property file.
iq127db.db.out – output log file.
new_main_store.iq– the new Sybase IQ 15.2 IQ_SYSTEM_MAIN.
In addition to these files, any additional SA catalog stores are created and the original versions are renamed with a .before_schema_reload extension.
