Installing an additional primary collection ObjectServer

Use the following steps to install the additional primary collection ObjectServer COL_P_2, and apply the SQL customization. If the ObjectServer is already installed and running, you can apply the SQL customization to the ObjectServer by using the collection SQL file provided.

About this task

To install and configure the ObjectServer:

Procedure

  1. Install Tivoli Netcool/OMNIbus and ensure that all components are selected for installation.
  2. Ensure that the $NCHOME/etc/omni.dat file is configured with all the component details.
  3. For UNIX operating systemGenerate the interfaces file as follows:

    $NCHOME/bin/nco_igen

  4. Initialize the ObjectServer COL_P_2 and include the SQL import file to be applied to this ObjectServer:

    $NCHOME/omnibus/bin/nco_dbinit -server COL_P_2 -customconfigfile $NCHOME/omnibus/extensions/multitier/objectserver/collection.sql

    The properties file, and default database tables, data, users, groups, and roles are created for the ObjectServer. The SQL customization is also applied.

  5. Start the ObjectServer COL_P_2:

    $NCHOME/omnibus/bin/nco_objserv -name COL_P_2 &

    The ObjectServer is confirmed as initialized and entering a RUN state.

Applying the SQL customization to a running ObjectServer

About this task

To apply the SQL customization when the ObjectServer is already installed and running, apply the collection SQL file against the ObjectServer COL_P_2, as follows:

For UNIX operating system$NCHOME/omnibus/bin/nco_sql -server COL_P_2 -user root –password password < $NCHOME/omnibus/extensions/multitier/objectserver/collection.sql

For Windows operating system"%NCHOME%\omnibus\bin\isql" -S COL_P_2 -U root -P password -i "%NCHOME%\omnibus\extensions\multitier\objectserver\collection.sql"

It is assumed you are logged on as root with a preferred password.

Tip: In the $NCHOME/omnibus/extensions/multitier/objectserver directory, the collection_rollback.sql script is provided to roll back the changes that the collection.sql script makes to the ObjectServer, if required. You can apply this rollback script by using the nco_sql or isql utility with the syntax shown for applying the collection.sql script.