Question
How to Increase the storage limit for historical performance data in ITNM

Answers

- 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.cfgv 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.   Your Comment






Search
Can you Answer!!
  • Q How many Rajya sabha seats in the state?
  • Q what is plantar arch
  • Q How do u implement PUSH on a flex appln?
  • Q How to convert a .NET object into COM operabililty?
  • Q What is the .net framework?
  • Q Explain what is permutation?
  • Q What causes a language to evolve? Can this be stopped? How?
  • Q How do I solve 'The server failed to load the application' errors?
  • Q Tell me the properties of RDBMS as per CAP Theorem.
  • Q How can a users custom environment be made permanent?
  • Q Can you catch HIV from kissing?