18
Couldn't compute lock promotion level in DES for object %d in database %d. Using default level = %d.
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.
Error 8219 can occur if the table size is 0 (zero rows) or the number of pages for the table is 0 (zero). 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, contact Sybase Technical Support.
Refer to “Lock promotions” in the chapter “Monitoring Performance with sp_sysmon” in Performance and Tuning: Monitoring and Analyzing.
Have the information listed in “Reporting errors” when you call Sybase Technical Support, including the output of sp_configure (or a copy of the configuration file), sp_helpdb, sp_help on the table involved, and sp_spaceused on the table involved.
Versions earlier than 12.5.x