Sybase IQ 12.4.0 Server User Manual


 
Adaptive Server IQ 12.4.0 -Z switch must be uppercase
Release Bulletin for Digital UNIX 21
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
-z command-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
IQ PAGE
SIZE
IQ SIZE
default
TEMPORARY
SIZE default
Minimum
explicit IQ
SIZE
Minimum
explicit
TEMPORARY
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