Informix

  • 1.  how to from informix sbspace

    Posted Fri October 29, 2021 08:46 AM
    I create a sbspace and create a table with blob column。 
    blob column in sbspace。
    insert many many rows.

    dbaccess dbname -
    > truncate table tabname;

    $ onstat -d 

    I find  sbspace's  remain unchanged。

    how can I free sbspace ?

    ------------------------------
    David Cui
    Technical support
    gbase.cn
    ------------------------------


  • 2.  RE: how to from informix sbspace

    IBM Select
    Posted Fri October 29, 2021 10:26 AM
    There are two lines for each sbspace chunk in onstat -d:
    • User Data (sblobs)
    • Metadata (sblob headers) - you can think of those as regular tables (partitions), only not directly accessible
    First one would reflect your truncate immediately, showing all your sblobs' space being released ('free' going up).
    Second one's used space (size - free) will never shrink, that's just how partitions work. Yet that doesn't mean that the space previously occupied by your sblobs's headers hadn't been freed and wouldn't be available for and reused by any new sblobs's headers.
    Quite typically Metadata consumption is only a fraction of the space reserved for or occupied by User Data anyway.

    HTH

    ------------------------------
    Andreas Legner
    ------------------------------