Technical References

Fields in Application_Gateway_Half_Hour Table :
Keys and Null
Option:
Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Identifies the Application Gateway.
ApplicationGatewayID
NULLDBINT
The average response time, in milliseconds, for all requests to the
Application Gateway during the half-hour interval.
AvgDelayToHalf
PK NOT NULLDBSMALLDATE
The Central Controller date and time at the start of the interval.
DateTime
IE-1 NULLDBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
Number of errors that occurred for Application Gateway requests
during the half-hour interval. Consult EMS logs for specific error
information.
ErrorsToHalf
NULLDBINT
Number of responses that exceeded the LateTimeout value for the
connection during the half-hour interval.
LatesToHalf
NULLDBINT
The longest response time, in milliseconds, for any request to the
Application Gateway during the half-hour interval.
MaxDelayToHalf
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLDBINT
The number of requests rejected by the Application Gateway during
the half-hour interval.
RejectsToHalf
NULLDBINT
The number of request sent to the Application Gateway during the
half-hour interval.
RequestsToHalf
NULLDBINT
The number of requests to the Application Gateway that timed out
during the half-hour interval.
TimeoutsToHalf
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in minutes
from UTC (formerly called GMT).
TimeZone
NULLDBINT
Number of requests attempted while no Application Gateway was
available during the half-hour interval.
UnavailableToHalf
Application_Instance Table
This table is part of the Media Routing category (page 446). For database rules, click here. (page
507)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
66
Chapter 2: All Tables
Application_Instance Table