Error 8219



Message text

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:

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.

Additional information

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 in which this error is raised

Versions earlier than 12.5.x