|
On 08-May-2015 07:55 -0500, Paul Fenstermacher wrote:
Here's a snippet of info I got from IBM, the QADBIFLD file on this system has 251 million records: At 30% the code kicked off a RSTOBJ of the complex MRI objects from the /Q5770SS1/Q7200024/Q00/Q90 file. At 90% is the code that does the RSTOBJ of the complex MRM file from the /Q5770SS1/Q72000M_/Q00/Q90 file. The 20 minutes for the complex MRM doesn't appear too bad, but I wouldn't think it would take 5 hours to do the complex MRI. That does appear to be a lot of records (qadbifld is a cross reference file that contains information about every field in every file on the system) and if there is any underlying copying taking place from the old qadbifld to the new qadbifld during the restore, then I would suspect that it could take some time.
And if the database effected conversion of any of the System Database Cross Reference files (QADB* in QSYS), then there would be a record of that activity remaining in the spooled SCPF joblog produced for the IPL of the install\upgrade; the messaging is not purged. And if the delay was [additionally] for some other work, then there may be record of whatever other activity took place over that time as well; just as joblogs might do normally, if the program activity does not clear their program message queues such that the messages are logged according to the logging level [which for SCPF I believe is always LOG(4 0 *SECLVL)].
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
