Creating a database instance

The ARSDB program creates the instance.

About this task

Oracle users: You must create the database by using the Oracle utilities before you create the Content Manager OnDemand instance.

Procedure

To create an instance of Content Manager OnDemand:

  1. Log in to the server as the root user.
    Option Description
    Db2 Type the following command at the prompt:
    /opt/ibm/ondemand/V10.5/bin/arsdb -I archive -gcv
    Where archive is the name of the Content Manager OnDemand instance.
    Oracle Type the following command at the prompt:
    /opt/ibm/ondemand/V10.5/bin/arsdb -I archive -rtv
    Where archive is the name of the Content Manager OnDemand instance.
  2. Press the Enter key.
    The ARSDB program prompts you before creating a link to the database user exit program:
    • If you maintain Db2® archived log files on disk, enter 1 when prompted
    • If you use Tivoli® Storage Manager to maintain the Db2 archived log files, enter 2 when prompted
  3. Content Manager OnDemand creates the instance, makes a backup image of the database, and restores the Content Manager OnDemand system tables to the database. This process will take several minutes.
    The ARSDB program generates a series of messages. For example:
     Creating the Db2 ARSDBASE database
     Creating table ARSSERVR.arsag
     Creating index ARSSERVR.arsag_name_idx
     Creating index ARSSERVR.arsag_agid_idx
     ..... .. . . . . . . . . . . . . . . . . . . .
     ..... .. . . . . . . . . . . . . . . . . . . .
     ..... .. . . . . . . . . . . . . . . . . . . .
     Updating runstat statistics for table ARSSERVR.arsusrgrp
     Creating table ARSSERVR.arsusrgrpid
     Creating index ARSSERVR.arsusrgrpid_idx
     Updating runstat statistics for table ARSSERVR.arsusrgrpid