Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    washington dc
    Posts
    12

    Unanswered: Define BLOB to 1M, so is 1M allocated at beginning (the maximun), or will be variey

    Define BLOB to 1M. Does DB2 reserve the space for 1M (the maximun?), or will be variey depend on how big the file? I mean, if there is only 1 byte for BLOB, will DB2 still reserve 1M for the inserted 1 byte?

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

    Re: Define BLOB to 1M, so is 1M allocated at beginning (the maximun), or will be vari

    Originally posted by simonyang
    Define BLOB to 1M. Does DB2 reserve the space for 1M (the maximun?), or will be variey depend on how big the file? I mean, if there is only 1 byte for BLOB, will DB2 still reserve 1M for the inserted 1 byte?
    As far as I understand, DB2 does not pre-allocate space for LOBs according to the maximum field length as specified in the CREATE TABLE statement. However, space for LOB data is allocated in chunks that are multiples of 1K: 1024, 2048, 4096 etc. In your case 1024 bytes will be allocated.

Posting Permissions

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