Application group data table

An application group data table contains one row for each document that is stored in the application group. The name of an application group data table is owner.applgrpInternalIdn, where owner is the value of the SRVR_INSTANCE_OWNER parameter for the instance from the ARS.INI file, applgrpInternalId is the identifier that is assigned to the application group when the application group is created, and n is an incremental value. For example, arsdbas3.rba1, arsdbas3.rba2, and so on. The application group identifier is listed on the Advanced Storage Management page of the application group.

The application group data tables are also known as dynamic tables that are created by Content Manager OnDemand.

A row in an application group data table contains from 1 to 128 user-defined fields followed by approximately 40 bytes of Content Manager OnDemand control information (fields).

Table 1. Application group data table
Column Name Data Type Description
user_field_1 varies First user-defined application group field
user_field_n varies Last user-defined application group field
doc_name VARCHAR(11) Document name
doc_off INTEGER Document offset
doc_len INTEGER Document length
comp_off INTEGER Compression offset
comp_len INTEGER Compression length
annot CHAR(1) FOR BIT DATA (Db2®), BINARY(1) (SQL Server), RAW(1) (Oracle) Annotation flag
comp_type CHAR(1) FOR BIT DATA (Db2), BINARY(1) (SQL Server), RAW(1) (Oracle) Compression type
resource INTEGER Resource identifier
pri_nid SMALLINT Primary storage node identifier
sec_nid SMALLINT Secondary storage node identifier
Table 2. Indexes for application group data table
Index name Columns in index Types of index
doc_name doc_name Index
usr_index_1...usr_index_n    
Note:
  1. This table is indexed on one or more of the user-defined fields, as represented by user_field_1 … user_field_n in the table.
  2. The index doc_name is used only when the Expiration Type of the application group is set to Load or Storage Manager.