I've also seen this when browsing a large table by one user and another process attempts to update the same table (maybe using a cursor).
In the very old days I recall "exceeding the number of file handles available".
But I may have mis-remembered.
Dennis
*****
At 08:57 AM 11/17/2012, you wrote:
My usual culprit is a cursor that is not dropped, still open.
Karen
In a message dated 11/16/2012 4:17:14 PM Central Standard Time, [email protected] writes:
RB7x user is getting "Resources Unavailable" message and then they have to reset.
If a table is locked this will happen. Other causes?
TIA,
Dennis
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290

