I'm, trying to create a sql query that will show total number and duration of incoming and outgoing calls. Since there is no such option in CDR I have decided to do this via publisher cli with "run sql query". I have already created the queries.
My concerns is : Could this query cause crash of the publisher (high CPU utilization)? Customer CDR database contains 1.7 mil records in billing_data table with the latest entry from 29/2/2012.
Is this option(run sql query from publisher) suitable for such large queries?
Does the publisher/Iformix DB have some prevention mechanisms, against queries that cannot be handled or against high CPU utilization?
You really shouldn't be doing analysis type queries on your CUCM DB. You should be feeding the CDRs into another system, and running analysis on there.
Think of the call data records in the CUCM DB as just a cache before they are delivered to an external DB.
As to whether the query will bring down CUCM. Assuming your publisher has no phones/gateways registered to it, then your pathalogical SQL query *shouldn't* affect call processing. When I've done some pathalogical SQL UPDATES to my CUCM cluster, I've seen CUCM rollback the UPDATE because it was taking too long, so there are some protections in there.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
[toc:faq]CUCM Database Replication is an area in which Cisco customers
and partners have asked for more in-depth training in being able to
properly assess a replication problem and potentially resolve an issue
without involving TAC. This document discusse...