Long running F986110 query in R22
Dear Community,
We have been noticing these long running queries on our new R22 (9.2.7.1) install coming from almost all Enterprise servers (windows). This the message in the queue kernel logs.
Anyone know why would the SELECT on F986110 be runing so long. We have not seen any other query running longer.
And we have a really fast SQL Server 2019 server.
14368/1204 Sun Mar 19 05:05:05.135000 jdbodbc.c8989
doTimeOutQueryDiagnostics: The following SQL query took 2 seconds which is equal to or greater than QueryExecutionTimeThreshold (2 seconds) for E1User(JDE) with DBProxyUser(JDE).
14368/1204 Sun Mar 19 05:05:05.136000 jdbodbc.c9018
SELECT JCJOBQUE, JCJOBPTY, JCJOBSTS, JCENHV, JCUSER, JCPSWD, JCJOBTYPE, JCSBMDATE, JCSBMTIME, JCJOBNBR, JCEXEHOST, JCORGHOST, JCPROCESSID, JCACTDATE, JCACTTIME, JCFUNO, JCPRTQ, JCFNDFUF1, JCFNDFUF2 FROM JDE920.SVM920.F986110 WHERE ( JCJOBQUE = 'QBATCH' AND JCJOBSTS = 'W' ) ORDER BY JCJOBNBR ASC