Run iqunload with the appropriate parameters to migrate your databases. Multiplex migration differs from Simplex migration and requires additional 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 your existing server name used in 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 muliplex. For complete syntax, see “Sybase IQ 15.1 Unload utility (iqunload)”.
For multiplex, there are two differences in the way you will execute the iqunload utility:
You need to 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 attempts to start the database server as simplex first. This start requires that the name of the server match the naming conventions for the multiplex nodes. Once the iqunload detects that the server is a multiplex node, it shuts the node down and restarts it with the iqmpx_sn 1 option.
The name of the new main store needs to be visible and accessible by all nodes of the multiplex. This is important because main store filename defaults to new_system_main.iq. This path is relative to the catalog database file (.db). Later, when the15.1 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 are unable to find the shared main store.
For multiplex writers, required arguments are ENG=, DBF=, and -ms_filename:
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, then the server name is enforced. If you are unsure of the servername, check the administrative script start_server in the database directory.
The DBF= argument must specify the actual path that you 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.
For example:
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.0.0.5120 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".
