Filter
Top Products
A. OLCmd Reference
A-14
January 2002 7800-A2-GB32-00
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
[
-d
database_instance
] [
-s
start_time
] [
-e
end_time
]
[
-i
ip_address
] [
-r
] [
-h
]
Where:
Example:
To roll up and delete 15-minute buckets created before January 2001 for all
devices, enter the command:
OLCmd dbroll '-e 20010101000000 -r'
-d
database_instance
Optionally specifies the user history database to roll
up. If no database is specified, the default database is
used.
-s
start_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.
-e
end_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.
-i
ip_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.