Re: Tech Tip du Jour: Fragmenting (at all)

Obnoxio The Clown wrote: > I seem not to have sent this out at all. Must have been drunk again. > Advert: > http://obotheclown.blogspot.com/2008/07/tech-tip-du-jour-fragmenting-tables-at.html > > Delivery: "I'll post some ruminations on actual fragmentation strategies in the future." I was thinking of reporting this fraud to the Intertubes police but I'm fascinated to find out if this incipient monetisation of a comedy character ultimately leads to some sort of Ronald McInformix chimera. ;-) -- RGB I remember when OTC was funny. Sigh.

RedGrittyBrick said: > Obnoxio The Clown wrote: >> I seem not to have sent this out at all. Must have been drunk again. >> > > Advert: > >> http://obotheclown.blogspot.com/2008/07/tech-tip-du-jour-fragmenting-tables-at.html >> >> > > Delivery: > > "I'll post some ruminations on actual fragmentation strategies in the > future." > > > I was thinking of reporting this fraud to the Intertubes police but I'm > fascinated to find out if this incipient monetisation of a comedy > character ultimately leads to some sort of Ronald McInformix chimera. > > ;-) I think you've glossed over the salient point, slightly: Informix cannot be made aware of operating system-level data distribution. If you want to use things like fragment elimination, PDQ, etc., then you have to use Informix's fragmentation. (You can, of course, use this on top of RAID / SAN / whatever.) But if you just use the storage subsystem to partition or fragment the data, then as far as Informix is concerned, it's all in one big pot. > RGB > I remember when OTC was funny. Sigh. At least I was once. :op -- Bye now, Obnoxio http://obotheclown.blogspot.com/

Obnoxio The Clown wrote: > RedGrittyBrick said: >> Obnoxio The Clown wrote: >>> I seem not to have sent this out at all. Must have been drunk again. >>> >> Advert: >> >>> http://obotheclown.blogspot.com/2008/07/tech-tip-du-jour-fragmenting-tables-at.html >>> >>> >> Delivery: >> >> "I'll post some ruminations on actual fragmentation strategies in the >> future." >> >> >> I was thinking of reporting this fraud to the Intertubes police but I'm >> fascinated to find out if this incipient monetisation of a comedy >> character ultimately leads to some sort of Ronald McInformix chimera. >> >> ;-) > > I think you've glossed over the salient point, slightly: > > Informix cannot be made aware of operating system-level data distribution. > If you want to use things like fragment elimination, PDQ, etc., then you > have to use Informix's fragmentation. (You can, of course, use this on top > of RAID / SAN / whatever.) But if you just use the storage subsystem to > partition or fragment the data, then as far as Informix is concerned, it's > all in one big pot. > >> RGB >> I remember when OTC was funny. Sigh. > > At least I was once. :op In the Oracle world the phrase heard most often is SAME: Stripe And Mirror Everything. And the discussion is often about when to use 64K stripes versus 1M stripes and similar issues. Nowhere in what you wrote do you discuss striping. Any thoughts that are written using other than the common vernacular? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond)

DA Morgan wrote: > Obnoxio The Clown wrote: >> RedGrittyBrick said: >>> Obnoxio The Clown wrote: >>>> I seem not to have sent this out at all. Must have been drunk again. >>>> >>> Advert: >>> >>>> http://obotheclown.blogspot.com/2008/07/tech-tip-du-jour-fragmenting-tables-at.html >>>> >>>> >>>> >>> Delivery: >>> >>> "I'll post some ruminations on actual fragmentation strategies in the >>> future." >>> >>> >>> I was thinking of reporting this fraud to the Intertubes police but I'm >>> fascinated to find out if this incipient monetisation of a comedy >>> character ultimately leads to some sort of Ronald McInformix chimera. >>> >>> ;-) >> >> I think you've glossed over the salient point, slightly: >> >> Informix cannot be made aware of operating system-level data >> distribution. >> If you want to use things like fragment elimination, PDQ, etc., then you >> have to use Informix's fragmentation. (You can, of course, use this on >> top >> of RAID / SAN / whatever.) But if you just use the storage subsystem to >> partition or fragment the data, then as far as Informix is concerned, >> it's >> all in one big pot. >> >>> RGB >>> I remember when OTC was funny. Sigh. >> >> At least I was once. :op > > In the Oracle world the phrase heard most often is SAME: Stripe > And Mirror Everything. And the discussion is often about when > to use 64K stripes versus 1M stripes and similar issues. > > Nowhere in what you wrote do you discuss striping. Any thoughts > that are written using other than the common vernacular? I think Obnoxio the Lovely was specifically referring to Fragmentation within Informix, even putting in a little caveat for us lesser sized lovelies *(You can, of course, use this on top of RAID / SAN / whatever.)* Another topic would be "How to not use RAID 5"

DA Morgan said: > In the Oracle world the phrase heard most often is SAME: Stripe > And Mirror Everything. And the discussion is often about when > to use 64K stripes versus 1M stripes and similar issues. > > Nowhere in what you wrote do you discuss striping. Any thoughts > that are written using other than the common vernacular? I haven't spoken about RAID and striping at all. To be honest, stripe sizing doesn't seem to be as big an issue for IDS as it is for Orrible. And the decisions about stripe sizing seem to have been made everywhere already. But the one cool thing about your comment was that it led to me finding this: http://members.iinet.net.au/~nsouto/photos/moah.jpg 'Outspoken, opinionated, not afraid to stir the pot or think outside the square, loves a bbq and a late arvo chat. In summary: just another Oracle DBA. Or as Albert Camus would say: "Don't walk in front of me, I may not follow. Don't walk behind me, I may not lead. Just walk beside me and be my friend."' What a pretentious cunt! I wonder if you have one too? :o> -- Bye now, Obnoxio http://obotheclown.blogspot.com/

Massive respec', Aaaiiiii! http://farm3.static.flickr.com/2261/2593345174_9a3411059d_m.jpg Especially with a face like this: http://sqluniversity.net/image/side_morgan.jpg -- Bye now, Obnoxio http://obotheclown.blogspot.com/

http://orana.info/author/jeff-erickson-tech-editor-oracle-publishing/ I’m trying to decide what was the best part of PSOUG’s Oracle Days event up in Seattle last week. Was it hearing an advocate of IBM Z series fire back, quite convincingly, at IBM’s blade server rivals? Was it getting a serious lesson in data storage by Pillar Data Systems as they introduced the Axiom 600? No, the best part would have to be riding to Microsoft in Dan Morgan’s Jaguar to shoot clandestine video for our upcoming Oracle Magazine story and video podcast. As we were driving, Morgan, second in command at the Puget Sound Oracle User’s Group, discussed the benefits of being an Oracle Ace Director. “It doesn’t lead directly to money,” he said. But it does, he said, come with interesting speaking opportunities, such as upcoming engagements that Oracle booked for him in Finland and, I think, Bulgaria. And it does lead indirectly to money. When Morgan, a professor of database technology in University of Washington, does go out to do consulting, being an ACE Director can help land gigs. “”When I walk into a client who is also talking to a global giant like Accenture, I simply ask if the firm is going to put someone on their account who is recognized by Oracle as one of the top people on the planet who really, really knows his stuff,” he said. “So in that way, I guess it does lead to money.” Oh, the humility!! -- Bye now, Obnoxio http://obotheclown.blogspot.com/

Obnoxio The Clown says... >When Morgan, a professor of database technology in University of >Washington, A professor in Univ of Washington??????

Naw. He just teaches a class at a satellite campus. Not a professor. Right Serge? > From: dcruncher4@aim.com> Subject: Re: Tech Tip du Jour: Fragmenting (at all)> Date: Wed, 23 Jul 2008 09:16:30 -0700> To: informix-list@iiug.org> > Obnoxio The Clown says...> > >When Morgan, a professor of database technology in University of> >Washington, > > A professor in Univ of Washington??????> > _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Time for vacation? WIN what you need- enter now! http://www.gowindowslive.com/summergiveaway/?ocid=tag_jlyhm

Ian Michael Gumby wrote: > Naw. > > He just teaches a class at a satellite campus. > Not a professor. > > Right Serge? Let's not go there...again. Waste of bandwidth... -- Serge Rielau DB2 Solutions Development IBM Toronto Lab