Active5 years ago
Where can I find the redistributable version of the IBM DB2 Type 4 driver?I suppose this is the driver I would use to connect from a Java app (on windows) to DB2 on the mainframe?
Vish
DB2 JDBC Driver and URL connection. DRIVER LOCATION: db2jcc.jar and db2jcc. The name of the file that contains the DB2 App driver is usually.
6 Answers
You will not be able to connect to the mainframe with any redistributable JDBC driver. The driver pack consists of the actual type 4 driver (db2jcc.jar) and any number of license files of the form:
where the
cisuz
bit is variable, indicating the platforms that you're allowed to run on (iSeries, pSeries, System z, LUW and so on).You're only likely to get
cu
with any freely distributable pack. You need the z
to access DB2 on the mainframe and that's jealously guarded so you'll need to purchase a specific edition of DB2 Connect to get it. I think both PE and EE, the personal and enterprise editions, have this licence file.Without that license file, the type 4 driver won't even try to talk to the server, you'll get an exception.
Mssql Jdbc Jar Download
paxdiabloDb2 Jdbc Drivers
paxdiablo667k185 gold badges1324 silver badges1724 bronze badges
IBM's Fix pack site has the 'IBM Data Server Driver for JDBC and SQLJ' which is nothing but the JDBC type 4 driver. Though the page I pointed to above happens to be the windows page, it's the same type 4 driver for all platforms, as should be expected.
I don't think any user/password is required.
TanktalusTanktalus18k4 gold badges34 silver badges63 bronze badges
There is no need to download the JDBC driver separately it is already shipped with your DB2 product.You can easily find it at this location :
C:Program FilesIBMSQLLIBjavadb2jcc.jar
db2jcc.jar
is the driver nameExecutable Jar File Download
harmenderharmender
You can get the drivers from the IBM site. You will need to have IBM ID and password to login (which you can obtain here). Zip file is about 7 MBs, in contains DB2 9.5 JDBC (type 2/4) and SQLJ drivers. Type 4 drivers are in db2jcc4.jar.However, you won't be able to connect to mainframes with this driver if mainframe is running DB2 for z/OS. To do so, you need at least to purchase DB2 Connect product, which will cost you about $500 minimum.
DasDas1972 gold badges7 silver badges14 bronze badges
If you're running on an AS/400 (or iSeries, or whatever the heck IBM is calling it these days), you'll probably want to get it from JTOpen.
Their toolbox replaces the old Java Toolbox and includes the JDBC drivers.
J.T. GrimesJ.T. Grimes3,7191 gold badge23 silver badges31 bronze badges
If I need any IBM JARs for DB2 or MQ, I usually just add it to the instructions that DB2 or MQ needs to be installed as a prerequisite along with a URL to download it.
The same goes for Java and many other not easily redistributable products as well.
This eliminates the need to worry about licensing issues as it would be on the onus of the user rather than the vendor to obtain the proper licenses.
Archimedes TrajanoArchimedes Trajano11.1k4 gold badges85 silver badges112 bronze badges