× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On Wed, Jul 27, 2016 at 5:46 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:
The one thing I did really wish I could easily do that did not work well
oevr ssh was the running of SQL on each LPAR. For instance, if I wanted to
collect PTF information on each system it's just a matter of running a SQL
statement on each machine and collating the output. I could not find (and I
am still looking for) a simple way of doing this.

[...]

Given the amount of services being exposed by SQL it would be great if we
could more easily run the SQL over ssh or even via the Access client for
multiple systems to easily collect this stuff. I am thinking i might even
fall back on perl or python and script this stuff using an odbc connection.
Not my first preference but probably workable and over the long haul it
might be more configurable.

Well, not surprisingly (if you know anything about me at all), I think
a Perl or Python script would be a great choice for your situation.
This would be my first choice. Especially for anything SQL, I have
found Python with pyodbc extremely easy and pleasant to use. (I assume
Perl has something equally good, if you are more comfortable with
Perl.) To me, this sounds easier right off the bat than anything else
you have described, not just over the long haul.

And it definitely best meets your "least touch on the remote systems"
goal. Specifically, your target systems should already be
ODBC-enabled, meaning you would have exactly ZERO new development or
configuration to do on any of the target systems.

I'm happy to hash out some pyodbc ideas with you if you need some help
getting started.

One intriguing thing I wanted to mention, just because it looked neat,
not because I have tried it:

http://mobaxterm.mobatek.net/

It's just something I stumbled across while researching something
else. I am not sure it would be all that useful for me, and maybe it
wouldn't be useful for your situation either. But maybe it would. I
was especially intrigued by the "multi-execution" mode. There's a
picture of it on the features page:

http://mobaxterm.mobatek.net/features.html

John Y.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.