TROUBLESHOOTING

Resolving error "failed to extend tablespace"
Each IBM® Lotus® Notes® database is represented by several IBM® DB2 Universal Database™ Enterprise Server Edition tables stored in a DB2 tablespace.

When you enable a IBM® Lotus® Domino™ server for DB2, you can specify the directory paths where DB2 creates container files for the DB2 tablespaces. For example, you may see an entry similar to this in the Domino server's NOTES.INI file, or on the DB2 tab of the Server document in NAMES.NSF:


It is possible for a physical drive to become full. For example, we will assume drive H in the sample NOTES.INI and DB2 tab entry above is full. When a physical drive is full, the following error displays in the Domino server console:
Resolving the problem

To resolve this problem, do the following in DB2 using either the DB2 Control Center or DB2 Command Line Processor:

1. Create a container file on a drive other than the drive that is full.

2. Remove the container file from the drive that is full.

3. After container rebalancing completes, move the new container file to the drive from which you removed the full container file.

For instructions on how to create a container file and how to remove a full container file, see the DB2 Information Center http://publib.boulder.ibm.com/infocenter/db2help/index.jsp.

Example

We are using tablespace USER1 with container FILE 'h:\db2\5.DB2NSF

Drive H is full.

1. Create a new container file on Drive I. Add 100MB (1GB) to drive I, as follows:

2. After container rebalancing occurs, drop the new container file on drive H. See also