SQL/MP Messages Manual

HP NonStop SQL/MP Messages Manual—427720-006
16-1
16 File-System Messages
This section describes file-system messages that are specific to NonStop SQL/MP.
File-system messages that can be issued for NonStop SQL/MP in addition to other
subsystems are not included here.
SQL 035
Cause. Either you have requested more than 5000 locks, or the disk process for the
accessed volume does not have space for more control blocks.
Effect. The statement fails.
Recovery. To correct the first condition of too many locks, you have two options:
1. Use CONTROL TABLE TABLELOCK ENABLE so that the system can escalate
individual row locks to a table lock or use CONTROL TABLE TABLELOCK ON so
that the system can acquire from the start a table lock.
2. Release the locks by using UNLOCK TABLE if the tables are nonaudited or by
either committing or aborting the transaction if the transaction is audited.
SQL 047
Cause. An INSERT, DELETE, or UPDATE statement was attempted on a row of a
nonaudited table that was locked by another user and that has at least one index
defined.
Effect. If the table cannot be updated before a timeout occurs, the operation might be
performed on that table; however, the indexes will not reflect the update.
Recovery. Alter the audit attribute of the table, or lock the row before attempting the
operation.
035 Unable to obtain I/O process control block.
047 The file system is unable to complete an update to a
table and its corresponding index. The table and index might
be inconsistent.