Symptom
- A process (spid) executiing a DUMP TRANSACTION command with a status of "sleeping" is shown in the sysprocesses table:
spid cmd blocked hostname hostprocess login status
----- ----- ---------- ------------- ---------------- ------- --------
157 DUMP TRANSACTION 0 <host> 9920 <login> sleeping
- "kill <spid>" does not kill the spid
- "kill <spid> with force" does remove the spid from the sp_who output but the process remains in sysprocesses.
- The ALTER DATABASE command to expand the database is blocked by the DUMP TRANSACTION process.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7
Keywords
hang, freeze , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.