Base Table (-basetable)

Database Administration

Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Base Table (-basetable)

Operating system and syntax	UNIX / Windows	-basetable n
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
DBS	32765	-32765	–	–

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