Yeah... Makes perfect sense. I did not think about it like that. Thanks.
On Wed Apr 25 12:55 , 'McKown, John' <[EMAIL PROTECTED]> sent: >> -----Original Message----- >> From: IBM Mainframe Discussion List >> [EMAIL PROTECTED]','','','')">[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...? >> >> 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 ---------------------------------------------------------------------- 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
