Dropping a Dbspace with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Dropping a Dbspace with SAPDBA

Use

You can use SAPDBA to drop an empty dbspace from your Informix database. SAPDBA checks whether the dbspace is empty during the procedure.

Prerequisites

SAPDBA is installed correctly. Refer to SAPDBA Setup.

You are logged on in expert mode, that is, as user informix , and you have started SAPDBA. Refer to Starting SAPDBA.

The dbspace to be dropped is empty (that is, it does not contain any tables).

Procedure

Choose Dbspaces ® Drop a Dbspace in SAPDBA.

Enter the dbspace that you want to drop.

Choose Continue.

Result

SAPDBA drops the dbspace and displays a confirmation message. If the dbspace could not be dropped, SAPDBA displays an error message including any further information available.

You can check the results by looking in the dbspace.log file, which you can find in the directory $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT). For more information, see SAPDBA Files, Directories, and Reports. Here is an example of the entry that SAPDBA writes to this file:

Example

DBSPACE DELETION:
Date	Dbspace	Size [KB]
11.Dec.98, 13:37:10	PSAPBTAB	1000
Primary Path: /informix/CX5/sapdata/physdev1/data1

See also:

Adding a Dbspace with SAPDBA