STRATA
Contains internal details of how the combines ROS containers in each projection, broken down by stratum and classifies the ROS containers by size and partition.
Contains internal details of how the Tuple Mover combines ROS containers in each projection, broken down by stratum and classifies the ROS containers by size and partition. The related
STRATA_STRUCTURES
table provides a summary of the strata values.
Mergeout describes how the Tuple Mover combines ROS containers.
Column Name | Data Type | Description |
---|---|---|
NODE_NAME |
VARCHAR | The node name for which information is listed. |
SCHEMA_NAME |
VARCHAR | The schema name for which information is listed. |
PROJECTION_ID |
INTEGER | Catalog-assigned numeric value that uniquely identifies the projection. |
PROJECTION_NAME |
VARCHAR | The projection name for which information is listed on that node. |
STRATUM_KEY |
VARCHAR | References the partition or partition group for which information is listed. |
STRATA_COUNT |
INTEGER | The total number of strata for this projection partition. |
MERGING_STRATA_COUNT |
INTEGER | The number of strata the Tuple Mover can merge out. |
STRATUM_CAPACITY |
INTEGER | The maximum number of ROS containers for the stratum before they must be merged. |
STRATUM_HEIGHT |
FLOAT | The size ratio between the smallest and largest ROS container in this stratum. |
STRATUM_NO |
INTEGER | The stratum number. Strata are numbered starting at 0, for the stratum containing the smallest ROS containers. |
STRATUM_LOWER_SIZE |
VARCHAR | The smallest ROS container size allowed in this stratum. |
STRATUM_UPPER_SIZE |
VARCHAR | The largest ROS container size allowed in this stratum. |
ROS_CONTAINER_COUNT |
INTEGER | The current number of ROS containers in the projection partition. |