Hi Everyone.

I have a situation where I need to persist an object that will serialized to binary.

Is the best choice of data type a BLOB?

Also, since I need to specify a length is it okay to use something like 1 GB since the field is variable length? I can assume the size of the object will never be over 1 GB.

Are there any database settings taht would need checked or modified for using BLOB data? The table will be accessed via JDBC.

I'm have DB2 v9.1 on Linux.

Thanks.

A BLOB is pretty much like any other data type. The only difference comes with logging in DB2 itself.

Whether a BLOB is the best choice depends on your requirements.