autolocate database off argument: Disable automatic fragmentation for a database (SQL administration API)
Use the autolocate database off argument with the admin() or task() function to disable the automatic location and fragmentation of tables for a specified database.
Syntax
| Element | Description | Key Considerations |
|---|---|---|
| database_name | Name of the database |
Usage
New tables that you create in the specified database are stored in the same dbspace as the database and are not fragmented. Existing tables that were automatically fragmented are not allocated new fragments as the table grows.
Example
The following command disables automatic location and fragmentation of tables in the customer_old database:
EXECUTE FUNCTION task("autolocate database off", "customer_old");