DB2 V8 Z/os

I am trying to unload a table that has a blob(100K) and receive a size error.

Is there a limit on the size of the lob field?

Any help would be appreciated.

Did you try using TRUNCATE key word in unload statements. Try one of the following options.

1. UNLOAD DATA FROM TABLE
BLOBCOLUMN TRUNCATE
or

2. UNLOAD DATA FROM TABLE
BLOBCOLUMN VARCHAR BLOBF TSYSLOB

TSYSLOB is template. You need to define for DSN.