A few screenshots of PMF

All screenshots are based on IBM's DB2 "sample" database, that includes the gentleman in the 3rd image. Click images to enlarge (they open in new tab).

Main View: Edit cells, no SQL required.

Main

Right-clicking a cell will open a useful menu

Main

Open/Display LOB. Supports drag&drop LOB data

Main


Edit XML data in place or drag&drop XMLs

Main

Manage Indexes, run Reorg, Runstats,...

Main

Search all tables for specific data or column names

Main

Monitoring a DB2 database

Main



PMF can display multiple tables in a tabbed view. Usually, the first 2000 rows are displayed (this is configurable).
You can directly edit the cells, and clicking 'Save' will update the database.

The cells have a context-menu for quickly filtering (e.g. SELECT * FROM table WHERE colName1 = colData1 AND colName2 = colData2 ....) data.
The context-menu also lets you edit XML data and display LOB (Large Object) data.
It's also possible to copy and paste rows across databases (provided source and target table have the same columns, of course).


Additional functions:

PMF is intended as a lightweight and intuitive tool for developers and admins. If you have suggestions for improvements, let me know.