Before you install

You must uninstall previous versions of products before you install Sybase IQ 12.6. Please read this section carefully before installing or uninstalling.

Sybase strongly recommends that you do not run Adaptive Server Anywhere and Sybase IQ on the same Windows machine. The environment variables for the product installed latest overwrite those of the product installed first, causing startup problems for the first product.

Plug-in requirements

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, run setup.exe. For details, 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

Interoperability with installed products

If your system already has a version of one of the products to be installed, the installation proceeds as follows:

If the product already installed has a newer date or version than the product installed with IQ, the installation does not install any older files.
If the product already installed is older than the one included with IQ, the installation only installs newer files.
When an older product exists, the IQ installation assumes that it is in use and omits it from the uninstall list. This prevents changing existing applications if you uninstall IQ.

Uninstalling IQ

Modifying or removing the installed Sybase IQ

Log into the Windows machine using an account with Administrator privileges.
Exit any Windows programs running on your machine.
Place the CD in the CD drive.

If your system is equipped with autorun, the installation starts immediately and you can skip the next step.
Select Start > Run.

Use Browse to select your CD drive letter, and, in the File Name box, type:
```
setup.exe
```
Choose the option button to Modify, Repair, or Remove installed Sybase IQ components.
Click Next and follow the prompts on ensuing screens.

Removing Sybase IQ if Uninstall fails (Method 1)

If Uninstall fails, reinstall, reboot, and then run Uninstall again.

When you reinstall in the same location, the creation of a new Uninstall log in the registry folder (including registry, menu, and files entries) verifies that everything was removed.

To reinstall easily, edit the registry (using regedit) and remove the tag that tells InstallShield that Sybase IQ is installed. The tag to remove is in the location:
```
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
```
Look through the entries similar to {A7337FCE-95DB-4AA1-9E1E-FBCE35AEACB9} and remove the one where “DisplayName” is “Sybase Adaptive Server IQ 12.6”. Once you remove this entry, the installer will reinstall completely.

Removing Sybase IQ if Uninstall fails (Method 2)

If you cannot remove Sybase IQ using Method 1, you can remove most of Sybase IQ from a system as follows.

Uninstall the Agent (if running):
1. Select Start | Run.
2. Type
```
ASIQagent -u SybASIQ-Agent1260
```
3. File not found indicates that the file is already removed.
Clean up files, as follows:
1. In the DOS window, type
```
cd /D %ASDIR%
```
  .
  
  WARNING! If you created a database in the %ASDIR% directory, the database will be removed with all the log files.
2. Verify that you changed to the correct directory.
3. Delete the directory and its contents.
At the Command Prompt, type:
```
cd /D %ASLOGDIR%
```
If you have set this variable, the specified directory contains all log files.
1. Verify that you changed to the correct directory.
2. Delete the directory and its contents.
If you have installed no other Sybase products, you can uninstall Open Client also. Remove Open Client only if you have no other Sybase products installed.
1. Change to the Sybase directory:
```
cd /D %SYBASE%
```
2. Verify that you’re in the correct directory.
3. Delete the directory and its contents.
Clean up the registry:
1. Select Start > Run.
2. Type:
```
 regedit
```
3. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Sybase
4. Remove “Adaptive Server IQ” and all contents.
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
6. Remove all entries that start with “SybASIQ“
7. Go to HKEY_CURRENT_USER\Sofware\ODBC\ODBC.INI
8. Remove “Adaptive Server IQ *” and all contents
Clean up the Program Group:
1. Select START > Programs > Sybase
2. Right-click on “Adaptive Server IQ” and select “Delete”
3. If you have no other Sybase products installed, you can remove the entire “Sybase” menu.
Clean up the environment, as follows:
1. On your desktop, right-click My Computer and select Properties > Advanced > Environment.
2. Find the ASDIR environment variable and record its value.
3. Remove ASDIR and ASLOGDIR variables, if present.
Clean out the path by carefully removing each directory that refers to:
```
	%ASDIR%\win32	%SYBASE%\%SYBASE_OCS%\dll	%SYBASE%\%SYBASE_OCS%\bin
```
Do this one at a time, and make sure you have the remaining directories separated by a semicolon “;”.

Press “Apply” when done.

If you cannot remove the previous version for some reason, install the current version in a completely different directory. Note that you could still have some problems with the old version because of conflicts with registry entries or environment variables.

Replacing files or components

The installation procedure has Repair and Modify options that allow you to add, replace, or remove certain files or components. If you install/repair/modify Sybase IQ and the existing version of Open Client on your system is newer than the version to be installed by IQ, the installation does not overwrite the existing version. In general, the IQ installation procedure does not overwrite files that have a newer version number or creation date.

Replacing Open Client

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

Sybase IQ recommends Open Client 12.5.1. If your system already has this 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. Make sure that if you overwrite %SYBASE%, the Version and EBF are newer than those of the version overwritten.

To see the current version, enter this command:

isql -v

If you install the SDK included with Sybase IQ 12.6, the installation modifies the environmental variables %SYBASE%, %SYBASE_OCS%, and %PATH%. If other Sybase products depend on the version or location of Open Client formerly defined in these variables, problems could occur.