Hi guys, I have a job running a SQL RPG, it usually takes about a minute to run but sometimes it starts dropping performance and runs for 30m or so:
Exec Sql
Declare C1 Cursor for
SELECT DISTINCT ORCO48,
ORSO48,ORCN48,ORDS48,cono48,ordn48,A.catn55,B.orlv 55,A.ordl55,A.locd5
a.qtor55, a.qtal55,a.qtos55,a.dtdr55
FROM NOEP048 inner join cuscodes on cono20=orco48 and
cusn20=orcn48 inner join cusnames on cono05=orco48 and
cusn05=orcn48 inner join ordlnord A on A.cono55=cono48 and
A.ordn55=ordn48
inner join OEP40E C on C.cono40=orco48 and C.ordn40=ORSO48
join ordlnord B on B.cono55=orco48 and
B.ordn55=ORSO48 and B.ordl55= A.ordl55 WHERE cono48=:L#CONO
and A.qtal55>0 and rsts05='' and b.ortp55 <>:@Ortp#
and C.DPTN40='A' and a.Cusn55 = :@Cusn ;
It stalls in the QDBGETMQO procedure, do you have any idea on how to improve the performance?
thanks
Nuno
Exec Sql
Declare C1 Cursor for
SELECT DISTINCT ORCO48,
ORSO48,ORCN48,ORDS48,cono48,ordn48,A.catn55,B.orlv 55,A.ordl55,A.locd5
a.qtor55, a.qtal55,a.qtos55,a.dtdr55
FROM NOEP048 inner join cuscodes on cono20=orco48 and
cusn20=orcn48 inner join cusnames on cono05=orco48 and
cusn05=orcn48 inner join ordlnord A on A.cono55=cono48 and
A.ordn55=ordn48
inner join OEP40E C on C.cono40=orco48 and C.ordn40=ORSO48
join ordlnord B on B.cono55=orco48 and
B.ordn55=ORSO48 and B.ordl55= A.ordl55 WHERE cono48=:L#CONO
and A.qtal55>0 and rsts05='' and b.ortp55 <>:@Ortp#
and C.DPTN40='A' and a.Cusn55 = :@Cusn ;
It stalls in the QDBGETMQO procedure, do you have any idea on how to improve the performance?
thanks
Nuno
Comment