To migrate the multiplex, run iqunload with the appropriate parameters.
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 the existing server name in SAP Sybase IQ 12.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 multiplex.
Specify the engine name in the -c connection parameters. This is the same name that your <mpx_dir>/<writer_node>/start_server script file uses to start the writer node. The iqunload utility initially attempts to start the database server as simplex. This start requires the name of the server to match the naming conventions for the multiplex nodes. Once iqunload detects that the server is a multiplex node, it shuts the node down and restarts it using the -iqmpx_sn 1 option.
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, and its location is relative to the catalog database file (.db). Later, when you synchronize the SAP Sybase IQ 16.0 multiplex, 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.
ENG – argument specifies the multiplex main engine name. iqunload attempts to start the database and determine whether the database is a simplex or multiplex. 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.
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.
-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".