db2db screenshots along with an overview of how to begin using the application:

Registering a JDBC driver - Click for bigger image (new window)
Register jdbc drivers with the application here. Alternatively, drivers can be used if they are available on the classpath (see userconnection screenshot below).
Creating a user connection - Click for bigger image (new window)
Create a userconnection, where a userconnection is a collection of details needed to connect to a DBMS e.g. username, password, the JDBC driver (as registered above).
Setting up datatype mappings - Click for bigger image (new window)
Set up a datatype mapping for each database you want to transfer tables to. db2db works by retrieving data and metadata from a database using JDBC datatypes. In order to create and populate tables in the target database it needs to maintain a mapping from these JDBC datatypes to equivalent types in the target database. As an example, the mappings are of the form:


This indicates that the JDBC type decimal maps to the database specific type decimal. In addition, 0, 1 or 2 arguments may be used with a precision in the range 1-28 and a scale in the range 0-28. There are three ways to create this mapping:

db2db will query the JDBC driver and the target database to discover mappings.
The user can enter the 'base type' (e.g. decimal) and db2db will discover the arguments allowed for that type (e.g. decimal(1-28);decimal(1-28,0-28)).
The user can enter the complete mapping.

Transfer of tables definitions and data - Click for bigger image (new window)
Now some tables can be copied from one database to another. A userconnection is chosen as the source database and another as the target database. Tables are chosen for transfer and the transfer is initiated.
Running an SQL query - Click for bigger image (new window)
An SQL query builder allows SQL queries to be created, saved, opened and run against the database.
Database Browser - Click for bigger image (new window)
The database browse shows information about the database: schemas, tables, table types, data, column datatypes, primary keys, referential integrity constraints, etc.

SourceForge.net Logo