In this blog post, let’s learn about the error message “1305 The specified schema location subvolume is already in use by schema schema.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1305 The specified schema location subvolume is already in use by schema schema.
Reason for the Error
In a CREATE SCHEMA command, you specified subvolumein the LOCATION clause; however, this subvolume is already being used as schema subvolume by schema.
Solution
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
