David
Actually this isn't to hard, but will need a couple of different tools in conjunction together 1) you need to parse out the SMF records to a flat file, (Depending on which SMF record and which field you want (or all the fields) that is comma delimited. (you can do this very easily do this using File-AID MVS. In fact we have the XREF/copybooks for the SMF records (last time I checked from our hotline) 2)Then have a utility to read the SMF CSV to load into the DB2 tables. (and yes File-AID DB2 can do this) If you are a client of Compuware fell free in contacting your local hotline (north America 1-800-538-7822 outside north America please refer to frontline.compuware.com for the local hotline number) Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist IBM Certified Database Associate IBM Certified DB2 9 for z/OS Database Administration Certified Information Privacy Professional/Canada Certified Information Privacy Professional/Information Technology [email protected] Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888 The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. We make IT rock around the world ________________________________ "Service in every product..." Les renseignements contenus dans le présent message électronique sont confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). Il est strictement interdit de distribuer ou de copier ce message. Si vous avez reçu ce message par erreur, veuillez répondre par courriel à l'expéditeur et effacer ou détruire toutes les copies du présent message. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of David Logan Sent: Wednesday, December 17, 2008 7:31 AM To: [email protected] Subject: Is there a tool to put SMF data into DB/2? I was poking around in the manuals and saw some things about possibly putting the SMF data related to RACF into DB/2 tables, and it got me wondering. Is there a tool that will convert *all* SMF record types and put them into DB/2 tables? That would be awesome if there were. David Logan Manager of Product Development, Pitney Bowes Business Insight <http://centrus.com/> http://centrus.com W: (720) 564-3056 C: (303) 818-8222 ---------------------------------------------------------------------- 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
