I actually use the IRRADU00 output, generated by IFASMFDP during our SMF processing run, and process it. So much easier. And it is "documented" in SYS1.SAMPLIB(IRRADULD). OK, it contains the DB2 load commands to load the data into a DB2 database. I don't have DB2. But I do have Perl. So I wrote a Perl program which reads the IRRADULD input in order to write another Perl program which parses up the records for me and loads them into a PostgreSQL database on Linux. SYS1.SAMPLIB(IRRADUTB) contains the DB2 commands to create the database. A fairly simple edit makes them compatible with the PostgreSQL psql command in order to define the database / tables to it.
-- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * [email protected] * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[email protected]] On Behalf Of Tony Harminc > Sent: Thursday, June 28, 2012 1:34 PM > To: [email protected] > Subject: Re: SMF Type 80 relocation section detail mapping macro > > On 28 June 2012 06:44, Donald Likens <[email protected]> wrote: > > I've been looking through the books but have not found a > detail mapping macro for the RACF SMF type 80 relocation > sections. I'll keep looking but in the mean time, does anyone > know what and where they are? > > > > Note: I have the standard mapping macro no problem. > > Regretably, despite requests over many years, RACF has chosen not to > provide this information in machine-readable form. The extremely > inconvenient doc in the Macros and Interfaces book is all there is. > Thus everyone who needs to use this information must write and > maintain their own macros and processing routines. > > Tony H. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
