Cisco Cisco IPCC Web Option Technical References
2-35
Cisco ICM Software Database Schema Handbook
78-11677-04
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.
ApplicationGatewayType
The type of gateway:
0 = custom gateway
1 = remote ICM
1 = remote ICM
Note
You can define a separate set of defaults for
each type.
each type.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
int
NOT NULL
Table 2-19 Applications_Gateway_Globals Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-20 Application_Gateway_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ApplicationGatewayID
Identifies the Application Gateway.
int
PK, FK, NOT
NULL
NULL
DateTime
The date and time at the start of the half-hour
interval.
interval.
datetime
PK, NOT NULL
TimeZone
The time zone for the date and time. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
PK, NOT NULL
RequestsToHalf
The number of request sent to the Application
Gateway during the half-hour interval.
Gateway during the half-hour interval.
int
NULL
RejectsToHalf
The number of requests rejected by the Application
Gateway during the half-hour interval.
Gateway during the half-hour interval.
int
NULL
TimeoutsToHalf
The number of requests to the Application Gateway
that timed out during the half-hour interval.
that timed out during the half-hour interval.
int
NULL
MaxDelayToHalf
The longest response time, in milliseconds, for any
request to the Application Gateway during the
half-hour interval.
request to the Application Gateway during the
half-hour interval.
int
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.
int
NULL
UnavailableToHalf
Number of requests attempted while no Application
Gateway was available during the half-hour interval.
Gateway was available during the half-hour interval.
int
NULL