In this blog post, let’s learn about the error message “079 No record locks available.” in Hydra and the description of the error.
Error Message
079 No record locks available.
Error Details
An operating-system error code with the meaning shown was unexpectedly returned to the database server. This implementation of the Informix database server probably uses kernel locking, the use of the operating-system facilities to lock rows of tables. The capacity of the operating-system lock table has been exceeded. Contact your system administrator and inquire about configuring the operating system to support more locks. Also examine your database application to see if it can use fewer locks by updating fewer rows in each transaction or by locking whole tables instead of rows.