HP NonStop SQL/MX, Messages Manual

Page: 90 / 752

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual — 640324-001
3- 64
SQL 1305
Where
subvolume
is the Guardian subvolume name specified in the LOCATION
clause of the CREATE SCHEMA command.
Where
schema
is the ANSI name of an existing schema that already uses
subvolume
as a schema subvolume.
Cause. In a CREATE SCHEMA command, you specified
subvolume
in the
LOCATION clause; however, this subvolume is already being used as schema
subvolume by
schema
.
Effect. The statement fails unless it includes the optional REUSE clause to allow
reuse of the same schema subvolume name. If the REUSE clause is used, this is a
warning message and the schema is created successfully. The warning can be issued
repeatedly for a single CREATE SCHEMA command if multiple schemas already exist
with
subvolume
as the schema subvolume.
Recovery. Only schemas that are RDF replicated to another node should have the
same subvolume names as their corresponding schemas on the other node. To create
these, use the optional REUSE clause in the CREATE SCHEMA statement. All other
schemas should have unique subvolume names. Schemas that are, or will be, related
as RDF primary and backup schemas must have identical schema names and
subvolumes on the primary and backup nodes.
SQL 1306
Where
schema
is the ANSI name of the schema specified in the CREATE SCHEMA
command.
Cause. In a CREATE SCHEMA command, you did not specify a LOCATION clause,
but NonStop SQL/MX was unable to generate a schema subvolume name that is not
already being used by existing schemas.
Effect. The operation fails.
Recovery. Retry the CREATE SCHEMA several times. If it continues to fail, contact
your service provider.
1305 The specified schema location subvolume is already in
use by schema schema .
1306 SQL/MX was not able to generate a unique schema location
for schema
schema .