Explain how to Increase the storage limit for historical performance data in ITNM?
Submitted by: AdministratorYou 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%etcprecisionNcPollerSchema.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..
Submitted by: Administrator
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%etcprecisionNcPollerSchema.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..
Submitted by: Administrator
Read Online IBM Tivoli Job Interview Questions And Answers
Top IBM Tivoli Questions
☺ | How to configure the Agent? |
☺ | What are the install support files to TEPS? |
☺ | What are the Install support files on RTEMS? |
☺ | Tell me what are various Connector modes in TDI? |
☺ | Write the command to verify the agent running status? |
Top Technical IBM Tools Categories
☺ | IBM AIX Interview Questions. |
☺ | MAXIMO Interview Questions. |
☺ | IBM Tivoli Interview Questions. |
☺ | IBM Netcool/Omnibus Interview Questions. |