Perform these steps to move a 32-bit database to a 64-bit platform.
Prerequisites
Review backup and restore procedures:
For simplex servers, see Administration:
Backup, Restore, and Data Recovery .
For multiplex servers, see Administration:
Multiplex > Back Up and Restore.
Make note of the 32-bit server raw device and IQ store path names. Raw device and
IQ store path names on the 64-bit target must match those on the 32-bit machine.
Task
Log in to your 32-bit server and back up the database.
Copy the backup to the 64-bit machine, and restore the database.
You may need to rename raw device and path names to ensure they match.
See Administration: Multiplex > Back Up and Restore.
On the 64-bit machine, do one of the following:
Server
Action
Simplex
Start the database with the appropriate startup flags.
Multiplex
Start the coordinator with the -iqmpx_sn
1, -gm 1 , -iqro 1,
and -iqmpx_ov 1 startup flags.
Start Interactive SQL and connect to the database.
Use DROP MULTIPLEX SERVER to drop all
existing secondary nodes.
Use ALTER DATABASE UPGRADE to
upgrade the database.
See Reference: Statements and Options > SQL
Statements > ALTER DATABASE Statement.
Run sp_iqcheckdb ('allocation database') and verify that the database is
error free.
sp_iqcheckdb checks the validity of
the current database. See Reference: Building Blocks, Tables, and
Procedures > System Procedures > sp_iqcheckdb Procedure.
Perform these steps for multiplex servers only:
Shut down and restart the coordinator normally (without the -gm 1
, -iqro 1, and -iqmpx_ov startup
flags).
Use CREATE MULTIPLEX SERVER STATEMENT to
recreate the secondary nodes.