SAP Knowledge Base Article - Preview

2465247 - Process running 'alter database' blocked by other spid - SAP ASE

Symptom

  • Process running 'alter database' blocked by other process running 'dump database' or 'dump transaction'
  • Auto-expansion is enabled and appears to not have worked
  • Queries and outputs below show how to identify processes :

select spid, dbid, starttime, name from master.. syslogshold
go

spid    dbid   starttime                      name
------   ------   ----------------------------  -------------
 123         4  Apr 01 2017  2:00PM  $dmpxact

select spid, blocked as 'Blocked By', status, cmd, tran_name from master..sysprocesses
where blocked != 0 or cmd like "DUMP%"
go

spid   Blocked By  status         cmd                                 tran_name
------  ---------------  --------------  --------------------------------  ----------
 123                  0   sleeping     DUMP TRANSACTION  $dmpxact
 456              123   lock sleep  ALTER DATABASE         NULL


Read more...

Environment

SAP Adaptive Server Enterprise (ASE). Not version specific.

Product

SAP NetWeaver 7.4

Keywords

'alter database stuck' , alter database , 'alter database hang' , 'expand database' , 'increase database' , 'expand database stuck' , 'increase database hang' , 'alter database blocked' , 'sp_dbxt_extend_db' , auto expand , auto expansion, "Error: 1105", commands hanging , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.