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.
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.
