IBM Tivoli Question:
Download Questions PDF

Explain how to Increase the storage limit for historical performance data in ITNM?

Answer:

You can increase the storage limit for historical performance data. This enables
Performance reports to display a greater amount of historical data.
The storage limit for historical performance data is set by default to a conservative
value of 5 million database rows. You can increase this value; however, this can
lead to a degradation in the performance of the Performance reports.
To increase the storage limit for historical performance data:
1. Locate the following file:
v UNIX $NCHOME/etc/precision/NcPollerSchema.cfg
v Windows %NCHOME%\etc\precision\NcPollerSchema.cfg
2. Find the section that contains the following lines:
-- =========================================================================
-- pruning
-- =========================================================================
create table config.pruning
(
MAXPOLLDATAROWS long64 not null
);
--
-- This defines the maximum number of rows allowed in ncpolldata.polldata.
-- Once the number of rows exceeds this limit the older data will be pruned
-- until close to the limit again.
--
-- Increasing this number will result in an increase in the data storage
-- size required for historical data and may also lead to a degradation
-- in the performance of reports using this data.
--
insert into config.pruning (MAXPOLLDATAROWS) values (5000000);
3. Change the value of MAXPOLLDATAROWS..

Download IBM Tivoli Interview Questions And Answers PDF

Previous QuestionNext Question
How to Assign poller for MIB graphing in ITNM?What are the phases of Discovery in ITNM?