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

Recovery Undo your changes by using the CLEAR option in UPDATE STATISTICS and
regenerate the statistics.
SQL 6007
6007 Multi-column statistics for columns column-names from table
table-name were not available. The columns were being used by op-name
operator. As a result, the access path chosen might not be the best
possible.
column-names
is a list of column names of the affected columns.
table-name
is the name of the HP Neoview database table to which the columns belong.
op-name
is the operator that was being processed when the warning was issued.
Cause Statistics for the set of columns was not generated. The warning is issued only for
multi-column stats.
Effect None. The plan generated by the optimizer may not be optimal. This is a warning
message.
Recovery Generate the statistics for the set of columns identified in the warning, and prepare
the query again.
SQL 6008
6008 Statistics for column column-name from table table-name were not
available. As a result, the access path chosen might not be the best
possible.
column-name
is the name of the affected column.
table-name
is the name of the HP Neoview database table to which the columns belong.
Cause Statistics for the column were not generated.
Effect None. The plan generated by the optimizer may not be optimal. This is a warning
message.
Recovery Generate the statistics for the column identified in the warning, and prepare the
query again.
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.
174 Optimizer Messages (6000 Through 6999)