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

Page 24

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

Image 24

Contents Release Bulletin Adaptive Server IQ For Digital Unix Product summaryRequired Operating System Patches Required Operating System Patches Adaptive Server IQRestrictions Adaptive Server IQ Converting 12.0.x databases toRelease Bulletin for Digital Unix Following outer join format is supported Installation Instructions Setting the Ldlibrarypath Environment VariableDocumentation for this version Accessing Current Release Bulletin Information Special migration instructionsObtaining query plans Go to support.sybase.comChanged functionality in this version Changed functionality in Adaptive Server IQImproved stored procedure output Adaptive Server IQ Known problems Adaptive Server IQ Stopasiq utilityTemporary tables in procedures Data definitionAdaptive Server IQ Queries 1 ANY, SOME, and ALL subquery supportAdaptive Server IQ Operations Large in subqueriesOutput to file in Dbisql Changing length of Dbisql column valuesUser-defined variable issue Dbspawn Error when starting a serverUnsupported terminal types cause Dbisql error User-defined variable issue Adaptive Server IQProblems with Add User-defined Data Type wizard DSE not installed on Windows client systemsAdd Service utility installed only with Server Components Notification message setting omitted from Index PropertiesDocumentation updates and clarifications Product compatibilitiesStartup, shutdown, and connection Data Type column in Table Editor retains focusAdditions to the startasiq or asiqsrv12 command-line options Specifying server switchesGm command line option Gn command-line optionUsing -v switch on 64-bit platforms Gm command line option Adaptive Server IQUsing Odbc connectivity with Unix Confirming connectionsAdaptive Server IQ Confirming connections Using a .odbc.ini file Using a .odbc.ini file Adaptive Server IQStopasiq utility Addition to Stop Database statement Adaptive Server IQ Addition to Stop Database statementError in Dbstop example Configuration files do not accept quotesError in Dbstop example Adaptive Server IQ Disconnect details omittedSwitch must be uppercase Adaptive Server IQ Switch must be uppercaseData definition DDL Change to Create Database statementLowDisk functions as HighGroup Column Limit CorrectionJoint Virtual Table JVT definition IQ database file paths must be uniqueError documenting IQ Path Error in raw partition limitError on Create Dbspace Adaptive Server IQ Error documenting IQ PathSize clause of Create Dbspace Addition to Drop Database statementSize clause of Create Dbspace Adaptive Server IQ Changes to Using join indexes Recommended index typesAdaptive Server IQ Recommended index types Changes to Using join indexes Adaptive Server IQ Id custid idlnameAdaptive Server IQ Changes to Using join indexes Error in Diskstriping default Data manipulation DMLAdaptive Server IQ Default Support for joins between stores or databasesNew and changed general database options New and changed general database options Adaptive Server IQAdaptive Server IQ Description InsertnumberrowsperrawiobufferCorrections to Insert Location Description Adaptive Server IQString function Repeat is supported Correction to Char functionNumber* function not supported Adaptive Server IQ String function Repeat is supportedBackup and system administration Using Isnull and CoalesceUsing Isnull and Coalesce Adaptive Server IQ New options for reserving spaceChange to error message Insufficient disk spaceForced recovery and leaked space recovery Effect of checkpoints Adaptive Server IQStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option Improved output in stored procedures New Stored Procedure ColumnsMinpasswordlength option Spiqstatus now displays IQ Page SizeTransaction Log utility Maintaining a transaction log or mirror Error message for buffer cache settings Setting PrefetchBufferLimit optionGrant Connect for existing user ID Documentation on Data Backup and Recovery Dropping users may delete tablesChanges to Backup statement Cleaning up after abnormal exitMonitoring server activity Using PC client applications Creating attribute tables for PowerBuilderClient applications Help filesTechnical Support Adaptive Server IQ plug-in help reflects Multiplex supportOther sources of information Sybase Certifications on the WebTechinfo.sybase.com