Use the DSPDBR and DSPFD commands on each physical and logical file of concern. Record the "Creation Date", the "Last Used Date", the "Days Used Count" , the "Data Space Activity Statistics" and the "Access
Path Activity Statistics" for each file.

All "Activity Statistics" reflect file usage since the last system IPL. This information is helpful in identifying unused indexes, but you must take into consideration when your last system IPL occurred.

If you find files with no last used date, no days used count and no activity statistics - there is a good chance that this is an unused index. You may find files with some usage but no recent activity. It is important to note that some operating system save and restore operations may reset an objects last used and days used attributes.