Tuning your environment with the -Dsrv startup parameter

The DataServer (-Dsrv) startup parameter allows you to use special DataServer options to tune your environment. You pass these options as arguments to -Dsrv when connecting to a MS SQL Server database.

There are two versions of the syntax, as follows:

Syntax

CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1 -Dsrv arg2,val2 -Dsrv arg3,val3...

CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1,arg2,val2,arg3,val3...

In this syntax:

The schema holder is already connected.

The data-source-name argument is the name of the data source and the logical-name argument is its logical name, which is defined when you create your schema image.

You pass the options as the argn,valn pairs.

Here is an example of how to use the CONNECT statement with the -Dsrv parameter:

CONNECT mssql_db -ld mydb -U x -P y
-Dsrv qt_debug,EXTENDED
-Dsrv PRGRS_IDBUF,100
-Dsrv PRGRS_MINBUF,10000
-Dsrv MAX_R,10000.

Note that MAX_R is an abbreviation of MAX_ROWS. You can abbreviate option names as long as they identify parameters uniquely.

Both the syntax statements and the example show the use of the -Dsrv startup parameter in CONNECT statements. You can also specify -Dsrv options in a parameter file, on a program item command line, or in the Connection Parameters field in the Database Connect dialog box.