Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2012
    Posts
    28

    Unanswered: best GUI tool for db2

    pls suggest me a good tool to work in DB2. i dont want to use clp. i am working on windows os. thanks.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    IBM Data Studio is a free download.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Another tool that is free is DB-Visualizer, which works with many databases (not only db2).
    It is much smaller and faster to load than IBM-Data-Studio.

    The free DBVis version has some limitations. The pay version is low priced.
    One benefit of db-vis is that it can work with 64-bit Java-Virtual-Machines , and also with 32-bit jvm's.
    I personally find the visual-explain feature in dbvis much more accessible than Data-Studio.
    DB-Vis is Available from dbvis.com - free download.

    The current IBM-Data-Studio is based on Eclipse foundation, and works only with 32-bit jvms currently(July 2012).


    Disclaimer: I have no connection with dbvis, just a satisfied customer. Other tools are available from other suppliers not only IBM. Some people like the Toad for DB2 product from Quest (non free). Some developers continue to use Oracle SQL-Developer with DB2 because they come from an Oracle background! Many people using older versions of DB2 on Windows (versions before v10.1) continue to use IBM's Control-Centre tool (again, java based) but IBM has now deprecated Control-Centre in favour of Data-Studio and related products.

  4. #4
    Join Date
    Nov 2010
    Posts
    7
    Toad for DB2 has a freeware version (4.6)
    Toad for DB2 Freeware
    This week freeware version = 4.7.2 is planned to be available

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by db2mor View Post
    Another tool that is free is DB-Visualizer
    Yep, also my recommendation. Pure java so it runs on linux just as well.
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •