TSContainerWindowTable

The TSContainerWindowTable table has one row for each rolling window container.

Two virtual tables are based on the TSContainerWindowTable table. The virtual tables contain a row for each partition:

  • The TSContainerUsageActiveWindowVTI contains information about the partitions in the active window.
  • The TSContainerUsageDormantWindowVTI contains information about the partitions in the dormant window.
Table 1. The columns in the TSContainerWindowTable table
Column name Data type Description
name VARCHAR(128) The name of the rolling window container.
windowinterval VARCHAR(8) The size of the interval of each partition: year, month, week, or day.
activewindowsize INTEGER The number of partitions in the active window.
dormantwindowsize INTEGER The number of partitions in the dormant window.
windowspaces LVARCHAR(4096) The list of dbspaces in which partitions are stored.
activewindow TimeSeries(TSContainerWindow_r) A row type that contains interval information for the partitions that are in the active window.

To view the starting timestamp and location information about the partitions, query the TSContainerUsageActiveWindowVTI table.
dormantwindow TimeSeries(TSContainerWindow_r) A row type that contains interval information for the partitions that are in the dormant window.

To view the starting timestamp and location information about the partitions, query the TSContainerUsageDormantWindowVTI table.
container_size INTEGER The first extent size of the partitions.
container_grow INTEGER The next extent size of the partitions.
windowcontrol INTEGER A flag that indicates how active partitions are handled when they are manually or automatically detached:
  • 0 = Default. As many as necessary dormant partitions are destroyed.
  • 1 = As many as necessary existing dormant partitions and older active partitions are destroyed.
  • 2 = Dormant partitions are destroyed, but limited to the number specified by the windowdordestroycount value.
  • 3 (2 + 1) = Existing dormant partitions and older active partitions are destroyed, but limited to the number specified by the windowdordestroycount value.
windowdordestroycount INTEGER How many partitions can be destroyed in an operation if windowcontrol is 2 or 3.
  • 0 = Default. No dormant partitions are destroyed.
  • A positive integer = The maximum number of partitions that can be destroyed in an operation.