CONFIGELEMENT
The CONFIGELEMENT table corresponds to one configuration element. An element can be either a node or an item. A node contains other elements. An item contains a value. The natural key of this entity is name of the configuration element.
This table is used by the following functional feature.
Tip: For detailed descriptions and more information about the InfoSphere®
MDM
Advanced Edition configuration elements, see Elements in the Configuration and Management component.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| ELEMENT_ID | A numeric artificial key used to uniquely identity a configuration element within a deployment or instance of an application. | BIGINT | Not Null | Yes |
| DEPLOYMENT_ID | A numeric artificial key used to uniquely identity a deployment of a particular application version. | BIGINT | Not Null | No |
| NAME | A hierarchical name that uniquely identifies a configuration item within the scope of a deployment or instance of an application. | VARCHAR(220) | Not Null | No |
| VALUE | The currently assigned value of the configuration item in its string representation. If this field is null then the value from the value_default field is used. If this element is a node, the value is always null. | VARCHAR(1000) | Null | No |
| VALUE_DEFAULT | The factory default value of the configuration item in its string representation. If this element is a node, the value_default is always null. | VARCHAR(1000) | Null | No |
| INSTANCE_ID | A numeric artificial key used to uniquely identity an instance of a particular application version. | BIGINT | Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
| IS_DYNAMIC | An indicator showing whether configuration changes made to this record take effect dynamically, i.e. without restarting the application server. | CHAR(1) | Null | No |
| DOCUMENTATION | A description showing the usage of this configuration. | VARCHAR(2000) | Null | No |