Filter
Top Products
ReadiVoice Administration & Maintenance Guide
110 Proprietary & Confidential
Purging the CacsEventUpdate Table
If you use the Provisioning Stored Procedure Interface (PSPI) for provisioning,
you need to purge the
CacsEventUpdate
table from time to time to keep it
from growing too large.
Several stored procedures don’t load the new data into call router memory
immediately. Instead, they put the new data into the
CacsEventUpdate
table;
the CACS then updates the call router with the data from the temporary table
every ten seconds.
For more information about PSPI, see the ReadiVoice PSPI Reference.
If you use stored procedure calls (SPCs) that write records to this table, then
you must purge those records regularly.
Your ReadiVoice installation includes a script,
cleanCacsEvtUpdate.pl
, that
purges the processed records from the
CacsEventUpdate
table. You can use
the cron task scheduler to run this script periodically.
The
cleanCacsEvtUpdate.pl
script resides in
/rahome/database/scripts
.
The syntax is:
cleanCacsEvtUpdate.pl [-rt nn]
The
-rt
parameter lets you specify a run time,
nn
, in minutes. If you omit it,
the run time defaults to 10 minutes. The script terminates at the end of the run
time, even if it hasn’t purged all processed records from the table.
Purging the AccOptChanges Table
If your system has the Account Options Updates feature enabled (see
“Enabling Account Options Updating” on page 128), you need to purge the
AccOptChanges
table from time to time to keep it from growing too large.
If the Account Options Updates feature is enabled, when subscribers change
their account options (using the account options menu in the call flow), the
ReadiVoice system records those changes in the
AccOptChanges
table (in
addition to updating the subscriber records).
You can use the
GetAccOptChanges
stored procedure to retrieve these account
options update records and update your customer database. The stored
procedure flags the records you retrieve as processed.
For more information about this stored procedure, see the ReadiVoice PSPI
Reference.
Your ReadiVoice installation includes a script,
cleanAccOptChanges.pl
, that
purges the processed records from the
AccOptChanges
table. You can use the
cron task scheduler to run this script periodically.
Caution!
Using this script improperly may impede your ReadiVoice conferencing services.
Your Polycom Global Services representative can help you determine the best
frequency, time, and run time parameter for this script.