SAP Knowledge Base Article - Preview

2621283 - sp_who and queries against sysprocesses show processes with cmd = "COMPILING" - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

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 ONE Support launchpad (Login required).

Search for additional results

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