Hello,

Can you please help me in how to find out answers of the folowing questions for our application. The application is J2ee/Java based -

1.Is application using db2 built-in routines?
2.Is application using any db2 API.
3.Does application make any reference to db2 system catalog?
4.Is application using any db2 cli commands?
5.Is any user defined db2 function, db2 procedure or db2 routine part of application to be migrated?
6.What is the jdbc driver version we are using at present. Are we using any other application driver?
7.Is application using any external java routine?
8.Are we using any other db2 feature or component?

9.Also let me know if the following impacts the application:

The DB2 JDBC type 3 driver is not supported in DB2 Version 9. Application that use this driver should be modified to use the IBM DB2 Driver for JDBC and SQLJ with type 4 connections instead.
Following is the behavioral differences between the IBM DB2 Driver for JDBC and SQLJ Version 3.0 or later and previous releases of this driver.
Default LOB data retrieval method has changed (Are we using this data type)
Starting with IBM DB2 Driver for JDBC and SQLJ Version 3.0, application data types are converted to column data types when column data type information is available by default. You can now choose to disable this conversion.
Using the JDBC 1.0 method to update or delete data: Starting with IBM DB2 Driver for JDBC and SQLJ Version 3.1, if you use the JDBC 1.0 method to update or delete data on a database server that supports multiple-row FETCH, the positioned UPDATE or DELETE statement might update or delete multiple rows, when you expect it to update or delete a single row.



Thanks for your help.

1) search you source code for built-in routines
2) maybe, search your source code
3) search your soruce code (syscat)
4) Search your source code
5) only you can answer this one
6) look at the connection command and the driver name
7) Only you can answer this one
8) Only you can answer this one also
9) I do not know

Andy

Thanks Andy.