Creation of a New Dbspace (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Creation of a New Dbspace

Use

SAP does not normally recommend you to create a new dbspace for your Informix database because your installation then differs from the standard setup for the SAP System.

However, you might still want to create new dbspaces if:

You need to move certain tables to separate disks so as to reduce disk I/O bottlenecks.

You have a very large database and you want to set up new dbspaces to make administration easier (for example, due to backup requirements).

Caution

Be aware that SAP System upgrades might assume a standard dbspace layout and make corresponding assumptions. These assumptions might concern the space requirements to complete the upgrade and the distribution of tables in dbspaces. If you alter the standard configuration in the ways suggested here, you might need to adjust the space requirements accordingly. Also be aware that tables might possibly be moved back to the standard dbspace during the upgrade. In any case, note the names and sizes of any tables that you move or fragment.

Process Flow

When deciding how to set up the new dbspace, you normally follow the same guidelines you used when first installing your system. Refer to Database Setup for Production.

You create a new dbspace using SAPDBA. Refer to Adding a Dbspace with SAPDBA.

You monitor the new dbspace using the following:

· Listing Dbspaces with SAPDBA

· Analyzing Tables for Critical Next Extent Size with SAPDBA

See also:

Informix documentation at http://www.informix.com