Application group table (ARSAG)

This table maintains a catalog of application groups.

Table 1. Application group table (ARSAG)
Column Name Data Type Description
name VARCHAR(60) Application group name
description VARCHAR(120) Application group description
agid INTEGER Application group identifier
agid_name VARCHAR(8) Application group internal identifier
db_seg CHAR(1) FOR BIT DATA (DB2®), BINARY(1) (SQL Server), RAW(1) (Oracle) Segment type (Database Organization)
ann_type CHAR(1) FOR BIT DATA (DB2), BINARY(1) (SQL Server), RAW(1) (Oracle) Annotation update
db_exp_date INTEGER Expire database indexes
db_mgrt_date INTEGER Migrate database indexes
sm_cache_doc INTEGER Storage manager cache definition
resgrp INTEGER Resource group identifier
load_id INTEGER Load Id counter
log INTEGER Log mask
load_id_suffix VARCHAR(8) Load Id suffix
mgrt_cache_date INTEGER Copy cache to archive storage
reimport_exp_date INTEGER Number of days to keep imported table before re-expiring
sid INTEGER Storage set identifier
expire_type CHAR(1) FOR BIT DATA (DB2), BINARY(1) (SQL Server), RAW(1) (Oracle) Expiration type
seg_rows INTEGER Rows per segment (Maximum Rows)
seg_id INTEGER Segment Id counter
obj_size INTEGER Size of storage object
type INTEGER Type of application group (Data Management; Create Tablespace Type)
upd_userid VARCHAR(128) Last user to update the application group
upd_date BIGINT (DB2, SQL Server), INT (Oracle) Date and time application group was last updated
last_doc_date BIGINT (DB2, SQL Server), INT (Oracle) Migrate last document date
migr_srvr_str VARCHAR(254) Migrate server string
sm_cache_delta INTEGER Delta value of the expiration (number of days) of cached data
database_name VARCHAR(8) Internal database alias name
sm_cache_res INTEGER Storage manager resources cache definition
fti_server VARCHAR Full text index server
upd_dt TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) Date and time application group was last updated
last_doc_dt TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) Migrate last document date
last_load_dt TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) Date and time application group was last loaded
last_query_dt TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) Date and time application group was last queried
last_retr_dt TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) Date and time application group was last retrieved
Table 2. Indexes for application group table (ARSAG)
Index name Columns in index Type of index
arsag_name_idx name unique index