SAP Knowledge Base Article - Preview

3107053 - sp_who shows system tasks are staying in a user database - SAP ASE

Symptom

  • sp_who may show that some system tasks such as "MEMORY TUNE" and "NETWORK HANDLER" are staying in a user database.
      1> sp_who
2> go
 fid spid status   loginame origname hostname             blk_spid dbname
         tempdbname cmd               block_xloid threadpool
 --- ---- -------- -------- -------- -------------------- -------- ------
         ---------- ----------------- ----------- ----------------
   0    1 sleeping NULL     NULL     NULL                        0 testdb
         testdb     MEMORY TUNE                 0 syb_default_pool
..........
   0   12 sleeping NULL     NULL     NULL                        0 testdb
         tempdb     NETWORK HANDLER             0 syb_default_pool
   0   13 sleeping NULL     NULL     NULL                        0 master
         tempdb     LICENSE HEARTBEAT           0 syb_default_pool
   0   17 running  sa       sa       testhost                    0 testdb
         tempdb     INSERT                      0 syb_default_pool

(13 rows affected)
(return status = 0)
1>


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.x
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sp_who, incorrect dbname, wrong dbname , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.