Hi Juhi,
The prd has these versions that need to be tested:
DB2 LUW - 11.1, 10.5
DB2 z/OS - V12, V11
I sent you the connection files for the z/OS machines. Those are versions 11 and 12. z/OS and LUW are two different platforms of DB2 that use the same jdbc driver. Need to test both platforms.
I was not able to see the error screenshot but -204 usually indicated that the object does not exist. When I look at the schema tree, I see a "zTest" table? I suspect that you need to quote the table name like "TOM"."zTest".
Thanks, Tom
Hi Juhi,
The prd has these versions that need to be tested:
DB2 LUW - 11.1, 10.5
DB2 z/OS - V12, V11
I sent you the connection files for the z/OS machines. Those are versions 11 and 12. z/OS and LUW are two different platforms of DB2 that use the same jdbc driver. Need to test both platforms.
I was not able to see the error screenshot but -204 usually indicated that the object does not exist. When I look at the schema tree, I see a "zTest" table? I suspect that you need to quote the table name like "TOM"."zTest".
Thanks, Tom
Done end to end testing with JDBC driver version 4.24.92 on:
1. DB2 LUW 172.24.1.145 v10.5
2. DB2 LUW 172.24.1.8 v11.1
3. DB2 ZOS 192.86.33.139 V11
4. DB2 ZOS 192.86.33.139 V12
Platform : Windows 7, 10
Note: There are some other observations on DB2 LUW and DB2 ZOS, we will raise different ticket for that.
Done end to end testing with JDBC driver version 4.24.92 on:
1. DB2 LUW 172.24.1.145 v10.5
2. DB2 LUW 172.24.1.8 v11.1
3. DB2 ZOS 192.86.33.139 V11
4. DB2 ZOS 192.86.33.139 V12
Platform : Windows 7, 10
Note: There are some other observations on DB2 LUW and DB2 ZOS, we will raise different ticket for that.
Hi Juhi,
Since Pankaj commented out the xml data transformer com.ibm.db2.jcc.am.ne.class to make this compile, would you please test DB2 luw and z/os with xml data. Just want to make sure that class is not required for the transformation. The test cases should include table creation with xml, table insertion and table selection. Also, confirm that the xml type shows up correctly in the schema tree.
Thanks in advance,
Tom
Hi Juhi,
Since Pankaj commented out the xml data transformer com.ibm.db2.jcc.am.ne.class to make this compile, would you please test DB2 luw and z/os with xml data. Just want to make sure that class is not required for the transformation. The test cases should include table creation with xml, table insertion and table selection. Also, confirm that the xml type shows up correctly in the schema tree.
Thanks in advance,
Tom
Yes Tom,
I have already tested the xml related test-cases with all the scenarios you have included in the above comment. As dev team has informed us at the time of driver updation and I have tested it accordingly.
Still I have tested it on latest build ADS19.5.0-dev-18 to make sure it's working fine.
Hence, marking it verified.
Thanks, Juhi
Yes Tom,
I have already tested the xml related test-cases with all the scenarios you have included in the above comment. As dev team has informed us at the time of driver updation and I have tested it accordingly.
Still I have tested it on latest build ADS19.5.0-dev-18 to make sure it's working fine.
Hence, marking it verified.
Thanks, Juhi
Issue #15576 |
Verified |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS19.5.0-dev-17 |
Time Estimate 24 hours |