autolocate database argument: Specify dbspaces for automatic location and fragmentation (SQL administration API)

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

Syntax

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

>--"autolocate database"--,--"database_name"--,--"dbspace_list"-->

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

Element Description Key Considerations
database_name Name of the database Cannot be the name of a tenant database.
dbspace_list A comma-separated list of names of the dbspaces in which the database server can automatically create fragments. The dbspaces must exist. The dbspaces cannot be dedicated to a tenant database.

Usage

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

By default, all dbspaces are available. The list of available dbspaces is stored in the sysautolocate system catalog table.

Example

The following command limits the list of available dbspaces for automatic location and fragmentation for tables in the customer database:

EXECUTE FUNCTION task("autolocate database", "customer",
 "dbspace1,dbspace2,dbspace4,dbspace8");

Copyright© 2019 HCL Technologies Limited