In this blog post, let’s learn about the error message “20210 A DDL_LOCKS name must be specified for object-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20210 A DDL_LOCKS name must be specified for object-name.
Reason for the Error
RECOVER found multiple entries for the current table or index that needs to be recovered and cannot determine which operation to recover.
Solution
Select the lock name from the DDL_LOCKS metadata table to determine which operation to recover and resubmit
