The Usage Monitor is a facility for recording location usage. While utilization monitoring is on, the system stores utilization information in the SYSXDB.SYSUSAGE table in the DSNDB06 subdirectory of the system location's directory. If you enable the usage monitor and security, the system will automatically maintain this table, and modify it each time a user logs in or out of a location. You can query the table to audit location usage.
If the SYSXDB.SYSUSAGE table becomes too large, delete entries from the table using the DELETE or TRUNCATE TABLE command. After deleting entries, you must pack the SYSXDB.SYSUSAGE table using the COMPACT command. COMPACT frees space formerly occupied by deleted records. It is good practice to perform this procedure each time you back up the system location when using the System Usage Monitor.
See the SQL Reference for the structure of the SYSXDB.SYSUSAGE table, and for information about the DELETE, TRUNCATE TABLE, and COMPACT commands. As is the case for all XDB Server system tables, the structure of the SYSXDB.SYSUSAGE table is subject to change.
To set the parameter on UNIX:
To set the parameter on Windows 2000: