Database Upgrades

Important information about database upgrades.

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

CR#	Description
726782	Drop Servers of Type asejdbc Before Migrating SAP Sybase IQ 12.7 Databases to SAP Sybase IQ 16.0 – The asejdbc server class is deprecated. Servers of type asejdbc must be dropped prior to running iqunload. SAP Sybase IQ 12.7 databases with remote server definitions based on the asejdbc driver will not have these definitions migrated to by the iqunload tool and will not give an error at the beginning of an unload saying that you need to drop any asejdbc servers (if there are any present).
702052	Drop all JOIN and all LD indexes. On multiplex, drop all logical servers named AUTO, COORDINATOR, ALL or DEFAULT – If you do not drop these objects and try to run an ALTER DATABASE UPGRADE in SAP Sybase IQ 16.0, the upgrade fails and the server returns a message that indicates that a database upgrade is not possible when these objects are in use. Recovery Infomation – To recover from a failed upgrade, shutdown the 16.0 server, open the database with SAP Sybase IQ 15.x, and drop all LD and all JOIN indexes as well as any named logical servers before proceeding with the migration.
487858	Upgrade Invalidates Data Source Names – In SAP Sybase IQ 15.x, 32-bit drivers are located in the bin32 directory, instead of win32, and 64-bit drivers are now in the bin64 directory, instead of x64. Therefore, when migrating from 12.x to 15.x, you may need to update registries and applications to locate libraries. For example, win32\dbodbc11.dll is now in bin32. In SAP Sybase IQ 16.0, 64-bit drivers are now in the bin64 directory, instead of x64. Therefore, when migrating from 12.x to 16.0, you may need to update registries and applications to locate libraries. For example, win32\dbodbc12.dll is now in bin32. If upgrading from 15.x to 16.0 the directory names remain the same, but the driver library has changed from dbodbc11.dll (from SAP Sybase IQ 15.0 – 15.3) or dbodbc12.dll (from SAP Sybase IQ 15.4) to dbodbc16.dll.
732621	Cannot Enable Row-level Versioning in Upgraded Database – If you upgrade a database from 15.x to 16.0, you cannot enable row-level versioning (using the ALTER TABLE statement), or perform LOAD, INSERT or UPDATE statements on any IQ base table containing a CHAR, VARCHAR or VARBINARY column of width greater than 255. If your upgraded database contains a table having a column with these criteria, run the sp_iqrebuildindex procedure. After you run this procedure, you can enable row-level versioning and perform DML statements on these large-column tables.