Neoview Database Administrator's Guide (R2.3)

NOTE: To query these views, you must be logged in as ROLE.DBA (or super.services or the
super ID if you are HP support).
HP_USTAT.USTAT_AUTO_LIST View
The USTAT_AUTO_LIST view contains all the automated tables. Because the row width is less
than 80 characters, long table and schema names might become truncated in the view. For full
column data, query the USTAT_AUTO_LIST_DETAIL view instead. See Table 8-2.
Table 8-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 runCHAR(11)LAST_RUN
Return value of last UPDATE STATISTICS run. If there was no
error, zero (0) is returned.
CHAR(5)RC
To list all the tables in the USTAT_AUTO_LIST view, execute this SELECT statement:
SQL>SELECT * FROM HP_USTAT.USTAT_AUTO_LIST;
SCH_NAME TBL_NAME LAST_RUN RC
------------------------- ------------------------- ----------- -----
SALES ORDERS 01-01 00:00 0
SALES PARTS 01-01 00:00 0
--- 2 row(s) selected.
For the syntax of the SELECT statement, see the Neoview SQL Reference Manual.
HP_USTAT.USTAT_AUTO_LIST_DETAIL View
The USTAT_AUTO_LIST_DETAIL view displays the full schema and table names, as well as
error text, for each row.
Table 8-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 runTIMESTAMP(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
------------------------- ------------------------- ------------------- ----------- -------------
106 Automating Update Statistics and Reorganize Operations