Sybase IQ 12.4.0 installation instructions Techinfo.sybase.com

Page 51

techinfo.sybase.com

2In the Browse section, click on the What’s Hot entry.

3Explore your area of interest: Hot Docs covering various topics, or Hot Links to Technical News, Certification Reports, Partner Certifications, and so on.

If you are a registered SupportPlus user:

1Point your Web browser to Technical Documents at the following Web site:

techinfo.sybase.com

2In the Browse section, click on the What’s Hot entry.

3Click on the EBF Rollups entry.

You can research EBFs using Technical Documents, and you can download EBFs using Electronic Software Distribution (ESD).

4Follow the instructions associated with the SupportPlusSM Online Services entries.

If you are not a registered SupportPlus user and you want to become one:

You can register by following the instructions on the Web. To use SupportPlus, you need:

1A Web browser that supports the Secure Sockets Layer (SSL), such as Netscape Navigator 1.2 or later

2An active support license

3A named technical support contact

4Your user ID and password

Whether or not you are a registered SupportPlus user

You can use Sybase’s Technical Documents. Certification Reports are among the features documented at this site

1Point your Web browser to Technical Documents at the following Web site techinfo.sybase.com

2In the Browse section, click on the What’s Hot entry.

3Click on the topic that interests you.

51

Image 51
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