Run iqunload with the appropriate parameters to migrate your databases.
Minimum required parameters for a multiplex writer are -au (migrate database), -c (connection parameters), ENG= connection parameter and -ms_filename. The ENG= value must match your existing server name used in Sybase IQ12.7 and the -ms_filename specifies the new main store for the migrated writer. This path must be the same for all nodes in the muliplex.
The name of the new main store must be visible and accessible by all nodes of the multiplex. This is important because the main store file name defaults to new_system_main.iq. This path is relative to the catalog database file (.db). Later, when the Sybase IQ 15.4 multiplex is synchronized, the catalog is replicated to the secondary nodes, formerly known as the query nodes. If you leave the default value for the main store name unchanged, the path remains new_system_main.iq and secondary nodes cannot find the shared main store.
The ENG= argument specifies the multiplex main engine name. This is because the iqunload utility attempts to start the database to determine if the database is a simplex or multiplex database. If multiplex, the server name is enforced. If you are unsure of the server name, check the administrative script start_server in the database directory.
The DBF= argument must specify the actual path used to create the multiplex. If you are unsure of this, look at the SYSIQFILE table in your 12.7 server to verify the database path.
The -ms_filename argument specifies the location of the new main store. This path must be visible and accessible by all servers in the multiplex.
iqunload -au -v -c "uid=DBA;pwd=SQL;dbf=/sunx5prod/users/marshall/mpx127/ w1/w1.db;eng=w1_1234" -ms_filename ../shared/new_main_store.iq
Sybase IQ Unload Utility Version 15.2.0.5533 Connecting and initializing 2008-11-23 22:32:07 Unloading user and group definitions 2008-11-23 22:32:08 Unloading table definitions 2008-11-23 22:32:09 Unloading index definitions 2008-11-23 22:32:09 Unloading functions 2008-11-23 22:32:09 Unloading view definitions 2008-11-23 22:32:09 Unloading procedures 2008-11-23 22:32:09 Unloading triggers 2008-11-23 22:32:09 Unloading SQL Remote definitions 2008-11-23 22:32:09 Unloading MobiLink definitions 2008-11-23 22:32:10 Creating new database 2008-11-23 22:32:48 Reloading user and group definitions 2008-11-23 22:32:48 Reloading table definitions 2008-11-23 22:32:53 Reloading index definitions 2008-11-23 22:32:53 Reloading functions 2008-11-23 22:32:53 Reloading view definitions 2008-11-23 22:32:53 Reloading procedures 2008-11-23 22:32:53 Reloading triggers 2008-11-23 22:32:53 Reloading SQL Remote definitions 2008-11-23 22:32:53 Reloading MobiLink definitions
Successfully backed up file "/sunx5prod/users/marshall/mpx127/w1/w1.db" by renaming it to "/sunx5prod/users/marshall/mpx127/w1/w1.db.before_schema_reload". Successfully backed up file "/sunx5prod/users/marshall/mpx127/main.db" by renaming it to "/sunx5prod/users/marshall/mpx127/main.db.before_schema_reload". Successfully backed up file /sunx5prod/users/marshall/mpx127/main.iqmsg" by renaming it to "/sunx5prod/users/marshall/mpx127/main.iqmsg.before_schema_reload". Successfully reloaded schema of database "/sunx5prod/users/marshall/mpx127/main.db".