IBM Tivoli Question: Download IBM Tivoli PDF

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..