You can use SAPDBA to add a dbspace to your Informix database. For more information about when to add a new dbspace, see Creation of a New Dbspace.

• 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.
• There is enough disk space available for the new dbspace. SAPDBA checks the available disk space during the procedure.

1. Choose Dbspaces ® Add a Dbspace in SAPDBA.

If you are adding a dbspace for the R/3 System, make sure you give it a name beginning with psap , for example, psapdbs01 . The ABAP Dictionary in the R/3 System is only updated with the new dbspace name if it begins with psap . If the ABAP Dictionary contains information about a dbspace, the dbspace is retained during upgrades, so you do not have to recreate the dbspace and its objects (that is, tables, indexes and so on). If you choose a name for your dbspace that does not begin with psap , SAPDBA warns you that it will not be registered in the Dictionary.

2. Enter the name of the dbspace you want to add.

The characteristics of the new dbspace are whether it is mirrored and whether it is temporary. Mirroring is used to replicate the dbspace on a second physical disk drive for improved reliability. Temporary dbspaces are used to store temporary tables. For more information about temporary dbspaces, refer to your Informix documentation.

3. Select whether you want the dbspace to be mirrored, and whether you want it to be temporary.
4. Choose Continue.

SAPDBA displays further fields for you to specify the size and location of the primary chunk of the new dbspace. If you are adding a mirrored dbspace, SAPDBA also displays fields for the location of the mirror chunk. The size of the mirror chunk is the same as the primary chunk.

You must specify the size first, followed by the location.

5. To define the chunk size in kilobytes, enter a value in the field Size.

The minimum size is 1000 KB and the maximum is 2 GB. SAPDBA checks that the size you enter is a multiple of the page size on your machine, usually either 2 or 4 KB. The size you enter here is also the threshold for the display in the dialog boxes for location of primary chunk and location of mirror chunk.

6. To define where the new primary chunk is stored, use location of primary chunk:

a. Choose Select gap (UNIX) or Select device (NT).

SAPDBA displays a dialog box showing the Available Gaps (UNIX) or disk drives (NT) on your system. The entries in the dialog box are the same as on Listing Devices with SAPDBA but only the free space is shown.

Only devices with free space equal to or greater than the Size of the chunk you entered in the previous step are displayed. Therefore, if you specified a large chunk size, it is possible that no gaps or disk drives are displayed.

b. Select a suitable gap (UNIX) or disk drive (NT).

SAPDBA fills the fields specifying the location of the primary chunk, using the values you selected.

7. If the dbspace is mirrored, use the box location of mirror chunk to define where the mirror chunk is stored. Use the instructions given for location of primary chunk in the previous step. SAPDBA looks for disk space for the mirror chunk on a physically different disk drive than the primary chunk.
8. Choose Execute.

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:

Dropping a Dbspace with SAPDBA