Setting a custom connection URL to identify the Db2 or Oracle RAC servers

Use this information to set a custom connection URL to identify the primary and backup Db2® servers, or to identify the Oracle RAC service. This connection will allow the Network Manager GUI to work in the Db2 HADR or Oracle RAC environment, depending on your database type.

To set a custom connection URL to identify the primary and backup Db2 servers, or to identify the Oracle RAC servers, edit the relevant properties files and specify the URL connection to the servers. Specify the same URL connection in each of the properties files.

The following properties file is applicable to the Network Manager GUI:
  • $NMGUI_HOME/profile/etc/tnm/tnm.properties

The following properties file is part of the Network Manager core installation: $NCHOME/precision/platform/java/lib/ncp_topoviz/etc/tnm/tnm.properties

To set a custom connection URL:

  1. Open the $NMGUI_HOME/profile/etc/tnm/tnm.properties and the $NCHOME/precision/platform/java/lib/ncp_topoviz/etc/tnm/tnm.properties files for editing
  2. Make the following changes to both, depending on your database type:
    Option Description
    Db2:For Db2 databases

    Specify the URL connection to the primary and backup Db2 servers using the following syntax:

    tnm.database.jdbc.url=jdbc:db2://primary_db2_server:primary_db2_port_number/dbname:clientRerouteAlternateServerName=backup_db2_server;clientRerouteAlternatePortNumber=backup_db2_port;

    where:

    • primary_db2_server — Specifies the name of the primary server on which the Db2 database is running.
    • primary_db2_port_number — Specifies the port number of the primary server on which the Db2 database is running.
    • dbname: Specifies the name of the Db2 database.
    • backup_db2_server — Specifies the name of the backup server on which the Db2 database is running.
    • backup_db2_port — Specifies the port number of the backup server on which the Db2 database is running.
    Oracle:For Oracle databases

    Specify the URL connection to the Oracle RAC servers using the following syntax:

    tnm.database.jdbc.url=jdbc:oracle:thin:@Oracle_RAC_SCAN_hostname:Oracle_RAC_port_number/Oracle_RAC_service_name

    where:

    • Oracle_RAC_SCAN_hostname — Specifies the Oracle Single Client Access Name (SCAN) address on which the Oracle RAC database is running.
    • Oracle_RAC_port_number — Specifies the port number on which the Oracle RAC database is running.
    • Oracle_RAC_service_name — Specifies the service name with which the Oracle RAC database is running.
  3. Save and close the files.