Polycom 3725-70003-009F Manual De Usuario
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;
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
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:
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.
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
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
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
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
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
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.
Your Polycom Global Services representative can help you determine the best
frequency, time, and run time parameter for this script.