Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 3)

Adaptive Server IQ 12.4.0 Converting 12.0.x databases to 12.4.0
Release Bulletin for Digital UNIX 3
To obtain patches, download them from the website at
http://www.service.digital.com/ or contact your Digital representative.
Note These patches require that you rebuild your kernel. You must halt your
system and then boot from the console after the new kernel is put into place.
When installing patches, log in as the “root” (superuser) and follow the
directions provided with the patch. All tasks for adjusting the operating system
configuration must be performed as “root”.
Failure to install the appropriate patches before starting Adaptive Server IQ
requires reinstalling Adaptive Server IQ.
2. Restrictions
Read this section! Your system may produce unexpected results if you ignore
the restrictions and other instructions listed below.
If you are upgrading from version 11.x to 12.4.0, see chapter 3 of the Adaptive
Server IQ Installation and Feature Guide for further restrictions.
Converting 12.0.x
databases to 12.4.0 Before you can use a database created with earlier versions of Adaptive Server
IQ, you must run the script upgrasiq.sql, located in the $ASDIR/scripts
directory. For example, to update a database named old.db:
% dbisql -c "uid=dba;pwd=sql;dbn=old;eng=servername"
$ASDIR/scripts/upgrasiq.sql
If you do not run this script, errors like the following may occur when you use
certain front end tools with the ODBC driver to import or link to a table:
The operation failed. There are too many indexes
on table ’amadbdbo_midtown’.
Delete some of the indexes on the table
and try the operation again.