Moving 32-Bit Databases to 64-bit Platforms

Sybase IQ Server Suite is no longer available for 32-bit platforms. See this section for steps to move a 32-bit database to a 64-bit platform.

Prerequisites

Review Backup and Restore procedures:
- For simplex servers, see System Administration Guide: Volume 1 > Data Backup, Recovery, and Archiving
- For multiplex servers, see Using Sybase IQ Multiplex > Multiplex Backup and Restore Operations
Make a note about the raw device and IQ store path names on the 32-bit server. Raw device and IQ store path names on the 64-bit target must match those on the 32-bit machine.

Task

Login 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 during restore to ensure they match. See Using Sybase IQ Multiplex > Multiplex Backup and Restore Operations.
On the 64-bit machine, do one of the following :

Server type Command

Simplex
Start the database with the appropriate startup flags.

Multiplex

Start the coordinator with these startup flags:

-iqmpx_sn 1, -gm 1 , -iqro 1, -iqmpx_ov 1
Start Interactive SQL and connect to the database.
Use the DROP MULTIPLEX SERVER statement to drop all existing secondary nodes.
Use an ALTER DATABASE UPGRADE statement to upgrade the database.
See Reference: Statements and Options > SQL Statements > ALTER DATABASE Statement for details.
Run sp_iqcheckdb ('allocation database') and verify that the database is error free.
sp_iqcheckdb is a stored procedure that checks validity of the current database. See Reference: Building Blocks, Tables, and Procedures > System Procedures > sp_iqcheckdb Procedure for details.
Perform these steps for multiplex servers only:
1. Shut down and restart the coordinator normally (without the -gm 1 ,-iqro 1, -iqmpx_ov startup flags).
2. Use the CREATE MULTIPLEX SERVER STATEMENT to recreate the secondary nodes.