Filter
Top Products
ReadiVoice Administration & Maintenance Guide
106 Proprietary & Confidential
The
purgeCDR
command syntax is:
Table 4-2 describes the options (command-line arguments).
Both the cutoff date and number of days options use midnight as the
boundary. If you specify a cutoff date of 08/21/2003, the last conference
purged will be one that ended at 11:59:59 on 08/20/2003. If you specify the
number of days as 30, and 30 days ago was 08/14/2003, the last conference
purged will be one that ended at 11:59:59 on 08/13/2003.
purgeCDR [-h] [-d mm/dd/yyyy] [-n numOfDays] [-i] [-u] [-m maxCpuUsage] [-rt numOfMinutes]
[-cs numOfSubscribers] [-v] [-ip] [-na]
Table 4-2
purgeCDR
command options
Option Description
-h
Display help.
-d
Cutoff date. CDRs of conferences that ended before this date are purged. Must be
in
mm/dd/yyyy
format, where
mm
is month,
dd
is day, and
yyyy
is year. This option is
only useful for running the script manually (interactive mode). Either it or the next
must be specified.
-n
Cutoff number of days. CDRs of conferences that ended more than this many days
ago are purged. May be any integer. Use this option to run the script automatically
at scheduled intervals. Either it or the
-d
(date) option must be specified.
-i
Run in interactive mode (manually at the command line as a one-time purge). The
script prompts you to confirm before purging the records. This option must be
specified in order to use the
-u
option.
-u
Updates database statistics (indexes) upon completion. The script must be run by
user cnow to use this option.
-m
Maximum CPU usage. The purge process halts temporarily if CPU usage (in
percent) by other processes exceeds this value. Valid values are 0 to 100. Doesn’t
check CPU usage if not specified. When running purgeCDR on a live conferencing
system, we strongly recommend using this option to minimize the impact on your
system.
-rt
Maximum run time in minutes. Default is 120.
-cs
Number of conferences to delete per batch. Default is 4000. Valid values are 50 to
4000.
-v
Display a list of conferences to be purged without purging them.
If you use this option with cutoff parameters that return a very large number of
records (>50,000), the script may terminate with an “out of memory” error.
-ip
Ignore the
processed
flag in the
cdr_post_conf
table. If this option isn’t specified,
the script deletes only conferences with the
processed
flag set to
1
.
-na
No archive. Specify this option to skip writing the records to a file before purging.