Creating ODF tables

After you successfully create any required table spaces or filegroups for ODF, use the instructions in this section to create the ODF tables.

About this task

IBM i only:Note: On IBM® i, you do not need to create the ODF tables because they are created when ODF is installed.

To create the ODF tables on your Content Manager OnDemand server, follow these steps:

Procedure

  1. Set up the environment:
    1.  Windows only:For Windows: Open the OnDemand Command Window V10.5.
    2. z/OS only:For z/OS®: Log in to OMVS. Switch to the super user (su). Export the environment variable by entering this command:
      export DSNAOINI="/etc/ars/cli.ini"
    3. Linux only:z/OS only:AIX only:For AIX®, Linux®, and z/OS: Change to the Content Manager OnDemand executable directory by entering this command:
      cd /executabledir where executabledir is the directory that contains your Content Manager OnDemand executable programs.
  2. Run the ARSDB program by entering this command:
    arsdb -I instance -O -rstv where instance is your Content Manager OnDemand instance name.

Results

The ARSDB program generates a series of messages similar to the following:
ARS4026I Creating table ARCHIVE.arsdfbdt
ARS4034I Creating index arsdfbdt_idx1
ARS4034I Creating index arsdfbdt_idx2
ARS4034I Creating index arsdfbdt_idx3
ARS4034I Creating index arsdfbdt_idx4
ARS4034I Creating index arsdfbdt_idx5
ARS4026I Creating table ARCHIVE.arsdfcrt
ARS4034I Creating index arsdfcrt_idx1
ARS4034I Creating index arsdfcrt_idx2
ARS4026I Creating table ARCHIVE.arsdfdct
...
ARS4026I Inserting default values into table ARCHIVE.arsdfeml
ARS4034I Creating index arsdfeml_idx1
ARS4026I Creating table ARCHIVE.arsdflis
ARS4034I Creating index arsdflis_idx1
ARS4034I Creating index arsdflis_idx2