reduce CCE database size

[shauret]

We are having problems with some some apps that have to write or read on CCE database. We We need to reduce CCE database to improve this. There is some job created to do this? Which is the risk to delete a big amount of registries at the same time?

[droart]

How big is the DB? I don't think Avaya has a magic # but we reccomend scripting a new DB when the ASMSDatax is between 6-8 GB. I have seen it grow a lot larger and have issues but in my opinon it is better to script a new one earlier than later. I am not aware of any documentation around this (there may be some, i just have figured out the way i like to do it). But there are two SPs in the ASMSControl DB. The first you need to run is the ASMSData Create SP. You can read the SP before executing to see the input parameters. That will create a new "child" DB. Once that is done you need to make a change to the Databases table in the ASMSControl to reference the new DB. Once that is done you can run the ASMSData Database update and it will bring the child DB up to the current version as defined in the tblASSystem table.

[depaulai]

store procedure

Sebastian didn't specified the version of CCE that is 3.03 in this case

So Avaya doesn't have a standard store procedure to make this?
Is there a way that you can contact product house to investigate?
The store procedures that are on the DB's are to reduce data on the TBL tables not on the AsscociatedData (ASMediaStore), conversations messages etc. This is where we are indeed to reduce the amount of records.

thanks in advance.

[droart]

I am not aware of a SP to truncate the tables to a certain date.. My thought would be to archive the DB and script a whole new DB. But it has been some time since I have worked with that version so i am not sure of the best way to do this.

[aapawan123]

in 3.0.3, it's 'procDeleteEventDetail' and 'procDeleteStats'. This will delete the events and stats table where most of the records.