Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  BLOBs in blobspaces

    Posted Wed July 22, 2020 10:03 AM
    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
    ------------------------------

    #Informix


  • 2.  RE: BLOBs in blobspaces

    Posted Wed July 22, 2020 10:48 AM

    Select length(blob) from table

     

    Will give you the size of the actual blob

     




    Original Message


Related Content