Sybase IQ 12.4.0 Size clause of Create Dbspace, Addition to Drop Database statement

SIZE clause of CREATE DBSPACE Adaptive Server IQ 12.4.0

in database /tech1/iq/cdrdb.db.

In another session, please issue a CREATE DBSPACE ...

IQ STORE command

and add a dbspace of at least 1000 blocks.

After commit and checkpoint messages, the following error displays:

1999-02-05 16:12:53 0001

Exception Thrown from hos_ion.cxx:170, Err# 4, tid 102 origtid 102

1999-02-05 16:12:53 0001

O/S Err#: 2, ErrID: 522 (hos_ioexception) 1999-02-05 16:12:53 0001 File does not exist.

File: /tech1/iq/cdrdb.iq2 -- (hos_ion.cxx 170)

After many intervening commit and checkpoint messages, the following message displays:

The DBA has added 1 IQ STORE dbspaces to database /tech1/iq/cdrdb.db.

Adaptive Server IQ (TM) is no longer waiting for more dbspace.

1999-02-05 16:14:52 0002 [20902]: Insert completed. Index ’CDR.DBA.CDR_FE_FP_lf’,

These messages are only informational. This is normal behavior as the server verifies that the dbspace does not yet exist, and no action is required. Such messages will be suppressed in a future release.

9.2.10 SIZE clause of CREATE DBSPACE

This clarification affects the Adaptive Server IQ Reference and Adaptive Server

IQ Administration and Performance Guide.

You can only specify SIZE for the IQ Store and IQ Temporary Store, not for the

Catalog Store.

9.2.11 Addition to DROP DATABASE statement

The following information should be added to the DROP DATABASE statement in the Adaptive Server IQ Reference.

The database must be stopped before you can drop it. If the connection parameter AUTOSTOP=no is used, you may need to issue a STOP DATABASE statement.

24 Release Bulletin for Digital UNIX