Sybase ADAPTIVE SERVER IQ 12.4.0 Manual do Utilizador

Copyright 1989-1999 by Sybase, Inc. All rights reserved. Sybase, the Sybase logo, Data Workbench, InfoMaker, PowerBuilder, Powersoft, SQL Advantage,

Data definition Adaptive Server IQ 12.4.010 Release Bulletin for Digital UNIX 7.1 Data definitionThis section reports pr

Adaptive Server IQ 12.4.0 Large IN subqueriesRelease Bulletin for Digital UNIX 11•= ALL•!

User-defined variable issue Adaptive Server IQ 12.4.012 Release Bulletin for Digital UNIXTo avoid truncated output, incr

Adaptive Server IQ 12.4.0 Sybase CentralRelease Bulletin for Digital UNIX 13 7.4 Sybase C

Data Type column in Table Editor retains focus Adaptive Server IQ 12.4.014 Release Bulletin for Digital UNIXWhen you use

Adaptive Server IQ 12.4.0 Additions to the start_asiq or asiqsrv12 command-line optionsRelease Bulletin for Digital UNIX

-gm command line option Adaptive Server IQ 12.4.016 Release Bulletin for Digital UNIXThe -iqmt switch is not set by star

Adaptive Server IQ 12.4.0 Confirming connectionsRelease Bulletin for Digital UNIX 17The f

Using a .odbc.ini file Adaptive Server IQ 12.4.018 Release Bulletin for Digital UNIXIf Adaptive Server IQ does not detec

Adaptive Server IQ 12.4.0 Addition to STOP DATABASE statementRelease Bulletin for Digital UNIX

Required Operating System Patches Adaptive Server IQ 12.4.02 Release Bulletin for Digital UNIX• Digital Unix V4.0fNote

Error in DBSTOP example Adaptive Server IQ 12.4.020 Release Bulletin for Digital UNIXThe following information should be

Adaptive Server IQ 12.4.0 -Z switch must be uppercaseRelease Bulletin for Digital UNIX 21

MESSAGE PATH Adaptive Server IQ 12.4.022 Release Bulletin for Digital UNIX 9.2.2 MESSAGE PATHIn the MESSAGE PATH clause

Adaptive Server IQ 12.4.0 Error documenting IQ PATHRelease Bulletin for Digital UNIX 23•

SIZE clause of CREATE DBSPACE Adaptive Server IQ 12.4.024 Release Bulletin for Digital UNIXin database /tech1/iq/cdrdb.d

Adaptive Server IQ 12.4.0 Recommended index typesRelease Bulletin for Digital UNIX 25 9.2

Changes to “Using join indexes” Adaptive Server IQ 12.4.026 Release Bulletin for Digital UNIXIf the join column is made

Adaptive Server IQ 12.4.0 Changes to “Using join indexes”Release Bulletin for Digital UNIX

Error in DISK_STRIPING default Adaptive Server IQ 12.4.028 Release Bulletin for Digital UNIX 9.3 Error in DISK_STRIPING

Adaptive Server IQ 12.4.0 DefaultRelease Bulletin for Digital UNIX 29DefaultONDescription

Adaptive Server IQ 12.4.0 Converting 12.0.x databases to 12.4.0Release Bulletin for Digital UNIX

New and changed general database options Adaptive Server IQ 12.4.030 Release Bulletin for Digital UNIX• In order to join

Adaptive Server IQ 12.4.0 DescriptionRelease Bulletin for Digital UNIX 31DescriptionThis

Description Adaptive Server IQ 12.4.032 Release Bulletin for Digital UNIXDescriptionFor joins within a query, the IQ opt

Adaptive Server IQ 12.4.0 String function REPEAT is supportedRelease Bulletin for Digital UNIX

Using ISNULL() and COALESCE() Adaptive Server IQ 12.4.034 Release Bulletin for Digital UNIXThe NUMBER(*) function is not

Adaptive Server IQ 12.4.0 DefaultRelease Bulletin for Digital UNIX 35Default1DescriptionT

Effect of checkpoints Adaptive Server IQ 12.4.036 Release Bulletin for Digital UNIXTemporary IQ Blocks Used:,163 of 6144

37• Incremental backups are disabled After the database is opened in forced recovery mode, incremental backups are disabled. The next backup must be a

38 To verify that the data is not corrupt and set the database storage to its actual value, you start the server with the -iqdroplks switch and connec

39Running sp_iqcheckdbIn order to recover leaked storage within a database, first start the server with the -iqdroplks switch in the asiqsrv12 command

Insert into table from remote SQL database not supported Adaptive Server IQ 12.4.04 Release Bulletin for Digital UNIXYou

40 The dbcc_option settings of 0 and 3, when combined with the server option -iqdroplks, update the free list if no errors are detected. In order to p

41ExampleAssume that the DBA cannot successfully open and connect to database foo, because of reported IQ errors during database open and recovery. To

42 9.5.6 SP_IQSTATUS now displays IQ Page SizeThe sp_iqstatus stored procedure now displays the IQ page size in addition to the block size. For examp

43When you use the RESTORE statement to move and/or rename a database, you can rename all of the files except the transaction log. Transactions contin

44 Set the name of the transaction log file (-t ) This option sets a filename, including an optional directory path, for a new transaction log. If the

45The same command can also be used to add a new user. For this reason, if you inadvertently enter the user ID of an existing user when you mean to ad

46 9.5.14 Changes to BACKUP statementIn the Adaptive Server IQ Reference, the SIZE and STACKER option descriptions in the BACKUP statement should re

47ipcrm -m mid1 -m mid2 ... -s sid1 -s sid2 ...For example:% ipcrm -m 40965 -s 5130 -s36682 9.5.16 Monitoring server activityIt may be helpful, especi

48 9.6 Client applications 9.6.1 ODBC AutoPreCommit omittedThe ODBC AutoPreCommit option was omitted from the Adaptive Server IQ Reference. Turning t

49 9.7.1 Adaptive Server IQ plug-in help reflects Multiplex supportAdaptive Server IQ Multiplex 12.4.0 is a separate product from Adaptive Server IQ 1

Adaptive Server IQ 12.4.0 Setting the LD_LIBRARY_PATH Environment VariableRelease Bulletin for Digital UNIX

50 • Output from sp_iqstatus procedureYou may find additional help from the Sybase online support database, MySupport. MySupport lets you search throu

51techinfo.sybase.com2 In the Browse section, click on the What’s Hot entry.3 Explore your area of interest: Hot Docs covering various topics, or Hot

52

Accessing Current Release Bulletin Information Adaptive Server IQ 12.4.06 Release Bulletin for Digital UNIXDepending on

Adaptive Server IQ 12.4.0 Changed functionality in Adaptive Server IQ 12.4.0Release Bulletin for Digital UNIX

Improved stored procedure output Adaptive Server IQ 12.4.08 Release Bulletin for Digital UNIX• Improved stored procedure

Adaptive Server IQ 12.4.0 stop_asiq utilityRelease Bulletin for Digital UNIX 9•-iqmc sets