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

SQL 12109
12109 To ensure optimal Refresh performance, the STORE BY clause should
include the following GROUP BY columns: col-names.
col-names
are the group by columns that should be included in the STORE BY clause.
Cause To improve the materialized view refresh performance, the specified columns should
have been included in the STORE BY clause.
Effect This is an informational message. The materialized view is created successfully.
Recovery None, but you can drop and recreate the materialized view with the recommended
STORE BY clause to improve refresh performance.
SQL 12110
12110 The materialized view mv-name and its dependents were dropped
because of insufficient privileges.
mv-name
is the name of the dropped materialized view.
Cause Privileges on the materialized view base table were revoked from the materialized
view owner.
Effect The materialized view and its dependent objects (such as views or other materialized
views created on this materialized view) are dropped.
Recovery None. If you need to recover the dropped materialized view, the revoked privileges
need to be acquired and the materialized view recreated.
SQL 12111
12111 NO AUDIT materialized views are not supported.
Cause You specified a materialized view that is not audited.
Effect The creation of the materialized view fails.
Recovery Correct the syntax and resubmit.
SQL 12112
12112 A secondary index index-name was created for the materialized
view.
index-name
is a system-added secondary index.
Cause You created an incremental materialized view.
Effect This is an informational message. For optimal refresh performance, the system added
the mentioned secondary index to the materialized view.
Recovery None.
SQL 12113
12113 ON STATEMENT MAVs and MAJVs are currently not supported.
Cause ON STATEMENT materialized aggregate views are not supported.
Effect The operation fails.
Recovery Create materialized aggregate views as ON REQUEST.
SQL 12114
12114 ON STATEMENT materialized views using this object.
Cause The table attribute was changed from audit to no audit.This is not allowed when an
ON STATEMENT materialized view is using it.
Effect The operation fails.
258 Materialized Views Messages (12000 Through 12329)