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
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
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.
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.