autolocate database remove argument: Remove a dbspace from the dbspace list (SQL administration API)

Use the autolocate database remove argument with the admin() or task() function to remove a dbspace from the list of available dbspaces into which the database server can automatically locate and fragment tables for the specified database.

Syntax

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

>--"autolocate database remove"--,--"database_name"--,--"dbspace"-->

>--)--;--------------------------------------------------------><

Element Description Key Considerations
database_name Name of the database  
dbspace Name of the dbspace to remove from the list of names of dbspaces in which the database server can automatically create fragments. The dbspace must exist.

Usage

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

The list of available dbspaces is stored in the sysautolocate system catalog table.

Example

The following command removes dbspace1 from the list of available dbspaces for the customer database.

EXECUTE FUNCTION task("autolocate database remove", "customer", "dbspace1");

Copyright© 2019 HCL Technologies Limited