Old data in the metric tables
The table PV_METRIC.C01_BASE_000_H0 holds 115 entries, the table
PV_METRIC.C01_BASE_000_H1 holds 8760 entries. The corresponding tablespaces are from C01_BASE_000_2006092600 through to C01_BASE_000_2007092500 (365 in total). Can you advice us how: - either we can force the old data to the ....H2 table, so that it can be purged by the purging process - or, how we can safely delete the old data manually
H0 and H1 tables cycles the old data out to H2, then it gets purged from H2. So H0 and H1 always hold more recent data
But the way the H0/H1/H2 tables are set up is from the last data hour, not the wall clock hour. so if the last data that came in was, say from 10 Jan 2006, the purge would only purge data that is older than the retention period say 90 days old, but 90 days old from 2006. Hence it makes sense why you have 4 years old data, because thats the latest it has.
The reason to design it this way is if a channel fell behind in time then you wouldn't want it to start purging data
How to get rid of it ?
You can drop the old 000_<date> datafiles, but you have to do it through Oracle, please don't delete the files from the OS
And then just truncate (delete all the entries in the table while leaving the table still there, just with zero entries) the 000_h0/1/2 tables so the table is still there but they have zero entries
Your DBA should be able to do that.
Please note if any reports look at those reports, they'll break. But I assume that's not a problem since it's back in 2006/2007
dbRegEdit mountpoint thresholds IV62150 2014-07-01=
Mount_Point should be of type STRING and not NUMBER
+- FILESYSTEM | +- THRESHOLD | | +- WARNING : NUMBER : "75" | | +- CRITICAL : NUMBER : "9" | | +- DEADZONE : NUMBER : "99" | +- SPECIFIC_THRESHOLD_1 | | +- WARNING : NUMBER : "85" | | +- CRITICAL : NUMBER : "9" | | +- DEADZONE : NUMBER : "95" | | +- MOUNT_POINT: STRING : "/export/home" | +- SPECIFIC_THRESHOLD_2 | | +- WARNING : NUMBER : "8" | | +- CRITICAL : NUMBER : "85" | | +- DEADZONE : NUMBER : "9" | | +- MOUNT_POINT: STRING : "/export/home"
Notification email address fiel is 'MAIL_ADDRESS' and not 'SCRIPT_NAME' - IV55743