Neoview Repository User Guide (R2.4 SP1)

Table 3-8 ODBC_SESSION_STATS_V2 Fields
Source and
NotesData TypeIncomplete SessionsComplete Sessions
STARTCHAR(10)SEGMENT_NAMESEGMENT_NAME
STARTINTEGER UNSIGNEDSEGMENT_IDSEGMENT_ID
STARTINTEGER UNSIGNEDNODE_IDNODE_ID
STARTINTEGER UNSIGNEDPINPIN
END, or
NULL for an
incomplete
session
SMALLINT UNSIGNEDSTART_PRIORITYSTART_PRIORITY
STARTCHAR(18)PROCESS_NAMEPROCESS_NAME
STARTCHAR(108)SESSION_IDSESSION_ID
STARTCHAR(8)USER_IDUSER_ID
STARTCHAR(20)USER_NAMEUSER_NAME
STARTCHAR(15)CLIENT_IDCLIENT_ID
STARTCHAR(130)APPLICATION_IDAPPLICATION_ID
STARTCHAR(20)\COMPONENT_NAMECOMPONENT_NAME
STARTCHAR(128)DATASOURCEDATASOURCE
STARTSMALLINT UNSIGNEDSEQUENCE_NUMSEQUENCE_NUM
STARTTIMESTAMPSESSION_START_DATETIMESESSION_START_DATETIME
STARTDATESESSION_START_DATESESSION_START_DATE
STARTTIMESESSION_START_TIMESESSION_START_TIME
STARTTIMESTAMPSESSION_START_DATETIME_UTCSESSION_START_DATETIME_UTC
STARTDATESESSION_START_DATE_UTCSESSION_START_DATE_UTC
STARTTIMESESSION_START_TIME_UTCSESSION_START_TIME_UTC
END, or
NULL for an
incomplete
session
TIMESTAMPSESSION_START_DATETIMESESSION_END_DATETIME
END, or
NULL for an
incomplete
session
DATESESSION_END_DATESESSION_END_DATE
END, or
NULL for an
incomplete
session
TIMESESSION_ END _TIMESESSION_ END _TIME
END, or
NULL for an
incomplete
session
TIMESTAMPSESSION_START_DATETIME_UTCSESSION_END_DATETIME_UTC
54 Repository Views