In this blog post, let’s learn about the error message “1764 Volume volume-name is not available for database database-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1764 Volume volume-name is not available for database database-name.
Reason for the Error
Volume specified in the LOCATION clause of the CREATE DDL statement or the syntax-based utility command is not associated with the database.
Solution
Specify the volume that is associated with the database