CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

SVM910 Query Makes JDE Client Slow Response

edited Sep 25, 2020 2:30AM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered

Hi Experts,

Is it true?
When I try to 'select' query SVM910 below :

select distinct JCUSER,

    substr(JCSBMDATE,2,2)"YY",

    substr(lpad("JCSBMTIME",6,0),0,2)||':'||

    substr(lpad("JCSBMTIME",6,0),3,2)"Job Time",

    substr(lpad("JCACTTIME",6,0),0,2)||':'||

    substr(lpad("JCACTTIME",6,0),3,2)"Act Time",

    substr(lpad("JCSBMTIME",6,0),0,2)-substr(lpad("JCACTTIME",6,0),0,2)"Diff(m)",

    JCJOBSTS"Status",JCENHV"Env",

    substr(JCFNDFUF2,0,(instr(JCFNDFUF2,'_')-1))"Report"

from svm910.f986110

where jcuser like '%SCHEDUL%'

    and JCSBMDATE = 120251 -- 07/09/2020

order by substr(JCSBMDATE,2,2) desc, substr(lpad("JCSBMTIME",6,0),0,2)||':'||

    substr(lpad("JCSBMTIME",6,0),3,2) desc

It make the JDE client slow response. 3 times I tried and it happen, so users complain to me.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center