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 (Db2®, SQL Server), INT (Oracle) | Segment start date (in old style) |
stop_date | BIGINT (Db2, SQL Server), INT (Oracle) | Segment stop date (in old style) |
post_date | BIGINT (Db2, SQL Server), INT (Oracle) | Date table was created (in old style) |
closed_date | BIGINT (Db2, SQL Server), INT (Oracle) | Date table was closed (in old style) |
reimported_date | BIGINT (Db2, SQL Server), INT (Oracle) | Date table was imported to the database (in old style) |
last_update | BIGINT (Db2, SQL Server), INT (Oracle) | Date table was last updated (in old style) |
last_backup | BIGINT (Db2, SQL Server), INT (Oracle) | Date of last table backup (in old style) |
last_stats | BIGINT (Db2, SQL Server), INT (Oracle) | 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 |