DB2 Extract BLOB Data

To extract BLOB data from DB2, first, you need and install DB2LobEditor.

Run DB2LobEditor.

After click ‘Tools->Export LOB’, LOB export form is displayed, you can extract LOB data from a table:

or a query:

DB2LobEditor is a database tool that helps DBA and Database Programmer edit DB2 LOB (BLOB, CLOB) data directly.