If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
As I reread your question I wonder if I misunderstood. If you are trying to identify files that have multiple members, I would again use the DSPFD command, but to an outfile.
Then run a query and select on the field ATNOMB (Number of members) greater than 1.
That command would create an output file with one row for each physical file in library MYLIB. You could replace “mylib” with “*allusr” if you wanted to list every physical file in every user library. (That basically means “every non-IBM library”.)
You might then use SQL:
SELECT PHLIB, PHFILE, PHNOMB FROM QTEMP/PFMBRCNT WHERE PHNOMB > 1
That’s probably the easiest way to list every physical file that has a member count greater than ’1′. There are many variations.
Rajeshece,
As I reread your question I wonder if I misunderstood. If you are trying to identify files that have multiple members, I would again use the DSPFD command, but to an outfile.
Then run a query and select on the field ATNOMB (Number of members) greater than 1.
Hope this helps,
Bill Poulin
Also, do you want to:
The details of the question might be useful.
Tom
I wanted to find all the files which have multi members
Rajeshece,
Then my 2nd answer should work for you.
Let us know if you need more detail.
Thanks,
Bill Poulin
Bill’s answer is essentially correct. Example:
DSPFD FILE( mylib/*ALL ) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE( QTEMP/PFMBRCNT )That command would create an output file with one row for each physical file in library MYLIB. You could replace “mylib” with “*allusr” if you wanted to list every physical file in every user library. (That basically means “every non-IBM library”.)
You might then use SQL:
That’s probably the easiest way to list every physical file that has a member count greater than ’1′. There are many variations.
Tom
you can do the DSPFD to an *OutFile (output file) and run query over it.
then look for multiple members in a report format you design, sorted however you want it, as well as include/exclude records based on selection.
-sarge