10
%d task(s) are sleeping waiting for space to become available in the log segment for database %.*s.
This message is written to the Adaptive Server error log by the checkpoint process when the last-chance threshold has been exceeded, and the specified number of processes have been put to sleep.
Ensure that the appropriate last-chance threshold action is executed to create free space in the log. If the procedure did not run for any reason, manually create free space in the transaction log with a dump transaction command and check on the cause of the failure by referring to the documentation in this manual.
Refer to the chapter “Managing Free Space with Thresholds” in the System Administration Guide: Volume 2 for information about last-chance thresholds.
All versions
