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

Page 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

Image 3
Contents Product summary Release Bulletin Adaptive Server IQ For Digital UnixRequired Operating System Patches Adaptive Server IQ Required Operating System PatchesRestrictions Adaptive Server IQ Converting 12.0.x databases toRelease Bulletin for Digital Unix Following outer join format is supported Installation Instructions Setting the Ldlibrarypath Environment VariableDocumentation for this version Go to support.sybase.com Accessing Current Release Bulletin InformationSpecial migration instructions Obtaining query plansChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problems1 ANY, SOME, and ALL subquery support Temporary tables in proceduresData definition Adaptive Server IQ QueriesChanging length of Dbisql column values Adaptive Server IQ OperationsLarge in subqueries Output to file in DbisqlUser-defined variable issue Adaptive Server IQ User-defined variable issueDbspawn Error when starting a server Unsupported terminal types cause Dbisql errorNotification message setting omitted from Index Properties Problems with Add User-defined Data Type wizardDSE not installed on Windows client systems Add Service utility installed only with Server ComponentsData Type column in Table Editor retains focus Documentation updates and clarificationsProduct compatibilities Startup, shutdown, and connectionSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGm command line option Adaptive Server IQ Gm command line optionGn command-line option Using -v switch on 64-bit platformsUsing Odbc connectivity with Unix Confirming connectionsAdaptive Server IQ Confirming connections Using a .odbc.ini file Using a .odbc.ini file Adaptive Server IQStopasiq utility Adaptive Server IQ Addition to Stop Database statement Addition to Stop Database statementDisconnect details omitted Error in Dbstop exampleConfiguration files do not accept quotes Error in Dbstop example Adaptive Server IQChange to Create Database statement Switch must be uppercaseAdaptive Server IQ Switch must be uppercase Data definition DDLIQ database file paths must be unique LowDisk functions as HighGroupColumn Limit Correction Joint Virtual Table JVT definitionAdaptive Server IQ Error documenting IQ Path Error documenting IQ PathError in raw partition limit Error on Create DbspaceSize clause of Create Dbspace Addition to Drop Database statementSize clause of Create Dbspace Adaptive Server IQ Changes to Using join indexes Recommended index typesAdaptive Server IQ Recommended index types Id custid idlname Changes to Using join indexes Adaptive Server IQAdaptive Server IQ Changes to Using join indexes Data manipulation DML Error in Diskstriping defaultSupport for joins between stores or databases Adaptive Server IQ DefaultNew and changed general database options Adaptive Server IQ New and changed general database optionsInsertnumberrowsperrawiobuffer Adaptive Server IQ DescriptionDescription Adaptive Server IQ Corrections to Insert LocationAdaptive Server IQ String function Repeat is supported String function Repeat is supportedCorrection to Char function Number* function not supportedNew options for reserving space Backup and system administrationUsing Isnull and Coalesce Using Isnull and Coalesce Adaptive Server IQInsufficient disk space Change to error messageEffect of checkpoints Adaptive Server IQ Forced recovery and leaked space recoveryStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option New Stored Procedure Columns Improved output in stored proceduresMinpasswordlength option Spiqstatus now displays IQ Page SizeTransaction Log utility Maintaining a transaction log or mirror Error message for buffer cache settings Setting PrefetchBufferLimit optionGrant Connect for existing user ID Dropping users may delete tables Documentation on Data Backup and RecoveryCleaning up after abnormal exit Changes to Backup statementMonitoring server activity Help files Using PC client applicationsCreating attribute tables for PowerBuilder Client applicationsAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com