Sybase IQ 12.4.0 Server User Manual


 
SIZE clause of CREATE DBSPACE Adaptive Server IQ 12.4.0
24
Release Bulletin for Digital UNIX
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.