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.  data insertion in multiple sbspaces

    Posted 08/07/26 08:38 AM

    Dear All,

            I'm working on IDS 14.10 using Solaris 5.

      I've created a table and need to store the data in multiple SBSPACEs, used below syntax:

    create table "informix".cs_csid_phto_00 (
    seqn            Integer not null,
    phto_file       clob    not null
    ) PUT phto_file IN (sbs001, sbs002, sbs003)
     extent size 1024 next size 1024 lock mode row;

    Config Changes:

    but when I checked, all the sbspaces, only sbs001 had been used

    Could someone please help to know me how can I distribute table data in multiple sbspaces.

    Thanks

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------


  • 2.  RE: data insertion in multiple sbspaces

    Posted 08/10/26 12:09 PM

    Hi Amit,

    How exactly did you populate this new table after creating it?

    Where did the sblob data come from, and what precise syntax or technique had been used?

    What you're describing sounds like that PUT clause got ignored during sblob creation and instead the SBSPACENAME configuration got picked.  What would happen if you left the SBSPACENAME parameter empty instead?

    BR,

     Andreas



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------



  • 3.  RE: data insertion in multiple sbspaces

    Posted 08/24/26 02:11 PM

    Dear Andreas,

       Sorry for late reply.

                 initially there was one another table where the data was in text column. Later created new table cs_csid_phto_XX and the data was being inserted from TEXT column to new table cs_csid_phto_XX after decrypting it via base64 mechanism.

    We were thinking to fragment the table in three SBSPACES, so gave above format to create table with multiple sbspace.

    SBSPACENAME parameter also taking one 1 values as default. We checked all in Google.

    But currently only SBSPACE sbs001 is taking all the data, other dbs002 , sbs003 are still empty. Data is not being fragmented to other sbspaces.

    Regards

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message


  • 4.  RE: data insertion in multiple sbspaces

    Posted 08/11/26 09:09 AM

    Hi,

    Which exact IDS version?

    Which client is being used - ESQL/C, Java etc? and which client version?

    See https://community.ibm.com/community/user/discussion/sbspacename-overiding-put-clause

    Regards,
    David.



    ------------------------------
    David Williams
    Senior Database Platform Engineer
    Flutter
    London
    ------------------------------



  • 5.  RE: data insertion in multiple sbspaces

    Posted 08/24/26 01:39 PM

    Dear David,

     Sorry for late reply.

           We are using IDS 14.10 Over Solaris 5. and client is Informix 4gl only.

    Thanks 

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message


  • 6.  RE: data insertion in multiple sbspaces

    Posted 30 days ago

    Hi,

    What the full version numbers?

    Run

    onstat -g smb s

    are some sbspaces logged and some not logged?

    Regards,
    David.



    ------------------------------
    David Williams
    Senior Database Platform Engineer
    Flutter
    London
    ------------------------------

    Original Message


  • 7.  RE: data insertion in multiple sbspaces

    Posted 29 days ago

    Hello David,

                       Informix Full version is : 14.10.FC6X3

    output of "onstat -g sms s"

    IBM Informix Dynamic Server Version 14.10.FC6X3 -- On-Line (Prim) -- Up 6 days 16:12:23 -- 38836224 Kbytes
    2026-08-26 17:45:21
     
    Sbspace Summary:
     
    sbnum 126  address 1726df928
        Space    : flags    nchk     owner    sbname
                   -------- 35       informix sbs001
        Defaults : LO_LOG
     
        LO       : ud b/pg  flags    flags    avg s/kb max lcks
                   2048     0        -------- -1       -1
        Ext/IO   : 1st sz/p nxt sz/p min sz/p mx io sz
                   0        0        0        -1
     
        HdrCache : max      free
                   512      0
    sbnum 127  address 1726dfb68
        Space    : flags    nchk     owner    sbname
                   -------- 4        informix sbs002
        Defaults : LO_LOG
     
        LO       : ud b/pg  flags    flags    avg s/kb max lcks
                   2048     0        -------- -1       -1
        Ext/IO   : 1st sz/p nxt sz/p min sz/p mx io sz
                   0        0        0        -1
     
        HdrCache : max      free
                   512      0
    sbnum 128  address 1726dfda8
        Space    : flags    nchk     owner    sbname
                   -------- 4        informix sbs003
        Defaults : LO_LOG
     
        LO       : ud b/pg  flags    flags    avg s/kb max lcks
                   2048     0        -------- -1       -1
        Ext/IO   : 1st sz/p nxt sz/p min sz/p mx io sz
                   0        0        0        -1

    HdrCache : max      free
                   512      0

    Regards

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message