78 IBM Content Manager OnDemand Guide
4.1  System control tables
Content Manager OnDemand creates and uses two sets of tables: a set of system control 
tables and a set of application group data tables. All system control tables are created by the 
arsdb command (except for the Archive Storage Manager (ASM) tables that are used by 
Content Manager OnDemand for IBM i server). The application group data tables are created 
when you load data (reports and documents) into the Content Manager OnDemand system.
Table 4-1 shows the Content Manager OnDemand system control tables with their 
descriptions.
Table 4-1   Content Manager OnDemand system control tables 
Note: For a Multiplatform or z/OS server, the complete table name consists of the owner 
name, which can be the database name or the instance name, and the table name. For 
example, the application group table ARSAG that belongs to the ODARCH instance has a 
complete table name of ODARCH.ARSAG. 
For the IBM i server, the complete table name is in the format of library/table, where the 
library name is always the same as the instance name. For example, the application group 
table ARSAG that belongs to the default QUSROND instance has a complete table name 
of QUSROND/ARSAG. 
Table name Purpose Description
ARSAG Application group table One row for each application group
ARSAG2FOL Field mapping table One row for each application group field that is 
mapped to a folder field
ARSAGFLD Application group field 
table
One row for each field that is defined in an 
application group
ARSAGFLDALIAS Application group field 
alias table
One row for each database (internal) and displayed 
(external) value in an application group
ARSAGINDEX Application group 
composite index table
One row for each composite index on application 
group fields
ARSAGPERMS Application group 
permissions table
One row for every user that is granted specific 
permission to an application group
ARSANN Annotation table One row for each annotation that is added to a 
database
ARSAPP Application table One row for each application that is defined to 
Content Manager OnDemand
ARSAPPUSR User logical views table One row for each logical view that is defined for a 
specific user
ARSCAB Cabinet table One row for each cabinet that is defined to Content 
Manager OnDemand
ARSCAB2FOL Cabinet to Folder table One row for every cabinet that is defined for a folder
ARSCABPERMS Cabinet permissions 
table
One row for every user that is granted specific 
permissions to a cabinet