Moving Local Stores With iqlsunload

Unload the schema and data for local objects in the 12.7 IQ Local Store, and move them to another node for migration.

Prerequisites

Upgrade to Sybase IQ 12.7 ESD #5 at a minimum before local store migration.

Task

Source the ASIQ-12_7.sh or .csh file before running the iqlsunload utility.
Run the 12.7 iqlsunload utility against each query server with a local store.
Edit the reload_schema.sql
- Delete unwanted objects.
- Change any commented objects in the reload_schema.sql that you want to reload.
- Add commands to define any objects that you defined in sp_mpxcfg_<servername> procedures.
Edit the extract_data.sql script to remove objects that you do not want to migrate. These objects are generally the same ones that you removed from reload_schema.sql.
Use Interactive SQL to run extract_data.sql from your 12.7 local store.

You now have unloaded the schema and data for local objects in the 12.7 local store.
Run the reload_schema.sql and reload_data.sql scripts against the 12.7 write server.

Note: If you prefer, wait until the write server has been migrated to 15 and run the reload_schema.sql and reload_data.sql scripts against the new 15 coordinator.