Segment table (ARSSEG)
This table maintains a catalog of segments of application group data. There is one row for each segment of application group data.
The segments of application group data are also known as dynamic tables that are created by Content Manager OnDemand.
If there is more than one application group
in a folder: OnDemand builds a query to the arsseg table
for each application group that is specified, assuming that you have
not limited your query to a specific application group. For example,
if you have eight application groups, you search the arsseg table
eight different times to find the tables applicable to your search.
| Column Name | Data Type | Description |
|---|---|---|
| agid | INTEGER | Application group identifier |
| table_name | VARCHAR(18) | Application group segment table name |
| start_date | BIGINT | Segment start date (in old style) |
| stop_date | BIGINT | Segment stop date (in old style) |
| post_date | BIGINT | Date table was created (in old style) |
| closed_date | BIGINT | Date table was closed (in old style) |
| reimported_date | BIGINT | Date table was imported to the database (in old style) |
| last_update | BIGINT | Date table was last updated (in old style) |
| last_backup | BIGINT | Date of last table backup (in old style) |
| last_stats | BIGINT | Date statistics last collected (in old style) |
| mask | INTEGER | Table properties |
| ins_rows | INTEGER | Inserted rows |
| upd_rows | INTEGER | Updated rows |
| del_rows | INTEGER | Deleted rows |
| mod_rows | INTEGER | Modified rows |
| max_rows | INTEGER | Maximum number of rows |
| database_name | VARCHAR (8) | The database name of the segment |
| fti_server | VARCHAR(254) | Full text index server |
| start_dt | TIMESTAMP (Db2®, Oracle), DATETIME2(6) (SQL Server) | Segment start date |
| stop_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Segment stop date |
| post_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Date table was created |
| closed_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Date table was closed |
| reimported_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Date table was imported to the database |
| last_update_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Date table was last updated |
| last_backup_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Date of last table backup |
| last_stats_dt | TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) | Date statistics last collected |
| Index name | Columns in index | Type of index |
|---|---|---|
| arsseg_name_idx | agid, table_name | Unique cluster index for Db2; Unique index for Oracle and SQL Server |
| arsseg_idx | agid, start_date, stop_date | Index |
| arsseg_cdate_idx | agid, closed_date | Index |
| arsseg_ssidx | agid, start_dt, stop_dt | Index |
| arsseg_cdt_idx | agid, closed_dt | Index |