Installation and Upgrade

Last-minute information about installation and upgrading that was omitted from or incorrect in your installation guide, or that needs special emphasis.

For detailed information about installing and upgrading Sybase IQ, see the Installation and Configuration Guide.

Before you run a new version of Sybase IQ, see Restrictions for the most current requirements. This section includes installation and migration information that is new for this release or needs emphasis.

Sybase strongly recommends that you check the online support Web site for software updates to these components before you install the software. If a software update (ESD or EBF) has been released, it contains bug fixes made after this product shipped. You must download the latest update and install it after installing Sybase IQ. See Downloading Sybase EBFs and Maintenance Reports.

Sybase IQ 15.4 Requires a License

Sybase IQ 15.4 uses the Sybase Software Asset Management (SySAM) licensing mechanism that lets system administrators enable and monitor their site’s use of Sybase products.

Sybase IQ includes separate SySAM licenses for each product edition and separate licenses for any optional features available for that edition. See Installation and Configuration Guide > Licensing Your Software.

Avoid Using Relative Path to Launch Installer [CR #691212]

Sybase IQ installation fails if you use launch the installer using a relative path. During GUI installation, the installer fails to prompt for the license file information and does not install properly.

For example, when launched from the console using a command line:

Installer files directory :  /system1/users/jones/installdir
$SYBASE dir : /system1/users/jones/IQ154
cd $SYBASE
../installdir/setup.bin 

Custom Sybase Control Center Install Omits HTTP, HTTPS, and RMI Prompts [CR #688044]

If your perform a custom install and only choose the Sybase Control Center for IQ option, the installer does not display the port configuration panel.

Note: UNIX variables and path names shown. Windows users substitute %SYBASE% as the installation location and change forward slash (/) path separators to back slashes.

Sybase Partners with v3 UDFs Must Specify a License Key When Upgrading to v4 [CR #688135]

If you are a Sybase design partner using v3 UDFs, your UDFs will not continue to work after you upgrade your libraries to v4 unless you specify the Sybase-provided license key in the a_v4_extfn_license_info structure. You must implement the extfn_get_license_info method, and the method must return a valid key. See the User-Defined Functions guide for information on upgrading to the v4 API, and adding the extfn_get_license_info method.

SySAM Licensing Checkout [CR #628594]

If Sybase IQ was licensed using a per-processor license type in previous releases, the license quantity was determined at startup. In this release, Sybase IQ periodically checks the number of processors it can use and attempts to check-out additional licenses for any increase. Sybase IQ shuts down after 30 days, if additional licenses are not made available within this period. See the SySAM Users Guide for details regarding license grace.

ALTER DATABASE UPGRADE PROCEDURE ON Required

To install new system tables, you must run ALTER DATABASE UPGRADE PROCEDURE ON on existing databases after installing Sybase IQ 15.4.

For syntax, see Reference: Statements and Options.

Using remote server classes for ASE [CR #615420]

Component Integration Services (CIS) connectivity from Sybase IQ to Adaptive Server® Enterprise (ASE) is available using server classes asejdbc and aseodbc. The asejdbc server class uses the Adaptive Server JDBC™ driver and the aseodbc server class uses the Adaptive Server ODBC driver. CIS connectivity through aseodbc server class is expected to provide better performance than the asejdbc class. The Adaptive Server ODBC driver requires a separate installation of SDK 15.5 ESD #8 which can be downloaded from the EBF download site.

Related reference
Restrictions