Problem Statement: Problem Statement

If enabled, you can use the autolocate database arguments with the admin() or task() function to

• If enabled, you can use the autolocate database arguments with the admin() or task() function to

• Manage the list of dbspaces for automatic location and fragmentation:
• The list of available dbspaces is in the sysautolocate system catalog table.
• Disable automatic location and fragmentation for the specified database.

• You can use the AUTOLOCATE environment option of the SET ENVIRONMENT statement of SQL to enable or disable the value of the AUTOLOCATE configuration parameter for a session.

• It is anticipated that the implementation of this feature will lead to fewer out of storage space errors and fewer databases and objects being created in under sized/allocated storage spaces.

• Users can still override automatic server based allocation of location by using the “in dbspace” clause of the create database, table and index clauses

It is anticipated that this will lead to fewer outages caused by having user defined databases and tables and indexes being stored in the rootdbs and causing that space to fill up completely (and stop the instance) or extend/expand unnecessarily beyond its original size.

• It is anticipated that this will lead to fewer outages caused by having user defined databases and tables and indexes being stored in the rootdbs and causing that space to fill up completely (and stop the instance) or extend/expand unnecessarily beyond its original size.

• This has been a long standing user issue and seen in many places.

• This is a good feature.

• Stands alone as a feature. In combination with the implementation of the storage pool it will be very difficult, if configured and administered properly initially, to run out of space.

• Best practice. With the storage pool feature implemented.

Turn off autolocation for the stores database:

• Turn off autolocation for the stores database:

• execute function task(“autolocate database off”, “stores”);

• Turn on autolocation for the stores databases:

• execute function task(“autolocate database add”, “stores”, “datadbs1”);
• execute function task(“autolocate database add”, “stores”, “datadbs1,datadbs2,datadbs3,datadbs4”);
• execute function task(“autolocate database anywhere”, “stores”);

• Remove datadbs2 from the list of available dbspaces for the stores database:

• execute function task("autolocate database remove", “stores", "datadbs1");

• onmode –wf/wm