Cisco Cisco Administrative Workstation Technical References
2-32
Cisco ICM Software Database Schema Handbook
78-11677-04
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-18 Application_Gateway_Connection Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ApplicationGatewayID
Identifies the Application Gateway associated with
the connection.
the connection.
int
PK, FK, NOT
NULL
NULL
Side
Indicates which side of the CallRouter uses the
connection. Valid values are ‘A’ and ‘B’.
connection. Valid values are ‘A’ and ‘B’.
char(1)
PK, NOT 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
Protocol
The communications protocol used for the
connection. 1 = TCP (the only value currently
supported).
connection. 1 = TCP (the only value currently
supported).
int
NOT NULL
ConnectInfo
A string the ICM software passes to the host during
initialization. The ICM software itself does not use
or validate the value.
initialization. The ICM software itself does not use
or validate the value.
varchar(255)
NULL
Description
Additional information about the connection.
varchar(255)
NULL
InService
Indicates whether the connection is currently
available: ‘Y’ (yes) or ‘N’ (no).
available: ‘Y’ (yes) or ‘N’ (no).
char(1)
NOT 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.
int
NULL
RequestTimeout
Number of milliseconds the CallRouter waits for a
response before timing out a request. The default
value is 300.
response before timing out a request. The default
value is 300.
int
NULL
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.
int
NULL
SessionRetry
Number of milliseconds the CallRouter waits before
trying to reconnect after a connection terminates or
a connection attempt fails. The default value is
30000.
trying to reconnect after a connection terminates or
a connection attempt fails. The default value is
30000.
int
NULL
SessionRetryLimit
The maximum number of times the CallRouter
attempts to connect or reconnect a session. (User
intervention is then required to restart the
connection.) If the value is 0, then no limit applies.
attempts to connect or reconnect a session. (User
intervention is then required to restart the
connection.) If the value is 0, then no limit applies.
int
NULL
OpenTimeout
Number of milliseconds the CallRouter waits for a
response to an open or close connection request.
The default is 15000.
response to an open or close connection request.
The default is 15000.
int
NULL