Results 1 to 4 of 4

Thread: CLOB question

  1. #1
    Join Date
    Apr 2002
    Posts
    188

    Unanswered: CLOB question

    I have created a table with a CLOB data type and I set it up to
    CLOB (4K),
    now my question is

    if the data I need to insert into this particular column is greater than
    4k, will DB2 increase the size of the CLOB column accordingly?

    Or I have to declare that column to be the max which is I think (2g)

    thank you

    marcos oliva

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: CLOB question

    DB2 will not increase the column size ..

    Cheers

    Sathyaram

    Originally posted by Maor71
    I have created a table with a CLOB data type and I set it up to
    CLOB (4K),
    now my question is

    if the data I need to insert into this particular column is greater than
    4k, will DB2 increase the size of the CLOB column accordingly?

    Or I have to declare that column to be the max which is I think (2g)

    thank you

    marcos oliva

  3. #3
    Join Date
    Mar 2002
    Posts
    7
    DB2 will not enlarge the allocated space for your CLOB field.


    You can make the CLOB field bigger and use the COMPACT option.
    This way space that is not used will be compacted which means the memory allocated is only the size of the text inserted in the CLOB.

    The only disadvantage is that the it has some negative influence on the performance.

    Cheers

  4. #4
    Join Date
    Apr 2002
    Posts
    188
    Originally posted by P VDP
    DB2 will not enlarge the allocated space for your CLOB field.


    You can make the CLOB field bigger and use the COMPACT option.
    This way space that is not used will be compacted which means the memory allocated is only the size of the text inserted in the CLOB.

    The only disadvantage is that the it has some negative influence on the performance.

    Cheers


    thank you to all of you for your insightfull answers,

Posting Permissions

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