Upgrading 12.4.3 multiplex databases to 12.6

You must upgrade all multiplex databases to version 12.4.3 before you can follow the instructions in this section.

Upgrading 12.4.3 databases

To upgrade 12.4.3 multiplex databases to 12.6, use the following procedure:

On UNIX systems, you may optionally install 12.6 Sybase IQ software on all the servers in a separate directory from the previously installed version before starting the upgrade process.

Once the new directories are ready, follow these steps:

Shut down all the servers.

Install Sybase IQ 12.6 on the write server’s system. On UNIX, you can do this before shutting down the servers. On Windows, installation forces a system reboot.

On UNIX systems only, stop the IQ Agent on the write server’s system and restart it using the 12.6 installation environment. (On Windows, this is not needed because the IQ Agent starts automatically during reboot.)

First, use the ps command to locate the java process for the IQ Agent:

ps -ef | grep jre

fionat 5795 5705 0 17:46:49 pts/8 0:00 grep jre

fionat 5781 5755 0 17:46:49 pts/8 0:00 /wrk/sybcentral/java/jre2/bin/../bin/sparc/native_threads/java -ms8m -m

To determine if the process is the IQ Agent or the client process for the Sybase Central viewer, repeat the command with the parent process’s ID:

ps -fp 5755

UID 			PID 		PPID C STIME 					TTY 		TIME 	CMD

fionat 5755 					1 	 0 	17:45:09 			pts/8 		0:00 /bin/ksh /work ASIQ-12_5/bin/scjview -mainclass sybase.scf.ro.SCAgent -1

At the end of the line, sybase.scf.ro.SCAgent indicates the IQ Agent. (If the parent process ends with scjview, it is the client process for the Sybase Central viewer, not the Agent.)

To stop the Agent in the preceding example, enter:

kill -HUP 5781

Remove any -n <servername> switch in a params.cfg file used to start a multiplex database.

Start the write server in single node mode using the -iqmpx_sn 1 switch. Note that if you use a server name different from the write server name, you must also use the override switch, -iqmpx_ov 1.Use a unique server name that you have not previously used, as follows:

start_asiq @params.cfg -n <upgrade_server> 
-iqmpx_sn 1 -x 'tcpip{port=<writer_port>}' <dbfile>

You may use the write server’s normal TCPIP port.

Note Sybase IQ 12.6 enforces column and table CHECK constraints that were previously unenforced, but only on inserts, updates, and loads of new data. Before you upgrade the database, Sybase suggests that you follow the procedure in “Before you install” to record and recreate constraints.

Connect to the server with dbisqlc or dbisql as DBA. Make sure that no other users connect during the upgrade process. Make sure that you have performed the preceding steps in this chapter and installed any available EBFs. For details, see “Finding the latest information on EBFs and software maintenance”. Upgrade the database to 12.6 by issuing the following command:
```
ALTER DATABASE UPGRADE
```
If the database you are upgrading was created with the Java options set off, append the keywords JAVA OFF JCONNECT OFF to the preceding command.

The defaults for MAIN_RESERVED_DBSPACE_MB and TEMP_RESERVED_DBSPACE_MB were increased in version 12.5 for newly created databases. If these options are set to less than the 200MB in your database, set the options to 200MB or 50% of the size of the last dbspace before or immediately after upgrading your database.
Reconfigure the database definitions, as follows.

Issue the following SQL statement:
```
call sp_iqmpxdropserverdbspaces('<write_server>')
```
The <write_server> specified for sp_iqmpxdropserverdbspaces must be the original multiplex write server name, not the <upgrade_server> name used to start the server in Step 4.

If your multiplex has a write server and no query servers, also issue the following statement to convert to a non-multiplex database:
```
call sp_iqendmpx();
```
Now that you have a non-multiplex database, continue at step 7 in “Upgrading servers and databases to 12.6” and skip the remaining steps in this procedure.
Stop the upgrade server. Start Sybase Central and use it to start the write server.
Connect to the server as DBA with dbisqlc or dbisql.
Reset the SQL Remote configuration by issuing the SQL statements:
```
call sp_iqmpxsetpublisher()
```
```
call sp_iqmpxaddremoteusers()
```
You can check the multiplex configuration by issuing:
```
call sp_iqmpxvalidate()
```
It should indicate that dbremote is not running for this server, but there should be no other errors.
Install Sybase IQ 12.6 on each query server system, if not done in advance. Windows systems will reboot as part of software installation.
(UNIX only) Stop and restart the IQ Agent in the 12.6 environment on each query server.
Start Sybase Central, connect, and run Synchronize from the write server.

All servers in the multiplex environment are now running version 12.6.

After upgrading multiplex databases

Because the shared top-level directory is not a good location for database files, you should move these files to directories local to each server in the multiplex environment. For instructions, see the section titled “Migration” in Sybase IQ System Administration Guide chapter “Backup and Data Recovery.” After you move all database files, you can remove the shared top-level directory from the server systems if desired.

See also “After you upgrade” for other items you may want to check after upgrading.