Jump to: navigation, search

In the Column List:

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

Table G_DSS_GUD_PROVIDER


The control table for the gud role, which stores data that pertains to attached data associated with interactions. The data sources are T-Server and Interaction Server.

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:
  • 1—T-Server
  • 2—Interaction 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
  • 3—Data source server restart (when possible)
  • 4—Switch reconnection (when possible)
  • 5—Switchover (when possible)

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 31 October 2016, at 16:08.