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

[Robert L. Harris]

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

Yes, it's 98% off topic. Looking for someone who's done some coding on
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.

Robert

- --

: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)

iD8DBQFPaze78+1vMONE2jsRAuVbAJ9Pi0Cd12P7FuskRwAn6zd51CmkgwCg39JZ
kQhJn5P9lA7HUAicekjHMWI=
=VwFt
-----END PGP SIGNATURE-----

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

[Mike Harrison]

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.

[Robert L. Harris]

-----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

- --

: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-----

[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

Robert

- --

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.
----------------------------------

[Jeff Hubbs]

Robert -

I've done some connecting to DB2 from Tomcat on Linux. The platform on
which DB2 runs probably won't be germane to how you connect to it, but I
*think* you'll be getting what you need on the Linux side from IBM. If
there's a generic (e.g., ODBC?) connector to use in Perl, I wouldn't run
to that first.

- Jeff