× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




I know when I RSTOBJ physical and logical files from a save file to QTEMP,
the QDBSRVxx jobs kick off to rebuild access paths.
The next statement is CPYF with *ADD to QTEMP and blows with a CPF5090 -
Unique access path problems prevent updates... I understand this is
because the access paths are still being rebuilt and I have seen someone
else post about this with no "good" answer. I can see the 3 messages about
access paths rebuilt for the 3 logicals doing the DSPLOG and see some after
the CPYF's. The one blowing up took 34 seconds even though there was just
one record. The last part of the program resaves those files back to the
save file for recycling errors such as bad part numbers. I am trying to
debug this and try looking for locks. So, I RSTOBJ to QTEMP like the job
and I only see one access path rebuilt message for just one logical doing
the DSPLOG and it was lightning quick.
This has been happening sporadically but always first thing in the morning
even though it runs throughout the day. This happened two days in a row.
This makes it seem like rebuilding the access paths then resaving makes
things happy until the next day. It's almost like there is caching going
on. Monitoring and retrying should be easy. I would just like to stop the
long waiting if possible.
My main question is: Why would it rebuild 3 access paths for a long time
then after resaving and restoring, only rebuilding one quickly?

As far as options for delaying and retyring if anyone is interested, I have
the following which should work:
1. MONMSG(CPF2972) the CPYF's then DLYJOB(3) in a loop 20 times.
2. Write an RPG program before the CPYF's looping on QUSRMBRD and checking
the access path validity and state.
3. ALCOBJ *EXCL on the physical. Obviously, I don't know if this would
work or if there are locks because I cannot debug. If I knew this would
work, this would be #1.

Any thoughts?


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.