Setting up DML Activity Collection displayed the following error:
The LAP_TABLESPACE parameter is incorrect.
The LAP_LOG_DIR parameter is missing.
Please run Configure Quest Server Agent from the File -> Admin menu, and set the above parameter(s).
What are these parameters used for?
LAP_TABLESPACE is the tablespace used to store the information gathered about how many inserts/deletes/updates for the table for a particular time period. The amount of space required would be small, definitely less than the size of the Space Manager statistics repository. Of course this depends on how many tables you monitor and for how long, but 50 MB or so should be plenty. The data will remain in our SQL Activity Profile tables until you delete the table from the DML profile tab in the Explorer window.
LAP_LOG_DIR is where Space Manager writes the log files for the SQL Activity Profile jobs indicating how many collections were run. Those logs are used internally. Normal users can view the job log files by right-clicking on a SQL Activity profile job in the job monitor page and selecting “Retrieve Script Logs”.
