2343551 - Unable to kill a spd in ASE when using tempdb as an in-memory database - ASE

• Tempdb is created as an In-Memory database
• sp_who on hung spid shows tempdb is being used

sp_who '2107'
go

fid spid status loginame origname hostname blk_spid dbname tempdbname cmd block_xloid threadpool

------ -------- ---------------- -------------------- -------------------- ------------------------------------------------------------ -----

0 2107 sleeping <login name> <origname> <hostname> 0 tempdb4 tempdb4 CREATE TABLE 0 clp_oltp_pool

• kill <spid> with force on hung spid does not kill the spid
• Only way to clear the hung spid is to recycle ASE

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

IMDB , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed