This report does a join on two specific PFs - simple report: join
the files, then print the records where the price in one doesn't
match the other. It's been running multiple times a day, every day,
But now after the DASD issue, the job runs, but isn't doing anything
I can see. It shows as active on WRKACTJOB, but no activity in the
file I/O, call stack, or job log - it just sits there with no
I thought I had it tracked down to a damaged join LF. I wasn't able
to pull up this LF using DBU - just got a continual loading message,
but could pull up each of its base PFs. So I recreated the join LF.
Just now I've tried recreating this report with SQL in the iSeries
Navigator Run SQL Scripts. Same thing - it's just sitting and
spinning. Again, this isn't a fancy report and should only take a
couple of minutes to run on our system with the data we have.
Any ideas on what's going on here? Is there an index that's been
I should note that as part of recovering space yesterday, I did a
RCLSTG and an IPL. Now not sure if that was a help or a hindrance.
Thanks for any input,