Sybase IQ 12.4.0 installation instructions Required Operating System Patches

Page 2

Required Operating System Patches

Adaptive Server IQ 12.4.0

Digital Unix V4.0f

Note The product name Digital UNIX has recently been changed to Tru64

UNIX. However the Adaptive Server IQ documentation still uses the old

Digital UNIX name.

The following operating system command shows the level of your base system software:

% sizer -v

Tru64 UNIX V4.0D (Rev. 878); Wed Jul 15 12:31:49 EDT 1998

Adaptive Server IQ 12.4.0 has been built to take advantage of certain performance features found in the Digital Alpha EV5.6 (21164A) and later chip architecture.

1.1 Required Operating System Patches

You must install the patches listed in this section to run Adaptive Server IQ on

Digital UNIX.

Digital UNIX V4.0d requires the March 1998 patch kit as the absolute minimum.

Normally, it is best to install the latest patch kit. However, as of Adaptive Server IQ 12.4.0 certification, the latest patch kits contain a problem in the pthreads library which causes a one to two times performance slowdown in Adaptive Server IQ, most notably in loads and multi-user activity. For this reason, you should avoid using those patches and use the previous patch kits. The following table shows you which kits to avoid (the middle column) and which you should use (the last column).

For this operating

Do NOT use this patch

 

system version

kit

Use this patch kit

 

 

 

DUNIX 4.0D

duv40das0004-

duv40das00003-

 

19990723

19990208

 

 

 

DUNIX 4.0E

duv40eas0002-

duv40eas00001-

 

19990617

19990202

 

 

 

DUNIX 4.0F

duv40fas0001-

None required

 

19990609

 

 

 

 

This problem should be resolved in the next release of these patch kits.

2

Release Bulletin for Digital UNIX

Image 2
Contents Release Bulletin Adaptive Server IQ For Digital Unix Product summaryRequired Operating System Patches Required Operating System Patches Adaptive Server IQRelease Bulletin for Digital Unix RestrictionsAdaptive Server IQ Converting 12.0.x databases to Following outer join format is supported Documentation for this version Installation InstructionsSetting the Ldlibrarypath Environment Variable Obtaining query plans Accessing Current Release Bulletin InformationSpecial migration instructions Go to support.sybase.comChanged functionality in this version Changed functionality in Adaptive Server IQImproved stored procedure output Adaptive Server IQ Known problems Adaptive Server IQ Stopasiq utilityAdaptive Server IQ Queries Temporary tables in proceduresData definition 1 ANY, SOME, and ALL subquery supportOutput to file in Dbisql Adaptive Server IQ OperationsLarge in subqueries Changing length of Dbisql column valuesUnsupported terminal types cause Dbisql error User-defined variable issueDbspawn Error when starting a server User-defined variable issue Adaptive Server IQAdd Service utility installed only with Server Components Problems with Add User-defined Data Type wizardDSE not installed on Windows client systems Notification message setting omitted from Index PropertiesStartup, shutdown, and connection Documentation updates and clarificationsProduct compatibilities Data Type column in Table Editor retains focusAdditions to the startasiq or asiqsrv12 command-line options Specifying server switchesUsing -v switch on 64-bit platforms Gm command line optionGn command-line option Gm command line option Adaptive Server IQAdaptive Server IQ Confirming connections Using Odbc connectivity with UnixConfirming connections Stopasiq utility Using a .odbc.ini fileUsing a .odbc.ini file Adaptive Server IQ Addition to Stop Database statement Adaptive Server IQ Addition to Stop Database statementError in Dbstop example Adaptive Server IQ Error in Dbstop exampleConfiguration files do not accept quotes Disconnect details omittedData definition DDL Switch must be uppercaseAdaptive Server IQ Switch must be uppercase Change to Create Database statementJoint Virtual Table JVT definition LowDisk functions as HighGroupColumn Limit Correction IQ database file paths must be uniqueError on Create Dbspace Error documenting IQ PathError in raw partition limit Adaptive Server IQ Error documenting IQ PathSize clause of Create Dbspace Adaptive Server IQ Size clause of Create DbspaceAddition to Drop Database statement Adaptive Server IQ Recommended index types Changes to Using join indexesRecommended index types Changes to Using join indexes Adaptive Server IQ Id custid idlnameAdaptive Server IQ Changes to Using join indexes Error in Diskstriping default Data manipulation DMLAdaptive Server IQ Default Support for joins between stores or databasesNew and changed general database options New and changed general database options Adaptive Server IQAdaptive Server IQ Description InsertnumberrowsperrawiobufferCorrections to Insert Location Description Adaptive Server IQNumber* function not supported String function Repeat is supportedCorrection to Char function Adaptive Server IQ String function Repeat is supportedUsing Isnull and Coalesce Adaptive Server IQ Backup and system administrationUsing Isnull and Coalesce New options for reserving spaceChange to error message Insufficient disk spaceForced recovery and leaked space recovery Effect of checkpoints Adaptive Server IQStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option Improved output in stored procedures New Stored Procedure ColumnsTransaction Log utility Minpasswordlength optionSpiqstatus now displays IQ Page Size Maintaining a transaction log or mirror Grant Connect for existing user ID Error message for buffer cache settingsSetting PrefetchBufferLimit option Documentation on Data Backup and Recovery Dropping users may delete tablesChanges to Backup statement Cleaning up after abnormal exitMonitoring server activity Client applications Using PC client applicationsCreating attribute tables for PowerBuilder Help filesTechnical Support Adaptive Server IQ plug-in help reflects Multiplex supportOther sources of information Sybase Certifications on the WebTechinfo.sybase.com