If any work location runs out of disk space during a sort, the sort fails and the associated transaction is aborted.

To correct this situation, you can add additional work locations or provide more space on the device that filled (by removing or relocating unneeded files). Alternatively, the device that filled can be dropped through the SET WORK LOCATIONS statement.

For information about work locations and the SET WORK LOCATIONS statement, see Work Locations (see page Work Locations). For a discussion on deleting unneeded files, see the chapter “Maintaining Databases.”