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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.