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

Page 21
Image 21
Sybase IQ 12.4.0 Data definition DDL, Switch must be uppercase, Change to Create Database statement