Blob Space Error

I support an application running on an IDS 7.3 server. One of the tables has huge blobs spread over several dbspaces and seems to have used it all up. (Excerpt from "freespace") dbsnum name total_size amount_free percent_free 1 rootdbs 2048000 1349914 65.91 2 ppiblobs 6000000 0 0.00 3 ppidbs 3840000 1825320 47.53 (Excerpt from "dbspace") Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 126 days 05:30:22 -- 87888 Kbytes Dbspaces address number flags fchunk nchunks flags owner name ce42150 1 1 1 1 N informix rootdbs ce427c8 2 10 2 3 N B informix ppiblobs ce42888 3 1 3 2 N informix ppidbs 3 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname ce42210 1 1 2356 1024000 674957 PO- /dev/ online_rootdbs ce42368 2 2 2356 1000000 ~0 1000000 POB /dev/ online_ppiblobs ce42448 3 3 2356 1000000 855 PO- /dev/ online_ppidbs ce42528 4 2 0 1000000 ~0 1000000 POB /dev/ online_ppiblobs3 ce42608 5 2 0 1000000 ~0 1000000 POB /dev/ online_ppiblobs4 ce426e8 6 3 0 920000 911805 PO- /dev/ online_ppidbs3 6 active, 2047 maximum How do I expand the blob storage size? I appreciate any guidance!

Matt wrote: > I support an application running on an IDS 7.3 server. One of the > tables has huge blobs spread over several dbspaces and seems to have > used it all up. > > (Excerpt from "freespace") > > dbsnum name total_size amount_free > percent_free > 1 rootdbs 2048000 1349914 > 65.91 > 2 ppiblobs 6000000 > 0 0.00 > 3 ppidbs 3840000 1825320 > 47.53 > > (Excerpt from "dbspace") > > Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 126 days > 05:30:22 -- 87888 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > ce42150 1 1 1 1 N informix rootdbs > ce427c8 2 10 2 3 N B informix > ppiblobs > ce42888 3 1 3 2 N informix ppidbs > 3 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > ce42210 1 1 2356 1024000 674957 PO- /dev/ > online_rootdbs > ce42368 2 2 2356 1000000 ~0 1000000 POB /dev/ > online_ppiblobs > ce42448 3 3 2356 1000000 855 PO- /dev/ > online_ppidbs > ce42528 4 2 0 1000000 ~0 1000000 POB /dev/ > online_ppiblobs3 > ce42608 5 2 0 1000000 ~0 1000000 POB /dev/ > online_ppiblobs4 > ce426e8 6 3 0 920000 911805 PO- /dev/ > online_ppidbs3 > 6 active, 2047 maximum > > How do I expand the blob storage size? I appreciate any guidance! Assuming you have disk space available, the onspaces command is used to add new chunks to an existing blobspace (or dbspace or, if you had version 9.x or later, a smart blobspace). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/