Oninit® Archive
Results for “RA_PAGES”
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
Large memory segment vs smaller ones
Hi Dennis. Yes: " vmo -p -o v_pinshm=1". You must have RESIDENT 2 or more for large pages as they must be pinned. The "rsam" pool is in the dynamic segment. You need RESIDENT 2 or more. It doesn't sound like the problem is with the buffer pool but the "rsam" pool. Your BTR is fin…
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 ------------------------------…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
Buffer wait occurs when performing INSERT in multiple sessions
You have to only peripherally related problems. The issue about not enough KAIO resources is an operating system tuning parameter. You can read the maximum value and set it here: $ cat /proc/sys/fs/aio-max-nr 65536 echo 131072 >/proc/sys/fs/aio-max-nr # set new maximum And see …
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
Index page size recommendations
16 k for indices is a good starting point. After that is depends on the data. If I am using TS then I would tend to have dedicate spaces as well. And yes you need a buffer pool for each page size. Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trade…
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…
Problem with backup
Original post: Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thank Response: The answer is possibly. At the start of every backup, the server…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
Connections over SSL
Clients need to have read permission on the files configured in SSL_KEYSTORE_FILE and SSL_KEYSTORE_STH .…
Creation on read only user.
Hello, 1. I have 2 user in my instance i.e. 'USER1' and 'USER2'. 2. 'USER1' and 'USER2' can Execute SELECT, INSERT, UPDATE, and DELETE statements as they gave got 'CONNECT' database level privilege, that comes with default 'PUBLIC' role. 3. I want to create 'USER3' that should…
Informix 11.70: Stored Procedure SQL exceptions
Alexandre, I should also explain that I set up a WHILE loop to read from a select cursor. Thanks, Bob…
EXTERNAL table read
Hi, How can I read one external table as an usual table, is it possible? Can I do select from one external table created by another program? As I only have seen operations over external table after create...??? Thanks for any help, SP…
Not sure if I have a problem with CKPs
Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
RAU
Hi, our current onconfig value for RA_THRESHOLD and RA_PAGES are 30 and 32 respectively. Do we need to increase/decrease both values? how can we measure the amount of increase/decrease we need to make? or is it a trial and error thing?…
SQL using the index
If I find one index has high buffer read, How to know which SQL use this index?…
Restore secndary from primary fails
Issue was solved. Primary had a backup filter and secondary couldn't read the backup from STDIO…
Could not position with in a table
Hi Mukesh. You probably have uncommitted changes to that table by another session, which results in exclusive row locks. If your application has the default SET ISOLATION TO COMMITTED READ, it will abort when it tries to read those rows. When you start a new session, execute SQ…
BUFFERPOOL Configuration
Oh, one more reason to use multiple page size buffer pools: - To be able to isolate the IOs against some objects from those of other objects so that, for example, index IO activity does not flush data pages from the cache.…
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…
Dbexport very slow
dbexport supposedly unloads the tables by reading sequential. Update statistics should be irrelevant in this case. What about the amount of data produced by that massive inserts?…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
Users from a database Import
I'm missing something to this whole thing. If Public has connect, it has read, write update and delete. I want the user to have only read and write to the entire database. Doesn't every user have public so he has read, write, update and delete?…
dbexport
my command doesn't seem to work. Reading the documentation...…
reading committed data on hdr
We are using informix IDS 12.1 with an HDR in near_sync mode. Some applications read data from hdr. We found that uncommitted data is also read n hdr that some times rollaback and information delivered at that instance does not recoincile. One solution might be keep the hdr in fu…
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.…
Cannot read from sysprocplan
Hi, we are seeing an error through an application when it tries to do a select on the database, but if we go on the server and use dbaccess, the select statement works. Anybody know anything about these errors? 12/08-09:22:26.211 [01] <002:0001:> (01) ==> inf_exec_stmt: (-211,-1…
Informix 12.1 Blocking Checkpoints
> On 7 Nov 2017, at 10:48, NATYURAL HORACIO <horacio.natyural@gmail.com> wrote: > > Hi, > > > Based on the current workload, the physical log might be too small > to accommodate the time it takes to flush the buffer pool during > checkpoint processing. The server might block tran…
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…
Secondary stuck in Fast Recovery
Hi, from reading other posts, it seems like I need to restore secondary so I will give that a go now.…
identify what is allocating memory
original post: Hi , How identify what/who is consuming memory in a specific virtual memory segment ? With onstat -g ses , there is no session with high memory allocated. The amount of users sessions is keeping at regular average... No buffers pool was allocated automatically (I…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
SQL have most IO read
HI, How to monitor which SQL has the most IO read operation? thanks for your time.…
Re: RE: Dev server restore fails
Hey Martin, believe me when I say I have read and read and read before I ask my questions. I think I have at least 6 different manuals for informix 11.5 and I'm guessing they have to be 10,000 pages. :)…
Buffer pools in 11.50.FC5
IDS 11.50.FC5 Solaris 10 Sparc I need some guidance on BUFFERPOOL. I am receiving the 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 threads. I am not sure how that translat…
IDS 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
Negative pages read in chunk
I have some system monitoring that captures pages read from each chunk. This is simply "select fname, pagesread from syschktab" For the most active chunk in the instance this statement returns a large negative number (-1,181,472,262). However an onstat -D returns a larger positiv…
updatable SDS
I just found the answer: The only isolation modes that are not supported at the Secondary server are REPEATABLE READ and CURSOR STABILITY.…
Odd Bufferpool Behaviou
Original post: AIX 6.1 IDS 11.70.FC8X8 I have a new machine with a lot of extra memory. Given that, I added a bunch of new buffers (4k, 8k, & 16k) and went to town testing away. Long story short, with all those new buffers, I get virtual segments added at startup. In onstat -g …
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Data loading quesiton
the customer will run the read only application on HDR, so reinitilize the HDR is not workable , the read data is about 60TB, ifxclone take about 9 hours.…
External table problem
I'm reading from a file and for the rejectfile of course informix should write…
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)…
dbspaces corrupted
Thanks so much. After fixing the read-only problem on the dbspace how does one bring the chunk back on-line?…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
Root db space fills up
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
Physical Log Size
IDS 11.70.FC8 AIX 1 6 00CC96664C00 I received the following message in the online.log file ..... is it something to be concerned about ? Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoi…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
virtual segment question
I read the online.log, it's dynamic lock allocation lead to the problem…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
new bufferpool
original post This concerns ids12.10TC3IE . These are the old lines in my onconfig... #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 #BUFFERPOOL size=4K,buffers=100000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 #BUFFERPOOL size=16K,buffers=…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Buffer Size and Use
Folks, We recently had a conversation with a well-respected name in the Informix world, recently, concerning our bufferpool configuration. When exported, our database takes up only about 18 GB. We had a buffer pool of 12 GB, figuring that the more memory resident, the better. Al…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
can we have to hdr servers ?
In fact i will use it for backuping the production. Is the rss read. Only. Likr hdr ?…
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.…
onstat -g ckp Question
When we are transferring an index from the primary to the secondary we = have a problem. All the work and maintain a clean buffer pool on the primary= is done all the index is being built. However on the secondary there is no= way to keep the buffer pool clean. If we do not keep …
How to set up temporary space per session
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
CREATE FUNCTION() containing ORDER BY clause
Excellent point Fernando! It seemed very obvious as I read your response. Thank you for pointing that out.…
recover SQLHOSTS file
Do the onconfig files also have that info?…
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
Ifxclone issue
Is it logging anything at all on the primary or secondary? is the primary still available for reads and writes or does it hang?…
Auditing HDR server
good evening, can we audit an hdr server ? which is, by definition, on read only mode :) thanks in advance…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Dirty Read with Coldfusion
Hey, all. We're running ColdFusion 9 against an 11.70.FC7 instance, and it insists on using Committed Read. I set up a sysdbopen() to set it to DIRTY READ, but it doesn't seem to honor that, almost as if CF9 is explicitly executing SET ISOLATION TO COMMITTED READ (or, more like…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
Indexes on Null values
For oracle, I have read that nulls are not indexed. How does Informix handle null values on a column that has an index? Thanks…
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,…
Bufferpool max size in Windows Server 2008 64bit
Hi, I restarted engine once more and now it looks right. So, probable user error! Are there other memory parameters that would benefit from very large values? Thanks, Lauri d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
buffer pool and dbimport (11.70FC5)
Hi, I'm facing a problem and i don't understand how is it possible ... I'm loading (dbimport) a big table (> 3 Million records) and my buffer pool becomes quickly full (700000 buffers with LRU min = 0.50 and max 1.00). Checkpoint is not trigger until CKPINTVL (180) and you can im…
shared memory
This concerns IDS 11.70.TC5IE on Windows Server 2008 . This article http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .perf.doc%2Fids_prf_750.htm defines buffer_value = (BUFFERS * pagesize) + (BUFFERS * 254) + 250000and goes on to say: âIf you hav…
Disabling LRU flush
Hi, IFX 11.70 FC 5 Innovator-C , Linux 64bits OpenSuse. I'm working with database load. Basically I'm using HPL, unfortunately some tables have huge rowsize0 (1 row size = 2 pages) and lvarchar datatype which force use deluxe mode. Consequently use buffer pool , and then LRU fl…
btr
How can the BTR be 334 while the %cached for reads is 91% to 95% ? (This is ids11.70.TC3IE )…
BTR on each buffer pool?
This concerns IBM Informix Dynamic Server Version 11.70.TC5IE . I have a 16k page size space where I put a temp space and all primary and foreign key indexes. Since I can select nbuffs, bufwaits, bufwrites, pagreads from sysmaster:sysbufpool I can get the BTR on each pool. Should…
Re: help with informix on windows oncheck -pr erro
thanks for link Fernando I will do some reading…
Correct method of sizing resident pool...
Hi all, I have a script that reads an onconfig file and outputs an estimated memory footprint of the instance. However, I am finding it hard to accurately predict the resident section size. According to http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com…
Informix Auditing
Hello, I want to know the difference between following two audit Mnemonic. ACTB Access Table RDRW READ ROW Thanks in advance.…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
What are best onconfig parameters for a DSS app
Someone posted this answer in http://stackoverflow.com/questions/10477914/which-of-the-ids-11-70-onconfig-para meters-can-be-changed-to-maximize-performanc and your reply contradicts some of the following: "..But in essence, DS_MAX_QUERIES is the maxumum number of parallel que…
"IDS seems to have shutdown cleanly"
Hmm, so wouldn't a better message be "onclean didn't find any problem that needed cleaning"?.. the "seems" made me feel like IDS could not totally guarantee that any problems were detected!.. Let me ask you this: I know for a fact that if an SE server crashes, it has no way of d…
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…
hello
wow give this a look http://www.panews15.net/biz/?read=6647671…
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 …
ZFS and Informix
I'm well aware that the buffer pool has nothing to do with the underlying file system. We're just trying to figure out what scales better. We know that ZFS's ARC scales very well (the algorithms come from IBM !!). I trust though the people that have been out in the trenches worki…
lock problem
check your isolation level as well. are you in repeatable read? thanks…
Informix Status Explanations
hi, can anyone shed light on this for me. what does this mean? status yield bufwait- does it mean i'm lacking buffer pools? what does this indicate? cond wait netnorm - session is not doing anything. running- does it mean the sql is currently running. yield lockwaits - does th…
Informix Locks On Select count(*)
Also, Will setting isolation to dirty read help with this? Thanks…
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
Informix process reads a lot of pages
Hello, I have a problem with Informix 7.31.UD8 on Linux. One of the Informix process reads a lot of pages. Can I see what does do this process? Why this process reads pages, when nobody use IDS?…
ONBAR restore error
I'm trying to restore a ONBAR backup It was a full system backup using ONBAR -b -w to disk When I try and restore it using ONBAR -r -w I get the error below in ism_watch what is the error and how can I fix it thanks Up since: Thu Oct 13 12:19:10 2011 Version: Informix_Stora…
4GL Read file
Hi, I want to use the new OPEN FILE, READ FILE, CLOSE FILE in Informix 4GL. Could anyone direct me to detailed documentation on it? I can't find any description on how to detect EOF in the READ statement as the READ statement does not seem to return a flag. Any help will be appr…
reading: Bad file descriptor
I'm trying to restore an onbar backup that is done to disk does the error reading: Bad file descriptor in ism_watch refer to a corrupt onbar file or something else ?…
RE: Performance v11.70.fc3
Art, Here is the onconfig.std part that talks about this. v11.70.fc3 # # RA_PAGES & RA_THRESHOLD have been replaced with AUTO_READAHEAD. # # AUTO_READAHEAD mode[,readahead_cnt] # mode 0 = Disable (Not recommended) # 1 = Passive (Default) # 2 = Aggressive (Not recommended) # rea…
Increase buffer pool size
Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page…
Informix question
Original Post: Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
ids 11.70.fc3 read ahead
it could be a defect as it seems to be that read head is behaving in either passive mode or not behaving period. # If the AUTO_READAHEAD configuration parameter is is set to 0 and there is no RA_PAGES information, the server performs passive read-ahead on 128 data pages when com…
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…
Upgrade to 11.70 from 11.50 results in low Read Ahead Utilization
I recently upgraded from 11.50.FC3 to 11.70.FC3. As expected, the upgrade was painless and there are no apparent issues as a result of the upgrade. One thing that I do notice is my Read Ahead Utilization (RA-pgsused / (ixda-RA + idx-RA + da-RA)) is in the toilet after the upgra…
Informix ... and marketing.
Informix ... and marketing. Please read this important post! : http://t.co/k0QfC0s #Informix…
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.…
must read.!!
way cool am baffled!!!!!! http://www.informix-zone.com/redbook-draft-version-ibm-informix-flexible-grid Thanks!!! Superboer.…
ER error
If I am reading it right cdr finderr 1 1 A connection does not yet exist for the given server. Is replication actually working ?…
ontape -p/r with changed ROOTPATH
Jack Parker Wrote: ================================================================================ Not sure if you noted that you also need to change your $ONCONFIG = ROOTPATH to point to what is on the backup image. j. ==========================================================…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
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…
informix dropping idle connections
Thansk for info Art John cant read your post…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
PDQ and Growth Edition
On 12 Aug, 20:21, LIGHT SCANS <light_sc...@yahoo.com> wrote: > Hello Neil, > > Try putting your TEMPDBS in ramdrive. That should speed up the > sorting required to create an index. Also, make sure your swapping is > zero. > > Just for grins, I would try everything: Define tabl…
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…
Tremendous number of reads
Hi guys, any ideas how to investigate or determine the casue for the following ? Platform Solaris 9 on sparc, Informix 9.4FC5 New application causes a very high cpu-load, and we see about 2BILLION reads on a specific index in 1 day (more then 4 million in a minute) for 2 other…
Re: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
data access control
Folks, IDS11.10 UC2 AIX5.3 We granted READ permission on most of our tables to Public. So all valid users have the default read privileges. We are going to have an exception : An newly added user will be prevented from reading some tables that are granted to Public already. W…
An interesting read...
http://radar.oreilly.com/2010/03/joe-stump-talks-location-and-n.html What makes it more interesting is that some of the readers relate the inability of MySQL not being able to scale as something all databases are unable to scale. XPS anyone? Sorry for those who don't think out…
Cannot read systemcatalog
Hi guys, During execution of "update statistics" scripts, which are build based on the performance guide and the recommendations of John Miller we have following issue on Solaris with IDS 9.4UC7. Database is in buffered logging mode. In the scripts , for every 100 statements we…
RE: Long Checkpoints with HDR and 11.5.
Art Kagel wrote: No, Jacques, IDS secondaries do not share buffer pool updates with the primary. Only the logical log buffers are transferred, so only the server's transaction rate would affect the data transfer rate between the servers and that would be about the same regardles…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
Is there a gateway issue?
I'm reading on c.d.i UseNet. It seems that there are replies that are referenced that I don't see. Is there an issue with the gateway? JWC…
Network Buffer Pools
IDS 11.50.FC5 AIX 5.3 For HDR replication between two AIX 5.3 servers, is there a suggested value for the following environment parameters: 1. IFX_NETBUF_PVTPOOL_SIZE 2. IFX_NETBUF_SIZE 3. Sqlhosts option b (client buffer size) The primary has 64GB of memory while the second…
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
Hi, The RA_PAGES parameter is the same in version 11.10 and 11.50? What is the definition of your DBSPACE ? Did you try 8KB? This issue is interesting, where is the bootleneck? Do you have WSTATS parameter enabled? Run your query and sysmaster:sysseswts for your session. Vagn…
Congratulations to Warren Donovan as the Fastest D
Warren, If your out there "Congratulations" I just read you are the fastest DBA. -- Eric B. Rowell --000e0cd70dbe5a2de90477181a6b…
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…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
onbar backup exited 151
Thanks Martin, You are right... Secondary Server can't be backup... Upon reading most all informix forums and your confirmation. Regards.…
Create index errors
Sorry - bad bit of reading on my part! Could it be number of extents/extent size for the index?…
Re: SSD --- The reliability of
Question how many times do you read write to a hard drive in a year? Question how many times do you think you will read write to a ssd in a year? Then go and buy a usb stick and read write to it then come back and tell us how long it took you break it. And how many read write op…
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…
physical log might be too small
Hello, We are getting following error while checking checkpoints "Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. I…
Catering for slow(er) drive access
Here's an interesting scenario.... We are being pressured to move our Informix database engines (IDS 11.50.xC2) between datacenters from physical Solaris machines with direct-attached drives to non-global Solaris zones with SAN drives. All tests on the new hardware show that th…
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 …
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…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
Buffer Pool
Hi, We are running informix 9.4 FC5xs with SAP. Our SAP admin recently advised that the INFORMIX buffers were set to low. Based on some SAP recommendation, we increased the buffers parameter from 301049 to 501049 (about 600Mb to a little les than 1Gb. 2 days later I found the fo…
dirty read isolation in views
Is it possible to create views with dirty read default isolation -or- run views in dirty read isolation? IDS 9.4UC8 Redhat Enterprise Linux 3 AS DISCLAIMER This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments theret…
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/.…
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
Change the informix database to read only
Dear All, I want to put one of my informix database to read only mode. Can anybody provide the solution to change the database to read only mode. Thanks, Gulshan…
Re: Best Use of Free Memory
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: 1. The required data is already in the buffer pool. In this case the thread nee…
Best Use of Free Memory
BUFFERS is generally a good place place to use extra memory, subject to a couple caveats: 1. If the working set already fits in the current buffer pool, adding still more buffers will not produce any noticeable performance increase. Check "onstat -g buf" output for your %cached.…
v11.50.fc2 excessive kernel reads
I just installed v11.50.fc2 on an Aix 5.3 system. Only changes to the config file was that I changed the sqltrace to be global and not user ... and I added SCANNER num=2,treashold=500000,rangesize=100,alice=6 previous that was not set ... Since the upgrade the kernel reads on …
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…
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…
If there were no onstat...
Noonan! I hate when I screw up a contraction... Think the title was also bumbled... should read If there was no onstat. MM…
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…
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?
Great Mr Kagel! i guess now working with IDS 11.* we get performance advisory in online.log but ur calculations and adivisory are of great help. Pls could you give us the formule for calculating Bufwaits Ratio (BR) Buffer Turnover Rate (BTR) Readahead Utilization (RAU) especi…
Anyone else read CRN ?
CRN - Computer Reseller News , a CMP publication... April 28th issue. IBM insert in the plastic wrap. Its a SWG advert. Interesting notes: 1) Information Management pillar had 5 products listed. The most of any brand ... 2) Note to Jerry K. Does it make sense to sell IDS as …
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
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…
Informix Helps Clean up London
Please read this case study for details. http://www.informixcity.com/downloads/LB_Camden.pdf…
Informix strong in the UK
Please read the following case study demonstrating Informix is still active in the UK. http://www.informixcity.com/downloads/Exel%20Case%20Study.pdf…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
Extent DB
I will read a bit more. The key answer came from Marcus. After reading a lot I thought: Disk->DbSpace->Chunk but now I think Disk->chunk->DbSpace Thanks for helping Freudi…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
HDR Secondary mode Log transfer handling
How the Informix handle the locking between the read only access and updates from Primary Database to Backup database?…
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
Error reading buffer on onunload
Hi i'm running informix 7.31 on a Compaq Proliant 3000. If I perform an onunload of small database, for example 130 Mb, it will finished without errors, but if I perform an onunload bigger than (15 Gb) . It returns the following error : " Error reading buffer ". The tape device…
Re: 9.40FC9 BUFFERS limit
On Jul 25, 4:41 pm, <eshkambx-i...@yahoo.com> wrote: > Hi > > Does anyone know what is real maximum number (not from release notes) of BUFFERS parameter for IDS > 9.40FC9 for Solaris 10? Exact Solaris version is: Solaris 10 11/06 s10s_u3wos_10 SPARC. > > Situation: > > We have ne…
description of onstat -g ntt
Hi Karl, From IBM Performance Guide v9.4, we can find this explanation on the q-exceed field: << output output field Description -------------------------------------------------------------------------------- -------------- onstat -g ntm q-exceeds Number of times the free buff…
Re: Strange behaviour of the buffer pool
On Jul 17, 8:57 am, RoB <pluma...@gmail.com> wrote: > >My post to the news group is taking forever. In any case, I looked > >around a bit and it seems like the easiest way to get your resident > >section to become larger, other then BUFFERS in the $ONCONFIG, is the > >LOCKS para…
Re: Strange behaviour of the buffer pool
On 17 Jul, 12:10, RoB <pluma...@gmail.com> wrote: > Hi all, > > IDS: 9.40.FC3W2 > OS: HP-UX 11.11 > > What am I missing here? An instance is unexplainably allocating 224 MB > of buffer pool in addition to the amount configured. > > The BUFFERS onconfig parameter is set to 6250 (=…
Re: Strange behaviour of the buffer pool
Looking at a larger instance on the same versions I can see the "resident" pool being 354MB while the "res-buff" being the same the BUFFERS setting: onstat -g mem|grep " R " res-buff R c00000001669d040 1280004096 2848 2 2 resident R c000000000491040 …
Strange behaviour of the buffer pool
Hi all, IDS: 9.40.FC3W2 OS: HP-UX 11.11 What am I missing here? An instance is unexplainably allocating 224 MB of buffer pool in addition to the amount configured. The BUFFERS onconfig parameter is set to 6250 (= 12.2MB): onstat -c|egrep "BUFF|SHM" BUFFERS …
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: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
Re: Slow database creation and loading
On Jun 18, 10:50 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > If you are using HPL, that grabs it's own memory. Data does not go through > the normal buffer pool (unless you are using deluxe mode). You might not > want to increase buffers. I need to double check but I…
RE: Some interesting reading
I was trying to find the origins of Informix & Oracle. Someone told me that Roger Sippl & Larry worked for the same company, had different ideas, resigned, and started their own databases. But I don't know if this is true, or just a story. While searching for more inf…
RE: Some interesting reading
You forgot http://en.wikipedia.org/wiki/IIUG -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Dirk Moolman Sent: Thursday, June 07, 2007 16:29 To: informix-list@iiug.org Subject: Some interesting reading http:/…
Some interesting reading
http://www.storyofinformix.com/ http://en.wikipedia.org/wiki/Informix http://en.wikipedia.org/wiki/Larry_Ellison Dirk Moolman Database and Unix Administrator Agility Technologies (HealthCorp) "People demand freedom of speech as a compensation for the freedom of thought whic…
Optimizer Question
Hi For better performance some key aspects are 1. Fast checkpoint ( in your case its 600 -> try to reduce it to 480) 2. RA_PAGES and RA_THRESHOLD increase values to RA_PAGES to 32 or above and RA_THRESHOLD to 30 As you have IDS 9.4 you also should check for LRU_MAX_DIRTY , LRU…
Re: Is IBM actually doing something with IDS?
> Otherwise they would > not have introduced Oracle like features , like > read consistency (read don't block writes > and vice-versa). And since it is Informix I > can bet it will do a better job than Oracle > at read consistency without locking. > Also RAC like shared disk fea…
look like something reputable
anyone in IT knows whats happened re: isoft CSC NHS IT corporate raiders corporate scum (read posts to comp.databases.pick informix people)…
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.…
Must Read!!!
Excellent material is available for test drivers on code providing enormous in depth information of the suggested test programs. Don't miss it! http://www.it-techexperts.com/Tutorials/KometTest.asp…
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…
Must Read!!!
New material has been added for the Silktest and WinRunner feature descriptions focusing on the day to day functionality provided by both the tools used for software testing. http://www.it-techexperts.com/Tools/SWFD.asp…
Connecting to IDS 9.4 from Linux x86_64
[authlive] should read [mydb]…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
index build performance
Back on that 1.1 billion row table again. Thanks to help from sources here, I was able to get the named pipes working to half the time for a load and unload for the table. Now I'm concerned with building the indexes. From sources here also, I am going to bounce the server and us…
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…
A Must Read !!!!!
I have not been able to find a proper tutorial for WinRunner & LoadRunner at a single place. This has been a good effort to share WinRunner knowledge and I am sure that this Blog would grow into an excellent resource over the time. http://test-techtools.blogspot.com…
How do I read a file with Informix 4GL?
What is the best way to read a flat file using Informix 4GL? Thanks…
dirty reada to committed read
Hi, Refer the follwing link. http://www.iiug.org/waiug/archive/iugnew84.html Regards, Premnath Srinivasan "eferreyra" <eferreyra@gmail. com> To Sent by: …
dirty reada to committed read
Hi, i start a program that uses ODBC for connect to an informix (7) IDS, i start the connection with isolation level of dirty read, but in some point checking the SMI tables i see connection have isolation level of committed read. I dont change the level via set isolation level …
an XBSA reference implementation?
Hello, Does there exist an XBSA reference implementation? I would like to read the source. Thank you, Vasili I. Galchin…
an XBSA reference implementation?
Hello, Does there exist an XBSA reference implementation? I would like to read the source. Thank you, Vasili I. Galchin…
RE: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
Total length of columns in constraint is too long
Hi, We recently migrated our application from MySQL to IDS. While the migration (post DDL and few other code changes) worked just fine in a dev. environment on windows, while executing DDL scripts on Linux, IDS throws this error. Basically I have a unique constraint on 3 columns…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
Re: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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…
Here you can read books free and buy all tickets
Here you can read books free and buy all tickets you can find all tickets here: http://allticket.yourfreewebspace.com/ you can read books free: http://onlinebook.yourfreewebspace.com/ http://bookonline.yourfreewebspace.com/…
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
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…
Re: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
Cached reads going to 0.00%
I've noticed this a couple of times in onstat, for no apparent reason cached reads go from 95% or so to 0.00% and then slowly build back up to 95% over the next 24hours or so. There's a cronjob that runs at 8, noon, 5 and midnight that records a few interesting statistics on the …
KAIO READ ERROR
Hi All, Through the working day I can constantly see error messages containing the information: KAIO: error in kaio_READ, kaiocbp = 8ac9e608, errno = 14 11:30:44 fildes = 8 (gfd 6), buf = 8be2e400, nbytes = 61440, offset = 37412864 Sometimes IDS goes down if the system is doin…
Database read only
Hi, I need to put my database in read-only mode to previne access while we migrate the data to the other database. I'm using Informix 7.31.UD6 on HP-UX. I would like to know to proceed in this case? Thanks. Rodrigo…
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 …
Changing database to read-only
Hello, I am trying to find out the procedure for preventing updates on an Informix database by changing it to read-only. Is there a stored procedure to do this? What would anyone recommend? Version 9.21UC4 HPUX 11.11 Thanks in advance, Howard…
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?…
How do it get writes form the lrus in V10
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bill > Marshall > Sent: Wednesday, May 03, 2006 7:21 AM > To: ids@iiug.org > Subject: How do it get writes form the lrus in V10 [6648] > > > I have a new HP Intel 32 bit chip mach…
Onar failure
My Apologies for poor spell checking. The Title should read OnBar Failure.…
Dirty Read Default
I thought I heard a while back about an environment variable setting to change the default isolation level to DR. Does anyone know about this, or maybe I was just dreaming. The users of our data warehouse have been running selects against tables with the default of Committed Re…
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/…
Re: Stored Procedures Limitation
oopps it should read pre 7.3 ..…
initialization rhead struct failing
Superboer wrote: > dono what your problem exactly is... if it's read ahead, and something > fails > to start.. (the database...) you may want to consider setting > RA_PAGES 0 > RA_THRESHOLD 0 > in your $ONCONFIG file > > since the default is 4 and 2 if i recall correctl…
column level encryption
hello all, i am correct in reading that column level encryption is available in IDS version 10 but not 9.3/9.4? thanks tom…
Can't INSERT blob into specific blob space using JDBC
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
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!…
Re: Splitting rows without temp tables
"I'm interested in this concept of read-only access not allowing temporary tables. You can even build temporary tables on an HDR secondary, the ultimate read-only database." Just testing.... ;-p…
Re: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
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 …
RE: Write cache rate
I have many machines running with write caching rates in that region. I have observed that the write caching rate is often low when there is a small proportion of write activity. I use Art Kagel's BR, BTR, and RAU calculations to tune the number of BUFFERS. But I think your RA…
Re: Shocked! Shocked, I tell you!
Don't ask...it's why I'm so annoyed. They read this here.... Hmmmmpffff....…
Write cache rate
I have a question about tuning the write cache %. I have an OLTP database running IDS 9.40 on AIX 5.2. There are 300,000 buffers configured (about 30% of physical memory -- 4 GB), and the read cache rate is pretty consistently 98.5 - 99.0%, but the write cache rate hovers between…
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.…
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
Read Block Size on Disk
Hi all, what block size is used when informix is reading from disks ? Is there a difference between the block size on solaris and linux ? thanks gerd ______________________________________________________________ Verschicken Sie romantische, coole und witzige Bilder per SMS! J…
Re: what elkie holland said about me on usenet july 23rd 2001
Never heard of him till I read your post, Thank you for a most entertaining afternoon...…
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: IDS 10 erratic run times
oops should have read Neil's post more carefully!…
Reading DBF from Informix
hello, can anyone tell me if exists any patch or something else for Informix that help me to read/write DBF files from Informix without using ODBC?…
Why Informix is Best
Not horseshit it was on the Slides at the may IBM Infobahn at Bedfont Lakes in the UK. I was at the front where even I could read it...…
ISM ism_catalog question
I was able to retrieve the information I needed using the mminfo command. Thanks to anyone who took the time to read this post.…
Onstat -P output
We need more information as requested by Jay Konigsberg otherwise we're guessing a bit. Leona Ankrah wrote: > Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line (Prim) -- Up 09:07:09 -- 3063808 Kbytes Do you still have support for version 9.21.UC6? You should conside…
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
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: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
Reading environment variables
People, Is there a way to read the environment variables from within dbaccess? for example select '$INFORMIXDIR' from systables where tabid =1' Thanks in advance Kenneth…
Re: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > Hi: > Let me begin by saying thanks to all of the frequent posters to this group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiem…
Re: ra_pages and io rate
hopehope_123 said: > > Obnoxio , > > -No. They way that the two products approach their disk access is > -completely different.. > > What kind of difference exist?( For os level io calls ,when i strace > the oninit and oracle processes , i see they use pread calls .I think > you …
Re: ra_pages and io rate
STOP RIGHT THERE! Do NOT try to tune Informix in the same way that you tune Oracle. Don't even think about how you would tune Oracle when tuning Informix. The implementations are completely different. hopehope_123 said: > > Hi Richard , > > Lets say that i use pdq . Does pdq al…
Informix Logocal Logs
Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: ra_pages and io rate
hopehope_123 schrieb: > Hi , > > When i strace the aio vps , no matter what the value i set for ra_pages > , the pread system calls always request 2kb. disk blocks form the disk > subsystem . How can i achive high io rates with informix. (For instance > , in oracle by using db_fi…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para…
Re: ra_pages and io rate
Hello Art, > Informix ALWAYS reads > and writes either a single disk page (2 or 4K prior to IDS 10.00), performs > a 'bigread' of 4 pages (8K or 16K), or does a block write of 4 pages at a > time. Period. not entirely true Pre 9.4 ; it can do bigwrites/reads of 16 pages and th…
Re: ra_pages and io rate
Hi Art, Thank you vrymuch for your reply. I am trying to opimize the sequental scans in a datawarehouse environment.My disk subsystem is emc , raid 10 . I have 1 hba and can transfer 100MB. per second. With oracle , seq. scans can read 1mb. per read operation and with these valu…
ra_pages and io rate
Hi , When i strace the aio vps , no matter what the value i set for ra_pages , the pread system calls always request 2kb. disk blocks form the disk subsystem . How can i achive high io rates with informix. (For instance , in oracle by using db_file_multi_block_read_count , i can…
Installation problem
I am attempting to upgrade an Informix installation from 7.3x on Sun 5.7 to 9.4 on Sun 5.9. When I run oninit -ivy I get the following: Creating buffer pool 200002 kbytes...succeeded Initializing rhead structure...succeeded init_alarm failed fyi: I installed a new version of IS…
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:…
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 Reading co…
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…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG par…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
Re: script for SQL Capture
michael i get an error reading header on this file after download tom…
How to determine optimum buffer size?
Hello, how do I (or how do you) determine the optimum buffer size (on IDS 9.40, but I think it's a generic question) ? I have a machine with almost 'unlimited' memory (96 GB RAM). Therefore I could define a large number of buffer pages. But I'm not sure if at some point the adm…
What counts sysbufhdr.reusecnt ?
Hi, I found the table sysbufhdr in the sysmaster database apparently containing information about the database buffer pages. One column has the name 'reusecnt' - does anybody know what exactly that column counts? Most entries have reusecnt=0 and I have one system (with a very la…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: Expert advice needed on Buffer management
jpierrot@chubb.com wrote: > Hi gang, His per-session buffer pool requirement calculation is completely bogus since most sessions will be sharing the use of the same pages of data and which pages are shared and which are uniquely used by a single session will differ from server t…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Re: Informix Performance Issues
TBP said: > Try something silly at least once :D > > RA_PAGES 1024 > RA_THRESHOLD 64 > > would be cranking it high. > > For a "mix" try > > RA_PAGES 128 > RA_THRESHOLD 16 Hmmm ... I am so going to remember *this* post... :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien…
Re: Informix Performance Issues
TBP said: > Try something silly at least once :D > > RA_PAGES 1024 > RA_THRESHOLD 64 > > would be cranking it high. > > For a "mix" try > > RA_PAGES 128 > RA_THRESHOLD 16 Hmmm ... I am so going to remember *this* post... :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien…
Re: Informix Performance Issues
Obnoxio The Chav wrote: > Anirudh Chitnis via DBMonster.com said: > >>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >> >>1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19 > > > Well, there's your problem right there -- 90.7% read c…
Re: Informix Performance Issues
Obnoxio The Chav wrote: > Anirudh Chitnis via DBMonster.com said: > >>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >> >>1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19 > > > Well, there's your problem right there -- 90.7% read c…
Re: Informix Performance Issues
PFB the onstat -p output and my thoughts on the same. Please provide your valuable inputs. The %cached for buffered read is a low number?it should be well above 95%. Adding more buffers should solve this problem. bufwaits can be brought down by reducing the RA_PAGES and RA_THRE…
Re: Informix Performance Issues
PFB the onstat -p output and my thoughts on the same. Please provide your valuable inputs. The %cached for buffered read is a low number?it should be well above 95%. Adding more buffers should solve this problem. bufwaits can be brought down by reducing the RA_PAGES and RA_THRE…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com said: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also > updated. But are they taking the *correct* index paths? I've had this exact problem, possibly…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com said: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also > updated. But are they taking the *correct* index paths? I've had this exact problem, possibly…
Cost Estimation for queries
hi, Does the optimizer take into consideration the number of buffers(BUFFERS) available and RA_PAGES into account to estimated the no of IO's required to complete the query. bye.…
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
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…
Re: Informix locking & transactions
Lock Mode is Row Isolation Level is Committed Read.…
cannot read system catalog
--0-1004379464-1102954650=:32339 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Hi, Using IDS 9.21 UC4. Solaris 8.0 we have this problem with users trying to connect to the database running. it gives the error 'cannot read system catalog (sys…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
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: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
Intitialization problem
Hi, I have a problem with IDS 7.31 on SCO 5.0.5 When trying to initialize IDS and it hangs. Here is the oninit -v command: # oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/usr/informix/etc/onconfig'...succeeded Creating …
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…
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…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
Problems with locks and committed read
Hi ! well, once again... another question on locks, and isolation level. This time it's rather "critical" for me. I've got 2 processes. One of them => insert data in some tables. The second => try to select row in it. (in fat , it select in it) the two transactions are initi…
Dirty Read dbschema?
Hello All, I have a question regarding dbschema. I have a script that copies data on a nightly basis to a reporting database. I wrote the script to capture the schema each night so that any schema changes are automatically incorporated. Occasionally, I cannot capture the schema …
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 …
RE: Clearing Buffer Pool
Informix (unlike MS SQL) keeps all pages in the buffer pool 'forever' - until page becames replaced by another page... ------------------------------------------ Alexey Sonkin > From: Dave Griffen [mailto:dgriffen@nospam.finishline.com] > > I do mean to remove all non essential…
RE: Clearing Buffer Pool
To clear the buffer pool from dirty pages, generate a chackpoint with 'onmode -c' If You mean to remove all pages from it, then it's impossible. ------------------------------------------ Alexey Sonkin > -----Original Message----- > > Does anyone know if there is a way to clea…
Clearing Buffer Pool
Does anyone know if there is a way to clear the buffer pool without bouncing the engine?…
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
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…
IDS9.4 Performance Issue
Hi, I've recently upgraded from IDS7.31 to IDS9.4 and have noticed that some queries run faster and some are actually slower. One query is 2x slower on 9.40 as compared to 7.31, which appears to be caused by a different more costly query path in IDS9.4. Other queries are about 1…
Performance is getting worst after turn on the LRUAGE
On Sun, 28 Mar 2004 22:40:01 -0500, miyaki wrote: Other is usually 'unused pages'. Look at the top of the onstat -P report. On the line for address zero (0), is the value under Other very large? Those are unused buffer pages, ie no data pages have been loaded into them. There…
Virtual Processors and CPU-Load
On Thu, 18 Mar 2004 05:13:05 -0500, Markus Bschorer wrote: DO NOT POST HTML/MIME! I'll answer but often folk here will ignore such posting altogether! Sorry I cannot include details of your post, it's gibberish in a non-HTML mailer! One major problem I see is that you have 5 N…
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,…
Help parameters RA_PAGES,RA_THRESHOLD
I have doubts with respect to these parametros, as I should calculate that so that the readings in secueciales in temporary it is mas fast. # Read Ahead Variables #RA_PAGES 4 # Number of pages to attempt to read ahead RA_PAGES 4000 # Number of pages to attempt to read ahead #RA_…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
Re: Buffers and LRU.
Madison, the standard interpretation of LRU is Least Recently Used. The standard usage of such a queue is as follows: Each queue has an MRU (Most Recently Used) end and an LRU end. When a buffer is touched (either read or written) it is moved to the MRU end of the queue. When a…
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…
Read only connection
Hi. I have installed IBM Informix Connect 3.82 32 BIT driver for connecting to a Informix Dynamic Server 9 for Linux. I have configured the driver and works fine but I don't know if I can restrict read access. Is there any option for configure the driver in a read only connectio…
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…
Buffers and LRU.
The buffer pool is the page cache of the engine. The LRUs are simply a means of chaining the buffers together. There are two chains per LRU - the free and the dirty. (Actually a free buffer has a page in it, but it is not dirty.) There are multiple LRUs so that if a thread tri…
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…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
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…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: memory sort and disk sort
On Fri, 24 Oct 2003 02:03:10 -0400, dusong wrote: In a vacuum these ONCONFIG values look OK, but we need to see the onstat output to make a diagnosis. Certainly you have lots of cache and an RA of 16 does not look outrageous (is that the RA_PAGES or RA_THRESHOLD and what's the …
Read sqexplain.out on client machine
Hi, Server IDS 9.30UC2 on linux. Client Apache/PHP/CSDK 2.81 on another linux box. I want to show the query cost and access plan in a web page, How can I retrieve it? I know that in page 10-13 of the IDS Performance Guide it says : <quote> When the current database is on anot…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
Question on split reads...
Quoting from page 17-10 of the IBM Informix Dynamic Server Administrator's Guide (IDS 9.4 on Solaris 8) -- "A data page is read from either the primary chunk or the mirrored chunk, depending on which half of the chunk includes the address of the data page.". If the disks containi…
Re: lock table overflow
The customer's server has 1GB of ram. Unfortuately, it also is the web server, so IIS is running on it. I upped the buffers to 400 and the locks to 40000. The service reported: 08:47:27 Onconfig parameter RA_PAGES modified from 4 to 8. 08:47:27 Onconfig parameter RA_THRESHOLD …
Re: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
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…
Commit-read question
I am experiencing a quirk of some sorts. I am running the query below with a wait 30 against a table that has an application stepping thru recordid #'s checking for the next record that has a status of "not processed". Once the application does other modifications to other tables…
RE: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
Is dirty read enough ?
This is a multi-part message in MIME format. ------=_NextPart_000_007B_01C339B8.442F6BB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, everyone , Here I encounter a problem, in our system some tables were accessed by many clients at the s…
Re: Is dirty read enough ?
> THIS IS A MESSAGE IN 'MIME' FORMAT. Your mail reader does not support MIME. > Some parts of this will be readable as plain text. > To see the rest, you will need to upgrade your mail reader. --PART.BOUNDARY.2960.4671.p057.1056372883.3930 Content-Type: text/plain Content-Trans…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
Re.Dirty reads
Hi Everybody, What would be the impact on database and its integrity if the application has used DIRTY READ during INSERT. Thanks in advance. Sushil... _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://cl…
IDS starting read only
----LNX_Thu_Mar_06_2003_10:17:52_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, = is it possible to start IDS 7.31.xDx (and IDS 9.30.xCx) 'read-only' , e.= g. starting with all checks for chunks / physical and logical logs…
regarding concept of physical logging??
hello, i have a serious confusion regarding tha concept of physical logging, this might sound silly for an expert kindly bear with me and explain.. according to what the book says.. physical logbuffer contains the before images of the data that taken from disk for modification..…
RE: what is light scan and look aside??
All of these 'advanced' questions. Are you retreading from some other vendor? You should consider a course. Light Scan: Normally when you read a table, you go through the buffer pool. That is your row is retrieved from disk, stuck into a buffer, an LRU entry is made to track…
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…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
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…
Re: Number of Light Scan Buffers
Mike Davies wrote: > > I believe the number of Light Scan buffers is dependent upon RA_PAGES and > RA_THRESHOLD but I am not sure of the exact formula. Does anyone know what > this is? Furthermore, are the formulae the same for IDS 7.3 and XPS 8.3? I don't know about XPS, but in…
Number of Light Scan Buffers
I believe the number of Light Scan buffers is dependent upon RA_PAGES and RA_THRESHOLD but I am not sure of the exact formula. Does anyone know what this is? Furthermore, are the formulae the same for IDS 7.3 and XPS 8.3? Thanks, Mike…
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 …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
Read in ACE
I have SE 7.20.UE2. I have an ACE report project where I have to do a SELECT with 55 compares in the WHERE clause. So I thought maybe I could put the 55 items in an ASCII file, READ them into an ACE report program that would put them in a temporary file. After all, there has go…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
Read only
Hi Can anyone tell me whether it is possible to make a Data source for the informix 3.32 32 bit ODBC driver read-only. Thanks Greg…
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
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…
How to improve bufwaits ratio?
How "close" is ? is 64/32 right ? Manel Falcó On Sat, 29 Jul 2000 10:38:56 -0600, "Bill Border" <bill_border@agilent.com> wrote: > > I had been told by an Informix developer (worked at Informix >developing DBMS code) that if you have RA_PAGES and >RA_TRESHOLD values close to…
Dirty Read
I have created a stored procedure in SQL7.0 which retrieves data from a linked server. The linked server is an Informix database - I want to set the query so it reads an uncommitted/locked records. I have set SQL7.0 to read uncommitted record which seems to be working, but how …
read dirty
I am developing an application in VB6.0 using ADO2.1. I want to Set Isolation dirty read, How can I do that through ADO? Thanks Peter pczurak@bigfoot.com…
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
Re: Load Performance problems
Hi ! QSTAT ? what does it do ? I didn't find it on my onconfig V7.30 and TBLSPACE_STATS 1 What is it for ? tablespace statistics ? where do they go ? so, better to 0 ? Regards, Manel Falcó > >>QSTATS 1 > >Do you really want this on? > >># Read Ahead Variables >>…
ace report & dirty read
How should I run a report with sacego in dirty read mode ? Thanks.…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
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…
Row locked on reads even under dirty read
Hi again, family. This is not so much a call for help as it is a request for discussion. Here's the way the problem was presented to me: The programmer, Charlie, complains to me that his app is getting a slew of error 244/154 (or, if not waiting on locks, 244/144). (Exactly how…
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…
Re: How do I check LRU contention - onstat -g spi ????
On Tue, 11 Apr 2000 13:30:59 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >bothwellno@spam.duke.edu wrote: > >> Art S. Kagel & Family <kagel@erols.com> wrote: >> : InfoJones wrote: >> : [output SNIPPED] >> >> : To determine whether buffer contention or LRU contention is in…
Re: How do I check LRU contention - onstat -g spi ????
bothwellno@spam.duke.edu wrote: > Art S. Kagel & Family <kagel@erols.com> wrote: > : InfoJones wrote: > : [output SNIPPED] > > : To determine whether buffer contention or LRU contention is involved > : try to calculate your buffer turnover rate: > > : Buffer Turnovers = (dskread…
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…
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…
Re: How do I check LRU contention - onstat -g spi ????
Art S. Kagel & Family <kagel@erols.com> wrote: : InfoJones wrote: : [output SNIPPED] : To determine whether buffer contention or LRU contention is involved : try to calculate your buffer turnover rate: : Buffer Turnovers = (dskreads + bufwrits) / BUFFERS : BTR = (Buffer Turnove…
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: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
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…
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…
Questions about compress & ra_pages
Hi everybody, I'd like to do a couple of questions: 1.-What's the meaning of <compress> in onstat -p? 2.-I have the next ratio = rapgs_used/(btradata+btraidx+dpra)=99.7%. Would it be a good operation to increase the RA_PAGES and RA_THRESHOLD values(now 20/10)? I think that if a g…
Read Cache %age on IDS
"Arshad, Shehla" wrote: > What are the general recommendations on improving the read cache %age. Read : 95+ Write : 85+. You need to play around with BUFFERS, RA_PAGES, RA_THRESHOLD to arrive at the figure. Rgds…
Re: About RA_PAGES
"Dpto. Informatica" wrote: > > mars1972@my-deja.com wrote: > > > > > RA_PAGES 1000 # Number of pages to attempt to read > > > > ahead > > > > RA_THRESHOLD 500 # Number of pages left before next > > group > > > > > > Or the bigger question (to me):…
Re: About RA_PAGES
From: "Dpto. Informatica" <navidul@retemail.es> > >mars1972@my-deja.com wrote: > > > > > RA_PAGES 1000 # Number of pages to attempt to read > > > > ahead > > > > RA_THRESHOLD 500 # Number of pages left before next > > group > > > > > > Or the bigg…
Re: About RA_PAGES
From: Informatica <navidul@retemail.es> > >I've a DSS style Server, I have this parameters in my ONCONFIG file: > ># Read Ahead Variables > >RA_PAGES 1000 # Number of pages to attempt to read >ahead >RA_THRESHOLD 500 # Number of pages left before …
About RA_PAGES
Hi, I've a DSS style Server, I have this parameters in my ONCONFIG file: # Read Ahead Variables RA_PAGES 1000 # Number of pages to attempt to read ahead RA_THRESHOLD 500 # Number of pages left before next group My AIO's working to much. Outpu…
Committed read
I am working on stock trading database where there is a 'quote' table accessed by multiple web users in commited read islation level. onstat -k shows a shared lock for placed. Now I want to alter table and change the page level locking of the table to row level. It returns an err…
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: checkpoints taking as much as 25 secs
Scott Huppert wrote: > > It's logical that turning the entire buffer pool every 10 minutes is > probably bad, but what is a reasonable time frame? Is there any rule of > thumb? On a busy server that is NOT primarily a DSS/DW server I'd like to see the buffer pool turnover rate …
Re: Bug 104328 ? Bug 121447 ?
David Williams wrote: >In article <81j41o$ch7$1@news.xmission.com>, michael martin ><michael_martin@komatsu.co.jp> writes >> >><SNIP> >> >>My question is: Has anyone encountered Bugs 104328 and/or 121447 >>and if so what is the fix ? >> > Not encountered but I belive they are …
Buffer Waits Ratio
Andrew Bland <blanda@hep.bradford.gov.uk> wrote in message news:383D2C9D.1D7000C4@hep.bradford.gov.uk... > Hi Everyone, > > I've been trying to get this ratio down below 10% I've been using a > calculation posted on here by Art. > > ratio = bufwaits/pagreads+bufwrits * 10…
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…
ovbuff vs. fgwrites question
Bobby Medus <jeepin@eatmydirt.com> wrote in message news:382C304D.90240C61@texas.net... > This may be a stupid question but you know the old saying..... > > I noticed an increase in 'ovbuff' on the onstat -p. This is a very > small database running on NT and so I increased my b…
RE: Long spins or onstst -g spi. Need any information.
Eugene Nechayev <4new@my-deja.com> wrote in message news:80bvko$so0$1@nnrp1.deja.com... > Art and William thanks for your responses > > Now it's more clear, and after Art's explaining line by line > my onstat -g spi output it's more understandable and useful for me > than after r…
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
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: bufwaits and RA_PAGES
In article <380DAF04.D290D679@SPAMsiemens.at>, Wolf D. Pichler <wolf- dieter.pichlerBLOCK@SPAMsiemens.at> writes >Art, thanks for your reply > >> Your new RA parameters are IMMENSE, > >I agree with you, BUT take a look at my new onstat -p: > >INFORMIX-OnLine Version 7.23.UC3 --…
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…
Re: bufwaits and RA_PAGES
Art, I have seen different posts on the BR formula. BR = (bufwaits / (dskreads + bufwrits)) * 100.00 See below first and BR = (bufwaits / (pagereads + bufwrits)) * 100.00 See below second Which one is the correct formula? Thanks Kernoal Please respond to kagel@bloomberg.ne…
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…
bufwaits and RA_PAGES
Colleagues, we are using ODS 7.23UC3 on ReliantUnix 5.43C40 and HP-UX 10.20. One day i wondered about 3.2 Mio bufwaits in 13 days when i made an onstat -p. This means the DB waits for approx. 3 buffers per second. Now i assumed, that the DB is waiting for data and changed the R…
Read ahead utilization
Family Jurkovic <jurkovic@netcom.ca> wrote in message news:37FB7EB9.FD262F96@netcom.ca... > Hi there, > > I am wondering if anybody succeeded to get read-ahead utilization > around 99% ?! Regardless of setting RA parameters I cannot achieve more > that 96-97%. Yes, I got the s…
Kevin read this
--------------- cc:Mail Forwarded --------------- From: Siroui Pink AT NYPBMIS1 Date: 10/06/99 09:13 AM To: informix-list@iiug.org AT INTERNET Subject: Testing from Siroui, Time Inc Service Desk ______________________________ Forward Header _______________________…
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…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
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…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
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…
Tuning RA for DSS on IDS7.30
Run onstat -p and look at the read-cache and write-cache percentages over a typical load period. Also look at the RA usage values reported and calculate the RA Usage Ratio: RA-pgsused / (ixda-RA + idx_RA + da-RA) * 100 This ratio should be VERY close to 100 (like I get 99.498 …
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.…
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.…
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…
syschkio view
Frederico Cox wrote: > > Hi all, > > I am trying to understand the syschkio view. What is the relationship between > read/pagesread. I read in an article that read means # of read operations and > pagesread means # of pages read.Therefore, I identified situations where the > numb…
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…
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…
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: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
Read Ahead Parameters
<< I am reposting this message. I don't think it made it through! >> I was recently looking at the same recommended parameters and thought it was rather strange with the numbers I came up with. My environment: BUFFERS=50,000 bp_fact=0.50 # random % large_queries=2 # rando…
Re: Out of buffer?
On Wed, 26 May 1999, Mark D. Stock wrote: > Xavier wrote: > > > > 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…
Re: Out of buffer?
Xavier wrote: > > 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 time…
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…
Re: Read-ahead parameters
I was recently looking at the same parameters and thought it was rather strange with the numbers I came up with. My environment: BUFFERS=50,000 bp_fact=0.50 # random % large_queries=2 # random queries RA_PAGES = ( BUFFERS*bp_fract ) / ( 2*large_queries ) + 2 = 25,000 / 4 + …
Read-ahead parameters
IDS 7.30.uc7 HPUX 10.20 The bugs are supposed to be gone; after eight months I'm ready to reenable read-aheads. Our original values of RA_PAGES / RA_THRESHOLD were 150 / 75. These seemed a bit high based on the postings that I've seen since that time. We're an OLTP shop, wit…
Mirroring parallel read
Can anyone confirm whether my understanding is correct in regard to Informix mirroring and parallel read performance. Informixs' implementation of parallel reads from mirrored DBspaces is thus: Data from the first half of the chunk is read from the primary DBspace and data from…
Re: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
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: Create index very slow
>I'm running a create index statement and its been busy for the last 7 >hours. The table's got 55 million rows (spread across 3 locations by >expression). rtpm/top/... shows my one CPU (of six) at 100% >continuously, while the others are idle. I've got affinity and all that >jazz…
Re: RESIDENT and PDQ
Chuck Renaud wrote in message <7ddp91$hpf$1@news.xmission.com>... > >As for light scans--those only happen if the table being read is >larger than the buffer pool. So if you max out your buffers, you >won't get light scans unless they're huge tables... So, would this mean that …
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…
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
Delete
Hi. I've a question. When execute a delete by where on field not indexes, it sequential scan table' s page. Before to delete records, it casche pages in buffer pool ? Tank you.…
Re: Buffer Waits
> hmm, could you go into a bit detail on the light-scan? I have a DSS system > but I am not sure how to make it use light scan. I read something on the > book about it, but it wasn't very clear on exactly how to utilize it or > how to check it. thanks yan Here's some more inform…
Performance Tuning
zandy@skyinet.net wrote: > snip > BUFFERS 1000 You have 512 MBytes of Memory. Why don't give Online more ? snip > RA_PAGES 8 > RA_THRESHOLD 4 Why don't Read 32 Pages instead of 8 ? > NUMAIOVPS 64 OOps - What's that ? > snip > > bufwaits…
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…
Read Ahead pages in 7.xx
__________________________________________________________________________ This message is intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the s…
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…
Re: ISAM ?
Guru wrote: > > What is a difference between ISAM reads, disk reads, page reads, buf > reads ? > I can watch it by onstat but I don't know exactly what it is. > Can YOU help me? Sure. dskreads are the number of read requests made to disk, some may be multiple page reads which i…
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…
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
Performance degraded after detaching indexes / fragmentation
Possibly you have hit the limits of your little SMP (4 CPU?). Or if you got them, jack NUMCPUVPS up and check the parallel processing parameters in the ONCONFIG. Time for more CPUs. Fragmentation splits up stuff so more parallelization can happen. but it won't happen if you do…
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.…
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…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
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.…
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 >…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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:…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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: Reducing checkpoint intervals...
Hi, in my opinion you must reduce LRU_MAX_DIRTY and LRU_MIN_DIRTY. It's not a good idea to reduce the time interval between the checkpoints because each checkpoint costs a lot of overhead ( thread-synchronisation and checkpoint-waits ). How about: http://www.weideneder.de/info…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
Performance problems with large SELECTS in 7.3x ?
Hi, I tried to select some pages of a table that was a bit larger than my buffer pool. I estimated that my statement will take about 5 seconds but it took 12 seconds. I found out, that the server spent approx. 7 seconds for "buffer waits". Now I added a few buffers to the buffer…
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
Re: Performance problem after merging db server
Stephan Stresing wrote: > > Hi, > we have a heavy performance problem after 'merging' two db systems > to one. We did this because according to the Informix Performance guide > and the advices of Informix experts. The most obvious thing is that BUFFERS 5000 is *WAY* too low. As…
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: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
Re: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
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…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
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: RA, bugs, and performance
Arun Shastry wrote: > > Andreas Zeugswetter wrote: [SNIP] > > Hmm, what you say can only be true on a system very low on memory. > > Our values are RA_PAGES 256 and RA_THRESHOLD 96 and we get very [SNIP] > See if you get any different performance, both query and cache, if you set…
Re: RA, bugs, and performance
SaTriGuy wrote: > > >>> most of the pages that were read-ahead. > >>> > >> > >>Wow, that's way too high for even a DSS environment. Rule of thumb I use > >>isto set these to about 32, 16 for a good sized DSS and to about 12,8 for an > >>OLTP envrionment. > > > >Hmm, what you say…
Re: RA, bugs, and performance
Andreas Zeugswetter wrote: > >> RA_PAGES 150 > >> RA_THRESHOLD 75 > >> > >> While these numbers were a bit high, we were able to take advantage of > >> most of the pages that were read-ahead. > >> > > > >Wow, that's way too high for even a DSS environment. R…
Re: RA, bugs, and performance
>>> most of the pages that were read-ahead. >>> >> >>Wow, that's way too high for even a DSS environment. Rule of thumb I use >>isto set these to about 32, 16 for a good sized DSS and to about 12,8 for an >>OLTP envrionment. > >Hmm, what you say can only be true on a system very…
Re: RA, bugs, and performance
>> RA_PAGES 150 >> RA_THRESHOLD 75 >> >> While these numbers were a bit high, we were able to take advantage of >> most of the pages that were read-ahead. >> > >Wow, that's way too high for even a DSS environment. Rule of thumb I use >isto set these to about …
RA, bugs, and performance
Informix DS 7.23.uc4 HPUX 10.01 HP K200 4-way Up to this time, I have maintained a RA hit percentage of 90-99%. My RA variables were set to : RA_PAGES 150 RA_THRESHOLD 75 While these numbers were a bit high, we were able to take advantage of most of the pages that were …
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]: Read Ahead Pages, etc.
Art, I find that the RA_PAGES is dependant upon the type of application more than the CPU/DISK performance. For a DSS app where you do lots of sequential scans you want a high value. For a OLTP app a small RA_PAGES is needed. As I stated in a posti…
Re: Read Ahead Pages, etc.
Is there any optimum upper limit for the values of RA_PAGES and RA_THRESHOLD? I've bumped mine up from the defaults of 4/2 to 64/16, and I'm still at 99.9% pages used. How high should I go? Should I just keep going until the percentages fall? Andrew Lawrenson david.ashby@w…
What is good number for bufwaits?
I just read the latest Informix TechNotes and they suggest bufwaits should be 0. Mine is at 136,923 (server has only been up 7 hours). My buffers are at 50,000 for 75 users on a 2Gb database on IUS 9.13. My read a write cache rates are 99% & 95%. My readaheads add up to my RS…
don't read%
Subject: PLEASE DON'T READ THIS MESSAGE From: MONEYMAN.COM Date: Sat, Apr 11, 1998 1:27 AM EDT Message-id: <6gmuvl$4f2653@news.mitm.net> **************************************************************** * This Article was Posted By an unregistered version of: * * …
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: Optimizing..
Know your schema, update statistics, and read sqexplain.out.…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: Read ahead
In article <350D8F6F.1E0A@bloomberg.com>, Art S. Kagel <kagel@bloomberg.com> writes >David Williams wrote: >> >> In article <6efd6m$nu0@bgtnsc03.worldnet.att.net>, Jay Aymond >> <jay@ulife.com> writes >> >Any recomendations on what percentage of buffers should be used for >"ra_pa…
Re: Read ahead
Jay, For OLTP environment, set ra_pages to the lesser value - ie. not to do too much Read Ahead. Again, exact value depends on the nature of your apps. Good Luck LeeKB Jay Aymond wrote: > > Any recomendations on what percentage of buffers should be used for "ra_pages" > an…
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
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: Load vs unload time differ. why?
yes... a write does take longer than a read.…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
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…
Re: bufwait tunning
Mr Cheuk Kong Lo wrote: > I'm getting quite some large bufwaits. Am I right to set a larger > RA_PAGES value to cut it down? Currently I have RA_PAGES set to 10 > and RA_THRESHOLD 8. > No, I don't think that will help. A bufwait occurs when a user is waiting for a buffer to be…
bufwait tunning
I'm getting quite some large bufwaits. Am I right to set a larger RA_PAGES value to cut it down? Currently I have RA_PAGES set to 10 and RA_THRESHOLD 8. Thanks. -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Pru…
Re: Informix vs. Sybase vs. SQL Server vs. Oracle
Andreas Zeugswetter wrote: > Oracle's only advantage is with concurrent read and update, > since it does not need a read lock. > But if you use dirty read isolation, you don't have read locks in > Informix either. Oralce read a row without read lock and get current value withou…
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: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
RE: BUFFERS & RA_PAGES
Hi, Your RA tuning is way out, I suggest applying the formula below. When you apply this formula to the RA output shown the onstat -p output, the result is 15% and it should be 0.5 - 2 %. So you need to reduce your RA configuration. I suspect this will improve the write cache ra…
BUFFERS & RA_PAGES
In the performance tuning manual for OnLine 7.x, Informix recommends that you set your buffers to 25/20% of physical memory. My question is, what unit are we meant to be measuring memory in. I have presumed kilobytes, so that for my box with 64 Mb, my buffers are set to 16000. If…
Re: Major performance problems with Informix Online
On Mon, 20 Oct 1997 07:21:54 -0400, Tim Schaefer <tschaefe@mindspring.com> wrote: >I <was> curious to some of the tuning information, were these recommendations >purely for a Siemens machine or were these for 7.2x in general? > >A couple of the recommendations were interesting …
Unix to DOS/Windows Tape
I have a series of tape backups done "tapecopy' in Unix 3.2.2. How can I read them in Windows/DOS machine? The "tar" programs generally available don't read them. I am desperate to recover these text files. Thanks…
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: When does bufwaits get incremented ?
> I talked to the instructor at Informix UK > when I went on the Online 7 performance Tuning course. He contacted > the USA but still could not find out EXACTLY what bufwaits meant. > > He did say that if bufwaits was too high then increasing the number of > buffers wou…
Reading a file with 4GL
Does anyone know how to read data from a text file into a 4GL program? I want to read data from a configuration file and initialize some program variables. Thanks in advance, Mike…
computing number of light scan buffers and their size
The P&T manual says: o Size Of Light Scan Buffers - RA_PAGES/(MAXAIOSIZE/PAGESIZE) o Number of Light Scan Buffers - (RA_PAGES+RA_THRESHOLD)/ (MAXAIOSIZE/PAGESIZE) Where MAXAIOSIZE on most 7.2 ports is 60KB and PAGESIZE in (2, 4)KB. Doing the math... (MAXAIOSIZE/PA…
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: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <3353A408.F9C85873@strengur.is>, Snorri Bergmann <snorri@strengur.is> writes: > > Sybase 11.0.X Informix 7.22 > > ------------- ------------- > > o ~2 gig max for data cache o 1 gig max for data cache > > > > Drawback Inf…
Replication
Hi, I would like to know if the replication is always a database (master) to a database (read only) ? I would like to have one database master and 4 databases (read only). Is it possible ? Could we have one database read/write and use the replicat…
SAme Aps on 2 Servers, different performance, help!
Hi Net, I have a very confusing situation regarding to performance for two similar Database. Server 1: HP-UX A.09.04 U 9000/887 INFORMIX-OnLine Version 7.12.UC1X8 768 MB memory Server 2: HP-UX B.10.01 U 9000/829 INFORMIX-OnLine Version 7.13.UC1 384 MB memory Both have …
Re: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
Re: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
SMI: VP level stats
I'm interested in getting VP level I/O statistics like reads, writes, buffer reads, and buffer writes. These are avilable via onstat with -g iob and -g iov, however I need to get at them via SMI.…
Re: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
Re: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
Indexed read on "order by X desc"
Is it possible to do a indexed read when doing order by desc ??? TIA, -Lin…
Re: Locks/Committed Read Problem
Committed Read implies that it can only return committed data. Therefore, if one process has the row locked (always the case if it is updated and still in a transaction), then the other process can not read the row until it is committed or rolled back (the transaction is closed)…
Re: Set transaction isolation level read uncommitted?
On Sun, 14 Jul 1996 03:08:37 -0400, "Chao Y. Din" <cdin@csc.com> wrote: >> >> SET ISOLATION TO DIRTY READ >> > > SET TRANSACTION LEVEL TO READ UNCOMMITTED. > > Usign SET ISOLATION TO DIRTY READ allows you to switch between dirty-reads and non-dirty reads during the SAME…
Re: RA_PAGES and RA_THRESHOLD Defaults
This is a multi-part message in MIME format. --------------A44C74DFA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit mailgw!hpx400!Trevisol_Roberto/bbb_cak@srv3-poa.nutecnet.com.br wrote: > > Recently, I heard from Informix Tech Support that you can n…
Re: RA_PAGES and RA_THRESHOLD Defaults
Recently, I heard from Informix Tech Support that you can not set RA-PAGES higher than 32, because that's the Informix limit for I/O length. Does anyone else have that information? By now I have it as true! Roberto Trevisol rtrevisol@bamerindus.com.br }John - I think they are R…
Re: RA_PAGES and RA_THRESHOLD Defaults
John Morton wrote: > > Does anybody have any idea what the defaults are for RA_PAGES and > RQ_THRESHOLD in 7.1? As far as I know it is switched off by default, with RA_PAGES=0. Have a look in the file $INFORMIXDIR/etc/onconfig.std, which should be your 'standard' configuration f…
Re: RA_PAGES and RA_THRESHOLD Defaults
John - I think they are RA_PAGES=4 and RA_THRESHOLD=2. I have found in our environment, which is heavy read and not so much write that these are very low. I have them set to 64 and 32 respectively, and am contemplating increasing them (I use 99.99...% of those I read ahead). I…
RA_PAGES and RA_THRESHOLD Defaults
Does anybody have any idea what the defaults are for RA_PAGES and RQ_THRESHOLD in 7.1? I'm not getting good read ahead numbers right now, but I don't want to adjust these two parms until I know where I'm starting from. Thanks! Regards, John Morton Toronto, Ontario, Canada mort…
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: Split comp.databases.informix!
Kerry's list looks reasonable to me. I too am skipping much more than I read.…
Barcode reading
The following are some snippets of code that show an example of how we read from barcode readers. The readers that we use are capable of being programmed. You can set a code sequence that is automatically sent at the beginning and the end if required of each barcode. The code we …
Re: Good Buffer Size For Tuning Informix?
Chris Jenkins (chrisj@informix.com) wrote: : 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…
Re: Isolation levels
In 6.0 and 7.10 also, I think, Informix isolation levels are dirty read commit read cursor stability repeated read…
Re: HELP : ODBC's physical-order read error message
Sure looks like you are trying to read a locked record…
Re: informix newsgroup
Same as what you did to read/send this/previous messages. Dave.…
test
Don't read this. Apologies for the inconvenience.…
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?…
YOU MUST READ THIS!!! NOW!!!
Allright, I know what you're going to say... This is just pure spam, I should be flame-broiled, thrown on a bun, chewed up, swallowed, digested, and shit out. But just listen to this for a sec. We've all seen it in various forms on local BBS systems, on CI$, AOL, and here on t…
Informix buy Borland?
I read somewhere that Informix was thinking about buying Borland? Has anyone else hurt anything more about this?…
Re: Reading Audit Files?
> Does anybody know of any utilities that would allow me to make sense of > the data contained in an audit file? We don't run transaction logs, but > we're wondering if the audit files might possibly yield useful info about > how data was entered into the table, and when and/or …
Reading Audit Files?
Does anybody know of any utilities that would allow me to make sense of the data contained in an audit file? We don't run transaction logs, but we're wondering if the audit files might possibly yield useful info about how data was entered into the table, and when and/or by whom.…
Reading over locked rows
Hi, i've a program which unload tables to an ascii file and updates a specific column in the rows after they are written to the file. Isolation mode is set to repeatable read to avoid rows to be written to the file which are not committed. Everything was fine but if there are …
re: read ascii in Informix
Here is a program I have been using for a few years that will read an ascii file in Informix. It is 'c' code with a sample of the Informix '4gl' code needed to run it. Have Fun Stuart Litel slitel@netcom.com ------ cut here----- /*From: slitel@netcom.com */ /* fileio.c for u…
Intersolve ODBC Q&E
I'm looking for feedback on Intersolve's ODBC Q&E Ver 2.0 software. I've read the marketing info,but if anyone reading this is actually using it I'd like to know what you think. Regs, Rick rodonnel@ibl.bm…
How to read Flat files from 4gl
I have a requirment to read the flat file from 4GL. Is there any way to do it. Thanks in advance <shanke11@singnet.com.sg>…
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…
Re: Informix Transactions
If you lock the table in exclusive mode and you wish to read from it, use SET ISOLATION TO DIRTY READ; before your select statement.…
Re: Keeping clean pages in shared memory
> If you have a DSS app, the buffer pool does not become dirty, so the > LRU_MAX_DIRTY will not have any impact. ...unless of course you're generating temp tables. Which just about all apps do at some time or another. akent@cix.compulink.co.uk (Andy Kent) ----------------------…
Reading BTrieve-file�p2
To narrow my question down, I only want to be able to read the file from one end to the other, and on my way extrat the information in each record. So to say that I don't need to be able to perform querys on the file, but only read trough it.. If that's impossible, is there a wa…
Re: INFORMIX/ UNIX/ C/ --ATL-
> If you do not want to read it, hit "d" -- that is all. d-- ?? That's how we got c--. -- cwoodall@vth1.vth.colostate.edu…
Read only databases - CD_ROMS
Hope you can help me, I'm trying to find a starting point. I am currently working on a project that will involve databases which will be distributed around the world on CD-ROM. There will be regualr updates (monthly or quaterly) and in each case all preceeding data will be repla…
Re: Reading DBEXPORT tape
I've received the same "invalid arg" errors when trying to read a tbtape archive using dd. I've only had this problem on Solaris. J. Dority…
tbunload for Online 6.0
tbunload and tbload utilities for OnLine 5.0 writes and reads databases and tables only to tape. Is there true, that OnLine 6.0 tbunload and tbload writes and reads to and from files ? Lines: 2 Vadim Ketchashin, St-Petersburg, Russia…
Reading C-ISAM Files
I need to be able to read files written in a C-ISAM file format. If someone could please detail the file format, provide source code to do the job or point me to where I could get the infor- mation I would appreciate it. Please address responses to matthew@aryabhat.umsl.edu. Th…
read this
Hello: We are looking for a client/server database for course management. This database will be installed on a database server which is connected to the campus network. The course database will be used to provide course and lecture information. Students should be able to do quer…
Re: Dirty Read info
In article <1993Nov8.145344.22870@athen.mch.sni.de> gm@athen.mch.sni.de (Guenther Moschen) writes: > >I'm looking for some background of Informix's "Dirty Read" mode. > >Specifically: How is it invoked? Can it be turned on/off for an entire > >session, or on a per…
Re: Dirty Read info
In article <CFz2I7.698@andyne.on.ca> stevenb@bbs.andyne.on.ca writes: > >I'm looking for some background of Informix's "Dirty Read" mode. >Specifically: How is it invoked? Can it be turned on/off for an entire >session, or on a per-query basis? > >Steven > > > It can be turn on …
Re: Reading locked rows
Scott Ford writes: |> user 1 -> begin work; update bozo |> set col2 = 10 |> where col1 = 'a'; |> let's say that the previous value for col2 was 5. note that |> we HAVE NOT yet done a commit work. |> |> user 2 -> set isolation to dirty read; |> select * from bozo; |> …
Re: Reading locked rows
In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: >Hey folks, >We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We >talk to it using inet-pc 4.10 and powerbuilder running on windows. >Today's question #1 is about reading locked records…
Re: Reading locked rows
> > In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: > > >Today's question #1 is about reading locked records. Here's the > >scenario: > > buffered logging data base "foo" with table "bozo". > > table bozo has two columns "col1" (primary key) & "c…
Re: Reading locked rows
In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: >We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We >talk to it using inet-pc 4.10 and powerbuilder running on windows. >Today's question #1 is about reading locked records. Here's the…
Reading locked rows
Hey folks, We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We talk to it using inet-pc 4.10 and powerbuilder running on windows. Today's question #1 is about reading locked records. Here's the scenario: buffered logging data base "foo" with table "bozo". …
ESQL/C: reading in to a structure
This must be a naive question, but I would appreciate if some one help me with this. How do I read a sql query response to a C lang. structure? For eg. if I have a table t with { x int, y varchar(40), z char(20)} In my prorgam if I execute a query "select * from t " using a c…
Re: Reading tbtape
> > Is there a way to read the tape after a tbtape has > been done to assure what was written? > Depends which tbtape you mean... Since we have been bitten by media failures, we verify all our archive and log tapes on production systems. To read the log tapes, we use tblog.…
Reading tbtape
Hello everyone, Is there a way to read the tape after a tbtape has been done to assure what was written? Thanks! Brian MacWilliams --------------------------------------------------------------------------- Brian MacWilliams IND. TECH. & DB ADMIN BR …
Test - do not read
This is a test. This is only a test. For the next 60 seconds .......... Wayneo burke_w*cdx_miss@msm.cdx.mot.com…
Dirty Read & Upd.Statistics
Hey expert ! I have a question, which you may be able to answer. Could there be any problem if in an online system you have to processes, which executes in parallel, when the 2 processes are: 1 Update statistics ... …
Re: stuffing the read buffer
mukesh@elsouth.wsnc.org (Mukesh Rathor) writes: >>Under DOS, a character can be placed in the front of the keyboard >>buffer using the BIOS interrupt 16h, service 05h. This character ... > > or under Sys V 3.2.x. I wrote a 4GL simulating sperform 2-screens > interface. …
stuffing the read buffer
>Under DOS, a character can be placed in the front of the keyboard >buffer using the BIOS interrupt 16h, service 05h. This character >is the next one read by the Informix application and can be used >in ON KEY code to push carriage returns into the keyboard buffer, >which Inform…
Cannot read system catalogue!!
Path: emory!swrinde!zaphod.mps.ohio-state.edu!think.com!snorkelwacker.mit.edu!tamsun!mtecv2!root From: alfonso@mtecv2.mty.itesm.mx Newsgroups: comp.databases.informix Message-ID: <5153@mtecv2.mty.itesm.mx> Date: 20 Feb 92 18:47:54 GMT Sender: root@mtecv2.mty.itesm.mx Reply-To: al…