Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table G_DSS_CFG_PROVIDER


The control table for the cfg role, which stores configuration-related information. The data source is Configuration Server.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column Data Type P M F Description

DSS_ID

INTEGER X X The data source session ID. Refer to the GSYS_DOMAIN field in all corresponding operational tables.

ICON_DBID

INTEGER X X The DBID of the ICON instance that created this record.

DS_DBID

INTEGER The DBID of the data source to which ICON connected.

DS_DBID_PRIM

INTEGER The DBID of the primary data source server (if defined in the Configuration Layer).

DS2_DBID

INTEGER The DBID of the Switch for the T-Server or Interaction Server.

DS_TYPE

INTEGER The type of data source server: 4 = Configuration Server

ICON_STIME

TIMESTAMP The timestamp when ICON was started.

DSCONN_STIME

TIMESTAMP The timestamp when connection to the data source server was established.

DSCONN_SDSTIME

TIMESTAMP The data source server timestamp when the connection to ICON was established. If the data source server timestamp is not available, the ICON timestamp is used.

DSCONN_SDSTS

INTEGER The UTC-equivalent value of the DSCONN_SDSTIME field.

DSCONN_TYPE

INTEGER The type of connection:
  • 1—First connection
  • 2—Reconnect
  • 5—Data source server switchover

ICON_ETIME

TIMESTAMP The timestamp when ICON shut down.

DSCONN_ETIME

TIMESTAMP The timestamp when the data source server disconnected.

FEVENT_ITIME

TIMESTAMP The timestamp of the first event for which data was stored on the connection (ICON time).

FEVENT_DSTIME

TIMESTAMP The timestamp of the first event for which data was stored on the connection (time from the data source server event).

FEVENT_DSSEQ

VARCHAR(255) The event sequence number of the first event for which data was stored on the connection (sequence number from the data source server event).

FEVENT_CSEQ

BIGINT The transaction ID (CSEQ) of data storage for the first stored event on the connection.

FEVENT_DSUTC

INTEGER The UTC-equivalent value of the FEVENT_DSTIME field.

LEVENT_ITIME

TIMESTAMP The timestamp of the last event for which data was stored on the connection (ICON time).

LEVENT_DSTIME

TIMESTAMP The timestamp of the last event for which data was stored on the connection (time from the data source server event).

LEVENT_DSSEQ

VARCHAR(255) The event sequence number of the last event for which data was stored on the connection (sequence number from the data source server event).

LEVENT_CSEQ

BIGINT The transaction ID (CSEQ) of data storage for the last stored event on the connection.

LEVENT_DSUTC

INTEGER The UTC-equivalent value of the LEVENT_DSTIME field.

NODATA_IUTC

INTEGER The UTC equivalent of the ICON timestamp in situations in which no data is received during a predefined time interval. The value of the time interval is 5 minutes.

ICON_DBID_PRIM

INTEGER The DBID of the Primary ICON. Currently not used (reserved).

DS_VERSION

VARCHAR(255) Reserved

CFG_SERVER

VARCHAR(255) Reserved

R_CREATE_DBLT

TIMESTAMP The timestamp for record creation (IDB local time).

R_UPDATE_DBLT

TIMESTAMP The timestamp of record update when event data changes (IDB local time).

R_CREATE_UTC

INTEGER The UTC-equivalent value of the R_CREATE_DBLT field.

R_UPDATE_UTC

INTEGER The UTC-equivalent value of the R_UPDATE_DBLT field when event data changes.

EXT_INT1

BIGINT Reserved

EXT_INT2

BIGINT Reserved

EXT_INT3

BIGINT Reserved

EXT_VCH1

VARCHAR(255) Reserved

EXT_VCH2

VARCHAR(255) Reserved

EXT_VCH3

VARCHAR(255) Reserved

   

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on October 31, 2016, at 15:08.