Dave, A couple of ideas spring to mind :
(1) Isn't there a documented way to upload the RACF database into DB2? If so - maybe a bit of SQL can accomplish what you need (2) RACROUTE REQUEST=EXTRACT,TYPE=EXTRACTN calls in an assembler program - not too bad as the USER class is just a discrete profile. [plug] If you are an MXI G2 customer you can achieve this with the following command : RL CLASS(USER) DETAIL(Y) REVOKED(NO) TSOPROC(>=A) [/plug] Rob Scott Rocket Software, Inc 275 Grove Street Newton, MA 02466 617-614-2305 [EMAIL PROTECTED] http://www.rs.com/portfolio/mxi/ -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dave Cartwright Sent: 16 May 2006 10:22 To: [email protected] Subject: Valid TSO Users I would like to report on those Users who are defined to RACF, who have a TSO segment and who are not revoked. Unfortunately our RACF DB contains many revoked Users and many Users without a TSO segment (IMS Users). If I unload the Database there are different record types for Userid and TSO segment, so it is not easy to process. I would accept a report of Users with TSO segments who ARE revoked. Anybody know how to do it? Dave ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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
