Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.

share|improve this question
Which OS is your client on? – Mark May 4 '11 at 9:15
Apologies, should have added a tag with the os. Windows.. – jgauffin May 4 '11 at 9:22
up vote 2 down vote accepted

DBvisualizer supports DB2 as well as most databases, IBM Data Studio or DB2 Control Centre are specific for DB2. You can download and use them all free.

share|improve this answer
However, IBM Data Studio is the only that provides control for db2 features, like compression, pure scale, dpf, etc. – AngocA May 21 '14 at 11:53

Try MS office - Excel and Access have MSQuery which allows simple SQL queries through ODBC..

If your keys are correct then it will automatically join tables using foreign keys to the primary key in the other table - but you can override these if needed.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.