No of Pages Consumed

Hi, I want to know if the number of pages stands at 98% used, and if i delete some rows from the table, will that space/pages (after deleting some rows) can be used for the new data ? We are using IDS FC7 on Sun Sparc. Thanks.

The space will remain assigned to that table and can only be used for new rows in that table. To release the space for other tables you will need to unload,drop,create,reload or relocate the table using a cluster index create. Keith On 6 Oct 2010 09:32, "SHAHZAD SALAM KASI" <skasi@i2cinc.com> wrote: > Hi, > I want to know if the number of pages stands at 98% used, and if i delete some > rows from the table, will that space/pages (after deleting some rows) can be > used for the new data ? > > We are using IDS FC7 on Sun Sparc. > > Thanks. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --0016367658309856570491efb73d

Yes. The deleted row space will be reused for new rows in the same table. If you need to release unused space within a table for use by other tables then you will have to reorg the table to coalesce the empty space into complete pages and free unneeded page extents to the free list. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 6, 2010 at 4:31 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com> wrote: > Hi, > I want to know if the number of pages stands at 98% used, and if i delete > some > rows from the table, will that space/pages (after deleting some rows) can > be > used for the new data ? > > We are using IDS FC7 on Sun Sparc. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163631053fc45eee0491f014b7

Or use ALTER FRAGMENT ... INIT IN... or use the "REPACK SHRINK" SQL API command. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 6, 2010 at 5:51 AM, Keith Simmons <smiley73@gmail.com> wrote: > The space will remain assigned to that table and can only be used for new > rows in that table. To release the space for other tables you will need to > unload,drop,create,reload or relocate the table using a cluster index > create. Keith > > On 6 Oct 2010 09:32, "SHAHZAD SALAM KASI" <skasi@i2cinc.com> wrote: > > Hi, > > I want to know if the number of pages stands at 98% used, and if i delete > some > > rows from the table, will that space/pages (after deleting some rows) can > be > > used for the new data ? > > > > We are using IDS FC7 on Sun Sparc. > > > > Thanks. > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --0016367658309856570491efb73d > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636283796838edf0491f01c7a

On Wed, Oct 6, 2010 at 9:31 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com> wrote: > Hi, > I want to know if the number of pages stands at 98% used, and if i delete > some > rows from the table, will that space/pages (after deleting some rows) can > be > used for the new data ? > > You can find how many pages are alocated and effectively used by querying sysmaster. If you need the query to do it, please say so. But it's possible to find in on the web. If you delete rows, Informix will be able to use that space for new rows, but the space will not be deallocated from the table. Since you're running a version later than 11.50.FC4, you can "repack" and "shrink" to try to free the unused space. Repack will move the rows to the "beginning" of the table. This process may be able to leave completely unused extents at the "end" of the table. Then, if this happens, "Shrink" can be used to free that extents, which effectively detaches them from the table and returns their pages to the dbspace free pages list. ALTER FRAGMENT and CREATE CLUSTER INDEX can also be used to "rebuild" thetable and this will also free unused space (but you need downtime to do that). Repack can be done "online" but that has some implications which must be taken into consideration (it may affect query results - specially if your queries do a full scan of the table). Regards. We are using IDS FC7 on Sun Sparc. > > FC7 is a fixpack level. You missed the version. If it's 11.50 than congratulations: You're running the latest versions and AFAIK this is a very good version. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00504501400c41da380491f03cb8