The F0911 is an overly indexed table. Has anyone here tired to determine which indexes are actually being used and deleting the unused ones? Just Curious?
I am a big supporter of applying proper DBA practices to JDE. I don't see it as different from any other system. If indexes are not in use and you have the monitoring data to prove it then I say remove the indexes. It will make a different to transaction performance, no doubt about it.
Justin, the dspfd command on OS400 gives a last used date on the logical. If that is old, then there'd be no reason not to drop the logical, right?
Further, would it be a useful idea to run a query over the system catalog to identify all logicals in the PD data library with a last used date older than some date and delete?
Sure, I think that using the dspfd command or QUSROBJD api to detect unused logicals is a good idea with one reservation. An index might only serve a specific piece of periodic processing -- e.g. Month End, Year End, Quarterly reports, etc. I would take a close look at logicals with older last used dates and see if they are supporting periodic processes before deciding to drop them. If it still made sense to drop them I would recreate those logicals to cover the periodic processing and then subsequently drop them after the processing completed.
This link on the IBM site gives some more specifics on the subject of "Detecting Unused Objects on the System".