Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    12
    Provided Answers: 1

    Question Unanswered: DB2 get individual non-inlined LOB size ?

    Hello everyone,

    I wonder if there is some way to get LOB size of individual LOB that is stored outside of table row (only descriptor stored in table row) in DMS tablespace on V10.5 FP5 and higher.

    For example if there is a table with one xLOB column. Application inserts data and due to the fact LOBs are too large to be inlined it gets stored outside of table row. I now wish to get size of LOB file that was stored outside of table row.

    Any idea?

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,310
    Provided Answers: 5
    Code:
    select code,length(content_blob) from MyTable order by 2 desc
    Andy

  3. #3
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    Hello,

    length(mycol), admin_is_inlined(mycol)
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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