Re: TEMS Custom SQL Query?
John Alvord <jalvord-r/[email protected]> Fri, 18 Oct 2013 07:45:51 -0700
| Newsgroups | gmane.comp.sysutils.tivoli.general,gmane.comp.sysutils.tivoli.tme10 |
|---|---|
| Message-ID | <OFBADDE4F9.A2DA9FCB-ON88257C08.00509640-88257C08.005118A4@us.ibm.com> |
This is a multipart message in MIME format. --===============1410948391== Content-Type: multipart/alternative; boundary="=_alternative 005118A288257C08_=" This is a multipart message in MIME format. --=_alternative 005118A288257C08_= Content-Type: text/plain; charset="US-ASCII" Don't even try. The TEMS SQL is non-standard [actually SQL '89 with major extensions] and the join is very very memory expensive... can easily lead to a TEMS crash. I remember one case where a SOAP in a join was crashing the hub TEMS 10 minutes after startup. There was an office-wide hunt for the problem workstation... took two days. In the end it was hiding behind a desk - belonged to an employee who left a year before. That machine was unplugged and then the hub TEMS stopped crashing. So Do - Not - Even -Try - !! Regards, ______________________________________________ John Alvord Advisory Engineer and ITM Historian IBM Tivoli Monitoring 6 Platform Customer Support Office: 1-720-396-2788 Mobile: none jalvord-r/[email protected] Cloud & Smarter Infrastructure IBM Support Portal Open a New Service Request Update your PMR via Email Escalate your PMR My Blog: Wonderful World of Situations Secure upload to ECUREP From: <[email protected]> To: <[email protected]>, Date: 10/18/2013 12:16 AM Subject: [TME10] TEMS Custom SQL Query? Sent by: [email protected] Hi folks. I need some help in writing a custom query to get information on all 32bit Windows OS agents installed on 64 bit hardware. I can get Host Info from one workspace and a lot of 32/64 bit agent installation info in the Agent Management log. But I need to combine them in one query. /Gus _______________________________________________ TME10 mailing list [email protected] Unsubscribe:[email protected] --=_alternative 005118A288257C08_= Content-Type: text/html; charset="US-ASCII" <font size=2 face="sans-serif">Don't even try. The TEMS SQL is non-standard [actually SQL '89 with major extensions] and the join is very very memory expensive... can easily lead to a TEMS crash.</font> <br> <br><font size=2 face="sans-serif">I remember one case where a SOAP in a join was crashing the hub TEMS 10 minutes after startup. There was an office-wide hunt for the problem workstation... took two days. In the end it was hiding behind a desk - belonged to an employee who left a year before. That machine was unplugged and then the hub TEMS stopped crashing.</font> <br> <br><font size=2 face="sans-serif">So Do - Not - Even -Try - !!<br> </font><font size=3><br> Regards, <br> ______________________________________________</font> <table width=433 style="border-collapse:collapse;"> <tr height=8> <td width=433 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1><br> </font> <table width=433 style="border-collapse:collapse;"> <tr height=8> <td width=221 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1 face="Arial"><b>John Alvord</b><br> Advisory Engineer and ITM Historian<br> IBM Tivoli Monitoring 6 Platform<b><br> Customer Support </b><br> Office: 1-720-396-2788 <br> Mobile: none </font><font size=1 color=blue face="Arial"><u><br> </u></font><a href=mailto:jalvord-r/[email protected]><font size=1 color=blue face="Arial"><u>jalvord-r/[email protected]</u></font></a><font size=3><br> </font><font size=1 color=blue face="Arial"><b><u><br> </u></b></font><a href=http://www.ibm.com/software/tivoli/><font size=1 color=blue face="Arial"><b><u>Cloud & Smarter Infrastructure</u></b></font></a> <td width=212 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><a href=https://www.ibm.com/support/><font size=1 color=blue face="Arial"><u>IBM Support Portal</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href=http://www.ibm.com/support/entry/portal/Open_service_request/><font size=1 color=blue face="Arial"><u>Open a New Service Request</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href="https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.html#naming"><font size=1 color=blue face="Arial"><u>Update your PMR via Email</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href="http://www-304.ibm.com/support/customercare/sas/f/handbook/getsupport.html#9"><font size=1 color=blue face="Arial"><u>Escalate your PMR</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href=https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord><font size=1 color=blue face="Arial"><u>My Blog: Wonderful World of Situations</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href=https://www.ecurep.ibm.com/app/upload><font size=1 color=blue face="Arial"><u>Secure upload to ECUREP</u></font></a> <p><a href=https://www.facebook.com/IBMTivolisupport></a><a href=https://twitter.com/TivoliSupport></a><a href=https://www.ibm.com/developerworks/servicemanagement/index.html></a></table> <br> <tr height=8> <td width=433 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><a href=http://www.ibm.com/software/tivoli// target=_new></a></table> <br> <br> <br> <br> <br><font size=1 color=#5f5f5f face="sans-serif">From: </font><font size=1 face="sans-serif"><[email protected]></font> <br><font size=1 color=#5f5f5f face="sans-serif">To: </font><font size=1 face="sans-serif"><[email protected]>, </font> <br><font size=1 color=#5f5f5f face="sans-serif">Date: </font><font size=1 face="sans-serif">10/18/2013 12:16 AM</font> <br><font size=1 color=#5f5f5f face="sans-serif">Subject: </font><font size=1 face="sans-serif">[TME10] TEMS Custom SQL Query?</font> <br><font size=1 color=#5f5f5f face="sans-serif">Sent by: </font><font size=1 face="sans-serif">[email protected]</font> <br> <hr noshade> <br> <br> <br><font size=2 color=#004080 face="Calibri">Hi folks.</font> <br><font size=2 color=#004080 face="Calibri"> </font> <br><font size=2 color=#004080 face="Calibri">I need some help in writing a custom query to get information on all 32bit Windows OS agents installed on 64 bit hardware.</font> <br><font size=2 color=#004080 face="Calibri">I can get Host Info from one workspace and a lot of 32/64 bit agent installation info in the Agent Management log. But I need to combine them in one query.</font> <br><font size=2 color=#004080 face="Calibri"> </font> <br><font size=2 color=#004080 face="Calibri">/Gus</font> <br><font size=2 color=#004080 face="Calibri"> </font> <br><font size=3 color=#004080 face="Times New Roman"> </font><tt><font size=2>_______________________________________________<br> TME10 mailing list<br> [email protected]<br> Unsubscribe:[email protected]<br> </font></tt> <br> --=_alternative 005118A288257C08_=-- --===============1410948391== Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline _______________________________________________ TME10 mailing list [email protected] Unsubscribe:[email protected] --===============1410948391==--