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