Before you install

Read this section carefully before you install Sybase IQ.

Plug-in requirements

For full Sybase Central functionality, Sybase IQ may require the Java Runtime Environment. You may also need to upgrade the version of the Sybase Central toolkit on your system. Review Table 1-1 before you install.

**Table 1-1: Plug-in compatibility with Sybase IQ installed products**
Plug-in	Sybase IQ	Sybase Central Toolkit	Agent	JRE
IQ 126	12.6 or 12.5 fully supported. Earlier IQ versions minimally supported.	4.3 or later required	126 Agent required	142 required
IQ 125	12.5 or earlier	3.2 required	125 Agent required	122 required (131 on Linux)

Any multiplex where all servers are not at the same version is mixed-mode multiplex. Upgrading Sybase IQ from version 12.5 to 12.6, for example, typically results in a mixed-mode multiplex for a short period.

The following operations are not recommended on mixed-mode multiplexes:

Creating a local store. Creating a local store succeeds on a 12.6 query server but not on the write server where it is lost at the next synchronize.
Creating a main store. The create operation succeeds but displays a warning. You cannot delete the space explicitly from any 12.6 query server. The query servers that still define the deleted main store will continue running, but once stopped will not restart without override flags, and a file_id mismatch between write and query servers causes subsequent main store creates to fail.

Running multiple IQ Agents

In general, you cannot install Sybase IQ 12.6 server components on a Sybase IQ 12.5 server without first uninstalling Sybase IQ 12.5. The exception to this rule is that you can install a standalone 12.6 IQ Agent on a 12.5 server in order to manage a multiplex containing both 12.5 and 12.6 servers (mixed-mode multiplex).

To convert 12.5 multiplex databases to 12.6, you first must convert each query server to 12.6. After all query servers are converted, you must install the 12.6 IQ Agent on the write server and convert the write server to 12.6. (If desired, you may run a 12.5 IQ Agent and the 12.6 IQ Agent on the same machine, as long as the agent version matches that of the connected server, and each has its own port number.)

To install a standalone 12.6 IQ Agent on a 12.5 Sybase IQ server, use the sybinstall parameter -add_agent. See “Installing the standalone IQ Agent on the write server”.

Upgrading LONG BINARY columns

Sybase IQ 12.6 does not support existing LONG BINARY columns created using any release prior to Sybase IQ 12.5 ESD8. You must explicitly drop LONG BINARY columns before installing 12.6, and recreate them after installing. For details, see the appendix “Upgrading existing LONG BINARY columns” in the manual Large Objects Management in Sybase IQ.

Preserving check constraints before database upgrade

Sybase IQ 12.6 enforces previously unenforced column and table CHECK constraints on updates, inserts, and loads of new data. Existing data in databases created with previous versions of Sybase IQ may contain unsupported constraints that now generate errors.

You need only remove and recreate constraints once per upgrade to 12.6. You need not repeat this procedure for 12.6 ESD releases.

To avoid errors:

Install Sybase IQ 12.6.

Query the existing database (before upgrade) to identify potential constraint violations.

Generate commands to recreate constraints in existing tables.

Run ALTER DATABASE UPGRADE as instructed in Chapter 3, “Migrating Data”.
Recreate constraints in the upgraded database.

To find existing table data that violates a given constraint, create a query. For example, to find data that violates the constraint C1 < 15, run the following query:

SELECT COUNT(*) FROM TABLE x WHERE NOT(C1 < 15)

Sybase provides two special stored procedures to help you remove and recreate constraints. These stored procedures are located in the scripts subdirectory of $ASDIR. Run these procedures, if desired, before upgrading each database:

The sp_iqprintconstraints procedure creates a script that you can run to recreate constraints. Commands are written to the server log, in the file servername.nnn.SRVLOG (where nnn is the number of times the server has been started) in the directory specified by $ASLOGDIR).
The sp_iqdropconstraints procedure drops all constraints on all IQ tables in database.

After you run ALTER DATABASE UPGRADE on each database, run the command script or scripts to recreate constraints.

For example, the following commands create the table rental, with a check constraint to validate that the date_returned is later than the date borrowed.

CREATE TABLE rental (date_borrowed DATE NOT NULL,date_returned DATE,title CHAR(20)           REFERENCES titles (id_num),CHECK( date_returned >= date_borrowed ) )

The sp_iqprintconstraints procedure returns the following:

ALTER TABLE rental ADD CHECK date_returned >= date_borrowed

Updating SDK

The Sybase IQ installation CD contains the Sybase Software Developers Kit, also called the Sybase SDK or Sybase Open Client Developer’s Kit.

Sybase IQ requires a minimum of Open Client 12.5.1 ESD3. If your system already has this minimum required version installed as part of Open Client, Open Server, or Adaptive Server Enterprise, you can skip installing the Open Client supplied with Sybase IQ 12.6.

Sybase recommends that you install Sybase IQ 12.6 in a clean directory for easier version management. Environmental variables are local to the shell and the subdirectories are specific to the versions.

You can update the Sybase SDK (Open Client) as future versions become available, provided that you set the INSTALL_ALL_PATCH environment variable before installing the update.

To set the variable using the csh or C shell:

setenv INSTALL_ALL_PATCH "Y"

To set the variable using bash or Korn shell (ksh):

INSTALL_ALL_PATCH="Y"
export INSTALL_ALL_PATCH