Technical References

Table 36: Indexes for Application_Gateway Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Application_Gateway
ICRInstanceIDnonclustered located on PRIMARYXIE1Application_Gateway
ApplicationGatewayIDclustered, unique, primary key
located on PRIMARY
XPKApplication_Gateway
Fields in Application_Gateway Table:
Keys and Null
Option:
Data Type:Description:Field Name:
PK NOT NULLDBINT
A unique identifier for the application gateway.
ApplicationGatewayID
NOT NULLDBINT
The type of gateway:
ApplicationGatewayType
• 0 = custom gateway
• 1 = remote ICM
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the application gateway.
Description
NOT NULLDBINT
The encryption method used by the application gateway:
Encryption
• 0 = none
• 1 = private key
AK-1 NOT NULLVNAME32
An enterprise name for the application gateway. This name
must be unique among all application gateways in the enterprise.
EnterpriseName
NOT NULLDBINT
The fault-tolerance strategy used by the application gateway.
To see values for this field, click here (page 466).
FaultTolerance
FK, IE-1 NULLDBINT
Identifies the instance associated with the application gateway.
ICRInstanceID
NULLchar(1)
Indicates which side of the Gateway the software should use
when both are available: A or B. This applies only when
ApplicationGatewayType is 0 (custom gateway).
PreferredSide
Application_Gateway_Connection Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
61
Chapter 2: All Tables
Application_Gateway_Connection Table