Nigel,

are there any logicals over any of these files on the 4way that are not on
the 12 way?

also, check the attributes of both old and new join log (dspfd?) to see if
how the access paths are maintained is the same.


---original message---
Hi,  I have a situation where a particular part of an overnight process is
taking much longer to run on a more powerful system, and wondered if anyone
might offer any suggestions as to why this may happen.  The remaining parts
of the process are running more or less the same length of time, or
slightly
better.

For one program that is called within the process, the elapsed run time is
1.5hrs on System A whereas it is 8.0 hrs on System B.

In both cases the job is run overnight when there is not much other
activity
on the system. The job has been run several times with the same results, on
each system.

System A is a 4-way system, system B is a 12-way system. Both are on the
same
version of OS/400 with the same CUM PTF's applied. The subsystem
descriptions
should be similar and both run in the base pool.

I am waiting to hear if SMP is installed on either/both (DB2 Symmetric
multiprocessing), but since it is an RPGLE program, I don't think this will
make a difference anyway.

The program is performing input-primary processing on a join logical based
on
three physical files. There is one format in the join logical. There are 11
million records in each of two of the joined files, and around 100,000 in
the
other. The data has been restored from one system to the other so it is
identical.

Any ideas ??

Thanks in advance!

Nigel




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-2022 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.