Sybase IQ 12.4.0 Error documenting IQ Path, Error in raw partition limit, Error on Create Dbspace

Page 23

Adaptive Server IQ 12.4.0

Error documenting IQ PATH

Specify a different pathname (for example, /iqfiles/main/iq and /iqfiles/temp/iq or different raw partitions

Omit TEMPORARY PATH when you create the database. In this case, the temporary store is created in the same path as the Catalog Store, with the default name and extension dbname.iqtmp where dbname is the database name.

Warning! On UNIX platforms, you must be careful not to specify filenames that are links to the same file. IQ cannot detect where linked files point to. If the filenames in the command differ but they point to the same file, your database will be corrupted.

In Sybase Central, the Create Database utility fails if you do not provide extensions for file names. The Introduction to Adaptive Server IQ fails to mention this and also does not mention that file extensions are needed when operating system files are used.

9.2.7 Error documenting IQ PATH

In Chapter 3 of the Adaptive Server IQ Administration and Performance Guide, the example shown in the section titled “Specifying an IQ PATH” should be corrected. The example shows where Adaptive Server IQ puts the message and log files when you do not specify the Temporary and Message PATHS. It should read:

The Temporary Store is in /disk1/iqdata/company.iqtmp

The IQ message log file is in /disk1/iqdata/company.iqmsg

9.2.8 Error in raw partition limit

The Adaptive Server IQ Reference contains an error in the CREATE DATABASE statement description of the IQ PATH clause. The statement that raw partitions cannot be larger than 2GB is incorrect. The current limit is 128GB per file or dbspace, with a limit of 2047 dbspaces.

9.2.9 Error on CREATE DBSPACE

The CREATE DBSPACE command may occasionally return the following message:

1999-02-05 16:09:45 0002 [20152]: You have run out of IQ STORE dbspace

Release Bulletin for Digital UNIX

23

Image 23
Contents Product summary Release Bulletin Adaptive Server IQ For Digital UnixRequired Operating System Patches Adaptive Server IQ Required Operating System PatchesRelease Bulletin for Digital Unix RestrictionsAdaptive Server IQ Converting 12.0.x databases to Following outer join format is supported Documentation for this version Installation InstructionsSetting the Ldlibrarypath Environment Variable Go to support.sybase.com Accessing Current Release Bulletin InformationSpecial migration instructions Obtaining query plansChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problems1 ANY, SOME, and ALL subquery support Temporary tables in proceduresData definition Adaptive Server IQ QueriesChanging length of Dbisql column values Adaptive Server IQ OperationsLarge in subqueries Output to file in DbisqlUser-defined variable issue Adaptive Server IQ User-defined variable issueDbspawn Error when starting a server Unsupported terminal types cause Dbisql errorNotification message setting omitted from Index Properties Problems with Add User-defined Data Type wizardDSE not installed on Windows client systems Add Service utility installed only with Server ComponentsData Type column in Table Editor retains focus Documentation updates and clarificationsProduct compatibilities Startup, shutdown, and connectionSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGm command line option Adaptive Server IQ Gm command line optionGn command-line option Using -v switch on 64-bit platformsAdaptive Server IQ Confirming connections Using Odbc connectivity with UnixConfirming connections Stopasiq utility Using a .odbc.ini fileUsing a .odbc.ini file Adaptive Server IQ Adaptive Server IQ Addition to Stop Database statement Addition to Stop Database statementDisconnect details omitted Error in Dbstop exampleConfiguration files do not accept quotes Error in Dbstop example Adaptive Server IQChange to Create Database statement Switch must be uppercaseAdaptive Server IQ Switch must be uppercase Data definition DDLIQ database file paths must be unique LowDisk functions as HighGroupColumn Limit Correction Joint Virtual Table JVT definitionAdaptive Server IQ Error documenting IQ Path Error documenting IQ PathError in raw partition limit Error on Create DbspaceSize clause of Create Dbspace Adaptive Server IQ Size clause of Create DbspaceAddition to Drop Database statement Adaptive Server IQ Recommended index types Changes to Using join indexesRecommended index types Id custid idlname Changes to Using join indexes Adaptive Server IQAdaptive Server IQ Changes to Using join indexes Data manipulation DML Error in Diskstriping defaultSupport for joins between stores or databases Adaptive Server IQ DefaultNew and changed general database options Adaptive Server IQ New and changed general database optionsInsertnumberrowsperrawiobuffer Adaptive Server IQ DescriptionDescription Adaptive Server IQ Corrections to Insert LocationAdaptive Server IQ String function Repeat is supported String function Repeat is supportedCorrection to Char function Number* function not supportedNew options for reserving space Backup and system administrationUsing Isnull and Coalesce Using Isnull and Coalesce Adaptive Server IQInsufficient disk space Change to error messageEffect of checkpoints Adaptive Server IQ Forced recovery and leaked space recoveryStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option New Stored Procedure Columns Improved output in stored proceduresTransaction Log utility Minpasswordlength optionSpiqstatus now displays IQ Page Size Maintaining a transaction log or mirror Grant Connect for existing user ID Error message for buffer cache settingsSetting PrefetchBufferLimit option Dropping users may delete tables Documentation on Data Backup and RecoveryCleaning up after abnormal exit Changes to Backup statementMonitoring server activity Help files Using PC client applicationsCreating attribute tables for PowerBuilder Client applicationsAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com