autolocate database add argument: Add a dbspace to the dbspace list (SQL administration API)

Use the autolocate database add argument with the admin() or task() function to add a dbspace to the list of available dbspaces for the automatic location and fragmentation of tables for the specified database.

Syntax

EXECUTE FUNCTION { admin | task } ( "autolocate database add","database_name" , "dbspace" );
Element Description Key Considerations
database_name Name of the database
dbspace Name of a dbspace to add to the list of names of the 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 adds the dbspace dbspace9 to the list of available dbspaces for automatic location and fragmentation for tables in the customer database.

EXECUTE FUNCTION task("autolocate database add", "customer", "dbspace9");