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.