SAP Knowledge Base Article - Preview

2475104 - DUMP TRANSACTION is hung with status "sleeping" - SAP ASE

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.