Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on July 03, 2013, 02:53:15 PM
-
hello,
I am just wondering if I run the manual purge in cca (v7.6) can it be manually stopped?
We are trying to reduce the db size without asking DB team to do this.
It is too large to just enable the purging option and have it run automatically overnight every night.
I am hoping it can be run over a weekend and based on etl assistant purge rules will complete however if it is not done by weekend we can stop it then finish on the following weekend.
thanks.
-
If your purging did not run for a long time and in your database are large amount of data, the purging can take a while and can increase load of whole DBS. For these purposes is better to write own purging procedures, which will purge with "smaller" segment of data. I did it for customer with big reporting database (over milions statistics per day)
-
Be also aware that if using MSSQL Transaction log will grow and potential failure point
-
[quote author=cavagnaro link=topic=7880.msg34402#msg34402 date=1372867510]
Be also aware that if using MSSQL Transaction log will grow and potential failure point
[/quote]
We are using MSSQL
Am I better asking our DB team to purge.
We were concerned about the impact of removing data without using the genesys services, as DB team would use their own procedures.
thanks.
-
Well ETL is just that, a processed information and has nothing to do with Genesys Core anymore. So you can delete data the same way just be sure to understand all tables relations and that is it. Worst scenario is you delete an object id and not its data...