SYSAUTOLOCATE

The sysautolocate system catalog table indicates which dbspaces are available for automatic table fragmentation. The sysautolocate system catalog table is reserved for future use.

Table 1. SYSAUTOLOCATE table column descriptions
Column Type Explanation
dbsnum INTEGER The ID number of the dbspace. 0 indicates multiple dbspaces.Reserved for future use.
dbsname VARCHAR(128,0) The name of the dbspace. An asterisk (*) indicates multiple dbspaces.Reserved for future use.
pagesize SMALLINT The page size of the dbspace. 0 indicates multiple page sizes.Reserved for future use.
flags INTEGER
  • 1 = On. The dbspace is available for automatic table fragmentation.
  • 2 = Off. The dbspace is not available for automatic table fragmentation.
Reserved for future use.

You add or remove dbspace from the list of available dbspace by running the task() or admin() SQL administration API function with one of the autolocate database arguments.

The sysautolocate system catalog table does not necessarily list every dbspace. For example, if all dbspaces are available for automatic table fragmentation, the table contains one row:

dbsnum       dbsname        pagesize     flags
0            *              0            1

If all but one dbspace is available, the table contains two rows, for example:

dbsnum       dbsname        pagesize     flags
0            *              0            1
12           dbs12          8            2

If all but two dbspaces are unavailable, the table contains three rows, for example:

dbsnum       dbsname        pagesize     flags
0            *              0            2
12           dbs12          8            1
13           dbs13          4            1