Creating the Content Manager OnDemand system tables

About this task

After you have successfully created a table space for the Content Manager OnDemand system tables, run the ARSDB program to create the Content Manager OnDemand system tables.

Procedure

To run the ARSDB program, do the following steps:

  1. Set up the ODBC environment:
    1. Log on to OMVS.
    2. Switch to the super user (su)
    3. Export the environment variable. For example: export DSNAOINI="/etc/ars/cli.ini"
    4. Run the set command to display the environment settings.
  2. Move to the Content Manager OnDemand executable directory. For example: cd /usr/lpp/ars/V9R5M0/bin
  3. Run the ARSDB program. For example: arsdb -trs The ARSDB program will generate the following series of messages:
    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