Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Question Unanswered: How to increase Buffer Pool size in DB2 to store Clob value

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: How to increase Buffer Pool size in DB2 to store Clob value

    Originally posted by sangeethk
    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.
    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.

  3. #3
    Join Date
    Jan 2004
    Posts
    10

    Cool

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •