#15577: Update DB2 Iseries JDBC driver from 9.2 to version 9.5

tomconrad reported 2018-05-11T15:59:47Z · last modified 2018-09-22T11:33:19Z

Update DB2 Iseries JDBC driver from 9.2 to version 9.5

v19.5

Dev	harishkhattri
QA	juhisindhani

Priority	Low
Complexity	Unknown

Component	DB - DB2 iSeries
Version	19.5

1) Copy the jt400.jar driver to the build-lib directory(...\ADS\dist\apps\common\build-lib) from the Google drive.

2) Copy the jt400.jar driver to the lib directory(...\ADS\dist\apps\common\lib\drivers) from the Google drive.

3) Test compile, unit test and resolve issues.

4) Check the driver into svn. Make sure the commit message contains the following:

<aquadatastudio:#15577>Update DB2 Iseries JDBC driver from 9.2 to version 9.5

5) Do a end to end test of all ADS DB2 ISeries functionality.

All Comments (4) Change History

harishkhattri 2018-08-20T11:00:23Z

New drivers are checked in revision no. 55979 in repository and will be available in build no. ADS19.5.0-dev-8

Pankaj.Isarka 2018-08-31T09:46:38Z

Revision: 55979

Author: hkhattri

Date: Thursday, August 16, 2018 4:34:16 PM

Message:

<aquadatastudio:#15577>Update DB2 Iseries JDBC driver from 9.2 to version 9.5

----

tomconrad 2018-09-12T16:48:42Z

Please revert this change as the new driver is not working correctly. I replaced the new driver with the old driver on my Google drive.

1) Copy the jt400.jar driver to the build-lib directory(...\ADS\dist\apps\common\build-lib) from the Google drive.

2) Copy the jt400.jar driver to the lib directory(...\ADS\dist\apps\common\lib\drivers) from the Google drive.

3) Test compile, unit test and resolve issues.

4) Check the driver into svn. Make sure the commit message contains the following:

<aquadatastudio:#15577>Revert change<svn 55979> for DB2 Iseries JDBC driver from 9.5 to version 9.2

5) Do a end to end test of all ADS DB2 ISeries functionality.

juhisindhani 2018-09-22T11:33:19Z

Hi Tom,

We have completed End to End Testing on DB2 iSeries 172.29.152.114

Server Product Version: 07.03.0000 V7R3m0

Platform : Windows 7

Following are some observations we came across while testing :

1. Database name 'DB2 iSeries' is not listed in DBA tools menu.

2. After reverting DB2 Iseries JDBC driver from 9.5 to version 9.2; it should show driver version as 9.2; but currently it shows 11.2(Screenshot).

3. Navigate to Query -> Execute Explain. It shows following pop up message(Screenshot).

Search Tips

Aqua Data Studio / nhilam

Update DB2 Iseries JDBC driver from 9.2 to version 9.5

Issue #15577

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Update DB2 Iseries JDBC driver from 9.2 to version 9.5

Issue #15577

Completion