Neoview Database Administrator's Guide (R2.5)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.5 Software

Table 5-2 USTAT_AUTO_LIST_DETAIL View

DescriptionData TypeColumn Name

Schema name. For a delimited schema name, the name is stored

in internal format, which means that two successive double quotes

are stored as only one double quote.

CHAR(128)SCH_NAME

Table name. For a delimited table name, the name is stored in

internal format, which means that two successive double quotes

are stored as only one double quote.

CHAR(128)TBL_NAME

Time of last UPDATE STATISTICS run. UPDATE STATISTICS

will not be run on a table or materialized view unless the

histograms have been used in the last 5760 minutes or unless

missing histograms need to be generated.

TIMESTAMP(0)LAST_RUN

Return value of last UPDATE STATISTICS run. If there was no

error, zero (0) is returned.

LARGEINTRC

Error text of the last UPDATE STATISTICS run.VARCHAR(250)ERROR_TEXT

To list all the tables in the USTAT_AUTO_LIST_DETAIL view, execute this SELECT statement:

SQL>SELECT * FROM HP_USTAT.USTAT_AUTO_LIST_DETAIL;

SCH_NAME TBL_NAME LAST_RUN RC ERROR_TEXT

------------------------- ------------------------- ------------------- ----------- -------------

SALES PARTS 0001-01-01 00:00:00 0

SALES ORDERS 0001-01-01 00:00:00 0

--- 2 row(s) selected.

For the syntax of the SELECT statement, see the Neoview SQL Reference Manual.

Stopping Automated UPDATE STATISTICS

HP_USTAT.STOP_AUTOMATED_STATS() Stored Procedure

The STOP_AUTOMATED_STATS() procedure immediately stops the currently running

maintenance window (or schedule) so that you can view and change the maintenance list (that

is, the list of tables for which statistics is automatically updated) and the maintenance window

for running UPDATE STATISTICS.

Syntax

HP_USTAT.STOP_AUTOMATED_STATS()

Considerations

• Use the CALL statement to execute the stored procedure, STOP_AUTOMATED_STATS().

For more information about CALL, see the Neoview SQL Reference Manual and the Neoview

Guide to Stored Procedures in Java.

• To call STOP_AUTOMATED_STATS(), log on to the master segment from NCI as ROLE.DBA

(or super.services or the super ID if you are HP support).

• In NCI, you can execute the CALL statement in SQL mode only.

• If you do not stop the maintenance window, automated REORG and UPDATE STATISTICS

continues continue to execute during the maintenance window.

Example

This CALL statement invokes the STOP_AUTOMATED_STATS() procedure, which stops the

currently running maintenance window:

Stopping Automated UPDATE STATISTICS 29