SAP Knowledge Base Article - Preview

2653109 - Mismatch between sysengines and monEngine - SAP ASE

Symptom

sysengines shows correct info on status and osprocid while monEngine shows 0 on Status and OSPID:
    
1> select * from sysengines
2> go
 engine osprocid    osprocname                 status       affinitied  cur_kpid   last_kpid   idle_1 idle_2 idle_3 idle_4 starttime          nodeid
 ------ ----------- -------------------------------- ------------ ----------- ----------- ----------- ------ ------ ------ ------ ------------------- ------
      0       63078                                  online                 2           0                 0      0      0      0      0 May 16 2018 11:47AM   NULL
      1       63079                                  online                 2    14221421           0      0      0      0      0 May 16 2018 11:47AM   NULL
      2       63080                                  online                 1           0                 0      0      0      0      0 May 16 2018 11:47AM   NULL
      3       63081                                  online                 0           0                 0      0      0      0      0 May 16 2018 11:47AM   NULL
      4       63082                                  online                 0           0                 0      0      0      0      0 May 16 2018 11:47AM   NULL
   
(5 rows affected)
   
1> select * from monEngine
2> go
 EngineNumber ThreadID    InstanceID CurrentKPID PreviousKPID CPUTime     SystemCPUTime UserCPUTime IOCPUTime   IdleCPUTime Yields      Connections DiskIOChecks DiskIOPolled DiskIOCompleted MaxOutstandingIOs ProcessesAffinitied ContextSwitches HkgcMaxQSize HkgcPendingItems HkgcHWMItems HkgcOverflows HkgcPendingItemsDcomp
HkgcOverflowsDcomp Status               StartTime           StopTime            AffinitiedToCPU OSPID
 ------------ ----------- ---------- ----------- ------------ ----------- ------------- ----------- ----------- ----------- ----------- ----------- ------------ ------------ --------------- ----------------- ------------------- --------------- ------------ ---------------- ------------ ------------- --------------------- ------------------ -------------------- ------------------- ------------------- --------------- -----------
            0           2          0           0            0     1804896            95         674        5009     1799116    63624776           1   1325629565  
1970247533        40685561               114                   2         6158846        11150                0            0             0                    
0                 
0                      Jan  1 1900 12:00AM Jan  1 1900 12:00AM               0           0
  
            1           3          0    14221421            0     1804896            69         637        5028     1799160    59294084           1            0           
0               0               131                   2         5647914        11150                0           66             0                    
0                 0                      Jan  1 1900 12:00AM Jan  1 1900 12:00AM               0           0
       
            2           4          0           0            0     1804896            68         568        5039     1799219    51480597           0            0           
0               0               139                   1         4451594        11150                0           42             0                    
0                 0                      Jan  1 1900 12:00AM Jan  1 1900 12:00AM               0           0
         
           3           5          0           0            0     1804896            79         580        5005     1799230    48686404           0            0           
0               0               122                   0         4614115        11150                0            2             0                    
0                0                      Jan  1 1900 12:00AM Jan  1 1900 12:00AM               0           0
        
          4           6          0           0            0     1804896            87         756        4973     1799078    48300779           0            0           
0               0               142                   0         4694585        11150                0            1             0                    

0                                    Jan  1 1900 12:00AM Jan  1 1900 12:00AM               0           0
   
(5 rows affected)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sysengines, monEngine, status, osprocid, OSPID, 0, mismatch  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.