> -----Original Message-----
> From: IBM Mainframe Discussion List On Behalf Of Rick Fochtman
>
> I'm working on reporting tools for RACF and could use a
> little help in determining sizes. I need to work with
> in-storage tables, or possibly linked lists, to associate
> various items of data. Could any of you who use RACF please
> respond, off-list, with counts of the various profile types
> in your RACF databases? I'm primarily concerned with counts
> of user, group, and dataset profiles at this time. The object
> in this first set is a spread-sheet-like report of dataset
> profiles with their access lists.
> [ snip ]
For those interested in responding, here's a quick'n'dirty way to get
those counts:
//SORT00 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTDIAG DD DUMMY
//SORTIN DD DISP=SHR,DSN=unloaded.racf.database.dsname
//R100 DD DUMMY
//R200 DD DUMMY
//R400 DD DUMMY
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FNAMES=R100,
INCLUDE=(05,04,CH,EQ,C'0100')
OUTFIL FNAMES=R200,
INCLUDE=(05,04,CH,EQ,C'0200')
OUTFIL FNAMES=R400,
INCLUDE=(05,04,CH,EQ,C'0400')
/*
The counts will show in the ICE227I messages in //SYSOUT.
R100 is GROUP profiles, R200 is USER profiles and R400 is DATASET
profiles. The same can be done with the other record types in the RACF
unload.
-jc-
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html