Re: dbspace full

Posted in 1998

Sujit.Pal@alltel.com — Thu, 31 Dec 1998 10:03:10 -0600 — source: Informix-list mailing list archive (1991-1998)

JianJun UPDATE STATISTICS will not release unused pages, if that is what you are asking. You would need to either drop/recreate the table(s), or use ALTER INDEX indexname TO CLUSTER to free unused pages. HTH Sujit ______________________________ Reply Separator _________________________________ Subject: dbspace full Author: jjdai@hotmail.com at internet Date: 12/31/1998 9:00 AM Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimport to reallocate the extent , what is the usage of statement "update statistic " our informix env is online version 5 Thanks JianJun -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own