Global payroll COBOL process GPPDPRUN stuck in processing
This process use to take around 7 hours, but now its taking more than 15 hours and still running.
The query that keeps running is :
SELECT s.emplid, s.empl_rcd, j.effdt, j.effseq, j.hire_dt, j.termination_dt,
j.lst_asgn_start_dt
FROM ps_job j, ps_per_org_asgn a, ps_gp_pye_stat_wrk s
WHERE s.run_cntl_id = :1
AND s.oprid = :2
AND s.emplid BETWEEN AND :4
AND s.emplid = a.emplid
AND s.empl_rcd = a.empl_rcd
AND s.frst_job_seg_ind = 'Y'
AND a.emplid = j.emplid
AND a.org_instance_ern = j.empl_rcd
j.lst_asgn_start_dt
FROM ps_job j, ps_per_org_asgn a, ps_gp_pye_stat_wrk s
WHERE s.run_cntl_id = :1
AND s.oprid = :2
AND s.emplid BETWEEN AND :4
AND s.emplid = a.emplid
AND s.empl_rcd = a.empl_rcd
AND s.frst_job_seg_ind = 'Y'
AND a.emplid = j.emplid
AND a.org_instance_ern = j.empl_rcd
1