IBM Support

WARNING: Not enough temp space for parallel index build

Technote (troubleshooting)


You run CREATE INDEX but see a warning similar to this:

WARNING: Not enough temp space for parallel index build.
Space required = 1000000 pages; space available = 50000 pages.
Partial index build started.


There is not enough TEMP space available for sorting required during a parallel index build.

Resolving the problem

You do not have to take action. This is a warning. The database server will create the index one fragment at a time, instead of all at once.

If you want the index to build more quickly in parallel, then follow these steps:

1. Cancel the currently running CREATE INDEX statement.
2. Add more temporary space by adding chunks to current temporary dbspaces or by adding new temporary dbspaces. Creating a temporary dbspace Make sure you add enough space to least equal the number of pages the Warning requested.
3. Rerun the CREATE INDEX statement. Improving performance for index builds

Document information

More support for: Informix Servers

Software version: 11.5, 11.7, 12.1

Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows

Reference #: 1459827

Modified date: 26 June 2014

Translate this page: