Sybase IQ 12.4.0 installation instructions Data definition DDL, Switch must be uppercase

Page 21

Adaptive Server IQ 12.4.0

-Z switch must be uppercase

The parameter string in the sample configuration file shown in Chapter 2 of the Adaptive Server IQ Administration and Performance Guide should be corrected to:

-n Elora -c 16M

-x tcpip(port=2367) -gm 10

-gp 4096 path\mydb.db

9.1.15 -Z switch must be uppercase

In Chapter 2 of the Adaptive Server IQ Administration and Performance Guide, in the seventh bulleted item under “What to do if you can't connect to an Adaptive Server IQ database, the -zcommand-line option should be -Z. This switch must always be specified uppercase.

9.2 Data definition (DDL)

9.2.1 Change to CREATE DATABASE statement

The defaults and minimums for the IQ SIZE and TEMPORARY SIZE parameters of CREATE DATABASE, for operating system files only, were stated incorrectly in the Adaptive Server IQ Reference. The default and minimum value depend on IQ PAGE SIZE.

Table 2: Default and minimum sizes of IQ and Temporary Stores

				Minimum
			Minimum	explicit
IQ PAGE	IQ SIZE	TEMPORARY	explicit IQ	TEMPORARY
SIZE	default	SIZE default	SIZE	SIZE

1024	512000	256000	1MB	1MB

2048	512000	256000	1MB	1MB

4096	512000	256000	1MB	1MB

8192	512000	256000	1MB	1MB

16384	1024000	512000	1MB	1MB

32768	2048000	1024000	2MB	1MB

65536	4096000	2048000	4MB	2MB

131072	8192000	4096000	8MB	4MB

262144	16384000	8192000	16MB	8MB

524288	32768000	16384000	32MB	16MB

Release Bulletin for Digital UNIX

21

Image 21

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 Special migration instructions Accessing Current Release Bulletin InformationObtaining query plans Go to support.sybase.comChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problemsData definition Temporary tables in proceduresAdaptive Server IQ Queries 1 ANY, SOME, and ALL subquery supportLarge in subqueries Adaptive Server IQ OperationsOutput to file in Dbisql Changing length of Dbisql column valuesDbspawn Error when starting a server User-defined variable issueUnsupported terminal types cause Dbisql error User-defined variable issue Adaptive Server IQDSE not installed on Windows client systems Problems with Add User-defined Data Type wizardAdd Service utility installed only with Server Components Notification message setting omitted from Index PropertiesProduct compatibilities Documentation updates and clarificationsStartup, shutdown, and connection Data Type column in Table Editor retains focusSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGn command-line option Gm command line optionUsing -v switch on 64-bit platforms Gm command line option Adaptive Server IQUsing 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 statementConfiguration files do not accept quotes Error in Dbstop exampleError in Dbstop example Adaptive Server IQ Disconnect details omittedAdaptive Server IQ Switch must be uppercase Switch must be uppercaseData definition DDL Change to Create Database statementColumn Limit Correction LowDisk functions as HighGroupJoint Virtual Table JVT definition IQ database file paths must be uniqueError in raw partition limit Error documenting IQ PathError on Create Dbspace Adaptive Server IQ Error documenting IQ PathSize 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 LocationCorrection to Char function String function Repeat is supportedNumber* function not supported Adaptive Server IQ String function Repeat is supportedUsing Isnull and Coalesce Backup and system administrationUsing Isnull and Coalesce Adaptive Server IQ New options for reserving spaceInsufficient 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 Creating attribute tables for PowerBuilder Using PC client applicationsClient applications Help filesAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com