9128 The transaction exceeded the maximum number of rowhash locks allowed.
Explanation:
This error is returned when a transaction has exceeded the number of rowhash locks allowed. The threshold on the number of rowhash locks allowed is defined in DBSControl via the General field 'MaxRowHashBlocksPercent'. This is done so that one transaction does not fill up the lock table with rowhash locks. The number of control blocks/locks that can fit into an AMP lock table is defined by STDMAXLOCKBLOCKS which is currently 51860.
Generated By:
LOK subsystem.
For Whom:
End user.
Remedy:
Reduce the number of rowhash locks that the transaction is acquiring. An alternative is increase the General field 'MaxRowHashBlocksPercent' value in DBSControl.