Drop a Dbspace, Blobspace, Sbspace, or Extspace

Home | Previous Page | Next Page Administrative Utilities > Managing Storage Spaces with the onspaces Utility >

Drop a Dbspace, Blobspace, Sbspace, or Extspace

Drop a Dbspace, Blobspace, Sbspace, or Extspace:
 
|-- -d--+-dbspace----------+--+-----+---------------------------|
        +-blobspace--------+  '- -y-'
        +-+-----+--sbspace-+
        | '- -f-'          |
        '-extspace---------'

Element	Purpose	Key Considerations
-d	Indicates that a dbspace, blobspace, sbspace, or extspace is to be dropped	Additional Information: You can drop a dbspace, blobspace, sbspace, or extspace while the database server is online or in quiescent mode. After you drop a storage space, you must back it up to ensure that the sysutils database and the reserved pages are up-to-date. Restriction: Execute oncheck -pe to verify that no table is currently storing data in the dbspace, blobspace, or sbspace. References: For more information, see dropping a storage space, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-y	Causes the database server to automatically respond yes to all prompts	None.
-f	Drops an sbspace that contains user data and metadata	Additional Information: You must use the -f (force) option to drop an sbspace that contains data. Restriction: Use the -f option with sbspaces only. Warning: If you use the -f option, the tables in the database server might have dead pointers to the smart large objects that were deleted with this option. References: For more information, see dropping a chunk from an sbspace with onspaces, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
blobspace	Names the blobspace to be dropped	Additional Information: Before you drop a blobspace, drop all tables that include a TEXT or BYTE column that references the blobspace.
dbspace	Names the dbspace to be dropped	Additional Information: Before you drop a dbspace, drop all databases and tables that you previously created in the dbspace.
extspace	Names the extspace to be dropped	Additional Information: You cannot drop an extspace if it is associated with an existing table or index.
sbspace	Names the sbspace to be dropped	Additional Information: Before you drop an sbspace, drop all tables that include a BLOB or CLOB column that references the sbspace.

Important:

Do not specify a pathname when you drop these storage spaces.