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 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.
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
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.
<set-property property="http.port" value="8282" /> <set-property property="https.port" value="8283" />
<set-property property="port" value="9999"/>
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.
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.
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.
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.