database DB2 有哪些查询浏览器？

What are the query browsers for DB2?

提问by kinkajou

What are the query browsers for DB2 e.g Database Administrator(Data Studio), Toad for DB2 etc? I worked with them but are there more ?

DB2 的查询浏览器有哪些，例如 Database Administrator(Data Studio)、Toad for DB2 等？我和他们一起工作过，但还有更多吗？

回答by gibbon.cz

I've recently discovered DBeaver (http://dbeaver.jkiss.org) and I love it. Runs on Win and Linux (on Centos7 I just unpacked an archive and ran executable), it's open source and without need of external driver it has connected to DB2 server right away. Same for PostgreSQL and MS SQL Server. Not sure how it compares with other in feature set though, but user experience compared to previously used Squirrel is amazing.

我最近发现了 DBeaver ( http://dbeaver.jkiss.org) 并且我喜欢它。在 Win 和 Linux 上运行（在 Centos7 上，我只是解压缩了一个存档并运行了可执行文件），它是开源的，不需要外部驱动程序，它立即连接到 DB2 服务器。PostgreSQL 和 MS SQL Server 也是如此。虽然不确定它与其他功能集相比如何，但与以前使用的 Squirrel 相比，用户体验是惊人的。

回答by AngocA

You can find a list of browsers in Wikipedia:

您可以在维基百科中找到浏览器列表：

http://en.wikipedia.org/wiki/Comparison_of_database_tools#General

http://en.wikipedia.org/wiki/Comparison_of_database_tools#General

and look at "Other" column. You will see which tools work with DB2.

并查看“其他”列。您将看到哪些工具适用于 DB2。

The popular ones are:

流行的有：

• Toad for DB2 http://www.toadworld.com/products#ibm-db2
• SQuirreL http://www.squirrelsql.org
• SQL Maestro http://www.sqlmaestro.com/products/db2/maestro/
• Altova DatabaseSpy http://www.altova.com/databasespy.html
• Embarcardero PowerStudio for DB2 http://www.embarcadero.com/products/db-powerstudio-for-db2

• Toad for DB2 http://www.toadworld.com/products#ibm-db2
• SQuirreL http://www.squirrelsql.org
• SQL Maestro http://www.sqlmaestro.com/products/db2/maestro/
• Altova DatabaseSpy http://www.altova.com/databasespy.html
• 用于 DB2 的 Embarcardero PowerStudio http://www.embarcadero.com/products/db-powerstudio-for-db2

Or

或者

• IBM Data Studio (Free) http://www-01.ibm.com/software/data/optim/data-studio/
• Technology Explorer (from IBM, on PHP) http://sourceforge.net/projects/db2mc/
• Control Center (Deprecated, included in IBM Data server client)

• IBM Data Studio（免费）http://www-01.ibm.com/software/data/optim/data-studio/
• Technology Explorer（来自 IBM，基于 PHP）http://sourceforge.net/projects/db2mc/
• 控制中心（不推荐使用，包含在 IBM 数据服务器客户端中）

回答by James Allman

I find DbVisualizerto be outstanding even when compared to many native tools.

即使与许多本机工具相比，我发现DbVisualizer也非常出色。

回答by Ren

I recommend the IBM data studio among the free tools. It lets you

在免费工具中，我推荐 IBM 数据工作室。它让你

• Manipulate(Create , modify, execute) stored procedures
• See explain plans - run performance analysis
• Let you open unlimited connections which some of the free tools doesn't let you.

• 操作（创建、修改、执行）存储过程
• 查看解释计划 - 运行性能分析
• 让您打开一些免费工具不允许的无限连接。

Also, it's based on eclipse framework, so if you are already using eclipse its almost a breeze to learn. Toad freeware is also cool, however the freeware has a licensing limitation of max 5 per enterprise.

此外，它基于 eclipse 框架，所以如果您已经在使用 eclipse，那么学习它几乎是轻而易举的。Toad 免费软件也很酷，但是免费软件的许可限制为每个企业最多 5 个。

Also, check the latest IBM data studio download

另外，检查最新的 IBM 数据工作室下载