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

Dropping a Chunk with SAPDBA

Use

You can use SAPDBA to drop an empty chunk from your Informix database. SAPDBA only lets you delete empty chunks.

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 chunk to be dropped is empty (that is, it does not contain any data).

Procedure

Choose Dbspaces ® Drop a Chunk in SAPDBA.

SAPDBA displays a list of empty chunks.

Select the chunk you want to drop.

Choose Continue.

Result

SAPDBA drops the chunk and displays a confirmation message. If the chunk 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 DROP CHUNK:
Date	Dbspace	Size [KB]
11.Dec.98, 13:37:10	PSAPBTAB	1000
Primary Path: /informix/CX5/sapdata/physdev1/data1

See also:

Extending a Dbspace with SAPDBA