Cisco Cisco Administrative Workstation 技术参考
2-55
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Application_Gateway_Half_Hour Table
Application_Gateway_Half_Hour Table
Central database only.
Provides statistics on each Application Gateway. The ICM software updates these statistics every 30
minutes.
minutes.
The ICM software generates Application_Gateway_Half_Hour records for each Application Gateway.
Table 2-41 Application_Gateway_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
ApplicationGatewayID
DateTime
TimeZone
DateTime
TimeZone
AK-1
RecoveryKey
FK
ApplicationGatewayID
Table 2-42 Application_Gateway_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ApplicationGatewayID
Identifies the Application Gateway.
DBINT
PK, FK
NOT NULL
AvgDelayToHalf
The average response time, in milliseconds, for all
requests to the Application Gateway during the
half-hour interval.
requests to the Application Gateway during the
half-hour interval.
DBINT
NULL
DateTime
The Central Controller date and time at the start of
the interval.
the interval.
DBSMALLDATE
PK
NOT NULL
DbDateTime
The current date and time stamp when the records
are written to the HDS database. The logger
database has NULL for this column.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
IE-1
NULL
ErrorsToHalf
Number of errors that occurred for Application
Gateway requests during the half-hour interval.
Consult EMS logs for specific error information.
Gateway requests during the half-hour interval.
Consult EMS logs for specific error information.
DBINT
NULL
LatesToHalf
Number of responses that exceeded the
LateTimeout value for the connection during the
half-hour interval.
LateTimeout value for the connection during the
half-hour interval.
DBINT
NULL
MaxDelayToHalf
The longest response time, in milliseconds, for
any request to the Application Gateway during the
half-hour interval.
any request to the Application Gateway during the
half-hour interval.
DBINT
NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
RejectsToHalf
The number of requests rejected by the
Application Gateway during the half-hour
interval.
Application Gateway during the half-hour
interval.
DBINT
NULL