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 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
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.