Paradyne SLM 5.5 manual OLCmd dbage

A. OLCmd Reference

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:
-ninstance	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.

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

7800-A2-GB32-00 January 2002 A-9