Base Table (-basetable)

-basetable n

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. Access to the statistics is handled through the Virtual System Tables (VSTs). Table statistics are stored in the _TableStat VST. To obtain table numbers, use the following ABL code:

FOR EACH _file NO-LOCK:
  DISPLAY _file._file-num _file._file.
END.

This results in the following output:

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

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.