Tools

Useful and free tools for the Windows, Linux or Unix platform, not only for DB2 users:

Nützliche und kostenfreie Tools für Anwender von DB2 auf Linux-, Unix-, Windows-Plattformen und darüber hinaus:

DB2MON

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.

IBM DSM – Data Server Manager

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.

Schema Spy(GNU)

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.

IBM DB2 Trials

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.

Cardets tools:

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)

IBM Data Studio administration console(DSAC)

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!)

IBM Replication Dashboard

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.

IBM Data Studio (SUSE Linux or Windows XP/Vista).The no-charge Data Studio download is available in two packaging options:(A) The integrated development environment (IDE) package includes all administrative capabilities as well as an integrated Eclipse development environment for Java, XML, and Web services.
(Free IBM Site pre-registration required!)

(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!)

Technology Explorer for IBM DB2The Technology Explorer for IBM DB2 is a light weight, web based console for DB2 that helps you learn about DB2 using demonstrations and tutorials. The TE is designed from the ground up to be easy to use and customize to suit your needs.
CA Free ERWIN subset

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.

FlySpeed SQL Query

Ä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 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.

DBeaver

… 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.

DbVisualizer

… 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 Explorer(GNU)

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.

Open Source Projects

IBM’s registry of open source projects.

… and more tools:

Für Anwender, die sich auf der z/OS Plattform wegen, sei diese Seite auf dieser Web Site empfohlen.