Chapter 4. Database structure 85
Figure 4-4   Search sequence from a folder
4.5  System log
The system log is used to track all activities in the Content Manager OnDemand Instance. 
Examples of these activities include logon and document retrieval. The system log is created 
as an application group. It is created by using the ARSSYSCR program. The application group 
identification name is SL and a 4-byte agid is added. Y ou will see SLXX in the ARSEG table, 
depending on how large your system log is growing. The creation of a new system log table is 
based on the number of rows on the Storage Management setting. The default is 10 million 
rows. This configuration can be modified.
4.6  Database creation and relationships on z/OS
The database creation, allocation of space for tables, and table space of the Content 
Manager OnDemand product are different in the z/OS environment. The database 
administrator (DBA) is responsible for the allocation, creation, maintenance, backup, and 
recovery of the database subsystem. 
Redbk Credit             Credit Card Statement...     
Name        Description                        FID
folder to 
application
group
ARSAG2FOL
FID      AGID    
5022    5020
folder table
ARSFOL
application
group table
ARSAG
Name          Description    AGID   AGID_Name
Rbk-Credit  Statements      5020    HAA
segment
table
ARSSEG
AGID  Table_Name   Start_date*      Stop_Date*
5020        HAA1           3.05.1994        12.31.1995
5020        HAA2           1.01.1996         6.30.1997
application
group data
table
HAA1
Name             Acount     Statement_date   Balance    Retrieval_info 
Index1                   Index2           Index3                          Index4
BIKE SHOP A                 000-000-123 03.07.1994                       697.08                2FAAA
BIKE SHOP B                 000-000-234 03.07.1994                     2258.79                2FAAA
SPORTS SHOP C           000-000-345 03.07.1994                     1892.28                2FAAA
SPORTS SHOP D           000-000-456 03.07.1994 1868.94                2FAAA
SPORTS SHOP E           000-000-567 03.07.1994                       104.18 2FAAA
Locate application group data table that 
contains the specified date
* Dates are not shown  in real format 
Identify application group(s) in folder
Use application group information to
Search ARSSEG table
Create a hit 
list that 
contains
documents 
that match 
the search 
criteria
5022