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.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-09-18T14:36:48Z by SystemAdmin
Pinned topic Accessing DB2 for a new user...
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-18T14:36:48Z at 2012-09-18T14:36:48Z by SystemAdmin
SystemAdmin 110000D4XK5837 PostsACCEPTED ANSWER
Re: Accessing DB2 for a new user...2012-09-18T14:36:48Z in response to dave981981Hello Dave,
I suggest you give a try to 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 :