In this blog post, let’s learn about the error message “1180 The required subvolume name for locations in schema schema-name is subvol-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1180 The required subvolume name for locations in schema schema-name is subvol-name.
Reason for the Error
One or more LOCATION clauses in the CREATE or MODIFY statement contained a Guardian location whose subvolume did not match the designated subvolume for the schema in which the object was being created.
Solution
Either correct the invalid LOCATION clauses or remove them and allow the system to generate the Guardian locations
