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

Search for additional results

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