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

EXECUTE FUNCTION { admin | task } ( "autolocate database off","database_name" );
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");