Loading the databases

Loading the database for Netcool Configuration Manager builds the schemas and loads the content. You can load the databases during installation, or separately at a later stage.

Before you begin

It is a requirement that the Oracle instance is reachable, and the user account credentials are active.

About this task

All relevant tables, keys and sequences are built in preparation for the database content. The scripts then create the content, such as realms, security settings, properties, searches, and other required functions.
Important: In a distributed architecture the schema must be loaded from one Netcool Configuration Manager GUI server only. If the database schema has already been loaded during installation, do not load it again.
CAUTION:
Loading the database schema removes any existing Netcool Configuration Manager database schema, removing all existing data.

Procedure

  1. Access the directory containing the utilities:
    /opt/IBM/tivoli/netcool/ncm/bin/utils/database
  2. Run the load schema script. If the installation is part of a distributed setup, execute the loadDBSchema.sh script from the main GUI server.
    sh ./loadDBSchema.sh
    This script creates a log file called dbload.log in ncm_install_dir/logs.
    Tip: This log file should be checked regularly, as errors from this script are not displayed on the console.
  3. Required: For DB2 databases only: Grant regex execute permissions as required.

    For example:

    db2 grant execute on function 'NCM_REGEXP_LIKE(CLOB,VARCHAR(512),VARCHAR(3))' to 'db2inst1'
db2 grant execute on function 'NCM_REGEXP_LIKE(VARCHAR(3000),VARCHAR(512),VARCHAR(3))' to 'db2inst1'
db2 grant execute on function 'DECODE_FUNCTION' to 'db2inst1'
    Note: UDF names like NCM_REGEXP_LIKE are only valid from Fix Pack 14 onwards. For Fix Pack 13 and previous fix packs, use the examples below.
    db2 grant execute on function 'REGEXP_LIKE(CLOB,VARCHAR(512),VARCHAR(3))' to 'db2inst1'
db2 grant execute on function 'REGEXP_LIKE(VARCHAR(3000),VARCHAR(512),VARCHAR(3))' to 'db2inst1'
db2 grant execute on function 'DECODE_FUNCTION' to 'db2inst1'
  4. Required: For Tivoli Common Reporting: Configure Tivoli Common Reporting to use your enterprise database. For detailed information, see the Tivoli Common Reporting information center.