Neoview Messages Manual (R2.2)

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.
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.
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.
• Could not create directory dirname, a component of the
path does not exist.
• Could not create directory dirname, read-only filesystem.
• Could not create directory dirname, a component of the
path is not a directory.
• Could not create directory dirname, errno is errnum.
162 Optimizer Messages (6000 Through 6999)