SAP Knowledge Base Article - Preview

2156962 - When should kill spid with force be used? - SAP ASE

Symptom

  • Would like clarification on the "kill spid # with force" option
  • ASE prints 'kill with force' message in the log: 

Process id 123 killed with force by Hostname OS_serrver_name, Host process id 456.

  • Usually followed by a stack trace in the ASE log, which may include functions related to the 'kill':

terminate_process
cold_terminate_process
ucbacktrace
upforcekill
cold_upsleepgeneric
Status: (0x00010000 (P_USERPROC), 0x00008000 (P_BACKOUT), 0x00000002 (P_KILLYOURSELF))

  • Followed by further functions that can help indicate what the spid was doing at the time of the kill


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP 121 and above
  • SAP Adaptive Server Enterprise (ASE) 16.x

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

terminate task, zombie process, processes holding resources, kill command failed , kill with force , KBA , sp_who , zombie process , phantom locks , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.