Tools

This is a fast windows GUI application for DB2 UDB performance monitoring. Shows active connections with lock information, SQLs in db cache, database snapshots, database hit ratios, database objects information, list history. Can help resolve locking problems and identify worst performing queries.

Der Nachfolger der IBM Data Studio: In einer kostenfreien Base Edition und einer kostenpflichtigen Enterprise Edition verfügbar. Die Enterprise Edition löst nicht nur DS, sondern noch einige andere kostenpflichtige Tools ab. Eine wirklich gelungene, wenn auch auf einer älteren Version von DSM basierenden Aufstellung der Features und Unterschiede, findest Du hier.

The GNU-free SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.

DB2 Express-C is a free version of the IBM DB2 database server. DB2 Express-C provides an excellent foundation for application development for small and medium business.

SNAPVIEW: redisplays DB2 Shapshots for easy reading
AQT: Advanced Query Tool is a fast and easy-to-use cross-database query tool (free non-expiring trial version)
Analdir: is a file and directory analysis tool (free non-expiring trial version)

This no charge web-based console for AIX, Linux or Windows provides basic entry-level health monitoring for your data servers and health monitoring for Q replication. Version 1.2 adds support for DB2 for z/OS Version 8 and 9.
(Free IBM Site pre-registration required!)

The Q Replication Dashboard provides health and performance monitoring for InfoSphere Replication Server and Data Event Publisher. This download supersedes the capability provided in Data Studio Administration Console.  The Q Replication Dashboard is a rich, customizable Web tool for monitoring the health and performance of replication and event publishing. The dashboard summarizes information to help you quickly identify and troubleshoot problems. It allows drill down into details in addition to at-a-glance status status of programs, queues, Q subscriptions, and other objects.
The Q Replication Dashboard is now a stand-alone tool with a new look and feel.

(B) The stand-alone package is a lighter weight offering designed specifically for administrators to get up and running quickly and easily. This package does not include some of the data development capabilities available in the IDE package and cannot be installed with other products to extend its capabilities.
(Free IBM Site pre-registration required!)

It is a FREE, entry-level data modeling tool that is a subset of CA’s flagship CA ERwin Data Modeler product. It is a great way for students and those new to modeling to get started with an industry-leading data modeling tool. It supports: Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, MySQL, ODBC, Sybase 12.5/15.

Ähnlich wie DbVisualizer setzt FlySpeed auf die ganze Breite verfügbarere Datenbank-Managementsysteme. Neben eine Lizenz-freien SQL Query Version, gibt es zahlreiche günstige Software-Produkte.

EMS SQL Manager for DB2 Freeware (EMS SQL Manager Lite for DB2) is the freeware version of the SQL manager. It contains the most important tools in DB2 for beginners and for those who need only its basic functionality.

… is free universal database tool for developers and database administrators.

• Usability is the main goal of this project, program UI is carefully designed and implemented.
• It is freeware.
• It is multiplatform.
• It is based on opensource framework and allows writing of various extensions (plugins).
• It supports any database having a JDBC driver.
• It may handle any external datasource which may or may not have a JDBC driver.
• There is a set of plugins for certain databases (MySQL and Oracle in version 1.x) and different database management utilities (e.g. ERD).

All major databases are supported.

… is the leading platform independent and cross database tool aimed to simplify database development and management for database administrators and developers. Support numereous database management systems.

If you want to buy a fully licensed version or educational version, come and visit DBSC.

Eclipse SQL Client for database querying/browsing any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended for to include specialized support for other databases.

IBM’s registry of open source projects.

• George Poulose Query Tool: Query Tool using ODBC or ADO, requires Win/XP SP2.
• IBM’s NMON Tool for AIX: http://www.ibm.com/developerworks/aix/library/au-analyze_aix/