> -----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

Reply via email to