Chapter 10. Migration and expiring data and indexes 231
The relationship between ARSMAINT and ARSSOCKD processing is illustrated in Figure 10-3.
Figure 10-3   Relationship between ARSMAINT and ARSSOCKD programs
Collecting statistics
Content Manager OnDemand provides two programs to collect statistics on database tables: 
the ARSDB program and the ARSMAINT program.
When you run the ARSMAINT program to collect statistics, it collects statistics on all of the 
tables in the database that changed since the last time that you collected statistics. Y ou can 
automate the collection of statistics by scheduling the ARSMAINT program to run with the 
appropriate options.
Y ou can use the ARSDB program to collect statistics on the Content Manager OnDemand 
system tables. The Content Manager OnDemand system tables include the user table, the 
group table, and the application group table. For most systems, the Content Manager 
OnDemand system tables require little maintenance. Y ou can probably schedule the ARSDB 
program to collect statistics once a month (or less often).
The syntax for the ARSDB program is shown:
/opt/IBM/ondemand/V9.0/bin/arsdb <options>
The options are explained:
-e Drop configuration indexes.
-r Create configuration indexes.
-s Collect statistics.
System log messages
When you run the ARSMAINT program, it saves messages about its activities in the system log. 
The types of messages that are saved in the system log depend on the options that you 
specify when you run the ARSMAINT program. 
The number of messages that are saved in the system log each time that expiration 
processing runs depends on the following factors:
/SM590000The options that you specify for the ARSMAINT program
/SM590000The number of application groups that is processed 
/SM590000The number of segments of data that is processed
/SM590000The number of cache storage file systems that are defined on the server
When to run the maintenance processes: Most maintenance processes need to run 
when no other applications are updating the database or need exclusive access to the 
database and when you are sure that no one is retrieving documents from the system. For 
example, you must not perform maintenance on the database while you are loading data 
into the system.
A RSMAI NT ARS SOCK D
1. Expir es Data fr om C ache
2. Expir es i nde xes
3. Expir es anno ta ti ons
Determi nes whi ch
In dexe s a nd ob jects
nee d to  b e expi red
Life of Date and I ndexe s Se ttings
A RSMAI NT ARS SOCK D
1. Expir es Data fr om C ache
2. Expir es i nde xes
3. Expir es anno ta ti ons
D e te rmin e s w h ich
In dexe s a nd ob jects
nee d to  b e expi red
Life of Date and I ndexe s Se ttings