Dbspaces with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Dbspaces with SAPDBA

Use

You can use SAPDBA for Informix to check the condition of your dbspaces and to modify them, that is, extend, add, or drop dbspaces, and drop chunks. You can choose alternative views of the dbspaces (for example, by chunk or device). You can specify the parameters when modifying dbspaces (for example, the size of a new dbspace).

Integration

Dbspace administration is fully integrated in SAPDBA. You can use this functionality for databases running on UNIX and NT operating system platforms.

Prerequisites

You know how to use SAPDBA and have set it up correctly. Refer to Getting Started with SAPDBA.

Features

SAPDBA executes the commands required to analyze and administer dbspaces. For example, a simple display shows you the available space when you add a dbspace. If you still prefer to use the Informix tools, see Extending a Dbspace Without SAPDBA.

SAPDBA helps you administer temporary and mirrored dbspaces.

SAPDBA enforces the 2 GB limit for dbspaces and also makes sure that the size of the dbspace is a multiple of the page size on your machine.

SAPDBA enforces expert mode for actions that modify the database, that is, adding a chunk, adding a dbspace, or dropping a dbspace or chunk. This reduces the risk of unintended changes to the database by inexperienced personnel.

SAPDBA creates an audit log of its actions on dbspaces in the dbspace.log file in the directory $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT). For more information, see SAPDBA Files, Directories, and Reports.

Activities

Listing Dbspaces with SAPDBA

Listing Chunks with SAPDBA

Listing Devices with SAPDBA

Adding a Chunk with SAPDBA

Dropping a Chunk with SAPDBA

Adding a Dbspace with SAPDBA

Dropping a Dbspace with SAPDBA

Renaming Chunk Paths with SAPDBA

See also:

Informix documentation

Management of Informix Database Growth