Oninit® Archive
Results for “onstat -g dsc”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
Informix 12.10 vs Informix 14.10 Performance Differences
Steve: First, an aside, I would go to v14.10.FC11w2 (or later) as there are some bugs in FC11 fixed in FC11w1 & FC11w2. Now: question: Did you drop all of your distributions and recreate them from scratch after the upgrade? There are often subtle differences between how the distr…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Question of dostats
Hi, Art, We use Dostats to update stats daily. The basic steps of the cronjob are, Step 1) update statistics low drop distributions Step 2 ) dostats -d mydatabase Question, Is step 1 (drop distribution) needed before running dostats? Thanks Frank…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
Check if buffers are in swap?
Marc: You should be setting RESIDENT to -1. Setting it to '1' only sets the initial resident segment and the first virtual segment to be non-swappable while the message and buffer cache segments will still be swappable. Setting RESIDENT to '-1' will set all shared memory segments…
When users complain of generic slowness (without specifics)...
Download the ratios.shr package which you can download from my web site at My Utilities if you do not have it already. Run the ratios.sql in sysmaster to create the stored procedures that the newratios.ksh script depends on, and run newratios.ksh. In the report, look at the BR (B…
index on timestamp & optimizer strategy failure
Hello Peter, did you test your SQL without the high or medium statistic? You will have a good distribution of the values and high statistics with a very high resolution is like a simulation of the index with increased effort. Best Regards Henri ------------------------------ Henr…
Help to understand this sqexplain (now with plain)
Right, About update statistics I use your script utils2_ak (dostats) every day. So, about data distributions, how can I improve that? ------------------------------ Leandro Kohler ------------------------------…
Informix 14 - ALTER JOIN -
Miguel: Ordinarily I would suggest that VM performance is always unpredictable and moving from one OS version to another has also impacted performance, however, if inner joins are consistently faster and outer joins are consistently slower, that's not caused by the VM or the diff…
AUS status
Sh To: The way to see if a task is active is to look at the ph_task.tk_enable column. If it is set to 't' then the task is active, if 'f' it is inactive. As for whether the AUS settings will survive the upgrade, that depends on whether the upgrade includes changes to the sysadmin…
Performance of 14.10.FC5 is worse compared to 12.10 is that possible?
To be strict at comparison, you should set the same amount of shared memory and same amount of cpu vps: this way you get rid of the SHMEM config parameters and also cpu vp number as potential cause of the difference. As Andreas said, the linux has much more memory than the windo…
DIRECT_IO/KAIO
John: Using DIRECT_IO will indeed use KAIO! Here's the full story: When Informix accesses RAW chunks (so character devices) it uses the OS's KAIO facility by starting a KAIO thread in each CPU VP to handle all IO to/from those RAW chunks. By default, when Informix accesses chunks…
Update Statistics
Kirit: The problem with using systables to determine the number of rows in a table is that the values in systables are ONLY accurately updated when UPDATE STATISTICS LOW is run (or LOW is implied by a HIGH without the DISTRIBUTIONS ONLY clause). On the other hand, using SELECT CO…
Increasing BUFFERS
Amit: Get my ratios.shr_ak package, install the ratios.sql stored procedure in sysmaster, then run the newratios.ksh script to get the set of metrics that I use to evaluate a server's state quickly. Look at the BTR #3 value for each bufferpool and for the total (see the report f…
Update Statistics on Non index field
If the new column will be included in join conditions or query filters then yes, it should have at least MEDIUM level data distributions. If not, you can get away with UPDATE STATISTICS LOW for that column. ------------------------------ Art S. Kagel, President and Principal Cons…
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
how to grab the update statistics sql statements of a database
Hello Eric, here is the one-liner to get statistics from dbschema -hd: $ dbschema -d DATABASE -hd all | nawk 'BEGIN{printf("SET PDQPRIORITY 25;\\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\\n")}{if($1~/^Distribution/){split($3,T,".")};if($0~/ Mode, /){M=toupper($1);printf("UPDATE …
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
memory monitor
Original post: HI, I use informix version 12.10, How to monitor below memory through SMI? dictionary cache; table statistics cache; ...... thanks for your time. Lu chuan Response: Well first off, when you say "table statistics cache" I'm assuming you mean the cache the s…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
shmmax syntax in onconfig file
SA here that needs to set the shared memory for Informix. I am not worried about performance at this point, just need to be able to get the informix server to start. The onconfig file syntax is a bit odd. All I want to set is approximately 4gb of shared memory. "WARNING: server…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
error initializing 11.70.FC9
>> What output would 'oninit -ivy' produce, would it also fail 'initializing >> dictionary and UDR caches'? When I run 'oninit -ivy', I get the following output: /test_ifmx/IDS11.70.FC9 1708> oninit -ivy 11476 Reading configuration file '/test_ifmx/IDS11.70.FC9/etc/onconfig.tes…
contention on dstpool
The performance guide documentation has some guidelines, you could use then as baseline: "For medium to large systems, you can start with the following values: DD_HASHSIZE 503 DD_HASHMAX 4 DS_HASHSIZE 503 DS_POOLSIZE 1000 Monitor these caches by running the onstat -g dsc command…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
-12014 Smart Large Objects: Cannot find entry in
-12014 Smart Large Objects: Can not find entry in lofd table. This error occurs in informix 12.10FC8 when activating ER Keys The solution is to apply the deletion of statistics as follows Update statistics low drop distributions only; Caution should be exercised in productive…
Full memory even if I set SHMTOTAL
Hello. It seems you are using vp memory cache without the "static" word, after the cache size. Try setting that. A second good practice is to schedule an onmode -F with a good period of execution, according to your memory fill rate. There are some kinds of problems in shared m…
RE: Rebuild Distributions After an Upgrade - B....
Thanks Art. I'm concerned about my larger tables being left with no distributions and wrong query plans for extended period of times. UPDATE STATISTICS LOW FOR TABLE systables DROP DISTRIBUTIONS ONLY; -- our distributions are gone now, right? -- any query plan generated between…
Rebuild Distributions After an Upgrade - Best Prac
I'm performing in-place upgrades from 11.50 and 11.70 to 12.10 and I am interested in the best way to drop and recreate distributions to minimize impact. Would this be the most reasonable approach? for each table: update statistics for table <table> drop distributions only; u…
IDS 12.1- Query cost High
Mike, I would love to understand what caused a same query plan to be significant slower in an N+1 version compared to an N version. That's not neither normal or usual. I've seen a corrupted index cause the query to use a different query plan (if run on a secondary server) or ca…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
shared memory issue
You should always post your platform and Informix version details so you don't have to wade through version specific answers that do not apply to you. Here's mine for you: If you are running any later v11.50, any 11.70, or v12.10 earlier than 12.10.xC5W1 there are at least three…
RSS/HDT Sec - Different Query Plans???
True... But there were some bugs that when we run updatet statistics on the primary, and when the resulting catalog data was sent to the secondary(ies) the in memory cache of the distributions was not refreshed. This can cause the mentioned effect. Regards. On Tue, Jul 7, 2015 …
-272 when using role and synonym
sysdbopen() doesn't get executed on distributed queries. Which actually is not a big deal... If you need to have a role for direct connections to the DB and a different role when running a distributed remote query you can create a sysdbopen() procedure and set the role for direct…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
- Workgroup Edition (WE) does support Enterprise Replication with no restrictions. However, Everett's basic point stands. If you are not now using features that WE does not support, or can do without them without hurting performance or breaking your applications, then WE is a …
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
informix 11.70 growth edition features
HI All, There are several things to look at. There is a difference between*Distributed Database* and *Distributed Processing*; this latter is sometimes called Distributed operations. A *distributed database system* consists of a collection of sites, connected together via some…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Update Stats Issue
never mind. found the following buried deep in the update stats log: update statistics high for table tbd1 ( cust_no ) distributions only; 312: Cannot update system catalog (sysdistrib). 107: ISAM error: record is locked. Error in line 860 Near character position 33 things m…
light scans with update statistics
Thanks for your response Fernando, By the moment, the upgrade is not posible. In HP-UX, the page size is 2K. When I run onstat-u for the session, I get a range between 300 and 500 nreads per second, which I find very little. I have more hardware to use, but I can not know what…
DB Tuning question
Hi Art, This is the updated configuration: I have changed SHMADD and SHMVIRTUALSIZE from 20000 to 100000. LRUS is still 16. LOCKS 300000 # Maximum number of locks #BUFFERS 150000 # Maximum number of shared buffers BUFFERS 50000 # Max number of shared buf NUMAIOVPS 1 # Number of…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
update statistics comparison
Hello, Honestly, although doing update statistics for years :-) , still not in 100% clear on some results comparisons ( the optimizer likes one better than other ....) OK. What are the major possible differences of the following two sets of update statistics jobs for a table? H…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
anyone using Netapp
We are using Netapp with Solaris 10 and Informix 11.70.FC5 since April. The Netapp Storage is a part of the SAN. Each Informix Server instance has it's own volume which is splitted in a couple of luns. Important attributs: Big Flash Cache (1 TB), Stretched Metrocluster. Metrocl…
UPDATE STATISTICS may use indexes?
I'm chatting with a customer DBA about UPDATE STATISTICS HIGH and he's reporting some seemingly counterintuitive performance results... On a table having three columns (say A, B and C), he is reporting: UPDATE STATISTICS HIGH FOR TABLE tbl(A); UPDATE STATISTICS HIGH FOR TAB…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Problem with identifying root cause of continual m
Ok. I think it probably some application problem. Could you check out if your Informix server is using OPTOFC=1 value? It should. I also suggest you to search for the JDBC connection string (or properties), for IFX_AUTOFREE parameter. It also must be turned on. Maybe that´s the c…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
how often update stats should be run
Hi, we are running IDS 11.5 FC7 on AIX 6.1 How often update statistics should be run against database & in which mode (high, medium, low, distribution only) We have schedule it via OATS tool. Below are the parameters selected for evaluator (Auto Update Statistics Evaluation) AU…
What is virtual about Informix "virtual segment of shared memory"?
The "Virtual" designation is an internal Informix term referring to the internal management of memory that can be transient and shared between multiple oninit processes and user sessions. Basically it contains all of the server's in-memory data structures except the buffer cache…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
switch from block to raw, & modify HP-UX bufcache
Hi everybody, Informix Dynamic Server Version 11.70.FC1GE on HP-UX v11.11 (Risc) I am not a HP-UX admin, and it's been a long time since I've dealt with an Informix engine on block devices (I inherited, I didn't build it). I am seeking advice on whether my improvement plan bel…
Performance issue
Hi, I tried your query and it has a bit improve, but still not normal speed. I will update statistic for the whole database with your advise, then run the query again. I will date. Thank you all for your advices. update statistics low drop distributions; .... .... update statis…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
Instance Crashed !!
The resident segment is mostly the buffer cache, so that determines its size. The virtual segments contain the smaller caches like the dictionary cache etc. And working memory for sessions to use. There is no ratio between the two. Art On Jan 21, 2011 11:12 AM, "SHAHZAD SALAM KA…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
SQL slowdown. Index rebuild?
Sorry, forgot to mention that update statistics drop distributions was done and a re-creation of the statistics LOW and MEDIUM for the tables and HIGH for the indexes.…
ONSTAT -G DIC
Try DD_HASHSIZE 1013 DD_HASHMAX 10 You should also take a serious look at the data distribution cache (onstat -g dsc) to see if that doesn't need to be increased as well. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Di…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
Re: Mach11 questions
On Thu, Sep 9, 2010 at 5:29 PM, shorti <lbryan21@juno.com> wrote: > > And your question: "-How UPDATE commands are routed if coming through an > SDS > > node" made me think you understood that. > > > The updates are transparently sent to the primary node. Only the primary > > no…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
SQL Tunning
Hello Art, Data distributions are ok, update statistics run every nigth at diferent levels on all tables. I will try rewritting this query for better perfomance using OUTER JOINS as you recommend. Later, i will post the results. Thanks for your response. Leonardo…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
Re: Linux LVM snapshot
Andrew Ford schrieb: >> BTW, being a SAN admin/UNIX sysadmin/RDBMSes DBA all at once, I wonder >> what's it like to be a DBA unaware of how are your database chunks >> stored. Is it easier not to worry about underlying server/SAN stuff or >> one worries even more since he/she has…
Re: How to Change sysdistrib tables extent size?
Is what possible? In 9.xx you cannot change the initial extent size of the TABLESPACE TABLESPACE nor of the system catalog tables. You can, as informix, change the NEXT SIZE for the catalog tables before you start to create tables in the database to minimize the fragmentation of …
Update Statistics, with a Table Named Distribution
IDS 11.50.FC5 AIX 5.3 I am attempting to establish resolution and confidence factors for tables within a particular database; however, there is a table named "distributiions" within this database and it is too ingrained within the code to change at this time. This table name gen…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
Re: Resident Memory larger then expected
The RESIDENT segment is more than just the buffer cache. For example, the lock table and the data dictionary, data distribution, stored procedure, statement and other static caches are all stored in the resident segment. Also if you have set RESIDENT to a value other than zero o…
To 16K My Indices ... Or Not to 16K Them, That is
I think the answer to this question is...it depends. We looked at 16K page size (also looked at 4K, 6K, 8K, 12K and 14K) for some of our busiest OLTP indexes with the thought that a larger page size = more index entries per page/btree node = fewer index levels = better performan…
Application slow and data not saved
OK, there are three metrics that give one a quick look at the health of a server and suggest quick fixes. They are all calculated from the data in the onstat -p output which you have fortunately supplied: Bufwaits Ratio (BR): (bufwaits / (bufwrites + pagreads)) * 100.00 = 144.94…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
dostats for big big tables
Hi all, running dostats -d -e , I've realized that for the key columns the script runs update statistics low before running update statistics high. Is there any particular reason? is it to clean the distributions? My concern is because my system has really big tables and the who…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Configuring 2nd informix instance on the same serv
In my setup, SERVERNUM is unique and a new dbspace is created on that ROOTPATH. And correct ROOTPATH parameter is mentioned in onconfig file. I tried with "oninit -iv" option also. This time also i am getting the same errors in online.log file. # oninit -iv This action will in…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
IO problems and perf
If nothing else is running on the box then RESIDENT is irrelevant. Setting RESIDENT to 1 prevents the 'resident' shared memory segment (which contains the buffer cache and header structures for controlling shared memory) from being swapped out by other processes - you can also se…
ISAM reads of system catalog tables
On Jun 5, 4:46 pm, Art Kagel <art.ka...@gmail.com> wrote: > System catalog tables should not be read frequently at all, either from disk > or from the cache. It looks like your data dictionary cache is mis-sized. > Look at the DD_ parameters in the ONCONFIG file. They must prov…
UPDATE STATISTICS Performace Improvement
Read John Miller III's white paper at this link: * http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/ 0203miller.html * Also, you can use my dostats utility, taking the recommendations in John's paper into consideration about setting PDQPRIORITY an…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
about update statistics performance ?
VARAPORN VERAVITHAYA wrote: > 3. Any other recommend ? > > You might use Art Kagel's dostats program. This gives you this command sequence: UPDATE STATISTICS LOW FOR TABLE "t1" (a, b, c, d, x1); UPDATE STATISTICS LOW FOR TABLE "t1" (a, b, e, f, x2); UPDATE STATISTICS LOW FOR TABL…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
update statistics after 9.4 to 10 migration
Hi everyone. I have read up on this but I am still a little unclear on what needs to be done regarding update statistics after migration a database from IDS 9.4 to IDS 10. After I bring up the old 9.4 database in the new version 10 environment is it necessary to do: update stat…
IDS hangs; IBM diagnoses resident memory problem
"Eric Rowell" <erowell@gmail.com> wrote in message news:mailman.143.1232031123.1831.informix-list@iiug.org... Never had an issue with " RESIDENT " but then again currently we are not using it. Too many things sharing the server. Are you sure you aren't running into a memory lea…
9905 error with varchar in a multiset
sounds like an occasion of an oldie: 130885 9628 TYPE NOT FOUND USING SPL WHEN ROUTINE/EXT TYPE CACHE IS HAMMERED ERROR IS STORED IN SYSPROCPLAN up the values for PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX, PC_HASHSIZE,DS_HASHSIZE etc. Superboer. On…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
Question about sysindexes.clust
Art, Thank you for your analysis we came up with the same thing but backed into this via watching the page reads on the table during the applications run. We happened to find this as a production issue when trying to normalize this table in development so that the large highly r…
Re: Best Use of Free Memory
On 31 Oct, 00:49, "Kevin Cherkauer" <invalid_addr...@nowhere.com> wrote: > David, > > I see the confusion now. The English phrase, "Needs to acquire a buffer," is > too vague. There are really two major cases, but the manual is only > addressing one (the rarer one). The cases are…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
oninit:Fatal error in shared memory creation
Hi all, I have installes IDS 9.3 on a suse 8 enterprise box. The database is not starting and i am getting the following error message: "oninit: Fatal error in shared memory creation. The oninit -ivy and the online log are as follows; oninit -ivy ------------ login as: informix…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
CPU VPs
On Aug 5, 10:10 am, Mohit <mohitanch...@gmail.com> wrote: > To scale for anticipated traffic we increased number of CPU Vps from > 15 to 25. Along with that we changed the affinity also. We were > expecting increase in performance but it actually degraded the > performance. Since…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Re: load distribution to kio vps or hash PN_ID
On Jul 28, 1:36 pm, "Art Kagel" <art.ka...@gmail.com> wrote: > The KIO threads each run in one of the CPU VPs and ONLY service IO requests > from threads running in that specific CPU VP. > > The only way to spread the load better between the CPU VPs is to properly > tune your lis…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Parameter tuning?
Pls see the instance profile and shared memory parameters below. The problems I noticed are 1. low read-cache-hit 35% 2. low write-cache-hit 79% 3. a lots of bufwaits and seqscans What do you advice? Informix Dynamic Server Version 7.31.UD3 -- On-Line -- Up 158 days 02:30:01 --…
Mysterious update statistics
Hi all. Once again a question to update statistics: Makes it a difference how many data had changed between two runnings e.g. UPDATE STATISTICS FOR TABLE xxx; In other words: Is update statistics aware of the difference or is it running on all data at all times? Would it make s…
Re: long checkpoint duration
Floyd Wellershaus wrote: > Hi, > The age old question I guess. But our checkpoint durations are > consistently near 20seconds. > > ids10.0 fc5 on ibm p570 running aix 5.3 7 cpus 41g ram. > ckptintvl is 300, I am considering halving that. > We have 128 lru's and 128 cleaners > A…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
last run date of update statistics
Hi, how can i find the last update statistics run date for a table. i do not collec t distributions ie i run the following statement- UPDATE STATISTICS LOW FOR TABLE glpca here 'glpca' is a table. i do not get the correct value in 'constructed' field from the 'sysdistrib' tabl…
update statistics low drop distributions
Hello, Last summer we updated Informix 7 to Informix 10. We installed both versions next to each other and did an im/export of the data by dumps through the "BaaN IV" application. We didn't migrate the data through Informix update. Our database is 80Gb large and runs on an IBM P…
Re: long checkpoints
your sar says 90% busy doing 148 r/w sec which is 1906 blocks meaning aprox 1 MB/s a sec for a disk.... having an average of 6 Kb in size... onstat -Rr |grep dirty during checkpoint will tell you how many pages per 5 secs are written. Also it will tell how many pages are reall…
Re: long time to wait until "dbaccess - Database - Select" answers
On 9 Nov, 11:39, "Keith Simmons" <smile...@googlemail.com> wrote: > On 09/11/2007, wjb <w.beh...@uni-bonn.de> wrote: > > > > > On 9 Nov., 09:59, "Keith Simmons" <smile...@googlemail.com> wrote: > > > On 08/11/2007, bozon <cur...@crowson1.com> wrote: > > > > > On Nov 8, 7:49 am, w…
Re: long time to wait until "dbaccess - Database - Select" answers
On Nov 8, 7:49 am, wjb <w.beh...@uni-bonn.de> wrote: > Hello, > > dbaccess - Database - Select > takes about 30 ... 45 seconds to list all 8 databases. > > After selecting a database it takes the same time to > show the info or the missing connect permission. > > The same behavio…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Kill Update Statistics
Is there any way to kill a running update statistics. UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. I tried with with onstat -z several times but it runs and runs and seems to do nothing anyway. Regards Reinhard…
Re: Calculate optimal value for DS_POOLSIZE
Actually I believe the confusion is betwen the DS cache values with the DD cache variables. DD_HASHSIZE and DD_HASHMAX mean something else. DD_HASHSIZE is the number of buckets or lists, and DD_HASHMAX is the number of entries (soft limit) per buck or list. DS_POOLSIZE indica…
Re: Calculate optimal value for DS_POOLSIZE
>mohitanchlia@gmail.com >Version: IDS 10 >I am trying to determine the optimal value for DS_POOLSIZE and >DS_HASHSIZE. I looked at the onstat -g dsc. I have following question: > >1. How do I determine the correct size of DS_POOLSIZE. Should I look >at our update stats and see nu…
Calculate optimal value for DS_POOLSIZE
Version: IDS 10 I am trying to determine the optimal value for DS_POOLSIZE and DS_HASHSIZE. I looked at the onstat -g dsc. I have following question: 1. How do I determine the correct size of DS_POOLSIZE. Should I look at our update stats and see number of unique columns that w…
Problem in initialization of IDS.9.40.UC1
I have IDS9.40.UC1 on linux. I was trying to bring up the server using oninit command. The below is the output of oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/software/ids/etc/onconfig'...succeeded Creating /INFORMIXTMP/.…
Update statistics - slow index key search
Version: Informix 10 General Question about update statistics: For a given table that is fragmented into multiple dbspace: 1. Should update statistics be run in any specific way 2. Should the data distribution be dropped while running update statistics 3. I am seeing slow sele…
Re: General IDS 11 question
----- Original Message ----- From: "John Carlson" <jwcarlson1@yahoo.com.invalid> Newsgroups: comp.databases.informix To: <informix-list@iiug.org> Sent: Wednesday, July 25, 2007 10:13 PM Subject: General IDS 11 question > Of those of you who are using IDS 11 in a production envir…
Using STMT_CACHE
Hi These are the advantages of using SQL Statement Cache feature. 1)Reduced memory consumption because query data structures are shared among different users. 2)Faster query processing time because for statements present in the cache, the database server can skip parsing and opti…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
slow performance for one group of tables
laurad@dis-corp.com wrote: > I have a database where six records were corrupt. One of the fields > that was corrupt was a date field so it would not allow an export to > complete. In transaction mode I updated the date field to an > acceptable value and unloaded the table. The…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: update statistics
informix-list-bounces@iiug.org wrote on 03/05/2007 12:47:55 AM: > The IBM web page at ... > ... says to update statistics thusly: > > 1. Run UPDATE STATISTICS LOW on all tables in the database. > > 2. Run UPDATE STATISTICS MEDIUM on all columns which are in an > index, but are n…
Question about Linux VM tuning for IDS
Rob, To answer your question... Memory Residency is an OS thing. Informix has a flag/switch that if set, it will attempt to perform memory residency *if* and I mean *iff* the underlying OS does support this feature. Going from memory... mlock() is the c function which will lock…
Bug in V10 FC5??
Hello Richard, Did you run any update statistics after upgrade to FC5? You may need to drop the data distributions after upgrade. -Sanjit…
Re: How can I get throughput of informix such as how many query/update operations per second?
eagle_jyjh@citiz.net wrote: > HI Zachi, > Thans for your reply. > I knwo it depends on many factors, however, I want to know how to > estimate the expierenced value range of the throughput for an existing > system > > > > > > your server hardware: > > …
sysptprof
Floyd Wellershaus wrote: > I am writing some benchmark scripts to keep track of chunk and table IO. > According to the manual, the following is true about sysmaster:sysptprof > > > The *sysptprof* table lists information about a tblspace. Tblspaces > correspond to tables. > > Pro…
Re: Element Size - RAID 10 SAN
Hello Art, big writes are 16 pages. haven't checked out when the pagesize is 32k yet... i would use chunks which are twice 16 pages to avoid split writes. Superboer. Art S. Kagel schreef: > Tam O'Shanter wrote: > > Wondering about the optimal configuration for a Raid 10 arra…
Element Size - RAID 10 SAN
Tam O'Shanter wrote: > Wondering about the optimal configuration for a Raid 10 array, specifically, > element/block/stripe sizes. > > Does this relate to my DB block size the same way it would with Oracle? > > Given the smaller the element size, the more efficient the distributio…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
alter from serial to int crashes server
scottishpoet wrote: > Do you have a PMR number from when this was reprted to IBM Support? if you drop distributions on the table UPDATE STATISTICS LOW FOR TABLE <table> DROP DISTRIBUTIONS and then run the ALTER TABLE command does this stop the crash from occuring??…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
update statistics
I like to to the following: update statistics low for <table> (<columns>); -- where <columns> are all columns that are in an index update statistics medium for <table> (<columns>) distributions only; -- where <columns> are all columns of a table that do not appear -- in the …
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Update statistics and shared memory
So, a strange leap takes me to... how about if the update stats process messes up all the pages you've been happily cacheing all day, and then when the real work starts again you've loads of pages that you need to 'purge' before it can get going...?? You could maybe get a handle…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Re: Latch Waits
Interesting I'm running 7.31.FD7 - on Solaris 8 and constantly getting the global Cach lock as well. Here's truncated results from onstat -g prc and onstat -g dsc run when almost all users had 'S' in the first column with onstat -u onstat -g prc Informix Dynamic Server Version …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
update statistics - distributions
hello all - i am a bit confused on update stats & distribution only. we are going to a system that will be accessed 24/7/365 due to new international business on the other side of the world - currently, i run update stats on the tables (low on the table itself and high on column…
Re: composite indexes and filter
bozon wrote: >>Depending on the avail statistics the database server might decide >>that a sequential scan or use of a different index is less costly. > > > Yes, the devil is in the details. If Informix decides that it would > return more records than some X % of the table it wil…
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
Update Statistics medium for database
Hello, it's my first question in this forum and i think, it's a simple question, but.... does it make sense, to make an update statistics medium for the complete database ? So for all columns in a table i get a distribution. Would'nt it make sens, to get the distributions only o…
Re: Really Frustrating -9628 Errors
Sounds like a bug i've seen before but 'should' have been fixed??? ... update stats will work but it only for xx hours and someother may fail. phone TS and have them look in their bugdb. wa afaicr is cranking up spl cache params PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX…
Optimizing a BaaN installation
Since this is Baan and the # of tables is as usual incredible you may want to set also DS_HASHSIZE and DS_POOLSIZE in onconfig. see old article from Art: -------- DS_HASHSIZE is the number of hash list and must be a prime number. It defaults to 31 in IDS 7.21->7.31. DS_POOLSIZ…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
Hi. I hace a problem trying to initialize the rootdbs in the creation of a new instance. I type: informix@BO:/informix/sq/dev$ /informix/bin/onspaces -c -d rootdbs -p s1_rootdbs -o 0 -s 2097151 And appears the error: shared memory not initialized for INFORMIXSERVER 's1' -Doe…
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
Re: OT: IDS 10 QPlan sanity failure problems
update statistics drop distributions will not fix the stored procedure query plans so have little if any impact on your problem the reason I asked about replication was becasue of the sysmaster issue as it appears to only be related to ER If dropping the procedures and recreati…
Re: Re: oninit error .. [5496]
$ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informix/etc/onconfig.padbv2'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/opt/informix/etc/.infos.padbv2" ... "/opt/informix/etc/.co …
Re: informix and web logic
I would not recommend mucking around with the system catalog.... there is a thing called Distribution cache as well which does not get handled if you load/delete whatever of the sysdistrib. (onstat -g dsc) so i would say DO NOT. Superboer. tomcaml@yahoo.com schreef: > Art, > …
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: More Update Statistics
Answers to my questions from John Miller III if anyone needs this information in the future. "Andrew Ford" <andrewford@austin.rr.com> wrote in message news:sZOre.55857$6g3.51506@tornado.texas.rr.com... > Ok. I think all but 2 of my questions relating to update statistics have >…
More Update Statistics
Ok. I think all but 2 of my questions relating to update statistics have been answered. If anyone knows the answers to the following 2 questions, I'd appreciate some feedback. 1. Do the update statistics performance enhancements appear in 9.30.XC2 or 9.30.XC3? I have 2 docum…
Re: Update Statistics
> > What would I gain by dropping distributions? I always thought old > > And not rebuilding them? You gain the time needed for the US MEDIUM and US > HIGH. :o) But the whole point of running update statistics high or medium is to generate distributions? Especially when run wi…
Re: Update Statistics
Andrew Ford said: > For the following table on IDS versions 9.30xC2 and up > > create table t ( > a integer, > b integer, > c integer, > d integer, > e integer > ) > > create unique index idx1 on t (a, b); > create index idx2 on t (b, c, d); > create index idx3 on …
Update Statistics
For the following table on IDS versions 9.30xC2 and up create table t ( a integer, b integer, c integer, d integer, e integer ) create unique index idx1 on t (a, b); create index idx2 on t (b, c, d); create index idx3 on t (b, c, e); do update statistics low fo…
RE: Raid 5
Danny Wright wrote > > Someone's trying to sell us on RAID 5 and I haven't reviewed > Art's objections lately. > > They're saying all our concerns are no longer valid. > > > Agree or disagree? > Ask them what performance advantages has RAID 5 got over RAID 10. The answer - NONE…
Re: Raw vs. Cooked files
Martin Fuerderer wrote: > Hi, I emailed a simple response yesterday, but the link seems to be lost. Here's another more detailed one: It does not matter HOW much memory the OS has for a buffer cache. There are still several reasons why RAW will ALWAYS be faster than COOKED dev…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Readin…
Re: Checkpoint Stall problem?
Art, to get this straight both of us should make clear what we are talking about. I was referring to bug 170919 (dup of 169447) fixed in 9.40.UC7 and 10.0.UC2. It occurs in all previous versions and behaves as I described it. Can you give us the same information about your che…
Re: Checkpoint Stall problem?
Michael Mueller wrote: > This is quite incorrect and very misleading. There is a problem only for > some huge systems and it is not as dramatic as this article sounds. The > tunig tips are also wrong. As far as I have heard it will be fixed in > 9.40.UC7 and 10.0.UC2. We're talk…
Re: Checkpoint Stall problem?
Colin Dawson wrote: > Whilst searching for information on DS_HASHSIZE, I found the following, I > went in search of the results and summary on CDI but couldn't find it. Two > questions arise: 1) Which versions does this apply to? and 2) Does anyone > know where the results are lo…
Re: Checkpoint Stall problem?
Colin Dawson wrote: > Whilst searching for information on DS_HASHSIZE, I found the following, I > went in search of the results and summary on CDI but couldn't find it. Two > questions arise: 1) Which versions does this apply to? and 2) Does anyone > know where the results are lo…
Re: Checkpoint Stall problem?
This is quite incorrect and very misleading. There is a problem only for some huge systems and it is not as dramatic as this article sounds. The tunig tips are also wrong. As far as I have heard it will be fixed in 9.40.UC7 and 10.0.UC2. There is a problem at checkpoint time for…
Re: Checkpoint Stall problem?
This is quite incorrect and very misleading. There is a problem only for some huge systems and it is not as dramatic as this article sounds. The tunig tips are also wrong. As far as I have heard it will be fixed in 9.40.UC7 and 10.0.UC2. There is a problem at checkpoint time for…
Checkpoint Stall problem?
Whilst searching for information on DS_HASHSIZE, I found the following, I went in search of the results and summary on CDI but couldn't find it. Two questions arise: 1) Which versions does this apply to? and 2) Does anyone know where the results are located? A search on CDI archi…
Checkpoint Stall problem?
Whilst searching for information on DS_HASHSIZE, I found the following, I went in search of the results and summary on CDI but couldn't find it. Two questions arise: 1) Which versions does this apply to? and 2) Does anyone know where the results are located? A search on CDI archi…
Update statistics
Tilman Mode.... wrote: > There is a way to drop distributions without running 'update statistics > low' > > You may use the SQL command: > > DELETE FROM sysdistrib > WHERE tabid = > (SELECT tabid FROM systables > WHERE tabname = '<the_table_in_question>'); > > Disadvantage of thi…
Re: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I have DD_HASHSIZE=997 and DD_HASHMAX=27, these numbers were arrived at by running a script I downloaded from the s/w repository for calculating DD_HASHSIZE and DD_HASHMAX values. I have just rerun it and for a HASHSIZE value of 997 HASHMAX should be a minimum of 40. I'll check t…
Re: Latch Waits
Colin, I assume you are running some 7.3x version? The mutex name you see is truncated and really is "global cache mutex". This is either the mutex protecting the distribution cache (holding update statistics medium and high information) or the one for the stored procedure cache…
Latch Waits
Colin, I assume you are running some 7.3x version? The mutex name you see is truncated and really is "global cache mutex". This is either the mutex protecting the distribution cache (holding update statistics medium and high information) or the one for the stored procedure cache…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Update statistics and distributions
Hi, When i run Update statistics medium on the database, the space in the Dbspaces is getting filled up. I want to know whether the distributions created during this are stored in the corresponding dbspaces of the tables. Bye.…
RE: Memory resident tables
Gustavo Tobares wrote: > This message is in MIME format. Since your mail reader does not understand PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last…
Informix and RAID
In article <1102689507.780115a3c1139c370adf08eac9c2039f@teranews>, "Fernandez Garcia, Domingo" <domingo.fernandez@gestion.unican.es> wrote: > Up till now we have stored data in different chunks distributed betwen = > different disks to obtain a better performance in read-write…
Cooked files vs Raw disc
Peter, Our experience was that Informix on raw devices was about 10 times faster, not 10% (this was on Solaris servers). Setting up the raw partitions was no more demanding of my time than was doing cooked devices (although our sysad had to do some work to set up the raw devices…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Informix Tuning Problem
Andy Leung wrote: > My server run very slow for this few weeks.. I've checked the %cache go 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92 97670 146260 …
Re: Informix Tuning Problem
UPDATE STATISTICS? Andy Leung said: > My server run very slow for this few weeks.. I've checked the %cache go > 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92…
Informix Tuning Problem
My server run very slow for this few weeks.. I've checked the %cache go 99%.. Hardware : IBM - H80 , 4 CPU , 2G Ram , HD x 2 dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 25899 119543 30538756 99.92 97670 146260 2077545 95.30 ONCONFIG : - …
problems of Inztallation's
Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via onmonitor .... the error is: shared memory not initialized for INFORMIXSERVER 'crazy_tcp If i want to inicialize vi command ..... the err…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
cannot initialize root dbspace
$ oninit -iv This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine server run modesucceeded Reading configuration file '/informix/etc/on…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: Writing to disk or server cache?
Andris wrote: > Thanks, onmode -B indeed seems to be the solution for long > checkpoints, have to test it on IDS 9.21 yet. > > Anyway, another question remains - how to force IDS to use or not to > use cache memory? What do you mean by cache memory? Informix's shared memory? T…
Re: distributions management
On Thu, 03 Jun 2004 16:32:33 -0400, sumGirl wrote: > My company does data mining and we have one very large table that we > probably insert about 1000,000 records a week into and we never remove > records from it. We update stats on this table on a weekly basis, but we do > not …
Is it good to run update statistics as follows for system tables ?
--0-1818311736-1085258509=:39755 Content-Type: text/plain; charset=us-ascii Hi all, I am dropping dustributions while updating statistics for sytem tables. Is this a good idea ? Examples : update statistics low for table sysaggregates drop distributions; update statistics lo…
Informix IDS problem
Hi All, When I try to start the IDS 9.40 on HP PA-RISC machine, I get the following error. If I reinstall the IDS it works properly. If I shut down & restart the database it fails with the below message.. Checking group membership to determine server run modesucceeded Reading …
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Shared memory and SELECT-Performance
On Mon, 01 Mar 2004 05:07:19 -0500, Markus Bschorer wrote: Increase the size of the buffer cache (BUFFERS onconfig file parameter) so that more data is kept resident. The fact that after a few minutes the data need to be reloaded is a clear indicator that the cache is too small…
Problems running 9.40.UC3 on RedHat 8
I am having trouble creating an instance of Informix on RedHat 8. I have read all the problems people have been having running on RedHat 9 so we decided to try RedHat 8. We have also upgraded the glibc to glibc-2.3.2-4.80.8.i686. This was suppose to fix the problem with the TC…
RE: Whatcha' wanta have?????
Auto Update Statistics (i.e A set and forget option) To be done under some logical and meaningful circumstances - Change in number of rows by x% - Update of index columns by y% Optionally, this to be selectable so certain tables can be eliminated from the list of Auto Statis…
RE: Whatcha' wanta have?????
Auto Update Statistics (i.e A set and forget option) To be done under some logical and meaningful circumstances - Change in number of rows by x% - Update of index columns by y% Optionally, this to be selectable so certain tables can be eliminated from the list of Auto Statis…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
9.40.UC2 Startup on RedHat 9
I'm trying to initialise a database instance of IDS 9.40.UC2 on RedHat 9 (kernel 2.4.21, glibc-2.3.2-11.9.i686) However, when I run the oninit -iv command I get as far as the message "Bringing up the ADM VP..." and that's it. No further messages. The following is the exact output…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
RE: update statistics slowing system
Glen, I forgot to mention, that 'update statistics' intensively replaces data/index pages in the common buffer cache, and this can also effect performance of applications working with any database on the same server ------------------------------------------ Alexey Sonkin Senio…
Threads waiting on buffers
----- Original Message ----- To: dwright@sherwoodfoods.com At: 11/ 4 14:07 With that many tables also look into increasing the Data Distribution Cache (parameters DS_HASHSIZE & DS_POOLSIZE). Check out chapter 4 in the Performance Guide for details of all of these parameters, it …
updstats versus dostats
I compared the output of dostats and updstats for the same table and they were almost identical save for : dostats.post :::::::::::::: UPDATE STATISTICS MEDIUM FOR TABLE cdr_post_conf DISTRIBUTIONS ONLY; updstats.post :::::::::::::: UPDATE STATISTICS MEDIUM FOR TABLE cdr_post_…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
sql error -750
Dear all, OS: Solaris 2.6 IDS: 7.31.UC2 Problem: SQL statement error number -750. Invalid distribution format found for sn I have shopfloor application (with multiple executable 4gl programs) running on the IDS database engine (7.31.UC2). Some of the 4gl programs always hitting…
sql error -750
miyaki wrote: > OS: Solaris 2.6 > IDS: 7.31.UC2 > Problem: > SQL statement error number -750. > Invalid distribution format found for sn > > I have shopfloor application (with multiple executable > 4gl programs) running on the IDS database engine > (7.31.UC2). Some of the 4gl pro…
problems with oninit
hi, I installed IDS 9.40 on a Suse 8.0. After correct installation the oninit -iv command results the output: Checking group membership to determine server run modesucceeded Reading configuration file '/home/informix/ids/etc/onconfig.ids'...succeeded Creating /INFORMIXTMP/.infx…
cached tables
Let me add some points to Jonathon's comments here... If those tables are very active (massively hit), then they MAY stay in memory, or the buffer cache in particular. But this depends heavily on the size of the buffer cache. If the cache (BUFFERS) is too small, then these pages…
oninit: Fatal error in shared memory creation
What messages do you get in the online log? Regards Colin Dawson >What is the problem when your shared memory is not allocating and attatching? > >This is what I get >############################################## >$ oninit -iyv >Checking group membership to determine server …
Re: Performance & checkpoint
you can double your LRU number to decrease your checkpoint duration. I have been suffered the same problem and I increase my LRU from 128 to 512 and I really help. Also you can increase your CKPTINTVL from 300 to 600. "Wayne T" <ntrieu@yahoo.com> ???????:e6623a40.0305121517.15f3…
Re: Performance & checkpoint
You've almost answered your own question. You're experiencing data growth and performance degradation on a system that, no matter how it is configured, was hitherto accurate. So, what's changed in your application, and/or in your businesss? Ref the configuration, please tell us …
Re: Update statistics low drop distributions
There is no record of when an update statistics low was executed at all. However, if the last update statistics was a low drop distributions there will be no records in the sysdistrib table for the tabid(s) concerned and no output for the table(s) from dbschema ... -hd. Art S. K…
Update statistics low drop distributions
Is there a way to determine if the last time an update statistics was executed was it an "update statistics low" or an "update statistics low drop distributions"? Clay Velut Database Administrator SCF of Arizona cvelut@scfaz.com http://www.scfaz.com 602-631-2486…
Update Statistics....dropping distributions
I was at a "training day" in Denver last year and heard a presenter (maybe John Miller or Carlton Doe, but do not quote me on that) that there are times that distributions can just be added to and added to until they are huge and hindering performance. The proposed fix was to run…
Re: Multiple DBs vs Multiple instances
----- Original Message ----- From: Terrence Mu.... <terrence@wagerworks.com> At: 3/13 14:23 > What are the pros/cons of have multiple databases in one instance > as opposed to having multiple instances with just one database. For multiple databases: Makes better use of system r…
Re: undocumented parameters
----- Original Message ----- From: Ricardo Manzo <Ricardo.Manzo@cosan.com.br> At: 3/12 16:20 > Hi all , > > Does anybody know the meaning about the parameters below and how does it affect > performance ? Yes... > DD_HASHSIZE Not to forget: DD_HASHMAX The above control the siz…
undocumented parameters
Ricardo; These are paired hidden parameters that tune the sizes of the data dictionary cache (DD_HASHMAX, DD_HASHSIZE); the data distribution cache, (DS_HASHSIZE, DS_POOLSIZE); and the stored procedure cache (PC_HASHSIZE, PC_POOLSIZE). These parameters are documented in the Per…
Redbrick
----- Original Message ----- To: malcolmw@fast24.co.uk At: 3/26 8:29 Several commercial applications, notably SAP and PeopleSoft, have 10,000-30,000 tables, that's the main reason. Also there are instances, like our development servers here, where you may have over 100 databases…
UPDATE STAT.- DISTRIBUTION & PERFORMANCE
Hi Folks, I've noticed that dropping Distributions before running the UPDATE STATISTICS on a table (with Distribution) helps to improve the Performance on that table by more than 60%. UPDATE STATISTICS FOR TABLE MyTable DROP DISTRIBUTIONS; UPDATE STATISTICS FOR TABLE MyTable; …
DISK ARRAY
I use such an array. As Anndrew Hamm said, you'll have to present the 9 or 18GByte logical units you see from EMC as 2 GByte chunks. So, there will be an inherent level of indirection between the way you see the chunks on Informix and their physical position. In my experience,…
RE: 7.31 performance problem
Does your update statistics command create data distributions ?? This happens if you run update statistcs medium or high. In 7.31 there were some bugs related to these distributions. I solved the problem by dropping the distributions for some tables, and the performance increased…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
FW: Update statistics
Sorry, keep on forgetting about MIME (using Microsoft Outlook). Here is another copy - I've read about this in the manuals, I've asked advise and looked at samples, but update statistics is still not 100% clear to me. I also got different answers from different people with reg…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Extents management
NO! The SMI tables are NOT tables, they are pseudo-tables and are really just windows in to the engines disk and shared memory structures. NO NOT MUCK WITH THEM. On the other hand if you mean the system catalog tables, like the ones you mention, which are existent in every dat…
RE: Informix "hardware bottlenecks"
One of the issues about RAID5 is that media degradation can occur in "unused" parts of the disk space which is only discovered during another disk failure and rebuild with catastrophic results. If there is a background media scan built into the RAID (as opposed to an offline sca…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Fwd: FW: Informix on IBM SAN?
Doug: I have been using an IBM-2105/E20 for our production database for about ten months now all configured RAID5. Our array has 3Gig read cache and 192Meg of write cache NVS per cluster. The system is incredibly fast, but you can significantly improve performance by experiment…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
FAQ Update
David kill the 19 June posting on RAID5 it is completely redundant to the rest of the discussion. In 8.13 PC_HASHSIZE the note is incorrect. PC_HASHSIZE is related to PC_POOLSIZE, the former is the number of hash buckets and the latter is the number of entries permitted in each…
data distribution cache
All: System info: - Informix 2000 9.21.FC1 - Baan IVc3 - HPUX 11.00 - DB 280 GB . 30,000 tables "12 Baan companies" I'm currently running DD_HASHSIZE 511 DD_HASHMAX 50 Considering DS_HASHSIZE 511 DS_P…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Database Crash...Help
Hi All, I am having Informix v7.30.UC10X5 on HP UX 11.0. The database was running properly. I untared a isql tar file on the INFORMIXDIR and ran "installsql". The database was down when I installed it. But after instaling it did'nt comeup. So I again restore the earlier INFORMI…
UPDATE STATISTICS and Error -647
I have a script that performs the following statement: UPDATE STATISTICS MEDIUM FOR TABLE p3e DISTRIBUTIONS ONLY; From onstat -g sql I get a -647 in the SQL ERR column. Could someone explain, please? The platform is: Online 7.24.UC5 Sun 5000, Solarius 2.6 Thanks, Paige Miller…
SCO IPC
Bill Walker wrote: > > Art S. Kagel <kagel@bloomberg.net> wrote: > > > OK you tried, anyway. > > Yep. > > > IDS works fine on SCO, there are thousands of installations all using > > shared memory, indeed IDS NEEDS shared memory to work at all. > > Shucks. That do…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
prepares in 9.2
cstefanick@koz.com wrote: > I recently went from 7.22 to 9.2 (big change, I know). In 9.2 > statement cache is used so that similar query plans are shared. Does > this mean that preparing statements is no longer needed in 9.2? > > Sent via Deja.com http://www.deja.com/ > Befor…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
Re: Informix SE 7 slower than 5 ?
Steven Hauser wrote: > Did you run "update statistics" in the recommended way? I have tested both. The recommended way in Informix-SQL sintax guide and also have used a "macro-report" made by Obnoxio that generates different updates. UPDATE STATISTICS LOW DROP DISTRIBUTIONS; …
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
RE: update statistics high
Define long time. Chapter 10 of the Performance Guide details all. Summary; Update statistics medium distributions only, followed by high on columns that head indexes. HTH Scott H. > -----Original Message----- > From: him_lommel@t-online.de [SMTP:him_lommel@t-online.de] > S…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
RE: Routine DBA activities for Informix!!!
From: William Rice <ricew@operamail.com> > >Come in late. >Leave early. >Take long lunches. >Be arrogant. >Blame it on the developer. Go BDBAFH! Use obscure terminology to confuse users. Randomly batch delete chunks of data. Randomly drop or create indexes. Randomly bounce the …
RE: Routine DBA activities for Informix!!!
Come in late. Leave early. Take long lunches. Be arrogant. Blame it on the developer. Actually from what I have seen (which isn't that much) the following seem to always apply. 1. Watch space usage. 2. Ensure backup and restore strategy is reliable. 3. Tune database. a. Try to…
RE: fragmenting tables with RAID1
>===== Original Message From "John Stephenson" <JStephen@ctr.pcusa.org> ===== >Has anyone had any experiences, good or bad, using table fragmentation in >combination with RAID1 for their dbspaces? > >I like the idea of being able to intelligently distribute the data by >expressio…
RE: update statistics concurrency with application SQL
There is a performance impact on update statistics because it reading rows in tables and updating systables and sysdistrib. If one of you sql queries (programs) tries to search on a table using the column that update statistics is rebuilding at that exact time, then the program …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: oninit use 95+%cpu
richard palmer wrote: > Informix 'trainers' that I've been around tend to know about odd quirks > of the engine -- they hear about stuff from internal sources that we are Often true. > > rarely informed of. That said, I think the SERVERNUM suggestion is > a crock that I would …
error 750 - drop distributions work
Hi Guys, To correct the error 750 problem I droped the distributions while updating the statistics. Thanks a lot for all your help. Austin…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: Updating statistics
What do you mean not Y2K compliant? Are you talking about a DBCENTURY bug/problem or is this something new? Please give me specifics. Thank you, Tracy >>> <Dick.Brieck@chase.com> 12/15/99 2:20:51 PM >>> djw@smooth1.demon.co.uk wrote: "Move to 7.31.UC4 now! 7.30.UC6 is not Y2K …
Re: Updating statistics
djw@smooth1.demon.co.uk wrote: "Move to 7.31.UC4 now! 7.30.UC6 is not Y2K compliant and has bugs." I was surprised to hear this on December 13th! I thought we were compliant at 7.30.UC6. Would you please let me know what the bugs you referred to are? I am very interested. T…
Re: Updating statistics
Art, Thanks for your thoughts. In your answer to my first question you alluded to a bad index page flag problem. "...in 7.31 distributions MAY aggrevate the problem with the bad index page flags if you have an earlier version prior to the fix to that bug (fixed in 7.31UC4 or 5…
Re: System Admin Performance Tuning Exam.
From: "Neil Truby" <ntruby@netcomuk.co.uk> > >Follow my handy hints for performance tuning and you won't go far wrong: I don't think this will help Tracy pass the exam, Neil... :-) > >Disk Layout & Configuration >Don't bother. You'll have EMC or similar, and it's it's all so h…
Re: Updating statistics
In article <38555EBD.496B23B1@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Dick.Brieck@chase.com wrote: >> >> Greetings. I have a few questions regarding using distributions with IDS. >> We're currently using >> IDS 7.30.UC6 on Solaris 2.6. I've used Informix's pr…
Re: Updating statistics
Art, Sorry if I am being a little dense about this but I have a question about one of the suggestions you made to Mr. Brieck. In answer to question 3 you said: | |> 3) Are there any other resources to consider before using distributions on a |> large scale? | |Yes the data…
Updating statistics
Dick.Brieck@chase.com wrote: > > Greetings. I have a few questions regarding using distributions with IDS. > We're currently using > IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for > updating statistics on a > limited basis on our databases. I've bee…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Write cache help
Wayne Trieu <trieu@ti.L-3Com.com> wrote in message news:807t74$ufk$1@nnrp1.deja.com... > Hi all, Hi ! > Can some one please help me how to increase write cache, right > now my cache is about 73% it seem low. I've tried all source recommend I > see on this group, but did …
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: Update Statistics Plan for IDS 7.31
Obnoxio The Clown wrote: > > From: "Art S. Kagel" <kagel@bloomberg.net> > > > >Asside to Obnoxio: You guys were doing OK. What'd you need me for? ;-) > > If you have two indexes on a table, one on (a,b,c) and one on (a,b,d), > should you update statistics high on a and b or a,…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Re: Reac-Cache-Rate of a Data Warehousing System
From: "David Grove" <david_grove@health.state.ak.us> > >I'm wondering why achieving >95% read cache rate in a data warehouse would >be considered undesirable? Suppose you had several GB of shared memory. >You might be able to cache whole tables, or in a small warehouse, maybe >e…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: Reac-Cache-Rate of a Data Warehousing System
I'm wondering why achieving >95% read cache rate in a data warehouse would be considered undesirable? Suppose you had several GB of shared memory. You might be able to cache whole tables, or in a small warehouse, maybe even cache the whole thing. Light scans are fast, but isn't…
Re: Single CPU Performance Problems?
Art, Thank you - you have been very helpful! I am trying to find the best performance with this hardware platform before I start to add SCSI hard drives/more hard drives, etc. By the way - we have turned off logging for now. "Art S. Kagel" wrote: > I see the following: > > Y…
Re: informix parameters in onconfig file
edem wrote: > > Can anyone advise me what can i make better in onconfig file > Informix 7.30FC7 ( will be 7.31FC2 soon ) on HP-UX 11 ( machine V2500 6 > processors) > i am using kaio ( kaioon=1 ) > Any advise will be very helpful > Thanks! > > And this is my onconfig file : It …
write cache / NETTYPE
Webber Valerie H wrote: > How important is the % Write cache on the onstat -p (listed below)? > I read you should shoot for 85%..... ours is very low... 8% and > sometimes 0%. How do you tune the database for write cache. We do > mostly reads and inserts and very few updates. >…
dictionary cache parameters
Top Cat wrote: > > I read that the parameters (DD_HASHSIZE * DD_HASHMAX) should be greater than > the estimated number of active tables in all databases for performance > gains. Where the heck are these parameters? They are not in the onconfig > file. Environment variables? M…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
DS_POOLSIZE,DSHASHSIZE , DDHASHSIZE & DD_HASHMAX
Hi All , I am currently trying to set these parmaters and having difficultly get a rule of thumb to set these paramters. They are set to default values as we have not modified the onconfig files. The following is output from the :- onstat -g dic command. INFORMIX-OnLine …
Loading into Shared Memory...
Marshall Turner wrote: Well, there is the SET RESIDENCY feature in version 7.3 -- the syntax is something like --- SET TABLE tab_name MEMORY_RESIDENT The table will remain in the buffer cache as long as possible. Writing the table out happens normally via checkpoints/LRU wri…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
mutex problem
Help ! My engine has crashed twice in the past 3 days, & I don't really have any ideas why, except that I believe it related to shared memory somehow. ? The system has been very stable - until now. There have been no changes that I'm aware of. The os has not been swapping at a…
[update statistics high & syscolumns& distribution]
Hi, I am supporting IDS 7.24UC4 on HP-UX 10.20. It is recently upgraded from 7.23. After upgrade, some queries are slower than previous version because of changed query path. So, I 'update statistics high' for some table, but nothing changes. I looked up the syscolumns table, an…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Informix 7.30UC7XH Update Statistics
I would do seperate updates for each table .. however you need a better strategy than the one mentioned.. e.g. for a table with a primary key index something like update statistics medium for table <tablename> distributions only; update statistics high for table <tablename>(<pr…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
Re: read and write cache percentages
Art S. Kagel wrote: > > Everything looks fine except you definitely need many more buffers. > I'd start with 100,000 and work from there. Also with 240 users you > can need more than 16 LRUS which is verified by your enormous bufwaits > ratio of 25%, it should be below 7%. Go f…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
read and write cache percentages
Everything looks fine except you definitely need many more buffers. I'd start with 100,000 and work from there. Also with 240 users you can need more than 16 LRUS which is verified by your enormous bufwaits ratio of 25%, it should be below 7%. Go for broke and configure 127 LRU…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Re: DS_HASHPOOL and DS_HASHSIZE
kbg wrote: > > How do you configure DS_HASHPOOL and DS_HASHSIZE? > does these parameters exist on an IDS 9.14? That should be DS_HASHSIZE and DS_POOLSIZE (there was a typo in my article in TechNotes). DS_HASHSIZE is the number of hash list and must be a prime number. It default…
DS_HASHPOOL and DS_HASHSIZE
How do you configure DS_HASHPOOL and DS_HASHSIZE? does these parameters exist on an IDS 9.14? -- __________________________________________________ La meteo par le Web : http://www.meteoconsult.fr Meteo Consult - Bureau d'etudes meteorologiques Domaine de Marsinval F-78540 Ver…
Informix performance Issues
Dinkar Rane wrote: > > Art S. Kagel wrote: > > > OK here goes. > > > > Dinkar Rane wrote: > > > > > > We are facing serious informix performance issues, to the extent that > > > usres are not willing to use the system. [SNIP] > > > > Questions: > > > > 1) Are you updating statist…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Online Config Changes
From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Not necessarily. The variables can be reconfigured within the ONCONFIG >file while the engine is up; they won't take effect until the engine is >bounced. There's quite a bit of stuff that can be set dynamically. For example, o…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
DD_HASHSIZE,DD_HASHMAX, DS_HASHSIZE, DS_POOLSIZE
Hello list, Has anyone encountered either an absolute or practical upper limit to these parms? (excluding total memory requirements). I only recently got my databases updated with distribution statistics and much to my surprise encounter worst performance after the update. …
PC_POOLSIZE
Does anyone know how much memory is being used by the default Procedure Cache? I'd like to increase the PC_POOLSIZE, but I'd feel more comfortable knowing exactly what affects this will have. I've done some testing with PC_POOLSIZE, and the procedure cache always keeps (PC_POOL…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: UPDATE STATISTICS questions
>1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? Yes the distributions are created only by UPDATE STATISITICS MEDIUM or HIGH. Update statistics MEDIUM creates distribution by obtaining the random sample of the rows in the table. Whereas Update statistics …
RE: UPDATE STATISTICS questions
-----Original Message----- From: Dick.Brieck@chase.com [mailto:Dick.Brieck@chase.com] Sent: Monday, April 19, 1999 3:35 PM To: informix-list@iiug.org Subject: UPDATE STATISTICS questions I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS ME…
UPDATE STATISTICS questions
I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? Thanks for…
UPDATE STATISTICS questions
I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? Thanks for…
Re: The Fastest Way To Delete All Rows In A Table
>I could run UPDATE STATISTICS the following day but timing it is tricky. Why is this tricky? The process that inserts the data into the table can perform the statistics update for the table at the earliest possible moment with no danger of being too early. Assuming that the d…
Re: RESIDENT and PDQ
> > Also, as we all know, memory is cheap now. We would like to max out our > > Sun UltraEnterprise 3000 to 6G and cache up the entire database as > > resident, while still allowing substantial amount virtual memory. But > > it seems as though Informix is quite limited, permitt…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
UPDATE STATISTICS
Rekaish Bhardwaj wrote: > > Hello again everyone/ > Another quick question (I hope) > I'm slightly confused about the UPDATE STATISTICS command. > > If I do an UPDATE STATISTICS HIGH FOR TABLE tablename (col1, col2) > then do an UPDATE STATISTICS MEDIUM FOR TABLE tablename (col3)…
7.3x, 8.xx, 9xx Upgrade planning for OLTP product line
Will Roper wrote: > snip..... > Well, I've been called a lot of things, but never a troll, so I don't > think that's it. > OK, I got a little carried away...my apologies, no offense meant. > The million is a max - on the systems that do that, the daytime average > was more like…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
MORE RAM - BIG CONTROLLER CACHE / DB ON RAW - DB ON FS
I recently had a discussion with a consultant. The following is a replay of this discussion. I just wanted to see your opinions on it. I : Why do you only sell storage arrays with no cache or a small one ? X : Disk subsystems with GBs of NVRAM come from th…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Sizing the dictionary cache. Does anyone bother?
andy lennard wrote: > > Hi, > > I was wondering if anyone bothers to change the size and layout of the > dictionary cache to improve performance. I certainly do. I have engines with 1500 active tables, how else to force the engine to keep all of that data in memory? [SNIP deta…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: Way to determine UPDATE STATISTICS
Hi Jung-Hui, I got the following from a informix-training. Run UPDATE STATISTICS: - in MEDIUM mode with the DISTRIBUTIONS ONLY argument for colunms that have no indexes - in HIGH mode for columns that are the first key of a composite index - in LOW mode for each column in all m…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: B-Tree Levels of IDS
Lucie Janstova wrote: > Try: > select * from sysindexes > where idxname = "my_index"; This works if the statistics are updated by UPDATE STATISTICS LOW ... or UPDATE STATISTICS HIGH... on the table (MEDIUM does not update index statistics only distributions). > Lucy (lucie.jan…
Re: Best database for web backend on Linux?
This is a multi-part message in MIME format. ------=_NextPart_000_1916_01BDFD9B.6C0CD360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I pin my common procedures, so they don't get blown out of the cache. = In Oracle I have fairly …
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
Re: Distributions
Jay Aymond wrote: > > What is the difference in running the following two statements: > > (1) update statistics medium for table xzy distributions only; > > or > > (2) update statistics medium for table xyx (col1) distributions only; > update statistics medium…
Re: Distributions
Jay Aymond wrote: > > What is the difference in running the following two statements: > > (1) update statistics medium for table xzy distributions only; > > or > > (2) update statistics medium for table xyx (col1) distributions only; > update statistics medium…
Re: Update Statistics with Distributions
Jay, We had similar problems before with 7.23 on IBM AIX and Sequent Dynix. We did similar tests like yours (using 4 tables and a complicated join/subquery...etc) and ended up in the same conclusion as yours. We tried dropping the statistics (update statistics ... drop...) and…
Distributions
What is the difference in running the following two statements: (1) update statistics medium for table xzy distributions only; or (2) update statistics medium for table xyx (col1) distributions only; update statistics medium for table xyz (col2) distributio…
RE: Update Statistics with Distributions
Jay, You can get this kind of problem. The optimizer rules are to read the smaller table first (if you have a restrictive where clause that allows it to use an index), then join to the next table. The way I fix this problem is to drop the statistics on the smaller table. I am no…
Update Statistics with Distributions
I am running Informix Online 7.23.UC10 on a 4 Processor HP using HP UX 10.2. I was trying to imrove performance of some particular programs and noticed that "update statistics" was not being run regularly. After running the appropriate "update statistics" on all tables, most qu…
Opinions re: Sun OS disk caching with KAIO, On or Off?
Hello, For those of you using Sun boxes out there with Informix, help. Using 'top' recently I was looking at the memory free on our Sun E4000 (Solaris 2.5.1) and noticed that it was: Memory: 2048M real, 32M free, 52M swap in use, 972M swap free Notice the 32M free? After I r…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: DS 7.23 performance
Hi Niclas, first, read your Release Notes concerning the SHMBASE settings. You just have about 2000 BUFFERS, that is, 4MB of memory for your cache and about 8MB for the virtual segment. It must be possible to increase your cache. Your complete configuration file looks a bit as …
DS 7.23 performance
We have upgraded from Online 5.06 to Dynamic Server 7.23.FC1 on OSF1 ver 4.0 and have major performance problems. Some applications now are up to 6 times slower. Applications also once in a while receives error -25587 and -25588. I've tried to increase LOCKS and BUFFERS, but th…
Re: Multiple residency - 7.2.3 and 9.1.4
In article <35D20971.5E4@bloomberg.net>, kagel@bloomberg.net wrote: > harikoduru@my-dejanews.com wrote: > > > > Hi all, Is it possible to have both ODS 723 and IDS/UDO 914 running on the > > same machine, sharing data and resources. I personally feel that it is not > > possib…
Re: Multiple residency - 7.2.3 and 9.1.4
harikoduru@my-dejanews.com wrote: > > Hi all, Is it possible to have both ODS 723 and IDS/UDO 914 running on the > same machine, sharing data and resources. I personally feel that it is not > possible because they are two completely different architectures right now > but I nee…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: onstat -t output
Sadagopan, Sathish wrote: > > Hi, > The point is , I have all the tables populated with a large number of tuples > , whereas 'nrows' of onstat -t shows zeroes.Any explanation for that ? Easy. The nrows field is not maintained live it is only uptdated if you run UPDATE STATISTIC…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: onstat -g dic
>Someone knows what is the result of onstat -g dic ?? >Thanks. The Dictionary is the in core cache of information derived from the system catalogue of a database (i.e. those tables with tabid < 99 such as systables, syscolumns, sysindexes, etc). Added to this is some informatio…
Please help on BUFFERS configuration
Hello, This is the result of onstat -p: Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 55684746 62996402 402420642 86.16 585360 2321888 6684656 91.24 isamtot open start read write rewrite delete commit rollbk 158584062 4458…
Update statistics high vs medium
Hi, we are running Informix ODS v7.23 on AIX 4.2. There is a table with 27000 records look like this: TABLE dot ( dot_serial_num char(11) not null PK, dot_title char(82), create_dt date indexed) We have several queries that join multiple tables including this DOT t…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re[2]: sysmaster extents
This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable I have a couple of questions on this then=2E =20 I've got nothing set for DD_HASHSIZE or DD…
Re: Bad performance with DBSPACETMP enabled
Idiot wrote: > > > You have stumbled on a little known fact. Sorting is faster to > > filesystem space than to temp table space. And since you do not care > > about the safety of those sort-work files that's OK. > > > I am sure that you have tested this. Please excuse my ignora…
Re: Bad Distributions bug #91664
Don Simpson wrote: > > Heads up for all you running 7.24 and I believe 7.23 as well. Not sure > if all platforms or not. > B91664: > [REGRESSION IN BACKPORT OF FIX TO B80471. UPDATE STATISTICS PRODUCES > BAD ] > [DATA DISTRIBUTIONS AFFECTING QUERY PERFORMANCE. > > I recentl…
Re: Bad Distributions bug #91664
What version of 7.24.xx where you running? Steve Berg spb@nb.com On Wed, 22 Apr 1998, Don Simpson wrote: > Heads up for all you running 7.24 and I believe 7.23 as well. Not sure > if all platforms or not. > B91664: > [REGRESSION IN BACKPORT OF FIX TO B80471. UPDATE STATISTI…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: limiting oninits?
This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_6F3B737D.52335F71 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted…
Re: Detaching Indexes
>To spread the workload on our drives, we have taken the approach of >detaching the index from our tables. Our indexes are on one set of >disks and the data is stored on another set of disks (ie, physically >separate disks). > >If some cases we have seen comparable results when …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Performance With 7.21 and HSTools
Pascal PIZEINE wrote: > > We are using for our developments the following configuration : [SNIP] > Since we have upgraded informix 7.10 to 7.21, we have performance problems. > Some queries do not use index but sequential scan. This problem occurs only > with index on CHAR type a…
Re: sysptprof
Hi, Bill Ennis wrote: > I have a question on the sysptprof table in systables. The manual > says that profile information is available only when a table is > open. Does this mean that rows are deleted from this table when > no users are accessing OR does it mean that some inform…
the new bie with the share memory problem
Hi all: Thanks for all those who has responded to my previous question, you guy were a great help. Now I have put all the necessary stuff in /etc/system, rebooted, ran oninit -v, my results are: oninit -v Reading configuration file '/usr/yan/Informix/INFX_ODS_723/online/etc/o…
the new bie with the share memory problem
Hi all: Thanks for all those who has responded to my previous question, you guy were a great help. Now I have put all the necessary stuff in /etc/system, rebooted, ran oninit -v, my results are: oninit -v Reading configuration file '/usr/yan/Informix/INFX_ODS_723/online/etc/o…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: memory
Thuc Nguyen wrote: > > Hi > > I am running Online 7.23 on HP 10.20 > > We want to find out why we allocate alot of memory per user and never > release it. > > Is that memory leak? Actually you are probably not allocating any memory "per user". If your default connection, or the…
Re: HP HW/OS and Shared Memory Segments Problem...
Greg Moye wrote: > > Does anybody know if current HP hardware (and HP-UX) still has that > nasty problem where >2 Shared memory segments can *really* slow things > down?? > > If so, is it scheduled to go away anytime soon?? > > TIA - Greg OK, I've been researching this HP shared…
Update statistics Questions
Subject: Update Statistics Confusion Date: 10/9/97 9:08 PM We are running On-Line v7.23. I ran some test evaluating update statistics using the following SQL and we got some very strange behavior. Why? select count(*) from x_forms x,prdct_END e w…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: script or spl for update statistics
Zeljan Silje wrote: > > Hi, > > in Informix Guide To SQL Syntax there is recommendation for updating > statistics: > 1) run update statistics with distributions only > 2) run update statistics high for columns with indexes > 3) run update statistics low for multicolumn indexes > …
Re: Query Optimization question
Ignatius In version 7.x (not in 5.x) you can do: UPDATE STATISTICS MEDIUM FOR table(column) DISTRIBUTIONS ONLY The MEDIUM will do data sampling whether or not you create an index on the column. The DISTRIBUTIONS ONLY update the sysdistrib table in your database. In case you …
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
RE: Update statistics - Questions for guru's ?
Just an update for you all about this weird -750 error. This has now been identified as a new bug (77685). This bug is specific for 4gl applications running when an update statistics statement is running. Cheers, Tony. #include <standard disclaimers> ---------- From: EDWARDS, …
Re: Caching tables in shared memory
Hi, OnLine 7.3 will likely contain options to indicate that specific tables should be favoured for caching. This can be used to bias caching for highly active tables. Chris -- Chris Jenkins (chrisj@informix.com) Advanced Technology Group >>> All statements and opinions are…
Re: Caching tables in shared memory
Uh, Rav... That's what BUFFERS are for. Ask your DBA about this parameter. The system is designed to do it as best it can within limits of memory configured. Caching caches only works if you have a faster storage medium. You don't. BUFFERS is as good as it gets. Forg…
Caching tables in shared memory
Hi Gurus, Here are a few questions regarding caching of frequently accessed table in shared memory. During a recent setup , I found that in my code a few of the tables were accessed very frequently. These are master tables and this particular module need not do any updates on th…
Update statistics - Questions for guru's ?
Problem description. We currently run update statistics during the night ( 11 PM - 7 AM ) on the tables that have the biggest data distribution change through the day. The update statistics is controlled from a unix script that deploys each update statistics command one by one. …
Re: Help -- OnLine server refuses connections
With ur current configuration nugread are cached 95% (which is good) and bufwrits are cached only 37% (which is a bad omen). Couple of possibilities ... 1. it looks like a shared memory problem. Check BUFFERS size in onconfig file. Buffers should be fairly large to handle 30 co…
Possible to turn off file system cache?
Hi There, I'm working on a Solaris 2.5.1 machine which appears to be memory constrained. When I run sar -r 5 5 I see this: texas% sar -r 5 5 SunOS texas 5.5.1 Generic_103640-04 sun4u 04/19/97 22:42:39 freemem freeswap 22:42:44 2085 2896453 22:42:49 2110 2896128 22…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Pablo Sanchez wrote: > In article <3351f3b1.8299223@gate.idg.no>, Nils.Myklebust@idg.no writes: > > ichudov@algebra.com (Igor Chudov @ home) wrote: > > > > :I have been asked to do a comparison of captioned database engines, > > :to choose a database server for a medium size data…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5ith88$14g@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes >[ 1 - I've snipped, what I believe, were a whole bunch of unrelated > newsgroups from this note. I've left only the comp.database.* > > 2 - If you disagree with what I've written, let'…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
[ 1 - I've snipped, what I believe, were a whole bunch of unrelated newsgroups from this note. I've left only the comp.database.* 2 - If you disagree with what I've written, let's be constructive. ] In article <3351f3b1.8299223@gate.idg.no>, Nils.Myklebust@idg.no writ…
Re: Help with composite indices
Peter Whittleton wrote: > > Irwin Goldstein wrote: Hi all, I'm wondering whether the recommendations below are really from Informix. UPDATE STATISTICS HIGH and MEDIUM generate data distributions for the optimizer. This information must be read if they are available. If the optim…
Re: WWW.INFORMIX.COM - Nils, of course, right?
I just relize from reareading your post that you didn't actually complain about the server itself, but simply the graphics they display on the home page. I first read it as a complaint about their datablade techonology. I was far too fast, and appologize for my then more than un…
Re: Help with composite indices
Irwin Goldstein wrote: > > Check out http://www.objectsoft.com (shameless plug) for a > script which automatically performs an appropriate sequence > of UPDATE STATISTICS commands for specified tables. > This script is great, but it doesn't reflect the latest recommendations fro…
Re: BUFFERS setting
In article <32BACDF0.3467@informix.com>, Dave Kosenko <davek@informix.com> writes >Bill Ennis wrote: >> >> You need to consider that you will be reading from the buffers as well >> as writing to them. >> >> I would be careful lowering since your read cache percentage is already >…
Re: >1 Virtual Shared Memory Segment slow down
If you're on an HP, set up you system to need only one or at MOST two virtual shared memory segments. The difference in performance between 1 and 3 is in the 400% range. It's a defect/feature/whatever of the HPs, but it's a real issue.. davek @ informix.com ("David L. Kosenko…
Re: >1 Virtual Shared Memory Segment slow down
"David L. Kosenko" <davek@informix.com> writes: > > David Williams wrote: > > > > I've been told by Informix that having >1 virtual shared memory > > segment slows down your Informix Online Database server.[snip] > > Why would added more shared memory segments slow down …
>1 Virtual Shared Memory Segment slow down
I've been told by Informix that having >1 virtual shared memory segment slows down your Informix Online Database server. Informix normally has 3 share memory segments 1 Fixed size 'Resident' shared memory segment for disk cache etc. 1 Fixed size 'Message' shared…
Re: Update Statistics Low, Medium & High
This is a multi-part message in MIME format. --------------5C6612934DBB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Clem Akins wrote: > > >In our system, we discover sometimes some tables in index searching is much > >faster while we update their …
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: OnLine 7.X performance - R U satisfied?
ray, > Are you taking full advantage of you physical memory? How does you > caching ratios look (onstat -p)? If not in the 90's play arournd with caching ratios are good, high 90's. > BUFFERS and SHMVIRTSIZE. Also, is the engine frequently allocating > additional shared…
Re: Good Buffer Size For Tuning Informix?
Hi Michael, The only really important factor in determining the number of buffers is the read and write cache hit ratios reported by tbstat -p. Keep increasing the number of buffers until these cache hit rates do not increase when the system is running a 'normal' workload. This …
Re: Distributed Join
> relevant to the best solution today. As to distributed optimisation, ------------------------------- > OMNI does optimise distributed joins (because unlike its competitors, ----------------------------------------------------------------…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: DBMS Selection for 500+GB data and 500+ Users
msigler@informix.com (Mark Sigler) writes: > >Don't be sucked in to oversizing the hardware. Oracle will tell you that >the only way to scale that large is with an MPP system. Funny that I've >done it with Oracle on large SMP systems from Sun and outperformed MPP. >which causes …
PRESS VERSANT TO PROVIDE REPOSITORY FOR INFORMIX-NEWERA DEVELOPMENT TOOL
VERSANT TO PROVIDE REPOSITORY FOR INFORMIX-NEWERA DEVELOPMENT TOOL VERSANT ODBMS Selected to Provide Distributed Object Repository for Team Development Boston, MA (March 21, 1995) -- Versant Object Technology Corporation (Versant), the leading provider of object database manage…
Re: Keeping clean pages in shared memory
In article <3j7t1r$dbh@infmx.informix.com>, David Kosenko <davek@informix.com> wrote: > >Raj Gopalakrishna writes: >|> I am aware of the fact that flushed pages are not removed from the >|> cache but what I was trying to say that the effectiveness of the >cache is lost >|> for wr…
Informix Perf Question
I have setup an informix database on a Sparc10. 5.00.UC3. The configuration is generally the same as other servers I have but it runs different applications. I have noticed that this server generally has 0% - 30% cache reads and 80% - 95% cache writes. On the other servers th…
Re: Database tuning.. any hints?
Don't worry too much about the write caching rate. Although the book says that you should aim for 80% this assumes a well-balanced application. If you are doing a large number of INSERTs of large record sizes you will probably not achieve very high caching rates. Think about t…
Re: Can this be done?
In article <3adhaq$g49@gv-gate.gvg.tek.com>, martina@gvgtsg.gvg.tek.com (Martin Allred) wrote: > I was thinking, so look out. Can OnLine use a RAM-disk for the primary > database storage and put the mirror on a real disk? This should allow > for some serious speed improvements w…
Questions about Informix page buffers
Hi, in reading the Informix documentation, it mentions that page buffers are used to cache data from disk. It mentioned that the page size and number of pages are dependent on the database server and O/S. I am unclear on what the dependencies are other than the available memory a…
Questions about Informix page buffers
Hi, in reading the Informix documentation, it mentions that page buffers are used to cache data from disk. It mentioned that the page size and number of pages are dependent on the database server and O/S. I am unclear on what the dependencies are other than the available memory a…
Need Info on INET for Unix
We have a UNIX client-server application with Informix running on the host computeraccessed via esql only, and a series of workstations on an ethernet currently caching data with a cheapo flat file DBMS called c-tree. This has led to a lot of special purpose distribution softwar…
Re: BIG Istar performance problem
Paul, thanks for fast response, >> On the server I have 300 to 500 sqlturbo processes. No frontends >> runs on the server. All frontends are version 4.10.xx and all >> backends are version 5.00.xx. The slow connection with Istar is done by tcp/ip. >We have a Sun IPC (small, si…
Database monitoring tools
I am interested in tools to monitor Oracle and Informix databases over time in a distributed UNIX environment. Desired features include: o Predict future resource consumption based on past usage over time, and report problems on an exception basis. For example: Based …
Re: Systables in local cache (was: Correcting Next Extent problems).
}From: uunet!pyra.co.uk!graeme (Graeme Sargent) }Subject: Systables in local cache (was: Correcting Next Extent problems). }Date: 1 Mar 93 10:20:09 GMT }X-Informix-List-Id: <news.2727> }In <1993Feb23.160915.5802@informix.com> (Dave Kosenko) writes: }>Contrary to what the manuals…
Systables in local cache (was: Correcting Next Extent problems).
In <1993Feb23.160915.5802@informix.com> davek@somerset.informix.com (Dave Kosenko) writes: >While Jonathan is correct, I will venture to say that this entire >discussion is misguided. Contrary to what the manuals lead you to >believe, having more than 8 extents will not have an…
Re: SQL Precompilers (preoptimize!)
Path: emory!swrinde!elroy.jpl.nasa.gov!orchard.la.locus.com!prodnet.la.locus.com!jfr From: jfr@locus.com (Jon Rosen) Newsgroups: comp.databases.informix Message-ID: <1992Mar04.203112.01004902@locus.com> Date: 4 Mar 92 20:31:12 GMT References: <1992Mar4.160455.12513@rock.concert.n…