SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-80
DATASOURCES Table
DATASOURCES Table
DATASOURCES is a metadata table in NONSTOP_SQL_nodename.MXCS_SCHEMA
that contains data source information:
Column Name Data Type Description
*1 DS_ID INT Unique identifier for this datasource
description.
2 MAX_SRVR_CNT INT Maximum number of server
instances that must be kept
available for association requests.
3 AVAIL_SRVR_CNT INT Minimum number of server
instances that must be kept
available for association requests.
4 INIT_SRVR_CNT INT Minimum number of server
instances that must be kept
available for association requests.
5 START_AHEAD INT Number of server instances that are
started ahead each time the number
of available servers is less than the
AVAIL_SRVR_CNT.
6 SRVR_IDLE_TIMEOUT LARGEINT Count in seconds indicating the
length of time a server is allowed to
sit idle (no client activity) before the
server initiates disconnect.
7 CONN_IDLE_TIMEOUT LARGEINT Length of time in seconds that a
connection request is allowed to
wait before completing the
connection:
-1 wait forever.
0 do not wait. If a server instance
is not immediately available, refuse
connection requests.
8 REFRESH_RATE LARGEINT Frequency in seconds at which
accumulated statistics are written to
the permanent SQL statistics
table(s).
9 LAST_UPDATED TIMESTAMP(6) Julian timestamp of last update to
this description.
* Indicates primary key