arsdb

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.

Upgrades

In Content Manager OnDemand v7.1 and v7.1.1, upgrades to OnDemand that required database changes required you to export, drop, create, then import your CMOD metadata tables:

arsdb -I ARCHIVE -xlvf

arsdb -I ARCHIVE -d

arsdb -I ARCHIVE -trv

arsdb -I ARCHIVE -ilvf

In CMOD 7.1.2.x, 8.x and 9.x, IBM has added the -u option to arsdb, allowing you to update the definitions inside the OnDemand database.

arsdb -I ARCHIVE -uv