Neoview Database Administrator's Guide (R2.5)

4 Performing Database Operations
This chapter describes:
• “Schedule Maintenance Tasks” (page 21)
• “Schedule Table Row Deletion” (page 21)
• “Neoview VTS System Status Page” (page 21)
• “Interpreting the VTS System Status Page” (page 22)
• “Data Recovery” (page 23)
Schedule Maintenance Tasks
You can perform a variety of maintenance tasks on tables and materialized views, such as
scheduling automated update statistics or reorganize operations. For more information, see
Chapter 5 (page 25).
Schedule Table Row Deletion
To minimize table size and improve table performance, you should periodically delete older
rows from tables.
To purge a table, use the Neoview Command Interface (NCI) and issue a DELETE command
with the WITH MULTI COMMIT or WITH NO ROLLBACK option.
To run commands and scripts in NCI, refer to the Neoview Command Interface (NCI) Guide. For
the syntax of the DELETE command, see the Neoview SQL Reference Manual.
Neoview VTS System Status Page
If your Neoview platform includes a virtual tapeserver (VTS), you can access information about
the VTS from a browser. The system status page of the HP Neoview Virtual TapeServer (Neoview
VTS) contains information about the VTS and its virtual tape devices.
Displaying the VTS System Status Page
To display the system status page, open a browser window and enter the IP address of your
Neoview VTS. For example:
http://IP_Address
where IP_Address is the IP address of the Neoview VTS.
These browsers are supported on Windows: Microsoft Internet Explorer 6.0, Mozilla Firefox 1.5,
and Netscape 8.1.
Here is an example of the system status page:
Schedule Maintenance Tasks 21