SAP Knowledge Base Article - Preview

3678625 - Server hung during 'dump database' and processes stuck in runnable state SAP ASE

Symptom

  • Processes are hanging, being in a runnable state while waiting for the read lock held by an Dump database to be released.
  • Hanging dump database with several spids that are hanging and cannot be killed.
  • Process may be hanging in latchsleep.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.1

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.1 ; SAP NetWeaver 7.5

Keywords


CR 831417, ASE processes hanging, runnable state issue, dump database stuck, latchsleep process, read lock issue, sp_setpsexe command, sp_clearpsexe command, database

  • disk
  • map lock, hanging spids, database performance issue

, KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.