<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle21
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle22
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Wes,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mordechai<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> Wes Sisk [mailto:wsisk@cisco.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, May 15, 2008 1:32
AM<br>
<b><span style='font-weight:bold'>To:</span></b> Mordechai<br>
<b><span style='font-weight:bold'>Cc:</span></b> cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] redirect
admin:run sql to a file</span></font><font color=black><span style='color:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>Mordechai,<br>
<br>
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.<br>
<br>
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.<br>
<br>
/Wes<br>
<br>
Mordechai wrote: <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->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).<u5:p></u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u5:p> </u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<u5:p></u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u5:p> </u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Of course, all activities that might
impact performance are done off-hours (after being tested in the lab). <u5:p></u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u5:p> </u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards,<u5:p></u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u5:p> </u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mord<u5:p></u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u5:p> </u5:p></span></font><o:p></o:p></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> Wes Sisk [<a href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, May 14, 2008 5:59
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Mordechai<br>
<b><span style='font-weight:bold'>Cc:</span></b> <a
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] redirect
admin:run sql to a file</span></font><o:p></o:p></p>
</div>
<u5:p></u5:p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u5:p> </u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>Hi Mord,<br>
<br>
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.<br>
<br>
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.<br>
<br>
Regards,<br>
Wes<br>
<br>
<br>
Mordechai wrote: <u5:p></u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->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.<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards,<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mord<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> Wes Sisk [<a href="mailto:wsisk@cisco.com"
moz-do-not-send=true>mailto:wsisk@cisco.com</a>] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, May 14, 2008 3:30
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Mordechai<br>
<b><span style='font-weight:bold'>Cc:</span></b> <a
href="mailto:cisco-voip@puck.nether.net" moz-do-not-send=true>cisco-voip@puck.nether.net</a><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] redirect
admin:run sql to a file</span></font><u5:p></u5:p><o:p></o:p></p>
</div>
<u6:p></u6:p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u6:p> </u6:p><u5:p></u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>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.<br>
<br>
Regards,<br>
Wes<br>
<br>
Mordechai wrote: <u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Hello,<u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Anyone knows how (if) to redirect run sql command
output to a file instead of screen? <u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>I can use AXL but am not sure how it is going to
handle large volume response. <u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Thanks in advance,<u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Mord,<u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>NetVision Expert Solutions Inc.<u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><a href="mailto:m.rabinovich@nves.ca"
moz-do-not-send=true>m.rabinovich@nves.ca</a><u1:p></u1:p></span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u1:p> </u1:p><u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u6:p> </u6:p><u5:p></u5:p><o:p></o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span style='font-size:10.0pt'>No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008 7:49
AM</span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u6:p> </u6:p><u5:p></u5:p><o:p></o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span style='font-size:10.0pt'>No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008
7:49 AM</span></font><u6:p></u6:p><u5:p></u5:p><o:p></o:p></p>
<pre wrap=""><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><u6:p> </u6:p><u5:p></u5:p><o:p></o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><u5:p> </u5:p><o:p></o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><u5:p> </u5:p><o:p></o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>
<hr size=4 width="90%" align=center>
</span></font></pre><pre style='text-align:center'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><u5:p> </u5:p><o:p></o:p></span></font></pre><pre
style='text-align:center'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><u5:p> </u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'><u6:p> </u6:p><u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>_______________________________________________<u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>cisco-voip mailing list<u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'><a
href="mailto:cisco-voip@puck.nether.net" moz-do-not-send=true>cisco-voip@puck.nether.net</a><u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'><a
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
moz-do-not-send=true>https://puck.nether.net/mailman/listinfo/cisco-voip</a><u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'> <u6:p></u6:p><u5:p></u5:p><o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u5:p> </u5:p><o:p></o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span style='font-size:10.0pt'>No
virus found in this incoming message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008
7:49 AM</span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u5:p> </u5:p><o:p></o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span style='font-size:10.0pt'>No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008
7:49 AM</span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span style='font-size:10.0pt'>No
virus found in this incoming message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008
7:49 AM</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span style='font-size:10.0pt'>No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008
7:49 AM</span></font><o:p></o:p></p>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>No virus found in this incoming message.<BR>
Checked by AVG.<BR>
Version: 7.5.524 / Virus Database: 269.23.16/1434 - Release Date: 5/15/2008 7:24 AM<BR>
</FONT> </P><BR>
<P><FONT SIZE=2>No virus found in this outgoing message.<BR>
Checked by AVG.<BR>
Version: 7.5.524 / Virus Database: 269.23.16/1434 - Release Date: 5/15/2008 7:24 AM<BR>
</FONT> </P>