Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m sad

Cannot connect to DB2/400 and DB2 for i with DataGlass DB2

I have bought DataGlass DB2 for iPad 1.5 weeks ago for use with DB2 for i but cannot get it to connect to the local database of the system as400profis.de or rzkh.de on port 446. I always get an error message about "JDBC driver not licensed" and a missing file named "db2jcc_license_cisuz.jar". Please see also this thread where I filed the bug 1.5 weeks ago.

Please try yourself: You can get a free account to this system at: http://www.rzkh.de > (english) > AS/400 accounts. (You will need a TELNET 5250 emulation like TN5250 from MochaSoft to interactively sign in to this system. Type STRSQL into the command line to open an interactive SQL session. The name of the local database can be seen with command WRKRDBDIRE from the command line. It's named PUB1.)

I have searched the web and found an interesting document which describes the database configuration for DB2 on different systems. It states "/QIBM/ProdData/HTTP/Public/jt400/lib" as the location (directory) for the JDBC driver class path on IBM i for Business, i5/OS and OS/400 which contains the driver file "jt400.jar", instead of a file named "db2jcc_license_cisuz.jar" as for other DB2 systems.

Does that probably mean that DataGlass DB2 does not set this directory correctly or does not use this driver when connecting to DB2 for i systems (System i, iSeries, AS/400). Could you please check this?
5 people have
this problem
+1
Reply