SYSAUTOLOCATE

The sysautolocate system catalog table indicates which dbspaces are available for automatic table fragmentation.

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

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

Copyright© 2018 HCL Technologies Limited