Symptom
After upgrading from any pre 16.0 version to 16.0, sysprocesses is showing processes with cmd = "COMPILING"
This can be seen from various places including sysprocesses, sp_w, sp_who and monProcess
1> sp_w
2> go
fid spid command execution_time physical_io blocked
------ ------ ------------------------------- -------------------- ----------- -------
0 29 COMPILING 32 0 0
(1 row affected)
(return status = 0)
1> sp_who "29"
2> go
fid spid status loginame origname hostname blk_spid dbname tempdbname cmd block_xloid threadpool
--- ---- ------- -------- -------- -------- -------- ------ ---------- --------- ----------- ----------------
0 29 running sa sa localhost 0 master tempdb COMPILING 0 syb_default_pool
(1 row affected)
(return status = 0)
Read more...
Environment
Adaptive Server Enterprise 16.0
Product
Keywords
sysprocesses, COMPILING , 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.