autolocate database anywhere argument: Add all dbspaces to the dbspace list (SQL administration API)

Use the autolocate database anywhere argument with the admin() or task() function to specify that the database server can use any non-critical dbspace for the automatic location and fragmentation of tables for the specified database.


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

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

Element Description Key Considerations
database_name Name of the database Cannot be the name of a tenant database.


This command replaces any previous list of dbspaces with a list of all available dbspaces. Dbspaces that are dedicated to tenant database are not available. The list of available dbspaces is stored in the sysautolocate system catalog table.

The AUTOLOCATE configuration parameter or session environment variable must be set to a positive integer.


The following command adds all non-critical dbspaces to the list of available dbspaces for automatic location and fragmentation for tables in the potential_cust database:

EXECUTE FUNCTION task("autolocate database anywhere", "potential_cust");

Copyright© 2018 HCL Technologies Limited