ASE Database forum - Row level locking

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Row level locking

Ollie

2005-10-27, 8:21 am

Does ASE escalate to Ex_Table lock after 200 pgs for
datarows locking schema like it does for allpages?

Bret Halford

2005-10-27, 8:21 am

ASE will attempt to exacalate to a table lock based on the
same HWM, LWM, etc. parameters, but with datarow locking
it is based on number of row-level locks rather than page-level
locks (i.e. "after 200 pgs" is meaningless for a datarow table).

-bret

Ollie wrote:

> Does ASE escalate to Ex_Table lock after 200 pgs for
> datarows locking schema like it does for allpages?

Sponsored Links