请高手帮个忙

lxcseac

我现在碰到：
couldn't compute lock promotion level in des for object 1852533633 in database 5.using default level=200
问题不知道怎么解决？

chuxu

Explanation
You can use the following configuration parameters to control how Adaptive Server handles lock promotion:


lock promotion hwm sets the maximum number of locks allowed on a table. When the number of locks that an individual command acquires exceeds this number, Adaptive Server attempts to acquire a table lock.

lock promotion lwm sets the minimum number of locks that are allowed on a table before Adaptive Server attempts to acquire a table lock. Adaptive Server does not attempt to acquire a table lock until the number of locks on a table is equal to the lock promotion lwm.

lock promotion pct sets the percentage of locks (based on the table size) above which Adaptive Server attempts to acquire a table lock when the number of locks is between the lock promotion hwm and the lock promotion lwm.


If a command requires more locks than the number specified by lock promotion lwm but less than the number specified by lock promotion hwm, Adaptive Server compares the number of locks to the percentage of locks on the table. If the number is greater than the percentage, Adaptive Server attempts to issue a table lock.

Adaptive Server computes the lock promotion threshold as a percentage of the table size. If Adaptive Server is unable to get the table size, Error 8219, an informational message, is displayed and Adaptive Server uses the value of lock promotion lwm to determine the lock promotion level.

Action
Error 8219 can occur if the table size is 0 (no rows) or the number of pages for the table is 0. Run dbcc checktable and dbcc checkalloc for the table to determine if this is the case.

If this is not the case and the 8219 error occurs again, call Sybase Technical Support.

lxcseac

能说一下具体解决方法吗?

chuxu

Run dbcc checktable and dbcc checkalloc for the table