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 Central is installed on HP-UX with the Sybase IQ Server and is also available as a Windows or Linux client for use with the HP-UX 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:
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) |
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, use the sybinstall parameter -add_agent. See “Upgrading 12.5 multiplex databases to 12.7”.
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”.
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.
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
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.
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 start_asiq utility controls the version of the SDK used by Sybase IQ, and always sets it to the version installed by Sybase IQ.
The SYBASE_OCS environment variable controls the version of the SDK used by other Sybase products. On UNIX platforms the behavior of setup files has changed regarding this variable.
In previous versions of Sybase IQ, running the setup procedure set the SYBASE_OCS variable. If another installed Sybase product had already set the variable, the value was changed.
In Sybase IQ 12.7, running the setup procedure (ASIQ-12_7.csh or ASIQ-12_7.sh) only sets the variable if it is not already set. If the value of SYBASE_OCS has been set by another Sybase product, that value remains in effect unless you unset SYBASE_OCS, and then run the source file. See “Setting environment variables” for details.
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
