Neoview Database Administrator's Guide (R2.4)

Creating Materialized View Groups...............................................................................................79
Displaying Materialized View Groups and their Properties..........................................................80
Changing Materialized View Groups.............................................................................................81
Dropping (Deleting) Materialized View Groups............................................................................81
Synonyms..............................................................................................................................................81
Creating Synonyms.........................................................................................................................82
Considerations for Synonyms....................................................................................................83
Displaying Synonyms and Their Properties...................................................................................83
Changing Synonyms.......................................................................................................................83
Dropping (Deleting) Synonyms......................................................................................................84
Stored Procedures in Java (SPJs)...........................................................................................................84
Displaying Stored Procedures.........................................................................................................84
6 Performing Database Operations...............................................................................87
Schedule Maintain Wizard...................................................................................................................87
Schedule Table Row Deletion...............................................................................................................90
Displaying Scheduled Operations' Status............................................................................................90
Modifying Scheduled Operations...................................................................................................93
Deleting Scheduled Operations.......................................................................................................93
Neoview VTS System Status Page........................................................................................................93
Displaying the VTS System Status Page..........................................................................................93
Interpreting the VTS System Status Page...................................................................................94
Data Recovery.......................................................................................................................................95
7 Other Operations.........................................................................................................97
Managing the Super ID.........................................................................................................................97
Viewing System Events.........................................................................................................................98
Monitoring real-time messages.....................................................................................................100
Viewing a selection of past messages............................................................................................100
Viewing a summary of events.......................................................................................................101
Accessing Events Using a URL......................................................................................................102
Monitoring Queries.............................................................................................................................103
8 Automating Update Statistics and Reorganize Operations...................................105
Setting Tables for Automated UPDATE STATISTICS.........................................................................105
HP_USTAT.CHG_AUTO_LIST() Stored Procedure......................................................................105
Syntax.......................................................................................................................................105
Considerations..........................................................................................................................106
Examples..................................................................................................................................107
Listing the Automated Tables.............................................................................................................108
HP_USTAT.USTAT_AUTO_LIST View.........................................................................................108
HP_USTAT.USTAT_AUTO_LIST_DETAIL View..........................................................................108
Stopping Automated UPDATE STATISTICS......................................................................................109
HP_USTAT.STOP_AUTOMATED_STATS() Stored Procedure.....................................................109
Syntax.......................................................................................................................................109
Considerations..........................................................................................................................109
Example....................................................................................................................................109
Scheduling Automated UPDATE STATISTICS and REORG..............................................................110
SCHEDULE Command.................................................................................................................110
Syntax.......................................................................................................................................110
Considerations..........................................................................................................................110
Examples..................................................................................................................................110
Table of Contents 5