Before you install

Plug-in requirements

Read this section carefully and follow the procedures that affect your configuration.

For full Sybase Central functionality, this version of Sybase IQ requires a new version of the IQ plug-in, the IQ Agent (formerly ASIQ Agent), the Sybase Central Toolkit, and the Java Runtime Environment. Check the following table 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)

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 “Step 3: 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.

To avoid errors:

Query the database to identify potential constraint violations.

Generate commands to recreate constraints in existing tables.

Install Sybase IQ 12.6.

Run ALTER DATABASE UPGRADE as instructed in Chapter 3, “Migrating Data from Previous Versions”.
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. Run these procedures, if desired, before installing Sybase IQ 12.6:

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.SVRLOG (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(s) 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 Developers Kit.

Sybase IQ requires a minimum of Open Client 12.5.1. If your system already has this minimum version installed as part of Open Client, Open Server, or Adaptive Server Enterprise, you can skip installing the Open Client supplied with 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 C shell (csh):

setenv INSTALL_ALL_PATCH "Y"

To set the variable using Bourne shell (sh):

INSTALL_ALL_PATCH="Y"
export INSTALL_ALL_PATCH