[ale] OT: Querying DB2 on an AS400 via Perl on a Linux appliance

[Lightner, Jeff]

Maybe seeing what available Nagios plugins do would give you some ideas?   We had a couple of as400s here (and thank God we don't any longer) and I thought I had done some monitoring back then but can't find notes.  If I had this task I'd look to see what these things are doing:

http://exchange.nagios.org/directory/Plugins/Databases/DB2

http://exchange.nagios.org/index.php?option=com_mtree&task=search&Itemid=74&searchword=as400








-----Original Message-----
From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Robert L. Harris
Sent: Thursday, March 22, 2012 11:21 AM
To: Mike Harrison; Atlanta Linux Enthusiasts
Subject: Re: [ale] OT: Querying DB2 on an AS400 via Perl on a Linux appliance


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


  I'll see if I can find anything through ibm.com but I only have
hardware support.

  We tried a while back letting the customers export and upload but that
had problems all it's own...

Robert


On 3/22/12 9:06 AM, Mike Harrison wrote:
> On Thu, 22 Mar 2012, Robert L. Harris wrote:
>> a Linux appliance that connects out to a DB2 database running on an AS400.
>>
>> At work we have a new customer and haven't worked with DB2/AS400 before
>> and that combination with Perl is a bit hard to find practical
>> information on.
>
> I'm remote.. but I've done this many moons ago using ADO I think.
> IBM's website is prety good and deep, but not well google'd because you
> have to have a login for lot of information.
>
> I think I have tossed DB2 magazines with examples for PHP and Perl, I know
> it's possible.
>
> Often though, it's easier for the DB2 system to export CSV or fixed length
> text, and import that.
>
>
>
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo

- --

:wq!
====================================================================
Robert L. Harris                     | GPG Key ID: E344DA3B
                                         @ x-hkp://pgp.mit.edu
DISCLAIMER:
      These are MY OPINIONS             With Dreams To Be A King,
       ALONE.  I speak for              First One Should Be A Man
       no-one else.                       - Manowar

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)

iD8DBQFPa0N38+1vMONE2jsRAti3AJ9fRZgEEpZUeuLKUM6Z9efEsZ3WQgCfYEFa
4Mf5zWI0vU83YVhOJQHSc1k=
=L9Ya
-----END PGP SIGNATURE-----

_______________________________________________
Ale mailing list
Ale at ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo




Athena(r), Created for the Cause(tm)
Making a Difference in the Fight Against Breast Cancer

---------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------