[cisco-voip] redirect admin:run sql to a file

Thu May 15 17:04:27 EDT 2008

Hi Mordechai,

In that case you have upgraded to a version where CM changed from .csv 
to ontape for backup.  Unfortunately this precludes the backup method 
unless you possibly have an informix DBA around who can restore the 
ontape to another server.  looks like it's back to AXL.

/Wes

Mordechai wrote:
>
> Wes,
>
>  
>
> I liked your idea of using backup files because I can process large 
> amounts of text data assuming data from tables is dumped into csv. 
> However, I must be missing something or misunderstand. For the world 
> of me I can’t find any csv files in the tar. There is cdr_repository 
> backup (totally redundant, I wonder if I can exclude it from the 
> backup) and the only other large file is ‘drf_ontape_backup’. Where 
> should I look for db csv?
>
>  
>
> Thanks,
>
>  
>
> Mordechai
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Wes Sisk [mailto:wsisk at cisco.com]
> *Sent:* Thursday, May 15, 2008 1:32 AM
> *To:* Mordechai
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] redirect admin:run sql to a file
>
>  
>
> Mordechai,
>
> In CM5.x the DRS backup process actually exports to .csv files so you 
> could grab the .tar file from backup destination and extract the data.
>
> otherwise the only way is going to be axl.  direct queries should not 
> be too bad, just don't go for complex joins or data modification.
>
> /Wes
>
> Mordechai wrote:
>
> No, not CDRs (which are covered nicely by hourly exports via sftp to a 
> windows server and from there imported to my off-line MS-SQL for 
> queries etc).
>
>  
>
> We have over 10000 users and I am often asked to generate reports so 
> they can plan MAC and rollout activities. I haven’t tried an AXL query 
> that would result in a more that a couple of hundreds records, that’s 
> why I am asking what to anticipate if I want to dump the entire 
> endusers table for example.
>
>  
>
> Of course, all activities that might impact performance are done 
> off-hours (after being tested in the lab).
>
>  
>
> Regards,
>
>  
>
> Mord
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Wes Sisk [mailto:wsisk at cisco.com]
> *Sent:* Wednesday, May 14, 2008 5:59 PM
> *To:* Mordechai
> *Cc:* cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
> *Subject:* Re: [cisco-voip] redirect admin:run sql to a file
>
>  
>
> Hi Mord,
>
> What are you querying that is going to generate 20K records? My only 
> guess would be CDR data.  If so, doing it from CLI or AXL will have 
> the same result.  Informix has not been a strong point of the 5.x/6.x 
> platform so I would also be very concerned about performance impact.  
> 20k records would very much be an off hours activity.
>
> If you are looking to retrive CDR data then have a look at the CAR 
> interface.  It includes an item to export CDR's.  Very conventient for 
> a post mortem analysis.
>
> Regards,
> Wes
>
>
> Mordechai wrote:
>
> Wes, thanks for the VERY quick response. In your experience, would 
> there be an impact if the response generates over 20K records? I am 
> reluctant to experiment in production and the lab has only a few dozen 
> users/phones.
>
>  
>
> Regards,
>
> Mord
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Wes Sisk [mailto:wsisk at cisco.com]
> *Sent:* Wednesday, May 14, 2008 3:30 PM
> *To:* Mordechai
> *Cc:* cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
> *Subject:* Re: [cisco-voip] redirect admin:run sql to a file
>
>  
>
> AXL is preferred interface for any type of systemic updates.  CLI is 
> for troubleshooting purposes only. The CLI is also subject to change 
> at any time without notice or warning.  Whereas AXL is at least tested 
> for backward compatibility.
>
> Regards,
> Wes
>
> Mordechai wrote:
>
> Hello,
>
>  
>
> Anyone knows how (if) to redirect run sql command output to a file 
> instead of screen?
>
>  
>
> I can use AXL but am not sure how it is going to handle large volume 
> response.
>
>  
>
> Thanks in advance,
>
>  
>
> Mord,
>
> NetVision Expert Solutions Inc.
>
> m.rabinovich at nves.ca <mailto:m.rabinovich at nves.ca>
>
>  
>
>  
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 
> 5/14/2008 7:49 AM
>
>  
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 
> 5/14/2008 7:49 AM
>
>  
>  
>  
>  
>  
>
>
> ------------------------------------------------------------------------
>
>
>  
>  
>  
>  
>  
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
> https://puck.nether.net/mailman/listinfo/cisco-voip
>   
>
>  
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 
> 5/14/2008 7:49 AM
>
>  
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 
> 5/14/2008 7:49 AM
>
>  
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 
> 5/14/2008 7:49 AM
>
>  
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 
> 5/14/2008 7:49 AM
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1434 - Release Date: 
> 5/15/2008 7:24 AM
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1434 - Release Date: 
> 5/15/2008 7:24 AM
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20080515/d0e3321f/attachment-0001.html 