How Can I reduce the size of dbspace?

Posted in 2000

Topics: Storage & Space Management, Server Administration

Mahmoud Kamoun — Wed, 17 May 2000 15:17:38 GMT — source: Informix-list mailing list archive (1991-1998)

I have created a dbspace with a size of 500000 using onspaces. Now I realize that there is no need for such amount of space for the database. How can I reduce the size to 250000 without dropping the dbspace and recreate it since the space is not empty any more? Thanks Mahmoud Kamoun.

↪ replying to Mahmoud Kamoun

Carlson@WHSmith — Wed, 17 May 2000 15:02:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Mahmoud Kamoun wrote: > > I have created a dbspace with a size of 500000 using onspaces. Now I realize > that there is no need for such amount of space for the database. > > How can I reduce the size to 250000 without dropping the dbspace and > recreate it since the space is not empty any more? > > Thanks > > Mahmoud Kamoun. Only way to do it would be to unload the tables contained within the dbspace, drop the tables, drop the dbspace, recreate the dbspace, then recreate and reload the tables. All with the required backups in place . . . . 8-) -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

↪ replying to Mahmoud Kamoun

Victor Glass — Thu, 18 May 2000 03:55:18 GMT — source: Informix-list mailing list archive (1991-1998)

It is possible to reduce the size of a dbspace if and only if (a) it is composed of more than chunk and (b) one of the non-primary chunks is empty. If this were the case I believe onspaces will do it for you. Mahmoud Kamoun wrote: > I have created a dbspace with a size of 500000 using onspaces. Now I realize > that there is no need for such amount of space for the database. > > How can I reduce the size to 250000 without dropping the dbspace and > recreate it since the space is not empty any more? > > Thanks > > Mahmoud Kamoun.

Glossary

dbspace