This website uses cookies. By continuing to browse or login to this website, you consent to the use of cookies. Learn more.
OK
SatyaGannamraju
Lieutenant Commander
Lieutenant Commander
‎2020-09-27 06:04
243 views

OO execution queues and its impact.

Hi,

OO_EXECUTION_QUEUES is having some records with Assigned_Worker=EMPTY - is this an expected behavior?  Also what is the meaning of STATUS codes in the table?

Where Assigned_Worker column is having the central worker id, those are having 300+ records as assigned.  When I execute to identify for stale records with below queries on our central worker, mostly the count is 0 or some count appears for a while and when re-executed it goes 0 again.  Below are the queries

SELECT COUNT(*) FROM OO_EXECUTION_QUEUES q WHERE q.ASSIGNED_WORKER = 'CENTRAL SERVER 1' AND q.STATUS = 4 AND (NOT EXISTS (SELECT qq.MSG_SEQ_ID FROM OO_EXECUTION_QUEUES qq WHERE (qq.EXEC_STATE_ID = q.EXEC_STATE_ID) AND qq.MSG_SEQ_ID > q.MSG_SEQ_ID ))

Satya

 

Reply
Report Inappropriate Content
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.