> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Gary Green > Sent: Wednesday, April 25, 2007 12:43 PM > To: [email protected] > Subject: Re: Not mainframe but the latest in the TJMax fisaco > > > Always looking at the flip-side huh Rick...? <GGG> > > As an aside... > > This particular situation makes me wonder... How large can > some of the "data stores" on the "other" platforms grow to > and how easy is it to process those records? > > Yesterday I needed to sort about 46 million SMF records, the > same number of customer records that were compromised at TJX, > but my job ran out of sort-work space. Nothing unusual about > that except that it took less than 40 minutes of wall-clock > time to run out of that space, on a Z890-2086-A04. I told my > S.O. about it last night on the way home and she laughed at > how long it would take on their "other platforms". Laughed, > as in it would still be running at the end of the week. > > This is NOT to start another bashing... Just a situation of > inquiring minds want to know.
I don't think that "other platforms" bother to do many sorts. Most of their data reside in databases such as MS SQL, MySQL, Oracle, DB/2, etc. If they need something sorted, they depend on the database system to do it. I think this just basically sorts the keys with a pointer to the actual data and not the entire "record". And most DBAs will create a sorted index, if the request is not "ad hoc". -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. ---------------------------------------------------------------------- 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
