Informix

nested-group-icon.png

DB2

Expand all | Collapse all

BLOBs in blobspaces

  • 1.  BLOBs in blobspaces

    Posted 18 days ago
    I have a database in which is a several dozen tables with such a schema:
    create table t1
    i int,
    c char(20),
    some byte in xyzbls
    );

    The BLOBs are located in a special (different) spaces than the rest of the table.
    I am able to find out how full the xyzbls is. but I would like to know which BLOBs from which table take the most space?
    Is it possible?

    ------------------------------
    roze
    ------------------------------


  • 2.  RE: BLOBs in blobspaces

    Posted 18 days ago

    Select length(blob) from table

     

    Will give you the size of the actual blob