3524893 - Processes with the "alarm sleep" status prevent ASE shutdown - SAP ASE

When ASE's shutdown process is executed, if there is a process with the status of "alarm sleep", it will wait for its completion.

1> shutdown
2> go
SHUTDOWN is waiting for 2 process(es) to complete.
SHUTDOWN is waiting for 2 process(es) to complete.

1> sp_w
2> go
 fid    spid   command                            execution_time       physical_io blocked
 ------ ------ ---------------------------------- -------------------- ----------- -------
      0     29 WAITFOR                                           27398           0       0
      0     30 WAITFOR                                           30146           0       0

1> sp_who '29'
2> go
 fid spid status      loginame origname hostname    blk_spid dbname tempdbname cmd     block_xloid threadpool
 --- ---- ----------- -------- -------- ----------- -------- ------ ---------- ------- ----------- ----------------
   0   29 alarm sleep sa       sa       testase        0 master tempdb     WAITFOR           0 syb_default_pool

SAP Adaptive Server Enterprise (ASE)

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem