Installing the primary aggregation ObjectServer

Use the following steps to install the primary aggregation ObjectServer AGG_P, 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 aggregation 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 or %NCHOME%\ini\sql.ini 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 AGG_P and include the SQL import file to be applied to this ObjectServer:

    $NCHOME/omnibus/bin/nco_dbinit -server AGG_P -customconfigfile $NCHOME/omnibus/extensions/multitier/objectserver/aggregation.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 AGG_P:

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

    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 aggregation SQL file against the ObjectServer AGG_P, as follows:

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

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

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

Tip: In the $NCHOME/omnibus/extensions/multitier/objectserver directory, the aggregation_rollback.sql script is provided to roll back the changes that the aggregation.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 aggregation.sql script.