by Bruce Charn » Sat, 08 Apr 1995 04:00:00
by Ed Kell » Thu, 13 Apr 1995 04:00:00
Ed Kelley, Senior Specialist
AT&T Network Systems - CIO
WEB page: http://www.mindspring.com/~ekelley/html/ekelley.htm
by Leonard Spod » Thu, 13 Apr 1995 04:00:00
If you are a DBA, you will love Informix because it requires constant
tuning! Job Security.
I would advise you talk to your Oracle Sales Consultant and find out the
truth behind Informix's tall tails that they have the only architecture
available to handle large DSS.
by Shyam Davubu » Thu, 13 Apr 1995 04:00:00
We have been running our application which is compiled under Informix 5.2 and
the performance seemed to be pretty good. When we moved our upgraded Informix
rto 7.1 engine the performance is really bad. We have processes that use to
take few minutes under Informix 5.0 are taking hours to complete. We have not
compiled our application under 7.1.
System Configuaration :
IBM RS6000, AIX 3.2.5, 128 MB RAM and 700MB of database space.
I really need help on this problem, if anybody has done performance tunning
under 7.1 please give me a call or send me an e-mail.
I tried to get Informix Tech support but they don't seem to have any clue
except asking me add one more processor to the system.
I really appreciate your help on this proble.
Thanks in advance,
Shyam
---
--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Shyam Davuluru Phone #'s: (408)249 3062 (R)
Siemens Rolm Communications
by infor.. » Thu, 13 Apr 1995 04:00:00
Spoken like a true Oracle aficiando. Unfortunately, your so-calledQuote:>Oracle is the only proven solution on the market for your problem.
>Informix has some nice "m-architecture", but is not proven in real life
>situations with the number of users and size of DB you are talking.
>If you are a DBA, you will love Informix because it requires constant
>tuning! Job Security.
>I would advise you talk to your Oracle Sales Consultant and find out the
>truth behind Informix's tall tails that they have the only architecture
>available to handle large DSS.
Informix's products are, in fact, proven in real live situations
with the number of users and DB sizes you refer to. Ask K-Mart or
Home Depot - or Hyatt.
It is NOT true that Informix requires constant tuning!! Once tuned
correctly, the OnLine database engine remains that way. If you are
observing that Informix requires "constant tuning" it's because whoever
was doing the tuning was incompetent - or trying to fake up some job
security.
(Sideline: *all* database engines should have their tuned parameters
revisited any time the workload for which it was originally tuned is
significantly changed. In this respect, *all* database engines require
"constant tuning".)
I would advise anyone interested to read the Gartner Group's report and read
the REAL facts. Computerworld (3/20/95, p.32) reports that "'Informix had the
better architecture by far,' said Howard Fischer, senior project manager for
database services at Sears Merchandise Group in Hoffman Estates, Ill."
Informix's OnLine 7.1 runs rings around Oracle (whose representatives keep turning
tail at every TPC-C benchmark shootout when Informix is present). Oracle
simply cannot compete with OnLine 7.1.
Face it, Leonard. You picked the wrong newsgroup in which to extol the so-called
merits of Oracle. Or did you notice that you posted to comp.databases.informix?
---
Bill Williams
+-----------------------------------------------------------------+
| Disclaimer: My views, opinions, etc., are not those of AT&T or |
| or ATSI, Inc, nor should they be. |
+-----------------------------------------------------------------+
by Clem Aki » Fri, 14 Apr 1995 04:00:00
"When the OnLine system has been converted to INFORMIX-ODS,
all user tables created in version 5.x are marked as down.
They are unusable until they are converted to the new
index format that includes the delete flag."
__________________________________________________________________
| Clem Akins Standard Disclaimers Apply |
|Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" |
|________________________________________________________________|
by Calvin » Fri, 14 Apr 1995 04:00:00
Did he make a mistake here, I think Oracle DBA have more assurance of jobQuote:>>If you are a DBA, you will love Informix because it requires constant
>>tuning! Job Security.
Ask Oracle Sales Consultant!! I can imagine what the answer is!Quote:>>I would advise you talk to your Oracle Sales Consultant and find out the
>>truth behind Informix's tall tails that they have the only architecture
>>available to handle large DSS.
Talk about being bias. he probably can't even say Informix out loud.Quote:>Sounds like a sales pitch to me! Sorry, I don't buy it. I am running
>an INFORMIX 7.1 database on an AT&T GIS 3555. This server is running 5
>instances of the INFORMIX engine with a total of 250 GB of disk
>on-line (almost all full too), 8 90MHz pentium processors and about
>300 users in total. We are barely scratching the power in this box.
>CPU uitilization rarely goes above 20%. As to constant tuning, I have
>adjusted tuning parameters maybe three times in the last 4 months and
>that has taken all of 10 minutes.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-------------------------------------------------------------------------
[DISCLAIMER] Read at your own risks. The author is not liable for any
consequences directly or indirectly involved with reading this mail.
This mail MAY NOT be interpreted as those of my employer's.
-------------------------------------------------------------------------
This mail is sent with the help of Chameleon TCP/IP for Windows.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
by Nigel Tricke » Fri, 14 Apr 1995 04:00:00
Try running sql statement "update statistics".
This should be run on high transaction tables daily via cron and a shell
script which can be called via dbaccess command.
The statistics should be run when tables are reloaded.
Regards,
Nigel Trickett
>} Subject: Informix 7.1 performance on AIX 3.2.5 machine.
>}
>} Hi,
>}
>} We have been running our application which is compiled under Informix
5.2 and
>} the performance seemed to be pretty good. When we moved our upgraded
Informix
>} rto 7.1 engine the performance is really bad. We have processes that
use to
>} take few minutes under Informix 5.0 are taking hours to complete. We
have not
>} compiled our application under 7.1.
>} [...]
>}
> "When the OnLine system has been converted to INFORMIX-ODS,
> all user tables created in version 5.x are marked as down.
> They are unusable until they are converted to the new
> index format that includes the delete flag."
> __________________________________________________________________
> | Clem Akins Standard Disclaimers Apply |
> |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" |
> |________________________________________________________________|
by Jon C. Ve » Fri, 14 Apr 1995 04:00:00
If you have not upgraded/compiled your applications under ESQL 7.x or 4GLQuote:>Hi,
> We have been running our application which is compiled under Informix 5.2 and
> the performance seemed to be pretty good. When we moved our upgraded Informix
> rto 7.1 engine the performance is really bad. We have processes that use to
> take few minutes under Informix 5.0 are taking hours to complete. We have not
> compiled our application under 7.1.
I suggest upgrading your tools. I also suggest reading thru and manual, and
tune the server. OnLine 7.10 is a different animal then 5.x.
Jon
==================================================================
Bothell, WA USA
------------------------------------------------------------------
Watch out for road-kill on the information superhighway....SPLAT!!
==================================================================
1. DBMS selection for 500+GB and 500+users
We are in the process of selecting a database for our data warehouse. It is
expected to start at 50GB of data with 50+ users and grow over the next 2
years to be 500+GB of data and 500+ users. Much of the data will be obtained
from our IBM mainframe ADABAS operational databases on a daily basis. We
are looking at Sybase, Informix and Oracle. Does anyone have experiences
(good or bad) that might help with our decision. In particular, how do
these products scale throught this type of growth. Thanks
2. SERVER IS DOWN -DATABASE IS MISSING
3. OID/XID allocation (was Re: is PG able to handle a >500 GB Da
4. Urgent: Enterprise Manager Error
5. Sqlserver 2000 Hardware Requirements for 500 concurrent users.
7. 500 concurrent user SQL Server?
9. MS-SQL Server able to manage 500 GigaBytes with 400 concurrent users
10. Hardware requirements for SQL2000 server with 500 users
11. MS-SQL Server able to manage 500 gigabytes with 400 concurrent users
12. Looking for large (500+ user) SQL Server SMP UNIX Sites