Topic
1 reply Latest Post - ‏2012-09-18T14:36:48Z by SystemAdmin
dave981981
dave981981
1 Post
ACCEPTED ANSWER

Pinned topic Accessing DB2 for a new user...

‏2012-09-13T14:32:30Z |
Hi guys,

I'm in a bit of an odd situation...

I work in an organization which uses a legacy application that appears to run on an AS/400 build of DB2 and the application itself is very poor.

Accordingly, I'm now looking to alternatives to write manual queries on the tables.

My first step was to download IBM's own tool - IBM Data Studio. While I can get it to connect, the interface and performance of it's ad hoc query writing and exporting tools leaves much to be desired (as compared to any other tool I've used for MS SQL Server, MySQL, PostgreSQL, etc.). As a result, I've looked to other tools which seemingly don't require an ODBC driver for communication such as DB2 Maestro but that tool is seeming to give me problems (note this is on a pretty clean/fresh machine).

--> I've attached an annotated screenshot showing the issue. If someone could provide some guidance or some alternative for running ad hoc queries easily in this build of DB2, it would be greatly appreciated.
Updated on 2012-09-18T14:36:48Z at 2012-09-18T14:36:48Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: Accessing DB2 for a new user...

    ‏2012-09-18T14:36:48Z  in response to dave981981
    Hello Dave,

    I suggest you give a try to SQuirreL SQL Client :

    http://en.wikipedia.org/wiki/SQuirreL_SQL_Client

    It is a JDBC freeware. If you are not running on the same machine as the server, you will have to install the IBM Data Server Driver for JDBC and SQLJ, which you can choose from this page :

    http://www-01.ibm.com/support/docview.wss?uid=swg24033451

    Enjoy...

    Yves-Antoine Emmanuelli