Mittwoch, 16 of April of 2014

Tools

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

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.

easyDBase 

Graphical interface to process tables and views. Supports MySQL, Oracle, IBM DB2 und Access

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 Express-C 9.7 

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.

Cardett’s 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.

eva/3 Universal Database Converter (UDC) 

eva / 3 Universal Database Converter (UDC) – The easy way to copy database tables from one database system to another. eva / 3 Universal Database Converter supports fourteen different database systems can be converted in every direction. In addition to table structure, data and indices are convertable.

CA Database Command Center (Unicenter DCC) 

CA Database Command Center (Unicenter DCC) simplifies multi-database platform management through a consistent and Web-enabled user interface. Platform-specific trained database administrators can easily manage databases outside of their realm of core expertise by leveraging the common look and feel across multiple database platforms. DCC offers comprehensive multi-database administration, including catalog browsing along with Create, Create Like, Alter and Drop for multiple objects and database types allowing for heterogeneous, multi-platform database management from a common interface. Supports DB2 UDB for LUW, DB2 UDB for z/OS, SQL Server, Oracle and Ingres Open Source.

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.

Foxy SQL Free 

Foxy SQL Free is a simple database script and query tool that allows you to execute SQL commands and queries against any database. It supports Oracle, MS SQL, IB, DB2, MySQL, PostgreSQL, Firebird, Sybase etc.

DBDesigner 4 

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.
It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.

Open Source Projects 

IBM’s registry of open source projects.

… and more tools: 

For users who also work on z/OS platform: Don’t miss to visit also this page.