Before you install Sybase IQ Server

You must uninstall previous versions of Sybase IQ, jConnect, Sybase Central, and Open Client before you install Sybase IQ Server. Please read this section carefully before installing or uninstalling. This section does not apply to Sybase IQ ETL Server or Sybase IQ ETL Development.

Sybase strongly recommends that you install Adaptive Server Anywhere and Sybase IQ on different Windows machines. When you install them both on the same machine, the environment variables for the product installed last overwrite those of the product installed first, causing start-up problems for the first product.

Plug-in requirements

Sybase Central is installed on Windows with the Sybase IQ Server and is also available as a Windows or Linux client for use with the Windows server. For full Sybase Central functionality, this version of Sybase IQ Server 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-4: Plug-in compatibility with Sybase IQ installed products**
IQ Plug-in	Sybase IQ	Sybase Central Toolkit	Agent	JRE
12.7	12.5 and higher fully supported. Earlier IQ versions minimally supported.	4.3 or later required	12.7 Agent required	1.4.2 required
12.6	12.6 or 12.5 fully supported. Earlier IQ versions minimally supported.	4.3 or later required	12.6 Agent required	1.4.2 required
12.5	12.5 or earlier	3.2 required	12.5 Agent required	1.2.2 required (1.3.1 on Linux)

Running multiple IQ Agents

In general, you cannot install Sybase IQ 12.6 or higher server components on a Sybase IQ 12.5 server without first uninstalling Sybase IQ 12.5. The exception is that you can install a standalone 12.6 or higher IQ Agent on a 12.5 server to manage a multiplex containing both 12.5 and higher-version servers (mixed-version multiplex). See “Running a mixed-version multiplex” for more information.

To install a standalone IQ Agent on a 12.5 Sybase IQ server, run setup.exe. The install procedure detects the existing version and displays the Optional Agent Install screen.

If desired, you can run a 12.5 IQ Agent and a higher version 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 convert multiplex databases to Sybase IQ 12.7, you first must convert each query server to 12.7. After all query servers are converted, you must install the IQ Agent on the write server and convert the write server to 12.7. For details, see “Upgrading 12.6 multiplex databases to 12.7”.

Upgrading LONG BINARY columns

Sybase IQ 12.6 and higher versions do 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.7, 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 and higher versions enforce 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. (Databases created with previous versions of Sybase IQ are not deleted when you uninstall Sybase IQ and install a new version, but you need to upgrade each database to use the features of each new version.)

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%:

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.

The steps that follow describe how to use these procedures.

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

To avoid errors, follow these steps:

Install Sybase IQ 12.7. (Installing the product does not overwrite existing databases, which you must upgrade separately.)

Query the database to identify potential constraint violations.

Generate commands to recreate constraints in existing tables.

Run ALTER DATABASE UPGRADE as instructed in Chapter 4, “Migrating Data”.
Recreate constraints in the upgraded 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.7”. 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-Agent12
```
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%
```
  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.

Updating SDK

The Sybase IQ installation CD contains the Sybase Software Developer’s Kit (SDK), which includes Open Client.

Sybase IQ recommends Open Client 15.0, EBF 13563. If your system already has this version installed as part of Adaptive Server Enterprise, Replication Server, or other Sybase products, you can skip installing the Open Client supplied with IQ 12.7.

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

The SYBASE_OCS environment variable controls the version of the SDK used by Sybase products.

You can update 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, enter the following in a DOS window:

set INSTALL_ALL_PATCH="Y"

Alternately, to add the variable through System in Control Panel, select Environment Variables on the Advanced tab and click New.