Neoview Messages Manual (Volume 1) (R2.4)

Effect The HP Neoview database uses default statistics to generate plans. Therefore, these
might not be the best plans generated.
Recovery Undo your changes by using the CLEAR option in UPDATE STATISTICS and
regenerate the statistics.
SQL 6007
6007 Multi-column statistics for columns names from table name were not
available; as a result, the access path chosen might not be the best
possible.
names
is a list of column names of the affected columns.
name
is the name of the HP Neoview database table.
Cause Statistics are not available for the multicolumn join you are performing.
This message appears when the user has not updated statistics for column names and when
the rowcount in table name is more than the value of the defaults table constant
HIST_ROWCOUNT_REQUIRING_STATS. If you want to suppress this message, set that value
to a very large number, and you will see this message only for tables with more rows than
that, and for which there are no updated statistics.
Effect None. This is a warning message.
Recovery None.
SQL 6008
6008 Statistics for column name were not available. As a result, the
access path chosen might not be the best possible.
name
name of the column.
Cause Statistics are not available for the statement you specified.
This message appears when the user has not updated statistics for column name and when
the rowcount in the table is more than the value of the defaults table constant
HIST_ROWCOUNT_REQUIRING_STATS. If you want to suppress this message, set that value
to a very large number, and you will see this message only for tables with more rows than
that, and for which there are no updated statistics.
Effect None. This is a warning message.
Recovery None.
SQL 6009
6009 The Optimizer Simulator (OSIM): errmsg
errmsg
is one of these conditions:
• Invalid OSIM mode - It must be OFF or CAPTURE or
SIMULATE.
• CAPTURE <-> SIMULATE mode transition is not allowed.
• The file filename exists and it is not a directory.
• Log directory must be specified for CAPTURE/SIMULATE
mode.
• The log directory dirname doesn't exist.
• The directory dirname is not writable (access denied).
• The directory dirname is not writable (read-only
filesystem).
• The directory dirname does not have read permission.
• Could not create directory dirname, permission denied.
168 Optimizer Messages (6000 Through 6999)