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.
SAP Knowledge Base Article - Preview