Neoview Database Administrator's Guide (R2.2)

4. Click Next to display the Schedule page or Finish to schedule the operation to begin
immediately. If you select Next, DB Admin displays the Schedule Maintain Wizard:
Schedule Table Row Deletion
To minimize table size and improve table performance, you should periodically delete older
rows from tables. You can use the DB Admin Age Table operation to purge outdated rows that
meet a specified delete predicate.
Because an Age Table operation is long-running and can degrade performance, you should
schedule it for a time when it will have minimal impact on system resources and performance.
To perform an Age Table operation:
1. Start DB Admin and log on using any user ID that is authorized to modify the table for
which you want to delete rows.
2. Click the Database tab and navigate to the table for the operation. If you have not yet decided
what your delete predicate will be, you can review the column information for that table to
help construct the predicate.
3. Right-click the table name and select Age Table. The Schedule Age Table Wizard appears.
Enter the predicate to set the criteria for the subset of table rows to be deleted. For syntax
information, see the Neoview SQL Reference Manual:
80 Performing Database Operations