Introduction
The arsdb command performs database-specific tasks for Content Manager OnDemand Servers. This includes Installation related tasks, Maintenance, Upgrades, and Special tasks like importing and exporting database tables. Check the Usage section for sample online help, and a description of each feature. Examples shows some common tasks completed with arsdb.
Installation
arsdb is used during the installation process to create the database, plus OnDemand's internal tables for metadata, and indexes inside those tables.
arsdb -I ARCHIVE -ctrv
After the installation is complete, you must build the System Log, System Load, and System Migration Application Groups separately using the arssyscr command.
Common errors during this command are: ARS0147E and ARS4067E.
Maintenance
The IBM Content Manager OnDemand database needs routine maintenance to ensure performance and reliability. Depending on the volume and age of your system, you may want to run these options more or less frequently.
arsdb -I ARCHIVE -msv
Regular backups are a wise part of any maintenance window. For online backups, use:
arsdb -I ARCHIVE -zv
And for offline backups, use:
arsdb -I ARCHIVE -yv
Special Note about Database Backups
arsdb is a great way to do very simple online or offline backups, regardless of your underlying database engine. Some companies prefer to do their database backups through a different method. For example, DB2 provides for incremental and differential backups, in addition to online or offline backups. There are also options for enabling database backup compression, or backing up directly to tape via a facility like Tivoli Storage Manager. You will want to work with your DBAs to ensure your backups are recoverable and complete, regardless of which method you choose.