Neoview Database Administrator's Guide (R2.3)

Displaying Scheduled Operations' Status............................................................................................88
Modifying Scheduled Operations...................................................................................................91
Deleting Scheduled Operations.......................................................................................................91
Neoview VTS System Status Page........................................................................................................91
Displaying the VTS System Status Page..........................................................................................91
Data Recovery.......................................................................................................................................93
7 Other Operations.........................................................................................................95
Managing the Super ID.........................................................................................................................95
Viewing System Events.........................................................................................................................96
Monitoring real-time messages.......................................................................................................98
Viewing a selection of past messages..............................................................................................98
Viewing a summary of events.........................................................................................................99
Accessing Events Using a URL......................................................................................................100
Monitoring Queries.............................................................................................................................101
8 Automating Update Statistics and Reorganize Operations...................................103
Setting Tables for Automated UPDATE STATISTICS.........................................................................103
HP_USTAT.CHG_AUTO_LIST() Stored Procedure......................................................................103
Listing the Automated Tables.............................................................................................................105
HP_USTAT.USTAT_AUTO_LIST View.........................................................................................106
HP_USTAT.USTAT_AUTO_LIST_DETAIL View..........................................................................106
Stopping Automated UPDATE STATISTICS......................................................................................107
HP_USTAT.STOP_AUTOMATED_STATS() Stored Procedure.....................................................107
Scheduling Automated UPDATE STATISTICS and REORG..............................................................107
SCHEDULE Command.................................................................................................................107
9 Managing Client Data Sources and Connectivity.................................................111
Reconfiguring ODBC Client Data Sources.........................................................................................111
Configuring ODBC Client Data Sources for Update Operations.......................................................111
Removing ODBC Client Data Sources................................................................................................111
Performing Database Connectivity Tasks...........................................................................................111
NDCS Services....................................................................................................................................112
A Data Types.................................................................................................................117
B Special Neoview Features—Enabled Upon Request.............................................121
Mode_Special_2..................................................................................................................................121
Features Supported in Mode_Special_2........................................................................................121
Glossary.........................................................................................................................125
Index...............................................................................................................................127
Table of Contents 5