DB2 Native driver vs Type4 driver

jackfruit · #1 (**permalink**) 08-10-10, 05:30

Choice of appropriate drivers for connecting to DB2 database from BO Crystal Reports We have created Crystal reports by successfully connecting them to DB2 database using ODBC, JDBC(Type4 driver) and DB2 Unicode drivers.Which one out of the following three are we supposed to use so that we could get a better performance.
which is better in performance DB2 Native driver or Type4 driver

dr_te_z · #2 (**permalink**) 08-10-10, 06:44

You talk about Crystal Reports and type-4 drivers. I assume that Crystal Reports is a java-app?
Is you application on the same server as the database?
Then I would recommend the type-2 driver
Else I would recommend the type-4 driver

db2girl · #3 (**permalink**) 08-10-10, 10:39

What is the difference between type-2 and type-4 drivers? How do you tell which one an application is using?

n_i · #4 (**permalink**) 08-10-10, 11:00

Type 2 is what was formerly called the "app" driver, I think it works through CLI. Type 4 is Java-only, and it supports most of JDBC 3.0.

db2girl · #5 (**permalink**) 08-10-10, 11:45

How do you decide what to use with your application? How do I tell what the application is using, type 2 or type 4?

n_i · #6 (**permalink**) 08-10-10, 11:56

You use type 4 unless there is some reason why your application must use type 2 (which is deprecated anyway). The driver type is determined by the Java class name that you load, COM.ibm.db2.jdbc.app.DB2Driver (hence the "app" name) vs. com.ibm.db2.jcc.DB2Driver.

db2girl · #7 (**permalink**) 08-10-10, 12:27

How can a DBA determine the driver type their application is using without asking developers? Will some trace show com.ibm.db2.jdbc.app.DB2Driver or com.ibm.db2.jcc.DB2Driver? Or some other way?

n_i · #8 (**permalink**) 08-10-10, 12:57

I think the driver name shows in the application snapshot, at least for type 4.

db2girl · #9 (**permalink**) 08-10-10, 16:13

Do you know what to look for in the application snapshot? Application name or something else?

I've seen db2jcc_application for the application name in the application snapshot / list applications. Does db2jcc_application indicate it's a type 4 driver?

n_i · #10 (**permalink**) 08-10-10, 16:16

Yes, I think it does.

guygetsgirl101 · #11 (**permalink**) 08-10-10, 20:52

If Crystal Reports is a java-app. What type of driver would you recommend? type-2 driver or type 4?

guy likes you

dr_te_z · #12 (**permalink**) 08-11-10, 01:39

Quote:

Originally Posted by db2girl

How can a DBA determine the driver type their application is using without asking developers? Will some trace show com.ibm.db2.jdbc.app.DB2Driver or com.ibm.db2.jcc.DB2Driver? Or some other way?

Developers develop java-source containing JDBC-logic. Which jdbc-driver is used in production is mostly the choice of the DBA.

I would always recommend the type-4 driver except when the application is on the same server as the database. In that case squeezing all the db-traffic through a tcp-ip socket (event if it is localhost) could become a bottleneck.