My requirement is simple: I have a Rails web app that needs to read some data in from DB2 running on an iSeries AS400.
With the incredible help of the ibm_db gem maintainers, I believe I've been able to solve the technical hurdle of connecting to the DB2 instance.
The backstory is here if there are others looking for guidance:
- Download the DB2 CLI/ODBC package provided for Linux/OSX
- Set some environment variable and some connection config
- Attempt a connection.
- Leverage sequel gem in conjunction with ibm_db gem.
- It should work!!
Sadly, I'm now blocked on #3 by this error:
[FAILED]: [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968
I've been in touch with 3 different people at IBM in an attempt to resolve this and I'm constantly pointed to an article about DB2 Connect licenses with a cost of over $10K. iSeriesAccess (formerly ClientAccess) is available for Windows/Linux but is a heavy package and doesn't have an OSX counterpart.
I did find this question (License ERROR with DB2 driver on linux) but this I believe this assumes DB2 on Linux, not OS400.
Has anybody in the SO community had any luck or experience with this sort of thing?</div