[cisco-voip] cisco-voip Digest, Vol 60, Issue 97

Fri Oct 10 15:55:40 EDT 2008

http://www.cisco.com/en/US/docs/ios/voice/sip/configuration/guide/sip_cg
-basic_cfg.html

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Brad Westman
Sent: Friday, October 10, 2008 3:10 PM
To: 'cisco-voip at puck.nether.net'
Subject: Re: [cisco-voip] cisco-voip Digest, Vol 60, Issue 97

My question is where can I find good documentation on the SIP to
provider configuration for a IOS router. (book or online docs).

thanks

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of
cisco-voip-request at puck.nether.net
Sent: Friday, October 10, 2008 10:37 AM
To: cisco-voip at puck.nether.net
Subject: cisco-voip Digest, Vol 60, Issue 97

Send cisco-voip mailing list submissions to
        cisco-voip at puck.nether.net

To subscribe or unsubscribe via the World Wide Web, visit
        https://puck.nether.net/mailman/listinfo/cisco-voip
or, via email, send a message with subject or body 'help' to
        cisco-voip-request at puck.nether.net

You can reach the person managing the list at
        cisco-voip-owner at puck.nether.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of cisco-voip digest..."

Today's Topics:

   1. Re: CAR and CDR Records (Micah Bennett)
   2. Re: CAR and CDR Records (Matt Slaga (US))

----------------------------------------------------------------------

Message: 1
Date: Fri, 10 Oct 2008 10:27:30 -0500
From: "Micah Bennett" <mbennett at als-xtn.com>
Subject: Re: [cisco-voip] CAR and CDR Records
To: <cisco-voip at puck.nether.net>
Message-ID:

<160C116A79522E4B9404937D2E28811D014BFCC1 at exchange02.alsnet.als-xtn.com>

Content-Type: text/plain; charset="us-ascii"

Hello All

I was looking in some of my books to get a better understanding of the
CDR database stuff and I have a few questions.

My limit right now in CM is set for 2 million CDR records.  My alert is
set at 80%.  I have reached the 80% limit so I am getting alerts daily.

I know I can turn the alert % up, or I can ignore it and when it gets
full it will just start dropping off the oldest records.

I really would just like to save more records but I want to make sure
it's a safe thing to do especially with our high volume spikes and this
is our busy season.

The books I have say that the Call manager can safely store up to around
10 million records.  The default setting is 1.5 million.  Ours is at 2
million.

Right now at 1.6 million records (80% of 2 million) I have about 6
months of Call manager CDR data.  I would like to keep a year of CDR
records so I would really like to bump that limit up to around 4 or 5
million records.

We have two subscribers sending records back to our publisher.  We are
on CCM 4.2(3).

Is there anything I should watch out for in moving the limit this high?

Also, I have a lot of small flat files in the BAD directory on the
Publisher.  According to the documentation these are just corrupt CDR
records that could not be written to the database.

Is there a tool to fix these, or do they just need to be periodically
deleted so they are not taking up space.

Thanks for any input.

Micah Bennett

  _____

From: James Buchanan [mailto:jbuchanan at ctiusa.com]
Sent: Thursday, October 09, 2008 8:45 AM
To: Micah Bennett; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] CAR and CDR Records

Hello,

That is correct. Only the CDR records are affected.

Just a note-BARS does not backup the IPCC historical records. You have
to back those up doing a SQL dump.

Thanks,

James

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Micah Bennett
Sent: Thursday, October 09, 2008 8:43 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] CAR and CDR Records

Something new for me today.  Got an email message from my systems that
my CDR records and CAR records on my Call manager cluster have reached
the specified threshold.

I checked and the current settings are for 2 million rows with
notification at 80% full.

I also found that the automatic purge is not currently set.  I am going
to set this for 365 days so we have the last year of data, but I wanted
to confirm that this only affects the Call Manager records and not the
IPCC Records.  My understanding is that all the IPCC records are stored
in the CRS database.

Micah Bennett

Telecommunications Admin

Automated License Systems

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://puck.nether.net/pipermail/cisco-voip/attachments/20081010/56db4
37f/attachment-0001.html>

------------------------------

Message: 2
Date: Fri, 10 Oct 2008 11:34:47 -0400
From: "Matt Slaga \(US\)" <Matt.Slaga at us.didata.com>
Subject: Re: [cisco-voip] CAR and CDR Records
To: "Micah Bennett" <mbennett at als-xtn.com>,
        <cisco-voip at puck.nether.net>
Message-ID:

<C1FE15183DA37645BC0633BC604E44F00C0A7F15 at USNAEXCH.na.didata.local>
Content-Type: text/plain; charset="us-ascii"

My suggestion is to use a third party provider for CDR record reporting
and record management.  This keeps the mass number of records off your
CallManager and allows greater record access and faster reporting, and
for your case, a longer archive.

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Micah Bennett
Sent: Friday, October 10, 2008 11:28 AM
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CAR and CDR Records

Hello All