Sybase IQ 12.4.0 installation instructions Gm command line option, Gn command-line option

Page 16

-gm command line option

Adaptive Server IQ 12.4.0

 

The -iqmtswitch is not set by start_asiq on Digital UNIX systems. The setting

 

listed in the Adaptive Server IQ Administration and Performance Guide and

 

the Adaptive Server IQ Installation and Feature Guide is incorrect. The default

 

value is calculated from the number of connections and the number of CPUs,

 

and is usually adequate.

9.1.4 -gm command line option

 

 

The description of the server parameter -gmin the Adaptive Server IQ

 

Reference Manual should read as follows.

 

-gm num

Limit the number of connections to the server that can be active

 

at one time. If this number is greater than the number that is allowed under

 

licensing constraints, it has no effect. The value should approximate the

 

number of users expected to connect to the server.

9.1.5 -gn command-line option

 

 

The -gnserver parameter should be added to Chapter 2 of the Adaptive Server

 

IQ Reference Manual and to “Controlling performance from the command

 

line” in Chapter 2 of the Adaptive Server IQ Administration and Performance

 

Guide.

 

Function

Set the number of execution threads for the Catalog Store.

Syntax

asiqsrv12 -gn integer...

Applies to

All operating systems and servers.

Description

Set the number of execution threads that will be used for the Catalog Store and

 

connectivity while running with multiple users.

On Windows NT you need to specify this parameter in the asiqsrv12 command. To calculate its value use the following formula:

gn_value = gm_value - (( 2 * num_CPUs ) + 10)

Specify a minimum of 25.

On UNIX platforms, the start_asiq Server IQ Installation and Feature information.

utility sets this parameter. See the Adaptive Guide for your platform for more

9.1.6 Using -v switch on 64-bit platforms

16

Release Bulletin for Digital UNIX

Image 16
Contents Release Bulletin Adaptive Server IQ For Digital Unix Product summaryRequired Operating System Patches Required Operating System Patches Adaptive Server IQAdaptive Server IQ Converting 12.0.x databases to RestrictionsRelease Bulletin for Digital Unix Following outer join format is supported Setting the Ldlibrarypath Environment Variable Installation InstructionsDocumentation 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 IQConfirming connections Using Odbc connectivity with UnixAdaptive Server IQ Confirming connections Using a .odbc.ini file Adaptive Server IQ Using a .odbc.ini fileStopasiq 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 PathAddition to Drop Database statement Size clause of Create DbspaceSize clause of Create Dbspace Adaptive Server IQ Recommended index types Changes to Using join indexesAdaptive 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 ColumnsSpiqstatus now displays IQ Page Size Minpasswordlength optionTransaction Log utility Maintaining a transaction log or mirror Setting PrefetchBufferLimit option Error message for buffer cache settingsGrant 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