Inserting large string into DB2 filed.

[reshmimohan2007]

Hello,
I have a requirement to insert a very long string (2GB) into my db2 table. Also I need to perform a search based on these strings.

I have created a table with CLOB datatype to handle the above situation. But when I try to insert data from DB2 treminal I am facing 32K page limit issue. Am I moving in the right direction? Is there any way to insert very long strings into DB2 table? Also can I perform a search based on that field?

Thanks & Regards,
Reshmi.

[Anas Mosaad]

Make sure you are using a CLOB that can accommodate your file size. When you create the table you can specify the table space where the LOB data is going to be saved (i.e. LOB in Large_TBS).
May be you can consider using DB2 text search.