Free db2 1.05.02 software for windows

WareSeeker Editor

DBUtil is a free java database manager for viewing and manipulating database structure and data.
DBUtil provides both GUI and command line interfaces. It works with any JDBC compliant database and was tested with DB2, Oracle, Sybase, PostgreSQL, SQL Server, MySQL and SQLite in Windows, Linux and Solaris.
All basic database operations such as creating, deleting, dropping tables, inserting, updating and selecting values and transactions can be accomplished by simple DBUtil GUI operations or by SQL command executions.
When the DBUtil GUI operations are carried out, the corresponding SQL statements are recorded in an interactive console. This is very useful for database learners to get familar with the SQL language.
DBUtil is also useful to application developers because the resulting SQL statements can work as a template for their application SQL statements. The command line SQL statement execution provides a easy way for SQL statement testing for developers.
When a SQL statement fails in their application program, they can copy the SQL statement to the DBUtil interactive console to be tested/modified until the statement is correct.
Main features:
- Platform-independent (tested with Wondows, Linux and Solaris)
- Works with any JDBC compliant database (tested with Oracle, SQL Server, MySQL, DB2, Sybase and PostgreSQL)
- Provides both Gui and command line interfaces
- Browse database structure and display data
- Create tables with Gui or command line operations
- Insert, update and delete data with Gui or command line operations
- Create SQL queries with Gui operations

Jailer 2.7.0 is one of the most advantageous data extraction tool that enables you to: Extract small consistent (referentially intact) row-sets from your productive database and import the data into your development and test environment. Remove and archive obsolete data from your productive database.

Extracts consistent, referentially intact row-sets from your R-DB (DB2, Firebird, and Derby). Also Removes and archives obsolete data w/o violating integrity. Highly configurable, generates topologically sorted SQL-DML.

A software application that enables you to simplify and automate your database development process EMS SQL Manager 2007 for DB2 is a high performance tool for DB2 Database Server administration and development. SQL Manager 2007 for DB2 works with DB2 versions 8.1 and 8.2 and supports all DB2 objects and data types.
EMS SQL Manager Lite for DB2 provides a wide range of powerful utilities for experienced users such as Visual Query Builder, Visual Database Designer and powerful BLOB editor to satisfy all their needs. SQL Manager 2007 for DB2 has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.
Main features:
New state-of-the-art graphical user interface
- Office 11 and Windows XP visual schemes support
- Well-described Wizard System
- User-friendly Database Explorer for easy management of all DB2 objects
- Windows Toolbar to switch between windows easily, like in Windows Task Bar
- Navigation bars and hot keys in most of the windows
- Ability to save all program settings
- Customizable toolbars for all program windows
- Fully customizable program interface
- Powerful visual options module
- Localizable program interface
Easy management of all DB2 objects (including create / edit / drop operations)
- Managing database schemas
- Managing tables and all their subobjects: fields, primary, unique and foreign keys, indexes, triggers, and check constraints
- Managing views and all their subobjects: fields and triggers
- Managing materialized query tables
- Managing procedures, functions, sequences and packages
- Managing user-defined types and structure types
- Managing nicknames and aliases
- Managing users, groups and user mappings
- Managing tablespaces, buffer pools and partition groups
- Managing event monitors
- Managing servers and wrappers
- Duplicating database objects
- Viewing dependencies between database objects
Rapid database management and navigation
- Multiple database connections
- Registering selected databases to work with
- Projects to work with the selected database objects only
- Multiple user-defined tabs for any tree object to access it in one-click
- Working with multiple selected objects at a time
- Grouping / Ungrouping registered databases by node name
Advanced data manipulation tools
- Unicode support
- Plenty of useful tools such as data grouping, fast search and filtering
- Ability to continue working with SQL Manager while data are being fetched from the DB2 server
- A fetching process taking too long to execute can be aborted
Effective security management
- Grant manager displaying all database object grants in the form of a grid
- Easy management of database users, groups and user mappings
Excellent visual and text tools for query building
- Multiple SQL Editors of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features
- Large script execution (SQL script editor) with UNICODE support
- Ability to continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder
- A query taking too long to execute in SQL Editor or Query Builder can be aborted
Easy-to-use wizards for running DB2 services
- Back up and restore database
- Rollforward database
- Stop, start and restart database
- Quiesce and unquiesce database
- Reorganize database tables and indexes
- Run database statistics
- Background mode execution makes it possible to continue working with SQL Manager while any of DB2 services is being performed
Most of DB2 server versions support
- Support of 8.1 and 8.2 DB2 server versions
- Support of most DB2 server platforms (LUW, z/OS, etc.)
Other useful tools to make your work with DB2 server as easy as it can be
- Extracting metadata into text files or SQL Script Editor
- SQL Monitor
- Dependency tree tool allows to view dependencies between database objects
...and other useful features
- Keyboard templates
- External Tools editor
- To-do list
System requirements:
- 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
- 64 MB of RAM or more; 128 MB or more recommended
- 50MB of available HD space for program installation
- Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
- Microsoft Mouse or compatible pointing device
- Possibility to connect to any local or remote DB2 server

Foxy SQL Free is a database script and query tool designed for DB professionals.
It allows you to execute SQL commands and queries against any database. Supported DB: Oracle, MS SQL, IB, DB2, MySQL, PostgreSQL, Firebird, Sybase ASE and more.
Thanks to the ADO and OBDC connections, you can work even with databases that are not directly supported in Foxy SQL Free. Foxy SQL Free is a fast-performing tool that allows database developers and administrators to create and manage databases effectively using an SQL script.
Main features:
- access to a lot of different databases
- direct support for at least six databases
- possible connections via ODBC, ADO and also via a native connection for certain databases
Directly supported databases
- DB2
- Informix
- Interbase
- Firebird
- MySQL
- Oracle
- PostgreSQL
- MS SQL Server
- Sybase