In this blog post, let’s learn about the error message “1307 The schema location subvolume is reserved for SQL/MX metadata.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1307 The schema location subvolume is reserved for SQL/MX metadata.
Reason for the Error
In a CREATE SCHEMA command, you specified subvolume in the LOCATION clause, however subvolume names with the format ZSDdigit>anything> are reserved for SQL/MX metadata schemas.
Solution
Specify a subvolume name using the format ZSDletter>anything> in the LOCATION clause, and resubmit