Topic
1 reply Latest Post - ‏2013-10-08T19:14:34Z by Jotac
Jotac
Jotac
82 Posts
ACCEPTED ANSWER

Pinned topic JDBCS Type 2 direct connection to DB2 z/OS

‏2013-10-01T08:11:01Z |

Hi all,

IBM Data Server Driver for JDBC and SQLJ 4.14.122
DB2 v9.7.0.8 on RHL
DB2 z/OS 10.1.5

we are experimenting the direct connection to DB2 host from linux/windows boxes avoiding the db2connect.

There is anybody that have already decomissioned the DB2Connect in favor of direct connection and can share hints/tips or simply isseus found?

In our case we found a problem using JDBC type 2 connection.
Randomly but consistely we have SQL commands that fail because do not return the correct number of rows.
We noticed that such failing command have the WHERE clause with at least one paramenter marker integer datatype,
the client send the correct value :

[jcc][Time:2013-09-30-16:08:32.592][Thread:WebContainer : 2][PreparedStatement@1c411c41]setInt (1, 1) called
[jcc][Time:2013-09-30-16:08:32.592][Thread:WebContainer : 2][PreparedStatement@1c411c41]setString (2, VP) called

but at host side the query is executed with a different value, for istance:

(wrong case)
Number  Type                Null  Length  Data                   
     1  INTEGER              N         4             +16777216   
                                          0000                   
                                          1000                   
     2  VARCHAR              N         2  VP                     
                                          55                     
                                          60    
                 

This is an example of working case:

(fine case)
Number  Type                Null  Length  Data                  
     1  DECIMAL (09,00)      N         5  +1                    
                                          00001                 
                                          0000C                 
     2  VARCHAR              N         2  VP                    
                                          55                    
                                          60                 
   

The above happen when the client have direct db connection to Z/Os DB2.

If we catalog databases such that the connectio use the DB2CONNECT then everytingh work fine.

Anyone have see it before?
It's a kind of "puzzle" for us :-) so any advise or hint is welcome.

ciao
GIovanmi

  • Jotac
    Jotac
    82 Posts
    ACCEPTED ANSWER

    Re: JDBCS Type 2 direct connection to DB2 z/OS

    ‏2013-10-08T19:14:34Z  in response to Jotac

    This is ended with a PMR.

    It's strange to me to see that nobody try to save money avoiding HW & SW for db2connect system

    ciao

    GIovanni