Q
Problem solve Get help with specific problems with your technologies, process and projects.

Is there a bug in DB2 Connect?

I am using DB2 Connect with Microsoft Access to query data on an iSeries. When I run simple one-table queries on a large table (1.25 million records) with a simple select "where MYCHARFIELD = 'T') I not only get records where MYCHARFIELD = T but also a few records where it has C or E or P. Is there a bug in DB2 Connect that would cause this to happen. This happens even if I use the graphical query building tool. I can not use the Client Access ODBC driver to do this because it times out and will not run it.
I am not aware of a known bug that will cause the described situation. Please check the results by using iSeries access as follows:

  • Operation Navigator
  • Database
  • SQL script center
  • Run the SQL request

    This uses JDBC connection and sees what the results are.

    Note: I find the ODBC driver of iSeries Access superior to DB2 Connect most of the time, please recheck why it times out.

    ==================================
    MORE INFORMATION ON THIS TOPIC
    ==================================

    Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

    The Best Web Links: Tips, tutorials and more.

    PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

  • This was last published in November 2004

    Dig Deeper on FTP

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchDataCenter

    • How do I size a UPS unit?

      Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

    • How to enhance FTP server security

      If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

    • 3 ways to approach cloud bursting

      With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...

    Close