08-06-2015 02:01 PM - edited 03-15-2019 06:10 AM
We are having 8.0.3 ucce set up for both production and lab environment, can someone help on my below query:
How to check the data retension period in AWDB?
In production AWDB/HDS i can able to query any calls last month , last year even more older than that.
In lab AWDB/HDS when i query RCD,TCD, Event detail etc any tabels , am getting data for only last 20 -30 days.
Is this is an issue or the DB setted up like that as it is lab?
Please let me know where can i check the retension period of the data which presents in the DB?
08-06-2015 04:41 PM
You can do it in the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems, Inc.\ICM\<your_instance_name>\Distributor\RealTimeDistributor\CurrentVersion\Recovery\CurrentVersion\Purge\Retain
Under the Retain key, you'll find several others. Each DWORD value will be titled as "Days" and the decimal value is the number of days of retention.
Do not ever change the values under the System key unless TAC tells you so
08-07-2015 09:42 AM
Thank you both for your help,
I don't see any windows logs in EV for SQL data purge. and i have right clicked the HDS and checked on both lab and Produ, please see below:
In lab (Lab is the problem)- Initial size was set to 10000MB for data and 500MB for log
In Prod (Just to compare)- Initial size was set to 20000MB for data and 1000MB for log
from above size am sure something difference is there between Lab and Prod but trying to exact retention period .
I have checked in the above reg path on my machine it shows DWORD as 0x00000447(1095). Which means the retention period is for 447 days?
A doubt raised on this, i also checked in prod and its same for DWORD as 0x00000447(1095). If its 447 days then my prod DB should not show the data older than that, but my prod awdb pulls the data which is 2 years olders and even older.
08-07-2015 11:07 AM
how many DB's show up in SQL management studio. For example, in our environment we have a database called awdb and a database called sideA_hds. When you run your query do you have the proper DB selected? Just a thought and throwing out a guess. Based on what you provided above the DB seems to be set up with plenty of space.
08-06-2015 05:55 PM
Check your windows event logs for SQL warnings and see if the database is purging. once the database reaches 80% it will purge data until you fall below the 80% capacity.
Also, right click your HDS database and select properties then select file. You should see what the size of your is as well as what the initial size was set to.
08-07-2015 11:10 AM
Check the DB size using DB sizing estimator tool. Where you can able to see existing DB size and you can able to modify the values.
ICMDBA > Database > estimate.
Also find the below link for more reference.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: