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 for Me (Login required).

Search for additional results

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