Neoview Command Interface (NCI) Guide (R2.5)

C Connectivity Commands
This appendix describes the connectivity commands that you can run interactively or in script
files in NCI.
NOTE: NCI supports connectivity commands in SQL mode, provided that you run CMDOPEN
beforehand. After you run CMDOPEN, NCI recognizes only connectivity commands at the SQL>
prompt and does not recognize SQL statements. To end CMDOPEN's effect on the session and
to be able run SQL statements, run CMDCLOSE. For more information, see the “CMDOPEN
Command” (page 167) and the “CMDCLOSE Command” (page 168).
ADD DS Command
The ADD DS command adds a data source with the specified attributes to the Neoview Data
Connectivity Service (NDCS) configuration. A data source is a named collection of connection
attributes for the NDCS servers, which manage the client-server connections.
Syntax
ADD DS data-source-name[, MAXSERVER count]
[, AVAILSERVER count]
[, INITSERVER count]
[, SRVRIDLETIMEOUT timeout-value]
[, CONNTIMEOUT timeout-value]
timeout-value is:
SYSTEM_DEFAULT | "-1" | "num-minutes"
data-source-name
is the name of the data source to be created. data-source-name is case-sensitive and cannot
be the asterisk (*) wild card. It must be a new name, or the command fails.
MAXSERVER count
is the maximum number of NDCS servers that the NDCS service can start for this data source.
The default value is 1. Valid values are 0 through the total number of ports allowed, which
is 1000 by default, minus 3. A value of 0 specifies the system default, which is a value
determined by the system at run time. The MAXSERVER limit can be different for each NDCS
service and is often in the range of 20 through 500.
AVAILSERVER count
is the number of NDCS servers that the NDCS service keeps in the available state. Valid
values are 0 through the MAXSERVER count, with 0 as the default. This count represents
idle servers that are waiting for user connections.
After peak user loads, idle servers are terminated to the AVAILSERVER count value.
INITSERVER count
is the number of NDCS servers that the NDCS service starts for the data source when the
data source is started. Valid values are from 0 to the smaller of either 200 or the value specified
by MAXSERVER count. The default value is 0. This value cannot exceed the MAXSERVER
count.
To permit servicing incoming users, the data source goes to the STARTED state as soon as
the first server starts. These servers count as idle if they are not allocated to new users
immediately.
NOTE: If you set the STARTAHEAD value, the NDCS service ignores this value and does
not use it. Instead, you should set the INITSERVER value. The NDCS service uses the
INITSERVER value instead of STARTAHEAD.
ADD DS Command 155