Paradyne OpenLane SLM 5.5 - Manual (Page 79)

A. OLCmd Reference
7800-A2-GB32-00 January 2002 A-9
OLCmd dbage
The dbage command removes older records from the performance statistics
database.
Format:
OLCmd dbage [ -n instance ] [[ -d | -a ] | [[ -raw days ] [ -rpt days ]] | -dd ]
Where:
Example:
To delete Report data records older than 90 days and Raw data records older than
7 days, enter the command:
OLCmd dbage -n OracleStatsDB -raw 7 -rpt 90
To delete all records for nonexistent connections, then delete Report and Raw
data records according to individual device definitions, enter the commands:
OLCmd dbage -n OracleStatsDB -dd
OLCmd dbage -n OracleStatsDB -d
-n instance Specifies the database name. If -n is omitted, the default
database is used.
-d Removes records from the database by device according to
the parameters selected when each device was added.
-a Removes records from the database using the number of
days in the system-wide preferences (preferences.dat).
-raw days Optionally specifies the age in days of the oldest Raw
(quarter-hourly user history) data record to be retained. This
overrides the Save Raw Data For value entered when each
device was added to the database. If 0 is specified, all Raw
data records in the database are deleted.
-rpt days Optionally specifies the age in days of the oldest Report
(hourly user history) data record to be retained. This
overrides the Save Report Data For value entered when
each device was added to the database. If 0 is specified, all
Report data records in the database are deleted.
-dd Optionally deletes data for connections which no longer
exist. The -dd parameter may not be specified with the -d,
-a, -raw, or -rpt parameters.
A connection is determined to be nonexistent when an
interface appears in the user history database but not in the
LDAP database. If the -dd option is never used, user history
records for nonexistent connections are eventually deleted
like other records, according to age.