Migrating databases to a 64-bit system

The procedures in this section describe how to migrate your database from a 32-bit to a 64-bit hardware platform.

Prerequisite

The procedures assume your database is already upgraded to Sybase IQ 12.6.

StepsMigrating databases to a 64-bit machine

  1. Back up the database.

    NoteIf you created your Sybase IQ database on a Linux 32-bit version prior to Sybase IQ 12.6 ESD2, you must first install IQ 12.6 ESD2 for Linux 32-bit and create a new data backup before migrating to the Linux 64-bit version.

  2. Shut down the server.

  3. Install the Sybase IQ 64-bit software and any required ESDs.

  4. If the current version of Sybase IQ is higher than the version on which you were previously running, start Interactive SQL and issue the database upgrade statement:

    ALTER DATABASE UPGRADE

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

  5. Start the server.

Sybase recommends that you perform regular backups.