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