Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: DB2 error when creating new connection

  1. #1

    Question DB2 error when creating new connection

    Hello!

    I am a new user of PDI/Kettle (latest RC) on Linux RH (2.6.9-34.ELsmp) against a DB2 v9.1 database.

    After launching the app, I attempted to create a connection to a development database we have setup here. This is the error message I got when I clicked test.

    Code:
    
    Error occured while trying to connect to the database
    Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver)
    Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x2110
    The confusing thing is that I have no problem connecting against our production environment (different host but same database version).

    I have found another post on this forum but it was regarding BLOBs. Our database is very simple: no blobs.

    We are using the version 9 for the JDBC driver.

    Any idea/input?

    Thanks in advance for your insight.

    Alan.

  2. #2

    Default BUG? (Solved) DB2 error when creating new connection

    I discovered something odd in the options for the connection I attempted to create:

    For no apparent reason, the following options were set:

    DefaultFetchSize=500
    useCursorFetch=True

    I selected both options and hit the `delete` key to remove them. Once I clicked `test`, I no longer experienced the "...DRDA data stream..." error.

    I have attached a screen shot to this post (hope it makes it throught).

    Operator error or bug? Any ideas???

    TIA for your input.

    Alan.
    Last edited by acbonnemaison; 12-15-2008 at 04:49 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.