> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[email protected]] On Behalf Of Michael Wickman > Sent: Thursday, August 06, 2009 11:45 AM > To: [email protected] > Subject: Loading SMF data into a DB2 database. > > Does anyone try to load SMF records into a database (DB2) for > performance and capacity usage data mining? Just trying from > keep from > re-typing all the DB2 definitions if somebody has already done it or > have any suggestions along that line. Thanks. > > > Mike Wickman
I think most people use SAS and MXG or MICS for this type of thing. I don't know the legality of doing it, but it might be "interesting" to some to see if there is a way to somehow use the MXG or MICS source code to create DB2 DDL to define the DB2 tables and perhaps to create programs in a different language to load that data into the resultant tables. Of course, this could very well be considered a copyright violation as it might be considered a "translation". Translating (or transliterating?) a literary work from one language to another requires the consent of the copyright holder. I'd almost bet the same applies to transliterating MXG into a COBOL / DB2 "work alike". Luckily for me, I can prove that I don't have access to DB2 (or other RDMS), so nobody should come looking. In any case, we use MXG and SAS on a Windows PC to do this (fully licensed, of course!). -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell [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 ---------------------------------------------------------------------- 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
