2155463 - How to clear long-running open transaction held for spid 0 - SAP ASE

• How to clear long-running open transaction held for spid 0
• ASE outputs from syslogshold, sp_transaction and sp_lock show long-running open transaction holding lock(s) for spid 0

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

 dbid    spid   xactid               starttime               name                                                                
 ------ ------  -------------------- ----------------------- -------------------------------------------------------------------------
      6      0  0x000e4016000c       Jan 20 2015 3:02PM      000007D6_ejsNdzoMd3sQnP4PcjcUcj8OdlYMnP1vrmBDnRlMr6Zxp5hOomhBsOQNej


sp_transactions
go

 xactkey                        type        coordinator starttime            state             connection dbid   spid   loid        failover                   srvname                        namelen xactname                                                                                                                                                                                                                                              
 ------------------------------ ----------- ----------- -------------------- ----------------- ---------- ------ ------ ----------- -------------------------- ------------------------------ ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 0x000e4016000c00004267be370006 External    XA          Jan 20 2015  3:02PM  Prepared-Detached Detached        6      0        8053 Resident Tx                NULL                               182 000007D6_ejsNdzoMd3sQnP4PcjcUcj8OdlYMnP1vrmBDnRlMr6Zxp5hOomhBsOQNejAJd5ZvnRY0000000000000000003_bjARdzoPc3sMdlYNcP4Ucz0Rdj1vnRZv000000000000000000000000000000000000000000000000000003                                                                

sp_lock

 id          dbid   page       type   spid   class                          fid    context row    loid        partitionid nodeid
----------- ------ ---------- ------ ------ ------------------------------ ------ ------- ------ ----------- ----------- ------
  467842048      6          0      3      0 Non Cursor Lock                     0       0      0       39571           0   NULL
 1299636792      6          0      3      0 Non Cursor Lock                     0       0      0       39571           0   NULL

• SAP Adaptive Server Enterprise (ASE). All versions.
• Distributed Transaction Management (DTM) is ON : 'enable DTM' set to 1.

dbcc complete_xact, DTM , heuristic completion , distrubuted transaction , CICS , XA , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To