Assume that prior to migration, the directory W:\iq-i5\unload\127\db\* contains these files:
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.0 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.0 in writeable mode flags this file as upgraded, after which it cannot be used in previous versions.
iq127db.iqmsg.before_schema_reload – the original 12.6 or 12.7 message file. This is left intact in its pre-migration state in case you need messages issued during migration while using the 12.7 unload utility embedded in Sybase IQ 15.0.
iq127db.iqtmp – the Sybase IQ 15.0 temporary store.
iq127db.lmp – the Sybase IQ 15.0 license manager property file.
iq127db.db.out – output log file.
new_main_store.iq– the new Sybase IQ 15.0 IQ_SYSTEM_MAIN.
In addition to the files listed, any additional SA catalog stores would also be renamed to have the .before_schema_reload extension and new versions created.
