All tables in the repository share a common set of columns, which we refer to as “header columns.” Those columns serve the following purpose:
- A common set of conforming foreign keys provide a simple way to join data among views.
- A common set of identification columns enable both tenant interleaving and external multi-instance repositories.
- A common set of date and time columns enable temporal analysis of all data.
The remainder of each table contains data columns, which are defined per a common set of rules to ensure fact conformance.
As a rule of thumb, columns that are used as part of the primary key in an underlying table are defined as “NOT NULL” while all other columns (header or data) are defined as “DEFAULT NULL.” This technique allows the DCS server to write partial data to the repository tables without affecting calculations. In addition, the INSTANCE_ID or TENANT_ID column is defined as “NOT NULL” because this column is required for joins.
The following table defines the header columns that all repository tables contain.
Column Name | Data Type | Default | Description |
---|---|---|---|
INSTANCE_ID | INT UNSIGNED | NO DEFAULT NOT NULL NOT DROPPABLE | Unique ID that identifies the instance from which the metric originated. |
TENANT_ID | INT UNSIGNED | NO DEFAULT NOT NULL NOT DROPPABLE | Unique ID that identifies the tenant (if any) from which the metric originated. Value is 0 (zero) if there is no tenant. |
COMPONENT_ID | INT UNSIGNED | DEFAULT NULL | Unique ID for the component, 1 through 16. |
PROCESS_ID | INT | DEFAULT NULL | Unique ID from the operating system, which identifies the process associated with the metric. |
THREAD_ID | INT UNSIGNED | DEFAULT NULL | Thread ID for the process. |
NODE_ID | INT UNSIGNED | DEFAULT NULL | Logical node ID from the foundation layer, which is a numeric identifier for the current node. |
PNID_ID | INT UNSIGNED | DEFAULT NULL | Physical node ID from the foundation layer. |
HOST_ID | INT UNSIGNED | NO DEFAULT NOT NULL NOT DROPPABLE | Host ID from the operating system, which is a numeric identifier for the current host. |
IP_ADDRESS_ID | CHAR(32) CHARACTER SET ISO88591 COLLATE DEFAULT | DEFAULT NULL | Internet Protocol (IP) address of the node from which the data for this table originated. |
SEQUENCE_NUMBER | INT UNSIGNED | DEFAULT NULL | Sequence ID generated by the data producer. |
PROCESS_NAME | CHAR(32) CHARACTER SET ISO88591 COLLATE DEFAULT | DEFAULT NULL | Logical process name of the DCS server that is handling the query and that reported the statistics. |
SESSION_ID | CHAR(108) CHARACTER SET ISO88591 COLLATE DEFAULT | NO DEFAULT NOT NULL NOT DROPPABLE | Unique session ID generated by the DCS server when the connection was established. |
USER_NAME | CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT | DEFAULT NULL | Name of the user connected to the instance. |
ROLE_NAME | CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT | DEFAULT NULL | Name of the role that was granted to the user. |
CLIENT_NAME | VARCHAR(256 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT | DEFAULT NULL | Name of the client workstation. |
APPLICATION_NAME | CHAR(130) CHARACTER SET ISO88591 COLLATE DEFAULT | DEFAULT NULL | Name of the client application connected to the database. |
Return to the Trafodion Manageability page.