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

Wed May 14 23:39:50 EDT 2008

Hi Ryan,

I am aware of the limitations inherent in http/soap combination for large
amounts of data and that’s why I posted the question. I am looking for a way
to generate output locally and collect it using SSH. Bypass the SOAP
mechanism altogether. Under the windows I could run a query directly from
the SQL Analyzer, but with Linux do I have other choices than the AXL?

Regards,

Mord

   _____  

From: Ryan Ratliff [mailto:rratliff at cisco.com] 
Sent: Wednesday, May 14, 2008 6:03 PM
To: Wes Sisk
Cc: Mordechai; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] redirect admin:run sql to a file

If you are doing user queries be particularly careful as it has been known
to cause Tomcat to run out of memory when returning large numbers of users.

-Ryan

On May 14, 2008, at 5:59 PM, Wes Sisk wrote:

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 [HYPERLINK "mailto:wsisk at cisco.com"mailto:wsisk at cisco.com] 
Sent: Wednesday, May 14, 2008 3:30 PM
To: Mordechai
Cc: HYPERLINK "mailto:cisco-voip at puck.nether.net"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.

HYPERLINK "mailto:m.rabinovich at nves.ca"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

   _____  

_______________________________________________
cisco-voip mailing list
HYPERLINK "mailto:cisco-voip at puck.nether.net"cisco-voip at puck.nether.net
HYPERLINK
"https://puck.nether.net/mailman/listinfo/cisco-voip"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

_______________________________________________

cisco-voip mailing list

HYPERLINK "mailto:cisco-voip at puck.nether.net"cisco-voip at puck.nether.net

HYPERLINK
"https://puck.nether.net/mailman/listinfo/cisco-voip"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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20080514/ce40fca3/attachment-0001.html 