>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? >
The answer is "Big Blue (IBM)" has kinda done it on the mainframe. Back in a previous prior life working in a US Government agency, they replaced a simple Chargeback focused product with a DB2 based system and the answer was DPAM from IBM Sweden. It has evolved into what is today IBM Tivoli Decision Support" with all kinds of features for doing different things. Imagine SMF/SAS/MICS replaced by SMF/DB2/TDSS. So my little Chargeback system evolved into a big giant since it also took over the functions of Killer-MICS (System Performance) and my cheap, simple Chargeback system (MICS Chargeback failed 3 years prior and also 5 years prior). Then they had to buy the SQL reporting tools, write all the code, etc. So it can be done. Depending on what you want out of the SAS/MICS or DB2/TDSS, it takes resources. The startegy is interestng and sounds like a product which should be in the market place running on some $1K PC. Jim ---------------------------------------------------------------------- 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
