SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-77
MXCS Metadata Tables
MXCS Metadata Tables
ASSOC2DS Table
ASSOC2DS is a metadata table in NONSTOP_SQL_nodename.MXCS_SCHEMA that
associates the MXCS service to a data source:
Column Name Data Type Description
*1 ASSOC_ID INT Unique identifier for association
service description.
*2 DS_ID INT Unique identifier for datasource
description.
3 AUTOMATION SMALLINT 0 data source is started manually.
1 data source is started
automatically.
4 CURRENT_STATUS SMALLINT Current state of a data source
defined for this association
services: 0 STOPPED
1 STOPPING
2 STARTING
3 STARTED
5 DEFAULT_TYPE SMALLINT System default MXCS service.
6 LAST_STATUS_CHANGE TIMESTAMP(6) Julian timestamp of last time
change to the data source status.
7 LAST_UPDATED TIMESTAMP(6) Julian timestamp of the last update
to this description.
* Indicates primary key