Netcool Operations Insight V Installation and set-up (step by step procedure)

(1)

Contents

Document location and change history ... 3

CHANGE HISTORY ... 3

Documentation... 6

Information ... 6

Software list ... 10

Example of NOI PoC configuration (3 machines) ... 11

Example of NOI setup - Primary / Backup configuration (4 machines) ... 12

Preliminary steps ... 15

DB2 installation and set-up ... 16

DB2 troubleshooting (Event Analytics - Impact Data Model cannot connect to DB2 port 50000) ... 31

REPORTER database creation (Historical database for Event Analytics) ... 32

Installation Manager 1.8.6 ... 36

OMNIbus Core 8.1.0.16 – Console mode installation ... 38

OMNIbus Core 8.1 – Object Server migration from 7. x (Optional) ... 42

Netcool Operations Insight V.1.6.0 - Installation and set-up (step by step procedure)

(DB2, OMNIbus Core, DASH, OMNIbus WebGUI, Impact, LA, Event Analytics, Event Search) [ including reference to 2019 Q2 Fix Packs]

(2)

Object Server – Configuration options ... 44

Object Server Manual configuration ... 46

Object Server configuration with ICW ... 47

Object Server configuration using SMAC ... 54

JDBC Gateway installation – Console mode ... 57

Message Probe installation – Console mode ... 62

Process Agent configuration ... 64

DASH 3.1.3.0 Installation options ... 70

DASH 3.1.3.0 GUI Mode Installation ... 71

DASH 3.1.3.0 Silent mode installation ... 75

WebGUI 8.1.0.13 installation – Console mode ... 80

WebGUI / DASH migration from WebGUI 7.3.1 / 7.4 (Optional) ... 81

Impact 7.1.0.13 Cluster installation – Console Mode (OS Authentication) ... 82

Impact migration to 7.1 ... 91

Impact – Single sign-on configuration (DASH integration) ... 93

Configure Event Analytics ... 97

Event Analytics – Tuning and troubleshooting ... 101

Event Search – Install SCA-LA 1.3.5.1 with OMNIbus Insight Pack ... 106

Event Search - XML Gateway and OMNIbus Core configuration ... 119

Event Search Verifications ... 131

Event Search - Log Analysis how to delete data ... 135

Operations Analytics Log Analysis - Backup/Restore (information) ... 137

Upgrading NOI from previous version ... 141

Checklist for performing a new installation ... 145

(3)

Document location and change history

DOCUMENT LOCATION [INTERNAL] On BOX@IBM

https://ibm.ent.box.com/folder/26845385974 [EXTERNAL] On Developer works / Best Practices

(IBM Netcool Operations Insight 1.6 - Quick Installation & Upgrade Guide http://ibm.biz/nco_bps

[EXTERNAL] Specific

https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=cdd16df5-7bb8-4ef1-bcb9-cefb1dd40581#fullpage- WidgetId=W05de62601548_4e85_8940_81bb58657a85&file=d578d7a4-1d71-48ad-a0e7-7c5f21652a13

(4)

Version Date Details

1.1 31 July 2017 First published version

1.2 11 September 2017 New Items

[28.7 Create Console Integration]: added Knowledge center ID Link

[33.10 Configure OMNIbus WebGUI server.init ] : modified as a verification step, as values are set by installer [ 31.2 Impact JVM tuning for OutOfMemory exceptions ] : JVM setting suggestion for large databases

Corrections

[32.7 Install OMNIbus insight pack]: version corrected to 1.3.0.2 Updates

[4.8 Netcool OMNIbus Core 8.1 GA + Fix Pack]: added new links to Fix Central for FP13

[4.10 Netcool OMNIbus WebGUI 8.1.0.4 Refresh + Fix Pack]: added new links to Fix Central for FP11 [4.11 Netcool Impact 7.1.0.4 Refresh + Fix Pack]: added new links to Fix Central for FP11

1.3 25 January 2018 New Items

(5)

[3.2 Components distribution (example)]

[4.9 Software – Info to download new OMNIbus Core 8.1 Fix Pack 15] [ 4.12 Software – Info to download new OMNIbus WebGUI 8.1 Fix Pack 12] [ 4.13 Software – Info to download new Impact 7.1 Fix Pack 12 ]

[ 33. Event Search - XML configuration ] added info: Why configure SSL between LA and XML gateway [ 33.4 Export Server Certificate from LA server ] Alternative method (to get the certificate with openssl) [ 33.13 Add XML Gateway to PA ]

[ 34.8 Operations Analytics Log Analysis - Troubleshooting: cannot login into LA ] [ 35. Event Search - Log Analysis how to delete data ]

Updates

[ 4.10 JazzSM1130 Cumulative Patch 05 ] : updated from CP3 to CP5

[ 32.9 Create Log Analysis data source ] Added reference to Reference to scalaTransport.properties [ 33.8 XML Gateway - Configure Replication ] : updated with suggested setting

[ 33.9 Configure OMNIbus Object Server triggers ] updated with note: How to check trigger status 1.4 14 June 2018 Updated for NOI 1.4.1.2 – Event Analytics Configuration now done via the GUI

Section on upgrading added

Installation/upgrade checklists added

(6)

1.5.0 13th_{February 2019} _{updated with the latest fixpack information and additional post installation notes on setting EA properties.}

1.6 June 2019 Update with latest (Q2) fixpack information. Removed out of date information.

1.7 Jan 2020 Updated with review feedback.

Step Details

NOI on Knowledge center

https://www.ibm.com/support/knowledge-

center/en/SSTPTP_1.6.0/com.ibm.netcool_ops.doc/soc/collaterals/soc_netops_kc_welcome.html

Software Product Compatibility Reports / Operating System Reports http://www-969.ibm.com/software/reports/compatibility/clarity/index.html

Netcool Operations Insight Version 1.4: Deployment Guide http://www.redbooks.ibm.com/abstracts/sg248365.html?Open

Netcool Operations Insight: A Scenarios Guide http://www.redbooks.ibm.com/abstracts/sg248352.html?Open

Documentation

(7)

Step Details

Installation and set-up time (average) SCA-LA 1.3.5.3 (with Installation Manager 1.8.5) 25 min

OMNIbus Insight Pack 1.3.1.0 1

DASH 3133 (WAS8.5.5.15 / JazzSM 1.1.3.3) 30

WebGUI 8.1.0.16 25

Impact GUI 7.1.0.16 30

OMNIbus Core 8.1.0.19(with Installation Manager 1.8.5) 2

XML Gateway 8.0 2

Impact Server 7.1.0.16 30

Configuration

Event Search (Log Analysis) 20

Event Analytics (Seasonal Events & Related Events Groups) 10

Time to Install & Set-up NOI 1.6 2 hours 55 minutes

(8)

XML Gateway nco-g-xml 8 DB2 11.1 in REPORTER schema Message Probe nco-p-xml 1.4 Master netcool-server2 (BACKUP) OMNIbus Core 8119 OMNIbus WebGUI 8116 Impact 7116 XML Gateway nco-g-xml 8 DB2 11.1 in REPORTER schema JDBC Gateway nco-g-jdbc 1.6 Message Probe nco-p-xml 1.4 Slave analysis-server1 (LA PRIMARY) SCALA1353

OMNIbus Insight Pack 131 analysis-server2 (LA Backup) SCALA1353

(9)

Default URLs Login WebGUI Primary https://netcool-server1:16311/ibm/console/logon.jsp WebGUI Backup https://netcool-server2:16311/ibm/console/logon.jsp Impact Primary https://netcool-server1:17311/ibm/console/logon.jsp Impact Backup https://netcool-server2:17311/ibm/console/logon.jsp LA Primary https://analysis-server1:9987/Unity/login.jsp LA Backup https://analysis-server2:9987/Unity/login.jsp

Event Search (Log Analysis) - Integration components Event Search feature comes from the integration of following components: > Operations Analytics Log Analysis

(10)

> XML Gateway > OMNIbus Core > OMNIbus WebGUI

Event Analytics (Seasonal Events & Related Events) - Integration com-

ponents Event Analytics feature comes from the integration of following components: > OMNIbus Core

> OMNIbus WebGUI > Impact

> Historical archive database (REPORTER)

For information about checking prerequisites, see: https://www.ibm.com/support/knowledgecenter/SSTPTP_1.5.0/com.ibm.netcool_ops.doc/soc/integration/task/soc_int_install_prs.html

This link details the different software components that make up NOI 1.6, their part numbers and download locations (either PassportAdvantage or FixCentral).

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Netcool%20OMNIbus/page/Release%20details

This link also lists the components that have changed between this release and the previous release to enable upgrade planning.

(11)

Step Details

Components distribution Machine 1 - nectool-server1

OMNIbus Core 8.1.0.19 (with Installation Manager 1.8.6) XML Gateway 8.0

Impact Server 7.1.0.16

DB2 11.1 in REPORTER schema Machine 2 - nectool-server2

DASH 3130 (WAS85515/ JazzSM 1133) WebGUI 8.1.0.16

Impact GUI 7.1.0.16

Machine 3 - analysis-server1

SCA-LA 1.3.5.3 (with Installation Manager 1.8.6) OMNIbus Insight Pack 1.3.1

(12)

Machine requirements Minimal sizing

CPU: 4 cores - RAM: 8GB - HDD: 40GB

Suggested sizing

(13)

Schema (example)

Machine 1 - OMNIbus Primary (netcool-server1) Installation Manager 186 OMNIbus Core 8119 OMNIbus WebGUI 8116 Impact 7116

XML Gateway nco-g-xml 8

Step Details

(14)

Message Probe nco_p_message_bus 1.6 Master

Machine 2 - OMNIbus Backup (netcool-server2) Installation Manager 186 OMNIbus Core 8119 OMNIbus WebGUI 8116 Impact 7116 XML Gateway nco-g-xml 8 DB2 11.1 in REPORTER schema JDBC Gateway nco-g-jdbc 1.6

Message Probe nco_p_message_bus 1.6 Slave

Machine 3 - Log Analysis Primary (analysis-server1) Installation Manager 186

Operations Analytics Log Analysis 1353 OMNIbus Insight Pack 131

Machine 4 - Log Analysis Backup (analysis-server2) Installation Manager 186

(15)

Step Details Switch to the root user or other users that have the super user

permissions

Group and User creations (ncoadmin/netcool)

sudo -i

groupadd ncoadmin useradd netcool

passwd netcool (set password) usermod -g ncoadmin netcool chgrp ncoadmin /opt

chown -R netcool /opt Switch to the netcool user

Default variables

Add these variables to $HOME/.bash_profile

export NCHOME=/opt/IBM/tivoli/netcool

(16)

export WEBGUI_HOME=/opt/IBM/netcool/gui/omnibus_webgui export UNITY_HOME=/opt/IBM/LogAnalysis

Step Details

Software If you have GUI you can switch to root user and directly run the command: ./db2setup

1. Select the DB2 Version 10.5 Fix Pack 3 Workgroup, Enterprise and Advanced Edition (the first on the list) 2. Click “Next” at the Introduction, Software License Agreement, and select “Typical” ad Installation type 3. Select “Install DB2 Server Edition on this computer” as “Installation action”

4. Select “Next” in the Installation directory step 5. Insert a password for the DAS user

6. Select “Create a DB2 instance” in the Instance setup step 7. Select “Single partition instance” as Partitioning option 8. Create another password in step “Instance-owning user”. 9. Create another password for the step “Fenced user”

10. Select “Do not step your DB2 server to send notifications at this time” for the Notification setup step If you do not have the GUI, follow these steps:

~/DB2-11.1/server

db2

db2checkCOL_readme.txt db2checkCOL.tar.gz db2ckupgrade

(17)

(18)

Summary db2prereqcheck

~/DB2-11.1/server/db2prereqcheck

Checking DB2 prerequisites for DB2 database version "11.1.0.0" on operating system "Linux" Summary of prerequisites that are not met on the current system:

DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*".

DBT3594W The db2prereqcheck utility found that the directory "/" does not have the recommended amount of free space on host "netcool-server1.ibm.net".

Recommended amount needed: "5120000 KB". Actual space present: "2894710164 KB".

DBT3594W The db2prereqcheck utility found that the directory "/opt" does not have the recommended amount of free space on host "netcool-server1.ibm.net".

DBT3594W The db2prereqcheck utility found that the directory "/home" does not have the recommended amount of free space on host "netcool-server1.ibm.net".

DBT3571E The db2prereqcheck utility found that the directory "/var" does not have enough free space on host "netcool-server1.ibm.net". Required space: "512000 KB". Actual space present: "2894710164 KB".

DBT3571E The db2prereqcheck utility found that the directory "/tmp" does not have enough free space on host "netcool-server1.ibm.net". Required space: "2000000 KB". Actual space present: "2894710164 KB".

(19)

DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6".

DBT3563E The db2prereqcheck utility determined that SELinux is enabled, which is not supported with GPFS.

Libraries db2prereqcheck DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*". DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6".

DBT3564E The db2prereqcheck utility was unable to find the package "openibd" on host "localhost.localdomain".

In the db2prereqcheck.log file, the following errors are not critical and can be ignored.

http://www.ibm.com/support/knowledgecenter/SS4KMC_2.5.0.1/com.ibm.ico.doc_2.5/ts/ts_errors_of_32_bit_li- brary_files.htm

Install DB2 ./db2_install

[root@netcool-server1 server]# id

uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 [root@netcool-server1 server]# ./db2_install

Requirement not matched for DB2 database "Server" . Version: "11.1.0.0". Summary of prerequisites that are not met on the current system:

(20)

Default directory for installation of products - /opt/ibm/db2/V11.1

*********************************************************** Install into default directory (/opt/ibm/db2/V11.1) ? [yes/no]

yes

Specify one of the following keywords to install DB2 products. SERVER

CONSV EXP

CLIENT RTCL

Enter "help" to redisplay product names. Enter "quit" to exit.

***********************************************************

SERVER

(21)

no

Requirement not matched for DB2 database "Server" . Version: "11.1.0.0". Summary of prerequisites that are not met on the current system:

DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*". DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6".

DB2 installation is being initialized.

Total number of tasks to be performed: 48

Total estimated time for all tasks to be performed: 1873 second(s) Task #1 start

Description: Checking license agreement acceptance Estimated time 1 second(s)

Task #1 end ...

Task #50 start

(22)

Task #50 end

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2_install.log.9177".

Check DB2 installation log DB2 Setup log file started at: Tue Jan 31 09:33:00 2017 CST

============================================================

Operating system information: Linux 3.10.0-514.2.2.el7.x86_64.#1 SMP Wed Nov 16 13:15:13 EST 2016 x86_64 WARNING: Notification SMTP server has not been specified. Notifications cannot

be sent to contacts in your contact list until this is specified. For more information see the DB2 administration documentation.

Product to install: DB2 Server Edition Previously Installed Components:

(23)

Java support SQL procedures Base server support Connect support

DB2 data source support Spatial Extender server support

IBM Software Development Kit (SDK) for Java(TM) DB2 LDAP support

Verify that you have access to the DB2 Information Center based on the choices you made during this installation. If you performed a typical

DB2 Instance Setup wizard Integrated Flash Copy Support Spatial Extender client

Communication support - TCP/IP Tivoli SA MP

Base application development tools DB2 Update Service

Replication tools Sample database source DB2 Text Search

(24)

First Steps

Guardium Installation Manager Client

Target directory: /opt/ibm/db2/V11.1

Space required: 1254 MB

Install IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP): Yes Checking license agreement acceptance ... Success

(25)

Installing: CONNECT_SUPPORT Installing: RELATIONAL_WRAPPERS_COMMON Installing: DB2_DATA_SOURCE_SUPPORT Installing: SPATIAL_EXTENDER_SERVER_SUPPORT Installing: JDK Installing: LDAP_EXPLOITATION Installing: INSTANCE_SETUP_SUPPORT Installing: ACS Installing: SPATIAL_EXTENDER_CLIENT_SUPPORT Installing: COMMUNICATION_SUPPORT_TCPIP Installing: TSAMP

WARNING: DBI20105E An error occurred while installing the following file set: "TSAMP". Because these files were not successfully installed, functionality that depends on these files might not work as expected.

(26)

Installing: ITLM Installing: TEXT_SEARCH Installing: CLPPLUS Installing: INFORMIX_DATA_SOURCE_SUPPORT Installing: ORACLE_DATA_SOURCE_SUPPORT Installing: FIRST_StepS Installing: ESE_PRODUCT_SIGNATURE Installing: GUARDIUM_INST_MNGR_CLIENT Installing DB2 file sets ... Success

DBI1514I The DB2 High Availability (HA) scripts for the IBM Tivoli System Automation for Multiplatforms (SA MP) were successfully installed.

You need DB2 HA scripts to use SA MP with the DB2 HA feature. These DB2 HA scripts are located at /usr/sbin/rsct/sapolicies/db2. The DB2 installer detects whether these DB2 HA scripts need to be installed or updated.

(27)

Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) ... Suc-cess

Executing control tasks ... Success Updating global registry ... Success Starting DB2 Fault Monitor ... Success Updating the db2ls link ... Success Registering DB2 licenses ... Success

Setting default global profile registry variables ... Success Initializing instance list ... Success

Registering DB2 Update Service ... Success Updating global profile registry ... Success

Post install recommendations Required steps:

Set up a DB2 instance to work with DB2. Optional steps:

To validate your installation files, instance, and database functionality, run the Validation Tool, /opt/ibm/db2/V11.1/bin/db2val. For more information, see "db2val" in the DB2 Information Center.

(28)

Verify that you have access to the DB2 Information Center based on the choices you made during this installation. If you performed a typical or a compact installation, verify that you can access the IBM Web site using the inter- net. If you performed a custom installation, verify that you can access the DB2 Information Center location specified during the installation.

Ensure that you have the correct license entitlements for DB2 products and features installed on this machine. Each DB2 product or feature comes with a license certificate file (also referred to as a license key) that is distrib- uted on an Activation CD, which also includes instructions for applying the license file. If you purchased a base DB2 product, as well as, separately priced features, you might need to install more than one license certificate. The Activation CD for your product or feature can be downloaded from Passport Advantage if it is not part of the physical media pack you received from IBM. For more information about licensing, search the Information Center (http://publib.bould

er.ibm.com/infocenter/db2luw/v11r1/index.jsp) using terms such as "license compliance", "licensing" or "db2licm".

To use your DB2 database product, you must have a valid license. For information about obtaining and applying DB2 license files, see

http://pic.dhe.ibm.com/infocenter/db2luw/v11r1/topic/com.ibm.db2.luw.qb.server.doc/doc/c0061199.html

DB2 validation

/opt/ibm/db2/V11.1/bin/db2val

Insert your DB2 version number instead of V11.1

[root@netcool-server1 ~]# /opt/ibm/db2/V11.1/bin/db2val

DBI1379I The db2val command is running. This can take several minutes. DBI1335I Installation file validation for the DB2 copy installed at

(29)

DBI1343I The db2val command completed successfully. For details, see the log file /tmp/db2val-170201_072546.log.

Users and Groups creations Create Groups

groupadd -g 994 db2iadm1 groupadd -g 993 db2fadm1 groupadd -g 992 dasadm1 Create users for each group:

useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1 useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1 useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1 Set password

passwd db2inst1 passwd db2fenc1 passwd dasusr1

(30)

/opt/ibm/db2/V11.1/instance/dascrt -u dasusr1 /opt/ibm/db2/V11.1/instance/db2icrt -a server -u db2fenc1 db2inst1

DBI1070I Program dascrt completed successfully.

[root@netcool-server1 instance]# ./db2icrt -a server -u db2fenc1 db2inst1

DBI1446I The db2icrt command is running. DB2 installation is being initialized.

Total number of tasks to be performed: 4

Total estimated time for all tasks to be performed: 309 second(s) Task #1 start

Description: Setting default global profile registry variables Estimated time 1 second(s)

Task #1 end Task #2 start

Description: Initializing instance list Estimated time 5 second(s)

Description: Configuring DB2 instances Estimated time 300 second(s)

(31)

Task #4 end

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2icrt.log.3746". Required: Review the following log file also for warnings or errors:

"/tmp/db2icrt_local.log.*"

DBI1070I Program db2icrt completed successfully.

Troubleshooting - Missing libaio In case of error

db2start: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Solution Install libaio:

sudo yum install libaio

libaio x86_64 0.3.109-13.el7 rhel-7-server-rpms Install 1 Package

Total download size: 24 k Installed size: 38 k

Is this ok [y/d/N]: y Downloading packages:

libaio-0.3.109-13.el7.x86_64.rpm Running transaction check Running transaction test Transaction test succeeded Running transaction

(32)

Installed: libaio.x86_64 0:0.3.109-13.el7 DB2 Start su db2inst1 db2start [db2inst1@netcool-server1 DB2-11.1.0.0]$ db2 (c) Copyright IBM Corporation 1993,2007 Command Line Processor for DB2 Client 11.1.0

You can issue database manager commands and SQL statements from the command prompt. For example:

db2 => connect to sample db2 => bind sample.bnd For general help, type: ?.

For command help, type: ? command, where command can be

the first few keywords of a database manager command. For example: ? CATALOG DATABASE for help on the CATALOG DATABASE command ? CATALOG for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside interactive mode, all commands must be prefixed with 'db2'.

To list the current command option settings, type LIST COMMAND OPTIONS. For more detailed help, refer to the Online Reference Manual.

(33)

Step Detail Events Analytics - Impact Data Model cannot connect to DB2 port

50000

ID Link - Configuring TCP/IP communications for a DB2 instance

https://www.ibm.com/support/knowledge-

center/en/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server.doc/doc/

t0004727.html

Procedure To configure TCP/IP communications for a DB2 instance

Update the services file on the server. Refer to Updating the services file on the server for TCP/IP communications. Update the database manager configuration file on the server. Refer to Updating the database manager configuration file on the server for TCP/IP communications.

Set communication protocols for a DB2 instance Refer to Setting communication protocols for a DB2 instance.

Step Details

Install the Netcool/Omnibus Gateway ynco-g-jdbc-reporting-script package using the Installation Manager

Start Installation Manager:

/opt/IBM/IM/InstallationManager/eclipse/tools/imcl -c

=====> IBM Installation Manager> Install Select packages to install:

1. [ ] Netcool/OMNIbus Gateway nco-g-jdbc-reporting-scripts 1.1.0.0 O. Check for Other Versions, Fixes, and Extensions

C. Cancel

DB2 troubleshooting (Event Analytics- Impact Data Model cannot connect to DB2 port 50000)

(34)

Add Repository (Example):

=====> IBM Installation Manager> Preferences> Repositories $SW_Repository/im-nco-g-jdbc-rpt-scripts-1_0/repository.config

Install gateway:

=====> IBM Installation Manager Select: 1. Install - Install software packages < INSTALL

Package Group Name: IBM Netcool Core Components Installation Directory: /opt/IBM/tivoli/netcool

Shared Resources Directory: /home/netcool/IBM/IBMIMSharedPackages to be installed: Netcool/OMNIbus Gateway nco-g-jdbc-reporting-scripts 1.1.0.0Options:

G. Generate an Installation Response File B. Back, I. Install, C. Cancel ---> [I]

25% 50% 75% 100% ---|---|---|---| ...

=====> IBM Installation Manager> Install> Licenses> Location> Summary> CompletionThe install completed successfully.Options:

F. Finish ---> [F]

Update schema db2.reporting.sql File

(35)

$OMNIHOME/gates/reporting/db2/db2.reporting.sql (from JDBC scripts download)

CREATE DATABASE reporter @

CONNECT TO reporter USER db2inst1 USING password @

# Any associated journal and details rows are deleted from the database when the corresponding alerts are deleted.

, CONSTRAINT eventref FOREIGN KEY (SERVERNAME, SERVERSERIAL) REFERENCES REPORTER_STA- TUS(SERVERNAME, SERVERSERIAL) ON DELETE CASCADE)

Create database structure Commands

su db2inst1

cd $OMNIHOME/gates/reporting/db2 db2 -td@ -vf db2.reporting.sql

[db2inst1@netcool-server1 db2]$ db2 -td@ -vf db2.reporting.sql CREATE DATABASE reporter

DB20000I The CREATE DATABASE command completed successfully. CONNECT TO reporter USER db2inst1 USING

Database Connection Information

Database server = DB2/LINUXX8664 11.1 SQL authorization ID = DB2INST1

Local database alias = REPORTER

CREATE TABLE REPORTER_STATUS (IDENTIFIER VARCHAR (255), SERIAL INTEGER, NODE VARCHAR (64), NODEALIAS VAR

CHAR (64), MANAGER VARCHAR (64), AGENT VARCHAR (64), ALERTGROUP VARCHAR (255), ALERTKEY VARCHAR (255), SEV

ERITY INTEGER, SUMMARY VARCHAR (255), STATECHANGE TIMESTAMP, FIRSTOCCUR- RENCE TIMESTAMP, LASTOCCURRENCE TIMESTAMP, L

(36)

INTEGER, LOCATION VARCHAR (64), OWNERUID INTEGER, OWNERGID INTEGER, ACKNOWLEDGED INTEGER, FLASH

INTEGER, EVENTID VARCHAR (255), EXPIRETIME INTEGER, PROCESSREQ INTEGER, SUP- PRESSESCL INTEGER, ibm V

ARCHAR (64), SERVICE VARCHAR (64), PHYSICALSLOT INTEGER, PHYSICALPORT INTEGER, PHYSICALCARD VARCHAR (64), TASKLIST

INTEGER, NMOSSERIAL VARCHAR (64), NMOSOBJINST INTEGER, NMOSCAUSETYPE INTE- GER, LOCALNODEALIAS VARCHAR (64), LOCALPRIOBJ

VARCHAR (255), LOCALSECOBJ VARCHAR (255), LOCALROOTOBJ VARCHAR (255), REMOTE- NODEALIAS VARCHAR (64), REMOTEPRIOBJ VARCHAR (

, SERVERNAME, STARTDATE, CAST (NULL AS INTEGER), SEVERITY, CAST(NULL AS INTEGER), CAST(NULL AS INTEGER) FROM REP_AUDIT_SEVERITY UNION SELECT

255), REMOTESECOBJ VARCHAR (255), REMOTEROOTOBJ VARCHAR (255), X733EVENTTYPE IN- TEGER, X733PROBABLECAUSE INTEGER, X733SPECIFICPROB VARCHAR (64), X733CORRNOTIF VAR- CHAR (255), SERVERNAME VARCHAR (64) NOT NULL, SERVERSERIAL INTEGER NOT NULL, ORIGINALSEVERITY INTEGER, DELETEDAT TIMESTAMP, PRIMARY KEY (SERVERNAME, SERV- ERSERIAL) ) DATA CAPTURE NONE

DB20000I The SQL command completed successfully.

CREATE TABLE REPORTER_JOURNAL ( SERIAL INTEGER NOT NULL, USERID INTEGER NOT NULL, CHRONO TIMESTAMP NOT NULL, TEXT1 VARCHAR (255), TEXT2 VARCHAR (255), TEXT3 VARCHAR (255), TEXT4 VARCHAR (255), TEXT5 VARCHAR (255), TEXT6 VARCHAR (255), TEXT7 VARCHAR (255), TEXT8 VARCHAR (255), TEXT9 VARCHAR (255), TEXT10 VARCHAR (255), TEXT11 VARCHAR (255), TEXT12 VARCHAR (255), TEXT13 VARCHAR (255), TEXT14 VARCHAR (255), TEXT15 VARCHAR (255), TEXT16 VARCHAR (255), SERVERNAME VARCHAR (64) NOT NULL, SERVERSERIAL INTEGER NOT NULL , CONSTRAINT eventref FOREIGN KEY (SERVERNAME, SERVERSERIAL) REFERENCES REPORTER_STA- TUS(SERVERNAME, SERVERSERIAL) ON DELETE CASCADE ) DATA CAPTURE NONE

(37)

...

COMMIT WORK

DB20000I The SQL command completed successfully.

Verification point: connect to REPORTER DB Command

db2 connect to reporter

Database Connection Information

Database server = DB2/LINUXX8664 11.1 SQL authorization ID = DB2INST1

Local database alias = REPORTER

Verification point: verify REPORTER tables Command

db2 list tables

(38)

REPORTER_NAMES DB2INST1 T 2017-02-02-06.09.48.721973 REPORTER_STATUS DB2INST1 T 2017-02-02-06.09.48.643413 REP_AUDIT DB2INST1 V 2017-02-02-06.09.48.839306 REP_AUDIT_ACK DB2INST1 T 2017-02-02-06.09.48.712770 REP_AUDIT_OWNERGID DB2INST1 T 2017-02-02-06.09.48.694221 REP_AUDIT_OWNERUID DB2INST1 T 2017-02-02-06.09.48.684405 REP_AUDIT_SEVERITY DB2INST1 T 2017-02-02-06.09.48.703364 REP_REFERENCE_DATE DB2INST1 V 2017-02-02-06.09.48.829479 REP_SEVERITY_TYPES DB2INST1 T 2017-02-02-06.09.48.765391 REP_TIME_PERIODS DB2INST1 T 2017-02-02-06.09.48.783392 STATUS_VW DB2INST1 V 2017-02-02-06.09.48.834713 16 record(s) selected. Step Details

(39)

Installation Manager will be installed during the OMNIBUS

installation

Note to this Installation type

ID Knowledge Center - Installing or updating Installation Manager

Installation Manager can be installed in different ways.

(40)

https://www.ibm.com/support/knowledge-

center/en/SSDV2W_1.8.5/com.ibm.cic.agent.ui.doc/topics/r_in- stall_im_overview.html

This document describes stand-alone installation of Installation Manager with no files installed in the user default directory. This type of installation is mandatory when the NOI machines are sharing same home directory.

Install Installation manager in non-default location - Console Mode / Group Mode

cd $SW_Repository/IM186

./groupinstc -dataLocation /opt/IBM/IM/var -installationDirectory /opt/IBM/IM/InstallationManager -configuration /opt/IBM/IM/etc - acceptLicense

[netcool@netcool-server1 IM186]$ ./groupinstc -dataLocation /opt/IBM/IM/var -installationDirec- tory /home/netcool/IBM/IM/Installatio

nManager -configuration /home/netcool/IBM/IM/etc -acceptLicense

Installed com.ibm.cic.agent_1.8.6000.20161118_1611 to the /opt/IBM/IM/InstallationMan- ager/eclipse directory.

Installation Time ~ 30-60 Seconds

Install Installation manager in non-default location - Console Mode / User Mode (for LA machine)

cd $SW_Repository/IM186

./userinstc -dataLocation /opt/IBM/IM/var -installationDirectory /opt/IBM/IM/InstallationManager -configuration /opt/IBM/IM/etc - acceptLicense

Note

Log Analysis (SCA-LA) cannot be installed with Installation Manager installed in Group Mode

(41)

Select:

1. Install - Install software packages

2. Update - Find and install updates and fixes to installed software packages 3. Modify - Change installed software packages

4. Roll Back - Revert to an earlier version of installed software packages 5. Uninstall - Remove installed software packages

Other Options: L. View Logs

S. View Installation History V. View Installed Packages

---P. Preferences

---A. About IBM Installation Manager

---X. Exit Installation Manager

Step Details

(42)

To get the correct permissions, switch to root user and run the command: chmod 777 opt

(43)

If you don’t have the Installation Manager, run the command:

./install_gui.sh or install_console.sh and follow the “Console

Mode Installation section”

If you have already the Installation Manager: Create Repositories

Start Installation Manager in Console Mode /opt/IBM/IM/InstallationManager/eclipse/tools/imcl -c

Add Repository

=> IBM Installation Manager

> Preferences> Repositories > Add Repository

Example

(44)

Console Mode Installation =====> IBM Installation Manager Select:

1. Install - Install software packages < --- INSTALL

2. Update - Find and install updates and fixes to installed software packages

3. Modify - Change installed software packages

4. Roll Back - Revert to an earlier version of installed software packages

5. Uninstall - Remove installed software packages

=====> IBM Installation Manager> Install Select packages to install:

1. [X] IBM Tivoli Netcool/OMNIbus 8.1.0.19 < --- SELECT PRODUCT =====> IBM Installation Manager> Install> Licenses> Shared Directory Shared Resources Directory:

/opt/IBM/IBMIMShared

=====> IBM Installation Manager> Install> Licenses> Shared Directory> Location New package group:

1. [X] IBM Netcool Core Components

(45)

Installation Time ~ 60 Seconds

Selected location: "/opt/IBM/tivoli/netcool" < --- CHOOSE INSTALL DIR Selected architecture: 64-bit

=====> IBM Installation Manager> Install> Licenses> Shared Directory> Location> Features

IBM Tivoli Netcool/OMNIbus 1. [X] Administrator GUI 2. [X] Administrator tools 3. [X] TEC migration 4. [X] Operator GUI 5. [X] ObjectServer 6. [X] ObjectServer gateways 7. [X] Bridge server 8. [X] Proxy server 9. [X] Process agent 10. [X] Probe support 11. [X] Gateway support 12. [X] Netcool MIB Manager 13. [X] Extensions

(46)

Target Location:

Package Group Name : IBM Netcool Core Components Installation Directory : /opt/IBM/tivoli/netcool

Shared Resources Directory : /opt/IBM/IBMIMShared Translations:

English

Packages to be installed:

IBM Tivoli Netcool/OMNIbus 8.1.0.19

=====> IBM Installation Manager> Save response file

Response file was generated successfully: /opt/Core8119-response-file.xml ---> [I]

25% 50% 75% 100%

---|---|---|---| ...

=====> IBM Installation Manager> Install> Licenses> Shared Directory> Location> Features> Configurations> Summary

(47)

Start Installation Manager

/opt/IBM/IM/InstallationManager/eclipse/tools/imcl -c > V. View Installed Packages

2. IBM Tivoli Netcool/OMNIbus 8.1.0.19

If you are using the GUI Mode Installation, select the

Netcool/Omnibus Initial Configuration Wizard and follow Option B in the “Object Server- Configuration Options” section.

Step Details

(48)

Export from OMNIbus 7.x On Source System (7.x) cd $ OMNIHOME /bin

./nco_osreport -dbinit -server PRIMARY -user root -password < customer password>

(49)

Migrate OMNIbus 7.x to Object Server to 8.1.0.11

On Destination system (8.1) - Create Migrated Object Server

cd $OMNIHOME/bin

./nco_dbinit -force -server NOI_AGG_P -systemfile system.sql -applicationfile application.sql -alertsdata -alertsdatafile alertsdata.sql -desktopfile desktop.sql -automationfile automation.sql -securityfile security.sql

Update Interface and start Object Server Add Interface

vi $NCHOME/etc/omni.dat Apply modification

$NCHOME/bin/nco_igen

Start Object Server

$NCHOME/bin/nco_objserv – name NOI_AGG_P

Add interface example [NOI_AGG_P]

{

Primary: netcool1-server 4100 }

Verification point: login Object Server SQL $OMNIHOME/bin/nco_sql -server NOI_AGG_P -user root

ps -ef | grep objserv

root 2485 9841 0 2016 ? 17:01:44 /opt/IBM/tivoli/netcool/omnibus/plat- form/linux2x86/bin64/nco_objserv -name NOI_AGG_P

(50)

Select SQL file depending on migration path ($OMNIHOME/etc)

-rw--- 1 root system 1267 29 Apr 12:09 update81fp15to81fp16.sql -rw--- 1 root system 81450 29 Apr 12:09 update74fp3to81.sql -rw--- 1 root system 9689 29 Apr 12:09 update81fp10to81fp13.sql -rw--- 1 root system 28553 29 Apr 12:09 update71to72.sql -rw--- 1 root system 2153 29 Apr 12:09 update81fp7to81fp8.sql -rw--- 1 root system 2226 29 Apr 12:09 update81to81fp5.sql -rw--- 1 root system 17221 29 Apr 12:09 update81fp5to81fp7.sql -rw--- 1 root system 7753 29 Apr 12:09 update73to731.sql -rw--- 1 root system 15093 29 Apr 12:09 update72xto73.sql -rw--- 1 root system 3498 29 Apr 12:09 update81fp13to81fp15.sql -rw--- 1 root system 10902 29 Apr 12:09 update74to74fp3.sql -rw--- 1 root system 14983 29 Apr 12:09 update70to71.sql -rw--- 1 root system 1295 29 Apr 12:09 update81fp8to81fp10.sql -rw--- 1 root system 15899 29 Apr 12:09 update731to74.sql

cd $OMNIHOME/bin

./nco_sql -user root -password '' -server NOI_AGG_P < $OMNIHOME/etc/update74to74fp3.sql

./nco_sql -user root -password '' -server NOI_AGG_P < $OMNIHOME/etc/update74fp3to81.sql ./nco_sql -user root -password '' -server NOI_AGG_P < $OMNIHOME/etc/update81to81fp5.sql ./nco_sql -user root -password '' -server NOI_AGG_P < $OMNIHOME/etc/update81fp5to81fp7.sql ./nco_sql -user root -password '' -server NOI_AGG_P < $OMNIHOME/etc/update81fp7to81fp8.sql

Step Details

(51)

https://www.ibm.com/support/knowledgecenter/en/SSSHTQ_8.1.0/com.ibm.netcool_OMNI- bus.doc_8.1.0/omnibus/wip/install/task/omn_con_os_creatingobjserv.html

Option B: Object Server configuration using ICW ICW = Initial Configuration Wizard

Initial configuration wizard

The Initial Configuration Wizard (nco_icw) automates some initial configuration tasks, such as creating Ob- jectServers and gateways.

The wizard presents a series of panes in which you can create the common components of a Tivoli Netcool/OMNIbus installation for one or more computers. When your configuration is complete, it is saved to a deployment descriptor file. You can apply the deployment descriptor file on any computer where the wizard is installed.

https://www.ibm.com/support/knowledgecenter/v1/sso/login?redi- rect_url=https%3A%2F%2Fwww.ibm.com%2Fsupport%2Fknowledge-

center%2Fen%2FSSSHTQ_8.1.0%2Fcom.ibm.netcool_OMNIbus.doc_8.1.0%2Fomnibus%2Fwip%2Fin- stall%2Freference%2Fomn_ins_ict.html

Option C: Object Server configuration using SMAC SMAC = Standard Multitier Architecture Configuration

Best practices recommendation

http://www.ibm.com/support/knowledge-center/SSSHTQ_8.1.0/com.ibm.netcool_OMNIbus.doc_8.1.0/omnibus/wip/install/concept/omn_esf_configuringdeploymultitieredarch.html

Installing the primary aggregation ObjectServer

(52)

Installing the backup aggregation ObjectServer

Use the following steps to install the backup aggregation ObjectServer NOI_AGG_B, and apply the SQL customization. If the ObjectServer is already installed and running, you can apply the SQL customization to the Ob- jectServer by using the aggregation SQL file provided.

Configuring the bidirectional aggregation ObjectServer Gateway

Use the following steps to configure the bidirectional aggregation ObjectServer Gateway AGG_GATE. Note that installation of Tivoli Netcool/OMNIbus is not necessary because the gateway is configured on the same host computer as the backup aggregation ObjectServer NOI_AGG_B.

Create the Virtual Object Server

Use the following steps to configure the bidirectional aggregation ObjectServer Gateway AGG_V.

Step Details

(53)

Create the Primary Object server (NOI_AGG_P)

Add Interface

vi $NCHOME/etc/omni.dat Apply modification

Add interface example [NOI_AGG_P]

{

Primary: netcool1-server 4100

}

(54)

Create Object Server $NCHOME/bin/nco_dbinit -server NOI_AGG_P

Start Object Server $NCHOME/bin/nco_objserv -name NOI_AGG_P

Initialize root password (optional) $OMNIHOME/bin/nco_sql -server NOI_AGG_P -user root > alter user 'root' set password 'netcool';

> go;

Verification point: Object Server running ps -ef | grep objserv

root 2485 9841 0 2016 ? 17:01:44 /opt/IBM/tivoli/netcool/omnibus/plat- form/linux2x86/bin64/nco_objserv -name NOI_AGG_P

(55)

Step Details

Create Object Server with Installation wizard Create one single object server

Command

$OMNIHOME/bin/nco_icw -console

Initial Configuration Wizard

---The wizard will guide you through creating your configuration for your Tivoli Netcool/OMNIbus environment.

[1] What you want to do:

* Create a new configuration <==== SELECT Edit an existing configuration.

Apply an existing configuration on this computer. Multitier ObjectServers

---[1] Aggregation backup: No <==== SET [2] Primary Collection ObjectServers: 0 [3] Collection backup: No <==== SET [4] Display ObjectServers: 0

(56)

---[1] * Host: netcool-server1.ibm.com <==== SET [2] * NCHOME: /opt/IBM/tivoli/netcool <==== SET [3] Add <==== ADD

...

[5] Computers:

netcool-server1.ibm.com - /opt/IBM/tivoli/netcool <==== RESULT Process Agent configuration

---[1] Process Agent on netcool-server1.ibm.com <==== SELECT Process Agent on netcool-server1.ibm.com

---Computer: netcool-server1.ibm.com:/opt/IBM/tivoli/netcool PA name: NCO_PA

[1] * Name prefix: NCO [2] * PA port: 4200

Aggregation layer configuration

(57)

Primary Aggregate

---ObjectServer name: NOI_AGG_P

[1] * Computer: netcool-server1.ibm.com - /opt/IBM/tivoli/netcool <==== SELECT [2] Name prefix: NOI <==== TYPE PREFIX

(58)

NCO_PA

(59)

Save configuration

---[1] * Descriptor file: /opt/IBM/tivoli/netcool/omnibus/etc/deployment_descriptor.xml [2] * Instruction file: /opt/IBM/tivoli/netcool/omnibus/etc/icw_instructions.txt

Apply the configuration

---Component: Interfaces file

Action: Update /opt/IBM/tivoli/netcool/etc/omni.dat and run nco_igen Component: Process agent

Action: Create configuration for this computer Component: Process agent

Action: Add entry for ObjectServer NOI_AGG_P Component: ObjectServer

Action: Create properties file and database for NOI_AGG_P Successful application

(60)

---Netcool/OMNIbus Process Agent Daemon - Version 8.1.0 64-bit

Start Process Agent & Object Server

Netcool/OMNIbus PA API Library Version 8.1.0 64-bit

Update PA configuration file _{Sybase Server-Library Release: 15.0} vi $OMNIHOME/etc/nco_pa.conf

Server Settings :

Find netcool user ID _{Name of server} _{: HURAIX01_PA}

more /etc/passwd | grep netcool _{Path of used log file} _{: /opt/IBM/tivoli/netcool/omnibus/log/NCO_PA.log} netcool:x:10802:501::/opt/netcool:/bin/bash _{Configuration File} _{: /opt/IBM/tivoli/netcool/omnibus/etc/nco_pa.conf}

In this example, the UID for the netcool user is 10802

Child Output File : /dev/null Maximum logfile size 1024

Locate the following line: _{Thread stack size} ₂₆₂₁₄₄

Command '$OMNIHOME/bin/nco_objserv -name NOI_AGG_P -

pa NCO_PA ' run as 0 Message Pool size 45568

PID Message Pool size 50

Change run as 0 to run as 10802. Rogue Process Timeout 30 Command '$OMNIHOME/bin/nco_objserv -name NOI_AGG_P -

pa NCO_PA ' run as 10802

Truncate Log : False Instantiate server to daemon : True Internal API Checking : False

Start PA No Configuration File : False

(61)

Authentication System : UNIX Trace Net library : False Trace message queues : False Trace event queues : False Trace TDS packets : False Trace mutex locks : False

Host DNS name : huraix01.hursley.ibm.com PID file (from $OMNIHOME) : ./var/NCO_PA.pid Kill Process group : False

Secure Mode : False

Administration Group Name : ncoadmin

Properties file : /opt/IBM/tivoli/netcool/omnibus/etc/NCO_PA.props Message level : Warning

Host Alias Lookups : True Forking to a Daemon Process...

Verification point: Process Agent status and Object Server login $OMNIHOME/bin/nco_pa_status -server NCO_PA

Check PA log

---Service Name Process Name Hostname User Status PID

(62)

more $OMNIHOME/log/NCO_PA.log

---Test Object Server SQL login

$OMNIHOME/bin/nco_sql -server NOI_AGG_P -user root

Step Details

Set Interfaces on Primary Set Interfaces

vi $NCHOME/etc/omni.dat Apply Interfaces

PRIMARY Interfaces example

[NOI_AGG_P] { Primary: netcool-server1 4100 } [NOI-AGG_B] { Primary: netcool-server2 4110 } [AGG_GATE] {

(63)

}

[NCO_PA] {

Primary: netcool-server1 4200 }

Set Interfaces on Backup Set Interfaces

vi $NCHOME/etc/omni.dat Apply Interfaces

BACKUP Interfaces example

(64)

Installing NOI_AGG_P on Primary

Initialize the ObjectServer NOI_AGG_P and apply SQL import file $OMNIHOME/bin/nco_dbinit -server NOI_AGG_P -customconfigfile $OMNIHOME/extensions/multitier/objectserver/aggregation.sql Start the ObjectServer NOI_AGG_P

$OMNIHOME/bin/nco_objserv -name NOI_AGG_P &

Verification point: test SQL login

$OMNIHOME/bin/nco_sql -server NOI_AGG_P -user root

Installing NOI_AGG_B on Backup

Initialize the ObjectServer NOI_AGG_B and apply SQL import file $OMNIHOME/bin/nco_dbinit -server NOI_AGG_B -customconfigfile $OMNIHOME/extensions/multitier/objectserver/aggregation.sql

Verification point: test SQL login

(65)

Start the ObjectServer NOI_AGG_B

$OMNIHOME/bin/nco_objserv -name NOI_AGG_B &

Installing AGG_GATE on Primary

Start the gateway AGG_GATE:

$OMNIHOME/bin/nco_g_objserv_bi -propsfile $OMNIHOME/etc/AGG_GATE.props &

Copy the multitiered property gateway files for the gateway: cp $OMNIHOME/extensions/multitier/gateway/AGG_GATE.* $OMNIHOME/etc/

Configure AGG_GATE in the AGG_GATE.props file in

$OMNIHOME/etc by changing the name of the Object Servers in the following lines:

Gate.ObjectServerA.Server: ‘NOI_AGG_P’ Gate.ObjectServerB.Server: ‘NOI_AGG_B’

(66)

Create a Virtual Object server (NOI_AGG_V) Add Interface vi $NCHOME/etc/omni.dat Apply modification $NCHOME/bin/nco_igen

Add interface example

[NOI_AGG_V] {

Primary: netcool1-server 4100 Backup: netcool2-server 4110 }

(67)

Step Details

Install JDBC gateway

Start Installation Manager:

/opt/IBM/IM/InstallationManager/eclipse/tools/imcl -c Add Repository (Example):

=====> IBM Installation Manager> Preferences> Repositories $SW_Repository/JDBC-gate/NCOMNI_GTW_JDBC.zip

Install gateway:

=====> IBM Installation Manager Select:

1. Install - Install software packages < --- INSTALL

Netcool/OMNIbus Gateway nco-g-jdbc 1.6.0.0 Options:

G. Generate an Installation Response File B. Back, I. Install, C. Cancel

---> [I]

25% 50% 75% 100%

---|---|---|---|

... =====> IBM Installation Manager> Install> Licenses> Loca- tion> Summary>

Completion

The install completed successfully. Options:

(68)

Configure JDBC gateway props file

1. Copy the props files to the correct place and change their names:

(69)

cd $OMNIHOME/gates/jdbc cp reporting.jdbc.map $OMNIHOME/etc/JDBC_GATE.map cp reporting.G_JDBC.props $OMNIHOME/etc/JDBC_GATE.props cp jdbc.rdrwtr.tblrep.def $OMNIHOME/etc/JDBC_GATE.rdrwtr.tblrep.def cp jdbc.startup.cmd $OMNIHOME/etc/JDBC_GATE.startup.cmd 2. Verify cd $OMNIHOME/etc JDBC_GATE.map JDBC_GATE.props JDBC_GATE.rdrwtr.tblrep.def JDBC_GATE.startup.cmd

You can configure encryption of the password in the JDBC_GATE.props file, for example

ConfigCryptoAlg: 'AES'

ConfigKeyFile: '/opt/netcool/IBM/tivoli/netcool/etc/security/keys/netcool.keygen' # STRING (Location of the file containing the key for encrypted config values and files)

Gate.Jdbc.Username: 'db2inst1' # STRING (JDBC username) Gate.Jdbc.Password: '<nco_g_aes encrypted pwd>' # STRING (JDBC password)

where <nco_g_aes encrypted pwd> is the out put from running the

$OMNIHOME/bin/nco_aes_crypt command. For more information on encryption see:

https://www.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/com.ibm.netcool_OMN Ibus.doc_8.1.0/omnibus/wip/admin/reference/omn_adm_ncoaescryptcmdlineopts.html # JDBC Connection properties Gate.Jdbc.Driver: 'com.ibm.db2.jcc.DB2Driver' Gate.Jdbc.Url: 'jdbc:db2://netcool-server2:50000/reporter'

Note: netcool-server2 should be changed to you’re your hostname

(70)

Gate.MapFile : '$OMNIHOME/etc/JDBC_GATE.map' Gate.RdrWtr.Server : 'NOI_AGG_P'

(71)

Configure JDBC gateway startup.cmd _{vi JDBC_GATE.startup.cmd} Remove comment

TRANSFER FROM 'alerts.conversions' TO 'REPORTER_CONVER- SIONS' DELETE USING TRANSFER_MAP ConversionsMap; TRANSFER FROM 'alerts.objclass' TO 'REPORTER_CLASSES' DE-LETE USING TRANSFER_MAP ObjectClassesMap;

TRANSFER FROM 'master.groups' TO 'REPORTER_GROUPS' DE- LETE USING TRANSFER_MAP GroupsMap;

TRANSFER FROM 'master.members' TO 'REPORTER_MEM- BERS' DELETE USING TRANSFER_MAP MembersMap;

(72)

Install the DB2 JDBC driver files _{cd /opt/ibm/db2/V11.1/java}

Note: check the version of your DB2 cp db2jcc.jar $OMNIHOME/gates/java

cp db2jcc_license_cu.jar $OMNIHOME/gates/java

Add the JDBC information into $NCHOME/etc/omni.dat Example to add to omni.dat

[JDBC_GATE] {

Update the interfaces file Run $NCHOME/bin/nco_igen to regenerate the interfaces file.

Start Gateway

$OMNIHOME/bin/nco_g_jdbc -name JDBC_GATE &

No errors in Log File

more $OMNIHOME/log/JDBC_GATE.log

Verification point: gateway operation su - db2inst1

db2 connect to reporter

db2 select node from reporter_status db2 select name from reporter_classes

(73)

db2 select name from reporter_names db2 select name from reporter_groups

db2 select owneruid from reporter_members

Setup JDBC cold stand-by configuration (Optional)

Download the nco_test_gateway.sh script from this page:

https://www.ibm.com/developerworks/community/blogs/cdd16df5-7bb8-4ef1-bcb9-cefb1dd40581/entry/setting_up_a_cold_standby_netcool_gateway_on_unix24?lang=en

Appendix B of the Netcool/OMNIbus 8.1 Best Practices guide: http://ibm.biz/nco_bps How it works

It works by using nco_ping to monitor the primary Gateway. If it fails a nco_ping more than RETRIES number of times (modifiable parameter in the script), then it makes a call to nco_pa_start to start up the cold standby Gateway. After this point, it continues to try to nco_ping the primary Gateway. Once it receives a positive response, it makes a call to nco_pa_stop to stop the cold standby Gateway and returns to its original state of monitoring the primary Gateway's availability.

Update script nco_test_gateway.sh

# ObjectServer Gateway names PRIMARY_GATEWAY='GATE_P' SECONDARY_GATEWAY='GATE_B' PA_NAME='NCO_PA' BACKUP_GATEWAY_PROCESS_NAME='BackupGateway' NCO_USER='ncouser' NCO_PASS='netcool' Note

(74)

Step Details

Install Message Probe Start Installation Manager

Add Repository (Example)

=====> IBM Installation Manager> Preferences> Repositories $SW_Repository/MsgBus-probe/Im-nco-p-message-bus-5_0.zip Install gateway

=====> IBM Installation Manager Select:

1. Install - Install software packages < --- INSTALL Repository (Example)

Netcool/OMNIbus Probe nco-p-message-bus 1.6.0.0 Options:

G. Generate an Installation Response File B. Back, I. Install, C. Cancel

---> [I]

25% 50% 75% 100%

---|---|---|---|

...

=====> IBM Installation Manager> Install> Licenses> Loca- tion> Summary>

Completion

The install completed successfully. Options:

(75)

Configure probes in master/slave mode vi $OMNIHOME/probes/linux2x86/xml.props Master on Primary

Server: 'NOI_AGG_P' Two instances of a probe can run simultaneously in a peer-to-peer failover relationship. One instance is desig-

nated as the master. The other instance acts as a slave and is on hot standby. If the master instance fails, the slave instance is activated.

PeerPort: 9999 PeerHost: 'netcool-server2' Mode: 'master' Slave on Backup Server: 'NOI_AGG_B' PeerPort: 9999 PeerHost: 'netcool-server1' Mode: 'slave'

Start Message Probe on Primary and Backup

https://www.ibm.com/support/knowledgecenter/SSSHTQ/omnibus/probes/all_probes/wip/concept/run- ning_probe.html

Start Probe

(76)

INFO : Backed up data version: 1.3.3.0.201512140347 INFO : Restoring configuration data for Log Analysis

INFO : Extracting ~SCALA133-Backup/LogAnalysis_02May2017_Restore_001.zip Done

INFO : Restoring backed up Solr data on analysis-server2.bluemix.net Done

INFO : Performing cleanup on analysis-server2.bluemix.net

INFO : Finished restoring Solr data on analysis-server2.bluemix.net INFO : Finished performing restore

INFO : Restore was successful, removing temporary directories INFO: Configuring properties files...

INFO: Configuring Log File Agent...

INFO: Finished configuring Log File Agent... encrypting the unityadmin and unityusers

INFO : Log Analysis data have been restored from the backup in ~/SCALA133-Backup.

Make sure that Log Analysis is running fine before deleting the backed up data. Note that some

(77)

(78)

Step Details PA configuration on Primary

Check the Interfaces using the command: vi $NCHOME/etc/omni.dat

Apply interfaces using the command: $NCHOME/bin/nco_igen

PRIMARY interfaces example [NCO_PA]

{

(79)

Update configuration as netcool user vi $OMNIHOME/etc/nco_pa.conf

Note: type the command “id” in the terminal to check the user id (it is normally 1000) Start PA as root user

$OMNIHOME/bin/nco_pad -name NCO_PA -authenticate none Verification Point > PA Status

$OMNIHOME/bin/nco_pa_status -server NCO_PA

---Core MasterObjectServerPrimarynetcool-server1 netcool RUNNING 8652

---Verification Point: Test SQL Object Server access $OMNIHOME/bin/nco_sql -server NOI_AGG_P -user root

PA Stop (info)

nco_process 'MasterObjectServerPrimary' {

Command '$OMNIHOME/bin/nco_objserv -name NOI_AGG_P -pa NCO_PA - propsfile $OMNIHOME/etc/NOI_AGG_P.props' run as 1000

Host = 'netcool-server1' Managed = True

RestartMsg = '${NAME} running as ${EUID} has been restored on ${HOST}.'

AlertMsg = '${NAME} running as ${EUID} has died on ${HOST}.' RetryCount = 0 ProcessType = PaPA_AWARE } nco_service 'Core' { ServiceType = Master ServiceStart = Auto

process 'MasterObjectServerPrimary' NONE }

(80)

(81)

(82)

Add Message Probe to PA on Primary _{nco_process 'MessageProbe'} {

Command '$OMNIHOME/probes/nco_p_message_bus' run as 1000 Host = 'netcool-server1'

Managed = True

AlertMsg = '${NAME} running as ${EUID} has died on ${HOST}.' RetryCount = 0

ProcessType = PaPA_AWARE }

process 'MessageProbe' 'MasterObjectServerPrimary'

PA configuration on Backup nco_process 'MasterObjectServerBackup'

(83)

Update configuration as netcool user vi $OMNIHOME/etc/nco_pa.conf Start PA as root user

$OMNIHOME/bin/nco_pad -name NCO_PA -authenticate none Verification Point > PA Status

$OMNIHOME/bin/nco_pa_status -server NCO_PA

---Core MasterObjectServerBackupnetcool-server2 netcool RUNNING 31079

---Verification Point: Test SQL Object Server access $OMNIHOME/bin/nco_sql -server NOI_AGG_P -user root

PA Stop (info)

$OMNIHOME/bin/nco_pa_shutdown -server NCO_PA

Command '$OMNIHOME/bin/nco_objserv -name NOI_AGG_B -pa NCO_PA - propsfile $OMNIHOME/etc/NOI_AGG_B.props' run as 1000

Host = 'netcool-server2' Managed = True

nco_process ‘AGG_GATE’

{ Command ‘$OMNIHOME/bin/nco_g_objserv_bi -propsfile $OMNIHOME/etc/AGG_GATE.props ’ run as 1000

Host = ‘netcool-server2’

Managed = True RestartMsg = ‘${NAME} running as ${EUID} has been restored on ${HOST}.’

AlertMsg = ‘${NAME} running as ${EUID} has died on ${HOST}.’ RetryCount = 0 ProcessType = PaPA_AWARE } nco_service 'Core' { ServiceType = Master ServiceStart = Auto

(84)

}

nco_routing {

(85)

Add Message Probe to PA on Backup _{nco_process 'MessageProbe'} {

Command '$OMNIHOME/probes/nco_p_message_bus' run as 1000 Host = 'netcool-server1'

Managed = True

process 'MessageProbe' 'MasterObjectServerBackup'

Add JDBC Gateway to PA on Backup nco_process 'JDBCArchiveGateway'

{

Command '$OMNIHOME/bin/nco_g_jdbc -name JDBC_GATE' run as 1000 Host='netcool-server2'

Managed=True

(86)

AlertMsg='${NAME} running as ${EUID} has died on ${HOST}.' RetryCount=0

ProcessType=PaPA_AWARE }

#Note: the following line needs to be included in the nco_service ‘Core’ process 'JDBCArchiveGateway' 20

Run PA start-up script on Primary and Backup

Installing UNIX start-up scripts to automatically start PA

https://www.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/com.ibm.netcool_OMNI- bus.doc_8.1.0/omnibus/wip/admin/task/omn_adm_pa_automaticallystartpas.html sudo -i

$OMNIHOME/install/startup/linux2x86install

Notes

> linux2x86install needs to be run as the root user - because it has to create files in /etc/init.d and elsewhere.

> netcool user must belong to ncoadmin group

[root@netcool-server1 ~]# $OMNIHOME/install/startup/linux2x86in- stall This script copies a startup script into the /etc/init.d directory to enable you to automatically start and stop Netcool/OMNIbus processes. It does this by:

Copying linux2x86/etc/rc.d/init.d/nco to /etc/init.d/nco Running "/sbin/chkconfig --add nco"

Do you wish to continue (y/n)? [y] y

Name of the Process Agent Daemon [NCO_PA]: Should NCO_PA run in secure mode (y/n)? [y] n

Enter value for environment variable NETCOOL_LICENSE_FILE if required [27000@localhost]:

(87)

Step Details

Option A: GUI Mode Installation _{GUI / export display must be available on NOI machines.}

Option B: Silent Mode Installa-

tion If GUI / export display is not available on NOI machines DASH must be installed in Silent mode (DASH cannot be installed in Console mode)

Note Check the open files limit of your system by using the command ulimit -a and ensure it is larger than 2048

DASH 3.1.3.3 Installation options

(88)

Create Repositories Unzip

unzip <downloaded filename>.zip

(SDK files can be unzipped under same directory)

Add Repository

=====> IBM Installation Manager> Preferences> Repositories Repositories

(89)

$SW-RepositoryDASH3133/WASRepository/disk1/diskTag.inf

DASH 3133 GUI Mode Installation (with Response File genera- tion)

Start Installation Manager in GUI mode

/opt/IBM/IM/InstallationManagerr/eclipse/IBMIM

Start Installation Manager with Record option

/opt/IBM/IM/InstallationManagerr/eclipse/IBMIM -record /opt//DASH-Install-ResponseFile.xml

Note

This is useful to create a Response File that can be later used for Silent install.

GUI panel 1: Installation packages selection IBM WebSphere Application Server V8.5 > IBM WebSphere Application Server 8.5.5.15 IBM WebSphere SDK Java Technology Edition > 7.0.9.30

(90)

Core services in Jazz for Service Management > IBM Dashboard Application Services Hub 3.1.3.0

GUI panel 2: Features to install

GUI panel 3: Select installation directory Installation Time

(91)

Verification point: Login DASH Login DASH smadmin / < password >

(92)

Step Details Create Repositories Unzip unzip CNC1PML_IBM_jazzsm_v1300_Linux64.zip unzip CNC1ZML_IBM-was-8.5.5.9_Linux64.zip unzip 7.1.3.10_0001-WS-IBMWASJAVA-part1.zip unzip 7.1.3.10_0001-WS-IBMWASJAVA-part2.zip Add Repository

=====> IBM Installation Manager> Preferences> Repositories Repositories (Example)

$SW_Repository/DASH/JazzSM1300/JazzSMRepository/disk1/diskTag.inf $SW_Repository/DASH/WAS8559/WASRepository/disk1/diskTag.inf $SW_Repository//DASH/SDK/repository.xml

(93)

Encrypt Password in Response File Response File

vi DASH-Install-ResponseFile.xml Password Encryption

Response file requires DASH admin password to be encrypted

/opt/IBM/IM/InstallationManager/eclipse/tools/imutilsc encryptString < password >

Example

root@test:/opt/IBM/IM/InstallationManager/eclipse/tools # /opt/IBM/IM/InstallationMan- ager/eclipse/tools/imutilsc encryptString < password >

hi0uX5JGIycIzyiXd6Q9gw==

DASH-Install-ResponseFile.xml _{See response file at the end of this chapter}

DASH Installation in Silent Mode Example

/opt/IBM/IM/InstallationManager/eclipse/tools/imcl input $SW_Reposi- tory/ResponseFiles/DASH-Install-ResponseFile.xml -log $SW_Reposi- tory/DASH/DASH-install.log -acceptLicense

[netcool@netcool-server1 ResponseFiles]$ /opt/IBM/IM/InstallationManager/eclipse/tools/imcl input ~/Response- Files/DASH-Install-ResponseFile.xml -log $SW_Repository/DASH/DASH-install.log -acceptLicense

Installed com.ibm.websphere.BASE.v85_8.5.5009.20160225_0435 to the /opt/IBM/WebSphere/AppServer directory. Installed com.ibm.websphere.IBMJAVA.v70_7.0.9030.20160224_1826 to the /opt/IBM/WebSphere/AppServer directory.

(94)

Installed com.ibm.tivoli.tacct.psc.tip.install_3.1.3000.20160606-1749 to the /opt/IBM/JazzSM directory.

Verification point: check Installed packages on Installation Manager _{3-. IBM WebSphere Application Server V8.5} 4. IBM WebSphere Application Server 8.5.5.15

5. IBM WebSphere SDK Java Technology Edition (Optional) 7.0.9.30 6. Jazz for Service Management extension for IBM WebSphere 8.5 1.1.3.1 7-. Core services in Jazz for Service Management

8. IBM Dashboard Application Services Hub 3.1.3.3

Verification point: Login DASH No errors in Log file

$SW_Repository/DASH/DASH-install.log

Login DASH smadmin / < password >

https://netcool-server1:16311/ibm/console/logon.jsp

DASH restart (info) _{Stop DASH}

$JAZZSM_HOME/profile/bin/stopServer.sh server1 -username smadmin -password < password > Start DASH

(95)

(*) DASH INSTALL RESPONSE FILE

<?xml version='1.0' encoding='UTF-8'?> <agent-input>

</profile> <install>

(96)

</install>