Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLVNAME32
The system from which the user obtained the lock.
SystemName
NOT NULLvarchar(64)
The name of the user who holds the lock.
UserName
ICR_Node Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Each row represents a real- time distributor associated with an ICM instance. On a Network
ICM, you must configure the distributors associated with each Customer ICM. The Network
ICM needs this information to forward certain configuration changes. Use ICM Configuration
Manager to create, modify, or delete an ICM node.
Related table
ICR Instance (page 212)(via ICRInstanceID)
Table 108: Indexes for ICR_Node Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1ICR_Node
ICRInstanceIDnonclustered located on PRIMARYXIE1ICR_Node
ICRNodeIDclustered, unique, primary key
located on PRIMARY
XPKICR_Node
Fields in ICR_Node Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLvarchar(255)
Parameters to be passed to the node at initialization.
ConfigParam
NULLDESCRIPTION
Additional information about the node.
Description
NOT NULLvarchar(64)
The name of the NT domain that contains the node.
DomainName
AK-1 NOT NULLVNAME32
An enterprise name for the node. This name must be unique for all
nodes in the enterprise.
EnterpriseName
FK, IE-1 NOT NULLDBINT
The ICM instance associated with the node.
ICRInstanceID
PK NOT NULLDBINT
A unique identifier for the node.
ICRNodeID
NOT NULLVNAME32
The host name of the machine on which the node runs.
SystemName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
214
Chapter 2: All Tables
ICR_Node Table