Re: Running Commands on multiple systems

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.