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.3 has a new procedure for installation. The Sybase IQ 15.3 interactive installer is a standard graphical installation wizard. The interactive installer supports all product editions and installation types. A silent installation option is also available. See Installation and Configuration Guide > Server Installations > Installing Server Software.
Sybase IQ 15.3 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.
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 on existing databases after installing Sybase IQ 15.3.
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 Sybase EBF download site.
The LOAD_MEMORY_MB option has been deprecated. Instead of setting LOAD_MEMORY_MB, you must now adjust the IQ temporary cache setting. The amount to increase the IQ temporary cache is approximately the sum of all the LOAD_MEMORY_MB settings of all of the concurrent LOAD TABLE executions.