Paradyne SLM 5.5 manual Databaseinstance, Ipaddress, OLCmd dbroll -e 20010101000000 -r

A. OLCmd Reference

OLCmd dbroll

User history statistics are stored by 15-minute intervals. To speed up the processing of SLV reports, and to reduce the size of the database, you can roll up statistics into hourly intervals by using the dbroll function of OLCmd.

Format:

OLCmd dbroll [-ddatabase_instance] [-sstart_time] [-eend_time] [-iip_address] [-r][-h]

Where:
-d	Optionally specifies the user history database to roll
database_instance	up. If no database is specified, the default database is
	used.
-sstart_time	Optionally specifies the start time of statistics to be
	rolled up, in the form YYYYMMDDhhmmss.
	Example: 20011012235959 denotes one second
	before midnight (23:59:59) on October 12, 2001. If
	not specified, roll-up begins at the beginning of the
	user history database.
-eend_time	Optionally specifies the end time of statistics to be
	rolled up, in the form YYYYMMDDhhmmss.
	Example: 20020101000000 denotes midnight
	(00:00:00) on January 1, 2002. If not specified, roll-up
	ends at the end of the user history database.
-iip_address	Optionally specifies the IP address of a device whose
	statistics are to be rolled up. If not specified, statistics
	for all devices are rolled up.
-r	If specified, statistics that are successfully rolled up
	are deleted from the database.
-h	Prints usage notes similar to those shown here.

Example:

To roll up and delete 15-minute buckets created before January 2001 for all devices, enter the command:

OLCmd dbroll '-e 20010101000000 -r'

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