Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-51
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Application_Gateway_Connection Table
Application_Gateway_Connection Table
Each row describes the connection of one side of the CallRouter (side A or side B) to an Application
Gateway host.
Gateway host.
Use ICM Configuration Manager to add, update, and delete Application_Gateway_Connection records.
Table 2-37 Application_Gateway_Connection Table Constraints
Constraint
Field Name(s)
PK
ApplicationGatewayID
Side
Side
FK
ApplicationGatewayID
Table 2-38 Application_Gateway_Connection Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AbandonTimeout
An internal timeout used by the CallRouter to
determine a failure in the application gateway
interface process. The default value is 5000.
determine a failure in the application gateway
interface process. The default value is 5000.
DBINT
NULL
Address
A string that describes the connection to the host.
The format depends on the protocol. For TCP, the
format is hostname:port or IPAddress:port.
The format depends on the protocol. For TCP, the
format is hostname:port or IPAddress:port.
varchar(255)
NULL
ApplicationGatewayID
Identifies the Application Gateway associated
with the connection.
with the connection.
DBINT
PK, FK
NOT NULL
Command
A command the ICM software sends to the
application gateway when the row is created or
updated by the Update Central Controller
operation. You can use this field to send one-time
commands to the application gateway host.
application gateway when the row is created or
updated by the Update Central Controller
operation. You can use this field to send one-time
commands to the application gateway host.
DBINT
NULL
CommandParam
A parameter to be sent with the command.
DBINT
NULL
ConnectInfo
A string the ICM software passes to the host
during initialization. The ICM software itself does
not use or validate the value.
during initialization. The ICM software itself does
not use or validate the value.
varchar(255)
NULL
Description
Additional information about the connection.
DESCRIPTION
NULL
ErrorThreshold
Number of consecutive errors that cause the ICM
software to declare the host unavailable. The ICM
software then initiates a reconnect.
software to declare the host unavailable. The ICM
software then initiates a reconnect.
DBINT
NULL
HeartbeatLimit
Number of consecutive unanswered heartbeats
after which the CallRouter closes the connection.
The default is 10. (For purposes of this count, a
query is counted as a heartbeat.)
after which the CallRouter closes the connection.
The default is 10. (For purposes of this count, a
query is counted as a heartbeat.)
DBINT
NULL
HeartbeatRetry
Number of milliseconds to wait before retrying a
missed heartbeat. The default is 200. The total
time between heartbeat tries is HeartbeatTimeout
+ HeartbeatRetry.
missed heartbeat. The default is 200. The total
time between heartbeat tries is HeartbeatTimeout
+ HeartbeatRetry.
DBINT
NULL