Sybase IQ 12.4.0 用户手册

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.

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.

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.