Upgrading servers and databases to 12.6

Overview

The upgrade process includes these steps:

Table 3-1: Upgrading 12.x databases to 12.6

Step

Related information

1. Shut down servers

“Step 1: Shutting down servers”

2. Install IQ

“Step 2: Installing IQ”

3. Install the standalone IQ Agent (multiplex only)

“Step 3: Installing the standalone IQ Agent on the write server”

4. Start the IQ Agent (multiplex only)

“Step 4: Starting the Sybase IQ Agent”

5. Start the server

“Step 5: Starting the server”

5. Upgrade databases

“Step 6: Upgrading databases”

6. Enforce referential integrity

“Step 7: Enforcing referential integrity”

7. Restart after upgrading

“Step 8: Restarting after upgrading”

8. Verify after upgrade

“Step 9: Verifying databases after upgrade”

9. Back up databases again (recommended, not required)

“Step 10: Backing up databases after upgrading”

Before you upgrade

You must have a recent backup before you upgrade.

Different IQ versions on multiplex servers

You can deploy new releases on one server of an existing multiplex without interrupting other servers, as long as the servers being upgraded are version 12.5 or higher. Always upgrade the write server last.

Be sure to back up the write server before an upgrade. (Once you create an IQ Local Store on a query server, you must back up that query server as part of future upgrades).

New 12.6 features are only completely available after all databases are upgraded to version 12.6 using ALTER DATABASE UPGRADE. If you upgrade databases on a query server, but leave the write server at 12.5, synchronization returns database versions on the query server to version 12.5 and you will need to repeat the ALTER DATABASE UPGRADE. Databases take their version from the write server.

Synchronizing affects database version, not the installed software version on a server. If you install 12.6 software on the query server, that software continues to be 12.6 after any synchronizations. Multiple database versions may exist on servers with installed software version 12.6, as shown in Table 1-1. However, you must connect to each server using an IQ Agent of the same version and the appropriate agent port.

Upgrading multiplex databases

To upgrade 12.5 databases to 12.6, perform the steps that follow on each server in the multiplex. Note that, wherever backup is recommended, you need only back up the write server.

To upgrade 12.4.3 multiplex databases to 12.6, see “Upgrading 12.4.3 multiplex databases to 12.6”.