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.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->

>--"autolocate database off"--,--"database_name"--)--;---------><

Element Description Key Considerations
database_name Name of the database  


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.


The following command disables automatic location and fragmentation of tables in the customer_old database:

EXECUTE FUNCTION task("autolocate database off", "customer_old");

Copyright© 2018 HCL Technologies Limited