Hi John, Have you read the archives of MXG-L at Barry's site http://www.mxg.com/ ? There is some good discussion and tips in the archives. A number of folks really like processing with MXG and SAS on a PC and have been able to do so easily enough. One search that worked pretty well. I don't know that you would have any use for a relational database on the PC as part of this. Just input the raw SMF data into SAS data sets and report from those.
http://peach.ease.lsoft.com/scripts/wa.exe?S2=MXG-L&q=PC+&s=PC&f=&a=&b= Thanks, Sam ----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of McKown, John Sent: Tuesday, March 06, 2007 10:49 AM To: [email protected] Subject: SMF to SQL database? There is a good chance that we may stop using SAS on z/OS. At present, only one mission-critical application uses it and we are looking at replacing that. Our other main use is MXG. I know that many have run MXG and SAS on a PC platform for cost savings. What I am wondering, not being an MXG person, is if anybody has tried to load SMF data into an SQL database? In my particular case, this would likely require reformatting the SMF data into something that could be ftp'ed to a Linux box and then loaded into a PostgreSQL database. I'm more interested in the table definations than anything else. And what ya'll thing of this, given that using MXG and SAS on the z/OS system would be simplier. Am I going totally off track even considering this? -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology ==================== This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. ---------------------------------------------------------------------- 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
