Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 22)

MESSAGE PATH Adaptive Server IQ 12.4.0
22 Release Bulletin for Digital UNIX
9.2.2 MESSAGE PATH
In the MESSAGE PATH clause of CREATE DATABASE you must specify an
operating system file. The message file cannot be on a raw partition. This is a
correction to the Adaptive Server IQ Reference.
9.2.3 Low_Disk functions as High_Group
LD (Low_Disk) has been changed to function like HG (High_Group). It is no
longer supported by a separate index and therefore does not offer any benefit
beyond using HG. LD is still a valid syntax and may be used for compatibility
with older versions.
9.2.4 Column Limit Correction
In Chapter 13 of the Adaptive Server IQ Reference the limit is incorrectly
specified as 999 columns. The correct limit is 10,000 columns.
9.2.5 Joint Virtual Table (JVT) definition
A Join Virtual Table is a denormalized table which looks like a regular table; it
has a name, columns, rows, and indexes. Unlike a regular table, however, a
JVT cannot be created, modified or deleted by the user. It is created by
Adaptive Server IQ as a result of a Create Join Index for internal processing
purposes. It is deleted when the user does a Drop Join Index.
Error messages relating to join virtual tables appear only when a user tries to
use or modify a JVT directly.
9.2.6 IQ database file paths must be unique
When you create a database or a dbspace, the path for the Temporary Store
must differ from the path for the IQ Store. If your
CREATE DATABASE or
CREATE DBSPACE command specifies the identical path and filename for
these two stores, you receive an error. This requirement was omitted from the
Adaptive Server IQ Reference and the Adaptive Server IQ Administration and
Performance Guide.
You can cause a unique path in any of these ways:
• Specify a different extension for each file (for example, mydb.iq and
mydb.iqtmp)
• Specify a different file name (for example, mydb.iq and mytmp.iq)