Sybase IQ 12.4.0 Restrictions, Adaptive Server IQ Converting 12.0.x databases to

Models: IQ 12.4.0

1 52
Download 52 pages 23.29 Kb
Page 3
Image 3

Adaptive Server IQ 12.4.0

Converting 12.0.x databases to 12.4.0

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

Converting 12.0.x databases to 12.4.0

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.

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.

Release Bulletin for Digital UNIX

3

Page 3
Image 3
Sybase IQ 12.4.0 Restrictions, Adaptive Server IQ Converting 12.0.x databases to, Release Bulletin for Digital Unix