You can configure a connection to a valid Db2® database from within IBM®
Tivoli®
Netcool®/Impact.
Before you begin
In Netcool/Impact 7.1.0.13 and later releases,
it is recommended to use the Event
Analytics configuration wizard instead of
the ./nci_trigger
command to edit properties in the NOI Shared Configuration
properties file. For more information, see Configuring Event Analytics using the wizard.
About this task
Users can run seasonality event reports and related event
configurations, specifying the time range and name with Db2. Complete the following steps to configure
the ObjectServer data
source or data type.
Procedure
- Log in to the Netcool/Impact UI.
https://impacthost:port/ibm/console
- Configure the ObjectServer data
source and data type.
- In the Netcool/Impact UI,
from the list of available projects, select the NOI project.
- Select the Data Model tab and
select ObjectServerForNOI.
- Click Edit and enter information for <username>, <password>, <host
name>, <port>.
- To save the Netcool/Impact data
source, click Test Connection, followed by
the Save icon.
- Edit the data type. Expand the data source and edit
the data type to correspond to the ObjectServer event
history database type.
For example, AlertsForNOITable
- For
Base Table
, select <database
table>.
- To update the schema and table, click Refresh and
then click Save.
- Select the Data Model tab and
select ObjectServerHistoryDb2ForNOI.
- Click Edit and enter information for <username>, <password>, <host
name>, <port>.
- To save the Netcool/Impact data
source, click Test Connection, followed by
the Save icon.
- Edit the data type. Expand the ObjectServerHistoryDb2ForNOI data
source and edit
AlertsHistoryDb2Table
.
- For
Base Table
, select <database
name> and <database table name>
- To update the schema and table, click Refresh and
then click Save.
- Select the Services tab and ensure
that the following services are started.
ProcessRelatedEvents
ProcessSeasonalityEvents
ProcessRelatedEventConfig
- Configure the Db2 database
connection within Netcool/Impact if
it was previously configured for Oracle or MSSQL. The following steps
configure the report generation to use the Db2 database. Export the default properties,
change the default configuration, and update the properties.
- Generate a properties file, go to the <Impact
install location>/bin directory to locate the
nci_trigger
,
and run the following command from the command-line interface.
nci_trigger <server> <username>/<password> NOI_DefaultValues_Export
FILENAME directory/filename
where
- <server>
- The server where Event Analytics is installed.
- <user name>
- The user name of the Event Analytics user.
- <password>
- The password of the Event Analytics user.
- directory
- The directory where the file is stored.
- filename
- The name of the properties file.
For example:
./nci_trigger NCI impactadmin/impactpass NOI_DefaultValues_Export
FILENAME /tmp/seasonality.props
- Update the properties file. Some property values are
overwritten by the generated properties file, you might need to update
other property values in the generated properties file. For a full
list of effected properties, see Generated properties file.
- Import the modified properties file into Netcool/Impact,
enter the following command.
nci_trigger <Server> <username>/<password> NOI_DefaultValues_Configure
FILENAME directory/filename
For example:
./nci_trigger NCI impactadmin/impactpass NOI_DefaultValues_Configure
FILENAME /tmp/seasonality.props