[cisco-voip] Cisco CDR

[Daniel]

You can run the command
run sql select * from car:tbl_system_preferences

Look for the MAX_CDR_NUMBER value by default this is set to 2000000.

If need be (I would not advise this, do not change this without direction
from cisco TAC) you can increase the max cdr value. Increasing this value
will cause more disk space to be used. Make sure your retention policy is
set beforehand. Check your automatic purge settings, I won't advise any
values as I don't know how busy your system is.

You can run the command (I would not advise this, do not change this without
direction from cisco TAC)
run sql update car:tbl_system_preferences set param_value='5000000' where
param_name='MAX_CDR_NUMBER'

Restart the appropriate services like the car scheduling services.

Also check the service parameter "CDR Log Calls with Zero Duration Flag" you
might be logging calls that do not need to be kept.



On Tue, Apr 21, 2009 at 12:09 AM, VoIP Canada <voipcanada at gmail.com> wrote:

> you have to add a radius just to be safe so in case there is power outage
> you loose all records on the cisco ,,, voipcanada at gmail.com
>
>
> On Mon, Apr 20, 2009 at 9:35 AM, Ryan Ratliff <rratliff at cisco.com> wrote:
>
>> The size is a hard limit due to the max 2 million CDR records and cannot
>> be increased.  The retention period is going to be based on how many CDR
>> records you are generating and how quickly that 2 million records is being
>> reached.
>>
>> -Ryan
>>
>>
>> On Apr 20, 2009, at 5:04 AM, Mohammed Naviwala wrote:
>>
>> Hi
>>
>> does anyone know whats the problem with the CUCM CDR in 6.1?? somehow i am
>> not able to allocate more than 3 GB and 30 days retention period. anybody
>> has any solution?
>>
>> --
>> Best Regards
>>
>> Mohammed Abdul Razzaq
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>
>
>
> --
> Ajinder Singh
> CTO
> www.btel.ca
>
> 151 front street, toronto, canada
> Philippines || India || Canada || HongKong
>
> Delhi Phone +91 98 7166 0553
> Toronto Phone: +1 647-285-8677
> HK Phone: +852 9758 5459
> efax: +1 416 273 7501
> MSN: voipcanada at hotmail.com
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090422/c6836e36/attachment.html>