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

Recovery None necessary; however, you can:
• Generate new statistics now by using UPDATE STATISTICS FOR TABLE table-name
ON NECESSARY COLUMNS.
SQL 6012
6012 Statistics for column column-name from table table-name were
generated with small sample. As a result, the access path chosen might
not be the best possible.
column-name
is the name of the affected column for which statistics are missing.
table-name
is the name of the HP Neoview database table to which the column belongs.
Cause Statistics for the Column were not generated.
Effect Statistics were generated while the query was being compiled with a small sample;
the plan generated by the optimizer may not be optimal.
Recovery Generate the statistics with a larger sample for the column identified in the warning,
and prepare the query again.
SQL 6013
6013 Statistics for column column-name from table table-name were
generated with small sample. As a result, the access path chosen might
not be the best possible. Better statistics will be automatically
generated at the next opportunity; however, you can generate them now
by using UPDATE STATISTICS FOR TABLE table-name ON NECESSARY COLUMNS.
column-name
is the name of the affected column for which statistics are missing.
table-name
is the name of the HP Neoview database table to which the column belongs.
Cause Statistics for the Column were not generated.
Effect Statistics were generated while the query was being compiled with small sample; the
plan generated by the optimizer may not be optimal. Statistics for the column identified in the
warning will be automatically generated at the next available scheduled time window.
Recovery None necessary; however, you can:
• Generate new statistics now by using UPDATE STATISTICS FOR TABLE table-name
ON NECESSARY COLUMNS.
SQL 6015
6015 Escalate to gross file lock when user has nnn locks (nnn record
locks are for this file).Long ID Pool Usage: nnn bytes. Error code:
nnFile Name: $volume.subvolume.filenameANSI Table catalog.schema.table,
Partition partition_name
nnn
is a decimal number.
nn
is the file-system error code.
volume
is the specified volume.
subvolume
is the specified subvolume.
filename
is the specified file name.
partition_name
is the specified partition name.
Cause DP2 tries to escalate the table to gross file locks because one of the following occurs:
• The opener or the transaction using this table acquires too many record locks.
• The IDs for record locks of this table consume excessive long ID pool space.
Effect If the Error code is 0, DP2 successfully acquires gross file locks on the table. Otherwise,
DP2 cannot complete the escalation and will return Error code 33 or 35.
176 Optimizer Messages (6000 Through 6999)