Base Table (-basetable)

Operating system and syntax UNIX / Windows 
-basetable n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 32767 -32767 – 1
n
The starting table number in the range of tables for which you want to track access statistics.

Use Base Table (-basetable) with Table Range Size (-tablerangesize) to specify the range of tables for which you want to collect statistics. Base Table to Table Range Size parameters are for table number range, not the total number of tables.

Access the statistics through the Virtual System Tables (VSTs). The _TableStat VST stores table statistics. Specify a file number greater than 0 to limit output to an application schema and avoid showing meta-schema files. To obtain table numbers, use the following ABL code:

FOR EACH _file NO-LOCK WHERE _file-number > 0 AND NOT _file-name BEGINS "SYS"
    BY _File._File-Num DESCENDING:
    
    ACCUMULATE _file-number (COUNT).
    
    DISP _File._File-Num _File._File-Name ACCUMULATE COUNT _file-number.
END.

This results in the following output:

_File-Number _File-Name
     n3   table name3
     n2   table name2
     n1   table name1

To change this parameter while the database is running, use PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.

4