Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Jobs spinning but doing nothing

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Jobs spinning but doing nothing

    I have a strange problem that occurs every now and then on our system. We are running BPCS erp on OS/400 4.5. The programs are a mix of RPG and SQL. Sometimes when we encounter duplicate records, we will have jobs spin and never end until the dups are cleaned out of the file. However, sometimes duplicate records are not the problem. Jobs that usually take 5 seconds to run may run for 5 hours. Then, mysteriously, they will run quickly again for no apparent reason. Has anyone seen this before? Any ideas where to look for an answer here? I really dont have a good idea where to even start. It appears to be a database problem but what else besides duplicate records could cause such a thing? TIA for any insight Scott
Working...
X