
7. OpenLane Maintenance
Deleting Older Records from the Database
he dbage function of OLCmd has four modes:
The
The
The
Tdeleted according to values specified when the dbage function is executed The
When the dbage function is run periodically, it should be run twice: once to delete records for nonexistent connections with the
For a complete description of the dbage command, see Appendix A, OLCmd
Reference.
Frequency
How often dbage needs to be run depends in part on the disk space allotted to the database. In a system collecting data for
Tiny Database | Small Database | Medium Database | Large Database |
(Up to 25 devices | (Up to 250 devices | (Up to 750 devices | (Up to 5000 devices |
and 75 PVCs) | and 750 PVCs) | and 2250 PVCs) | and 15,000 PVCs) |
|
|
|
|
76 KB | 62 KB | 62 KB | 61 KB |
|
|
|
|
However, regardless of available space, the database will run more efficiently the more its size is limited.
The running of dbage can be automated using cron (under Solaris) or at (under Windows). See Automating the Generation of Scheduled Reports on page
Example
To delete all dead data records and then delete report and raw data records according to device definitions, enter the commands:
OLCmd dbage
OLCmd dbage
| January 2002 |