Hello,

I have created a table in Db2, which has a column of type Clob,size 10MB.

My front end is Java.

I'm trying to insert a large string into this column.

But only part of the string is stored.If i'm write it's size may be 4000 bytes.

I came to know in one of the forum that, buffer pool size should be increased.

Please anyone tell me whether my problem is related with buffer pool.

If so Please Tell what to do?.And How to Do?.

Awaiting suggestions.

With regards,
sangeeth

I don't think your problem has anything to do with bufferpool size.

However, to check your bufferpool sizes you can use the following statement:

select bpname, npages*pagesize as size_bytes from syscat.bufferpools

To change the size of a bufferpool use "ALTER BUFFERPOOL" statement.

Thanks n_i.

Yes my problem is nothing to do with Buffer pool.I realized this only after retrieving the clob value what I have written to DB.

that is, I'm using Db2 client interface,using which if I execute SELECT command to retrieve clob value,It displays only portion of the clob value,
if i'm right 4000B. But if i materialize it to client machine,I'm getting complete clob.

But certainly your reply is very informative to new developers like me to know how to get buffer pool size.

Thanks a lot.

Message you soon with new post.

Thank u very much n_i.

With regards,
sangeeth