Classification of Extended Work Locations
When extending a database to use additional work locations, classify them as follows:
• Work (also known as defaultable) locations are used for all user sorts on a database.
• Auxiliary locations are not used unless explicitly requested by a SET WORK LOCATIONS statement.
After a database has been extended to use an additional work location, you can subsequently modify the work area’s classification using accessdb or the Alter Database dialog in VDBA.