I suspect you’re thinking the “alternate” name is a logical file? Use the DSPDBR command (display data base relationships)
If “alternate name” is a LF, then DSPDBR won’t help.
For a normal LF, use:<pre>
DSPFD mylib/altname TYPE(*ACCPTH)</pre>
…where “altname” is the LF name and “mylib” is the library containing the LF. The name of the PF that is accessed by the LF will be at the end of the displayed information.
However, if “alternate name” refers to a SQL ALIAS, then perhaps use:<pre>
SELECT BASE_TABLE_NAME FROM SYSTABLES WHERE TABLE_NAME = ‘<altname>’</pre>
…where “<altname>” is the ALIAS.
Or perhaps “alternate name” means something else? If so, please describe how the name is used. We can probably figure it out from there.