README for HP Neoview Release 2.4 Service Pack 1

Table 1 USTAT_AUTO_LIST 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(25)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(25)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.
CHAR(11)LAST_RUN
Return value of last UPDATE STATISTICS run. If there was
no error, zero (0) is returned.
CHAR(5)RC
• On page 109, the Neoview Database Administrator's Guide should provide the following
information:
HP_USTAT.USTAT_AUTO_LIST_DETAIL View
Table 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
HP_USTAT.STOP_AUTOMATED_STATS() Stored Procedure
— If you do not stop the maintenance window, automated REORG and UPDATE
STATISTICS continue to execute during the maintenance window.
• On page 110, the Neoview Database Administrator's Guide should provide the following
information:
SCHEDULE Command
MAXREORGSLICE {percentage}% is a value from 0 to 100 expressed as a percentage of
the interval time during which the automated
MAINTAIN (REORG) operation runs. For example,
when MAXREORGSLICE is 40%, then REORG uses
40% of the maintenance window time, and UPDATE
STATISTICS uses 60% of the maintenance window
time. If you specify 100% for MAXREORGSLICE, you
will disable automated UPDATE STATISTICS. If you
New Features for Release 2.4 SP1 11