Converting to a new hardware platform

Sybase IQ supports migrating your database from one platform to another, as long as both have the same endian structure. If you are upgrading from an earlier version and want to move your Sybase IQ databases to a different supported hardware platform, perform the conversion before you upgrade your data to Sybase IQ 15.2.

1. Back up the database.

2. Shut down the Sybase IQ server.

3. Install the Sybase IQ 12.x server on the new platform. Your migration can take place on the same or a different machine.

4. Start the Sybase IQ server on the new hardware platform.

5. Connect to the utility database, utility_db.

6. Restore the database from the backup you created in Step 1.

7. Shut down the server and restart it against the restored database. If the current version of Sybase IQ is later than the version on which you were previously running, upgrade databases, and therefore restart the server in a way that restricts user connections. Sybase recommends using these server startup options:

   • Use -gd DBA so that only users with DBA authority can start and stop databases.

   • Use -gm 1 to allow a single connection plus one DBA connection above the limit so that a DBA can connect and drop others in an emergency.

   An alternate way to restrict connections is to specify this command on the connection where you intend to perform the upgrade:

   sa_server_option 'disable_connections', 'ON'
   

   After you upgrade, execute this command on the same connecion:

   sa_server_option 'disable_connections', 'OFF'
   

   This method precludes emergency access from another DBA connection.

8. Start Interactive SQL and issue the database upgrade statement. For example:

   ALTER DATABASE UPGRADE
   

   If the database was created with the Java options off, append the keywords JAVA OFF JCONNECT OFF to the preceding command.