RE: Looks Like The Party Is Over In Menlo (2nd try)
>===== Original Message From Mike Segel <Postmaster@iiug.iiug.org> ===== >Well Gee, >The mainframe is still making some people money. >But not IBM,CA, etc ... I seem to recall a slowdown in their mainframe products and >ernings. So your saying mainframes are going away and that IBM should just quit thinking about that out of date mainframe thing? You definitely work in a different environment than I do. I would be really surprised if IBM wasn't still pulling in lots of money from licensing contracts on their mainframes. Maybe not the selling of hardware, but most of the places I worked at sent IBM a decent sized check on a regular basis. Maybe it isn't growing, but that doesn't mean it won't make them money for a long time. > >But hey, what do you expect. >I've never seen a TPC benchmark on a "multivalue" database. Neither have I, but then again, I have never looked. > >At the same time, just how large is the largest pick database? >How many TB did you say? Ok, to qualify as a usable system you now have to have production systems in the Terabytes? To be honest I have never heard about a Terabyte sized OLTP system on a UNIX box. Now if we are talking about one of those antiquated mainframes, that would be a different story. As far as performance goes the largest Universe system I have seen had just under 1000 active users on a 70GB OLTP system running on a IBM F50 4 way. All user processes ran on the F50 as well, and were a large part of why an F50 was needed. When the system was around 40GB and there only around 500 users I believe they were running the database on a 990, with 2 C10's handling the user processes. I am just saying Universe is definitely a viable system, and that I hope Informix doesnt just throw it into the trash bin. I personally prefer to administer Informix, but I know a few people who are running Universe, and I dont think any other environment would suit them better. Will > >-Mikey > > >William Rice wrote: > >> I would say Universe is easy to maintain, hands off, and does not require >> a full time DBA. Would you mind naming some faults? >> >> Why are you bashing a good product? >> What is wrong with sites taking advantage of it? >> >> And without a doubt Pick databases are still allowing people to make money. >> >> Thanks, >> Will >> >> >===== Original Message From Mike Segel <Postmaster@iiug.iiug.org> ===== >> >DICK PICK IS DEAD! >> > >> >Got it? >> > >> >-Uncle Mikey. >> > >> >William Rice wrote: >> > >> >> I will agree that Ardent's database products are not in vogue, but >> >> claims about the death of Pick databases have been greatly exaggerated. >> >> My biggest concern when Informix purchased Ardent was that all focus >> >> on Ardent products would die. That would not exactly endear the current >> >> Universe/Unidata users to go to an Informix database. I hope with someone >> >> from Ardent at the helm, there is a chance that Informix's products >> >> will be pushed forward, and Informix will be able to still pick up a >> >> profit from Ardent's customers. Don't get me wrong, marketing is still >> >> a lost cause, but I still have some hope. >> >> >> >> Will >> >> ------------------------------------------------------------ >> This e-mail has been sent to you courtesy of OperaMail, as a free service from >> Opera Software, makers of the award-winning Web Browser, Opera. Visit us at >> http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail >> account is waiting at: http://www.operamail.com/ >> ------------------------------------------------------------
The size a Universe file depends on the operating system. If you are running on a Windows or NT platform, or any other 32 bit operating system, a file size is restricted to 2GB. There are ways to get around this by changing to distributed files and dynamic files. On a 64 bit system the file size can be as large as 19TB. And, of course, this can also be expanded by using distributed or dynamic files. That's one file. The number of files you have is only restricted by the operating system. How many files does a directory hold? As far as TPC running tests on Universe, I think it would be a good thing. There has been a lot of discussion on comp.databases.pick about this recently. You can make Universe into first normal form if you want to limit it's capabilities but if you want to see it's real power then you would make use of it's non-first normal form (NF2) structure. "William Rice" <ricew@operamail.com> wrote in message news:8ngtsg$ak7$1@news.xmission.com... > > >===== Original Message From Mike Segel <Postmaster@iiug.iiug.org> ===== > >Well Gee, > >The mainframe is still making some people money. > >But not IBM,CA, etc ... I seem to recall a slowdown in their mainframe > products and > >ernings. > > So your saying mainframes are going away and that IBM should just quit > thinking about that out of date mainframe thing? You definitely work > in a different environment than I do. I would be really surprised if > IBM wasn't still pulling in lots of money from licensing contracts > on their mainframes. Maybe not the selling of hardware, but most of > the places I worked at sent IBM a decent sized check on a regular basis. > Maybe it isn't growing, but that doesn't mean it won't make them money > for a long time. > > > > >But hey, what do you expect. > >I've never seen a TPC benchmark on a "multivalue" database. > > Neither have I, but then again, I have never looked. > > > > >At the same time, just how large is the largest pick database? > >How many TB did you say? > > Ok, to qualify as a usable system you now have to have production systems > in the Terabytes? To be honest I have never heard about a Terabyte sized OLTP > system on a UNIX box. Now if we are talking about one of those antiquated > mainframes, that would be a different story. As far as performance goes > the largest Universe system I have seen had just under 1000 active users on a > 70GB OLTP system running on a IBM F50 4 way. All user processes ran on > the F50 as well, and were a large part of why an F50 was needed. When > the system was around 40GB and there only around 500 users I believe they > were running the database on a 990, with 2 C10's handling the user processes. > > I am just saying Universe is definitely a viable system, and that I hope > Informix doesnt just throw it into the trash bin. I personally prefer to > administer Informix, but I know a few people who are running > Universe, and I dont think any other environment would suit them better. > > Will > > > >-Mikey > > > > > >William Rice wrote: > > > >> I would say Universe is easy to maintain, hands off, and does not require > >> a full time DBA. Would you mind naming some faults? > >> > >> Why are you bashing a good product? > >> What is wrong with sites taking advantage of it? > >> > >> And without a doubt Pick databases are still allowing people to make money. > >> > >> Thanks, > >> Will > >> > >> >===== Original Message From Mike Segel <Postmaster@iiug.iiug.org> ===== > >> >DICK PICK IS DEAD! > >> > > >> >Got it? > >> > > >> >-Uncle Mikey. > >> > > >> >William Rice wrote: > >> > > >> >> I will agree that Ardent's database products are not in vogue, but > >> >> claims about the death of Pick databases have been greatly exaggerated. > >> >> My biggest concern when Informix purchased Ardent was that all focus > >> >> on Ardent products would die. That would not exactly endear the current > >> >> Universe/Unidata users to go to an Informix database. I hope with > someone > >> >> from Ardent at the helm, there is a chance that Informix's products > >> >> will be pushed forward, and Informix will be able to still pick up a > >> >> profit from Ardent's customers. Don't get me wrong, marketing is still > >> >> a lost cause, but I still have some hope. > >> >> > >> >> Will > >> > >> ------------------------------------------------------------ > >> This e-mail has been sent to you courtesy of OperaMail, as a free > service from > >> Opera Software, makers of the award-winning Web Browser, Opera. Visit us > at > >> http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free > e-mail > >> account is waiting at: http://www.operamail.com/ > >> ------------------------------------------------------------ > >