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.
SAP Knowledge Base Article - Preview