text: **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. You can 
  automate the collection of statistics by scheduling the**ARSMAINT**program to run with the 
  appropriate options. 
  
  You 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. You 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**
  **-r**
  **-s** Drop configuration indexes. 
  Create configuration indexes. 
  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. 