I'd call in a PMR on it. Worse I'm concerned about record locks with normal
production starting.
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Maassel, John R.
Sent: Monday, October 17, 2016 7:32 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: reorg not finishing
There is a reorg job on our dev box (i 7.2) that's been running for a 5
days. It's been on the IDX- stage on one index for almost 4 days. This is a
rather large file, containing a billion records and 11 access paths. It's
stuck on #4.
It doesn't appear that the system is working on it. This is the only task
the machine had all weekend and it's still right where it was when I left on
Friday. CPU utilization for this job is 0.7% and overall CPU is 2-3%. I
checked disk stats and they're only 3% busy, so I don't see a bottleneck.
Unfortunately, it was submitted with "Allow Cancel = NO" so I don't think we
can stop it.
I reorganized it last month on 6.1 and it only took 3 days.
Is there a way we can make it hurry up? What should I check into?
________________________________
Notice from Bob Evans Farms: This e-mail message, including any attachments,
may contain confidential information that is intended only for the person or
entity to which it is addressed. Any unauthorized review, use, disclosure or
distribution is strictly prohibited. If you are not the intended recipient,
please contact the sender by reply e-mail and destroy all copies of the
original message and any attachments.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
