I am running the /VIRSA/ZVFATBAK job every hour and 1-2 times a day the job will literally sit at the point it is performing the SELECT on CDHDR. By "sit" I mean that it shows up in the SM50 screen as a process (BGD) and calculates workprocess time. This is no calculation of DB time, CPU time. In performing all trace activities.....there is nothing happening. It is like is zombies out.
Once the job sits for more than 2-3 hours, I have to cancel it.
I have reviewed a lot of information, but nothing that points me to an answer for this particular issue with this job.
If the process was calculating something, then I might understand what the issue is.
If anyone has any thoughts, I would greatly appreciate them.
Thank you.