There appear to be no other UNIX/Linux servers at my organization that would require connectivity to DB2 on iSeries. Which means there are most likely no installs of DB2 Connect anywhere.
All the windows boxes that I am aware of here connect to DB2 (on iSeries)
using either ODBC Driver I mentioned earlier
IBM i information center
which I think is part of IBM AS400 Client Access Express:
iSeries Information Center
or ShowCase ODBC drivers, v.7.00.280.10 by ShowCase Corporation dated 2006/05/16 .
In any case, for Linux, it appears that there are no DB2 Connect Gateways.
Which brings the next question - which version of DB2 Connect do I need? My take is that I need Personal Edition:
DB2 Database for Linux, UNIX, and Windows
since I only need to enable this one user account on one particular Linux server (actually, if I also want to install this on
the back-up server, I would need another license, wouldn't I?) to connect to half-a-dozen DB2 boxes (all on iSeries).
If that is indeed the case, I have two additional questions - so all I have to do now is pay $530?
IBM - DB2 Connect Personal Edition - Software
And, if yes, what is the sequence of actions after that - should I complete the operations with the DB2 Client driver configuraion
that I have not yet completed - see above:
- setting up an instance by running /opt/ibm/db2/V9.5/instance$ ./db2icrt (as root?)
- adding service to /etc/services (what do I actually put in there?)
- and then install this DB2 Connect driver
DB2 Database for Linux, UNIX, and Windows
Is that all?
And finally, I have an additional (silly) question - where in all this picture these iSeries Access for Linux drivers fit in:
ftp://ftp.software.ibm.com/as400/pro..._for_linux.pdf
These seem to be a completely different development - looks like these are based on unix-ODBC:
IBM iSeries Access for Linux Home Page
Most importantly, these don't require licencing:
http://www.redbooks.ibm.com/redbooks/pdfs/sg246551.pdf