The 88 Million records
– are they current?
– Needed for periodic processing?
– Does a purge process exist?
150 Logical Files — is it the PF with 88 million records???
– when considering the effect on updates/writes to the system
discount any with Maintenance *DELAY or *ReBUILD
– are updates/writes to this file unacceptably slow?
– remember some of the logicals may be accessed by Queries
I think you should tackle ways to reduce the number of logicals before you consider more radical changes.
2005 may seem like ancient history but on one system that I worked on, I had to be able to provide customer statements back to “the dawn of time” (the word time should be reverberating). That didn’t mean that they had to stay in the original files but a whole bunch of issues come out of having them in different files. So check out the retention rules.
Logicals are often overused and, in your case, when you do go to purge those old records, you can expect really poor performance because of all the index updates.