Have you seen the explanation for the reason code ?
Explanation: The page or row lock on the page or subpage identified by NAME in message DSNT500I or DSNT501I caused the total number of page or row locks concurrently held to
reach the installation maximum number of page or row locks (NUMLKUS) allowed for a single agent in the system.
oh ok. I tried the same sql to delete 10 rows at a time. I'm getting the same problem. I'll contact my DBAs. Thank you for your reply. Could you please let me know where can I get the explanation for reason codes?