80 IBM Content Manager OnDemand Guide
4.2  Main data table structures
The Content Manager OnDemand data tables can grow rapidly. Y ou must understand the 
structure of the data tables and the relationships between them.
Two important tables exist that you must examine here: the segment table (ARSSEG) and the 
application group data table (ag_internal_id). The segment table contains one row for each 
segment of each application group data table. Table 4-2 shows the first four columns of the 
ARSSEG table structure.
Table 4-2   ARSSEG table structure
The ARSSEG table points to the application group data table name (second column of the 
table, table_name). The application group data table is created or updated during the arsload 
process. The application group data table contains a row for each item that is stored in the 
application group. 
The name of the application group data table is ag_internal_id, which is the identifier that 
Content Manager OnDemand assigns to the application group when the application group is 
created with the Administrator Client. The three-digit application group identifier is listed in the 
Storage Management window of the Administrator Client, as shown in Figure 4-1 on page 81. 
In this case, the application group identifier is WBA, AGID 5185.
ARSUSRGRP Users in group table One row for each user that is assigned to a Content 
Manager OnDemand group
ARSUSRGRPID User group ID table Maintains the association of users with user 
owners and their authority for groups
Dynamic name Application group data 
table
One row for each document that is stored in the 
application group
Important: Do not update the tables by using SQL commands or DB2 system tools, such 
as SQL Processor Using File Input (SPUFI) or any other tools. The tables must be updated 
only by the Content Manager OnDemand Administrator Client or Content Manager 
OnDemand commands.
Table name Purpose Description
Column name Description
agid Application group ID
table_name Application group segment table name
start_date Segment start date
stop_date Segment stop date