HP NonStop G-Series Uživatelská příručka stáhnout pdf (Strana 62)

Object DS Commands

SQL/MX Connectivity Service Administrative Command Reference—526350-005

5-8

ALTER DS

This command is similar to the ADD DS command, except ALTER DS modifies the

attributes of an existing DS in the MXCS configuration on one system.

Command syntax is:

obj-name

[[[\system-name.][$service-name | *].]ds-name]

system-name

is the name of the current system of up to 16 CPUs with the same Expand

address and where the target MXCS process is running. system-name and

service-name identify one service instance.

service-name

is the name of the MXCS association server that handles or processes the

command or the asterisk (*) wild card. Most changes effect the DS on all

services in either case. An asterisk (*) causes connection to the database

rather than to any specific service, and it is the only valid value when no

services are active.

ds-name

is the name of the DS to be modified and cannot be the asterisk (*) wild card.

MaxServer count

is the upper limit on the servers that are operational for this service on this DS.

Valid values are 0 through the total number of ports allowed minus 3. See

documentation on the MXOAS command for the total number of ports allowed. The

practical limit can be different for each service and is often in the range of 20 to

500. A value of 0 gives the system default, which is a value determined by the

system at run time.

ALTER DS [obj-name]

[, MaxServer count][, IdleServer count][, InitServer count]

[, IdleTimeout timeout-val][, ConnTimeout timeout-val]

[, StartAutomatic [OFF]][, InitPri priority-val]

[, Trace [OFF]][, CpuList cpu-val][, AllStat [OFF]]

[, SQLExecuteStat [OFF]][, SQLExecDirectStat [OFF]]

[, SQLStmtStat [OFF]][, SQLFetchStat [OFF]]

[, SQLPrepareStat [OFF]][, SessionInfoStat [OFF]]

[, ConnInfoStat [OFF]];

Note. ds-name is an SQL identifier and is therefore case-sensitive. When using lowercase

characters, enclose ds-name in quotes to preserve the lowercase characters. Failure to do so

causes ds-name to be automatically uppercased during command execution, which can cause

errors. Enter the default ds-name as

"TMD_Default_DataSource".

1 2 ... 57 58 59 60 61 62 63 64 65 66 67 ... 102 103

Žádné komentáře

HP NonStop G-Series Uživatelská příručka Strana 62