Help: inserting BLOBs larger than 100k in DB2 8.1

[Bing]

Hi there,

I am using the DB2 universal JDBC driver type 4 to insert BLOBs into a
DB2 database. The Method I used for supplying the BLOB data value is
setBinaryStream(). Everything works fine as long as the binary data is
less than or equal to 100k. Anything larger than that (even for one
byte) will result an exception saying the value is too large.

All the DB2 samples (at least two)I have found have a limit of 100k
(magic number!!!), and I have not found anything involved with data

100k. But as the DB2 doc sates BLOBs in DB2 can be up to 2GB. There

must be some option or trick to get over that magic 100k limit in
inserting BLOBs into DB2.

Could someone please share some tips on resolving this issue? Any help
is greatly appreciated.

Thanks.
Bing.