allocating more table space

I have one table (2 chunks) that seems to have run out of tablespace after someone loaded in half-a-million rows without mentioning it (we won't discuss why). I should know this...but what is the most efficient way to add tablespace here? I have plenty of disk room left. thanks

"M.J. Holley" wrote: > > I have one table (2 chunks) that seems to have run out of tablespace after > someone loaded in half-a-million rows without mentioning it (we won't > discuss why). I should know this...but what is the most efficient way to > add tablespace here? I have plenty of disk room left. > > thanks If you need to add a new chunk, then look at the onspaces command: onspaces -a <dbspace_name> -p <chunk path> -o <offset> -s <size ofnew chunk in K> -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

you may want to add in the consideration of continuous(?, not sure the right expression but placement of the chunks is next to each other) chunks where possible if you are after performance. rgds Steven "Carlson@WHSmith" wrote: > > "M.J. Holley" wrote: > > > > I have one table (2 chunks) that seems to have run out of tablespace after > > someone loaded in half-a-million rows without mentioning it (we won't > > discuss why). I should know this...but what is the most efficient way to > > add tablespace here? I have plenty of disk room left. > > > > thanks > > If you need to add a new chunk, then look at the onspaces command: > > onspaces -a <dbspace_name> -p <chunk path> -o <offset> -s <size of> new chunk in K> > > -- > John Carlson > Informix DBA > WHSmith USA > > #include std_disclaimer.h /* These are my opinions, not my company's > opinion */