Oninit® Archive
Results for “AUTO_TUNE”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Re: Checkpoint durations
Hate to say the obvious, but... you could try upgrading to IDS 11 and not worry about checkpoints at all since it has nonblocking checkpoint technology. It also includes automatically configuring LRU flushing and lots of nice performance features. Just a suggestion :) On Nov 29…
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 ------------------------------…
Informix 12.10 vs Informix 14.10 Performance Differences
Hi Benjamin, Thanks again for the suggestions from you, from Mike, and from Art. It helps to understand WHY you should do something or have certain settings. Many of us simply inherit the setup from a previous person and don't always question it or if there is a better way. The p…
Large memory segment vs smaller ones
Art, AUTO_LRU_TUNING 1 No AUTO_TUNE parameter in 11.70. ------------------------------ 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 ------------------------------…
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.…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
PC_POOLSIZE?
IDS 12.10.FC12 Solaris 10 1/13 How does PC_POOLSIZE get changed? In our ONCONFIG file, the PC_POOLSIZE parameter is entered as: PC_POOLSIZE 127 The first few lines of 'onstat -g prc' are as follows: informix@ifmx-prod-anc>onstat -g prc|more IBM Informix Dynamic Server Versio…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
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…
HDR- Distance and Latency
here's my story ... IDS 11.50.FC8. Dallas TX to Wilmington DE (> 1000 miles). At the busiest times (over 40 commits per second) the primary would block waiting on the log latch. R&D has corrected that issue in later versions I believe , not totally sure on since we moved to usin…
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.…
Can you resize a dbspace?
If things are not moving you can also run the following to see what the thread associated with the restore are doing: onstat -g ath | egrep -v 'lio vp|pio vp|aio vp|msc vp|fifo vp|main_loop|soctcp|kaio|flush_sub|aslogflush|btscanner|readahead|auto_tune|onmo de_mon|periodic|memor…
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…
HDR_TXN_SCOPE
The parameters that are not specified in $ONCONFIG assume the default value. You can check the default value of any parameter by querying sysmaster:syscfgtab: IBM Informix Dynamic Server Version 12.10.FC7W1 -- On-Line -- Up 4 days 00:39:53 -- 325492 Kbytes bica@primary:fnunes->…
Required to have names for simple constraints?
Apart of what Art mentioned, automatically generated constraints names may give you issues when importing data. Depending on how you do it some constraints may not be in the schema and when Informix generates them it may conflict with others that were created in the original syst…
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.…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
upgrade from 11.70.FC4 to 12.10.FC4 onconf questio
HPUX 11.31 (11vi3) HP BL870c from 11.70.FC4 to 12.10.FC4 I'm testing our ERP upgrade to IDS 12.1 on our test server and after running the upgrade and checking the differences in the old and new onconf file I got a question or two. The new onconf doesn't have a VPCLASS aio setti…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
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…
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
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
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…
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.…
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…
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…
LRU *less* aggressive??
Hi , ifx 11.50FC9X6 , AIX 6.1 *My questions* : 1) The engine auto tunning, is smarter to make LRU less aggressive? (making dirty LRU higher). 2) Is possible make the auto tunning "more aggressive" ?? (please, read bellow to understand the context of my question) This last week…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
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…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
Re: help with informix on windows oncheck -pr erro
ok sounds like silly question but how do i find out what ONCONFIG variable is on windows ? which is likely to be correct set ONCONFIG=oncfg_apecert.0 ::set ONCONFIG=ONCONFIG.apecert…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
Reminding everyone about the upcoming bigger and better than ever 2012 IIUG Conference
In case you haven't heard, the annual IIUG Conference for 2012 takes place April 22nd - 25th at a new location in San Diego, CA. Here is a sampling of some of the topics that will be presented at the conference: *A Guide to Securing the Database* The enterprise database infras…
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…
RE: Performance v11.70.fc3
Oh, sure, do something completely weird and unconventional like reading the onconfig.std file! My problem was I did the obvious all these months and just read the MFM which only says: default value 1 values 0 = Disable automatic read-ahead requests. 1 = Enable automatic read-ahe…
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…
Informix User Group Meeting, Training and FREE Hands-on-Lab - March 10-11
Washington Area Informix User Group events! -------------------------------------------- This is less then two weeks away. Folks, the Lab is full, but if you register we can put you on a wait-list. We have lots of room for the user group meeting. Please be sure and register if y…
Informix User Group Meeting, Training and FREE Hands-on-Lab - March 10-11
Washington Area Informix User Group events! -------------------------------------------- Folks, we have only 3 spaces left in the FREE Hands on Lab! Please be sure and register if you are planning to attend. We are pleased to announce that Carlton Doe, IBM Informix Technical Spe…
RE: System Freezes
I'm using raw. I have 8GB RAM on the machine. It appears that dbc_max_pct and dbc_min_pct have been replaced by filecache_max and filecahce_min in the hpux 11.31. Here's what I see for those: # kctune -v filecache_max Description Maximum amount of physical memory to …
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…
Multiprocessor setting
This is a very good point. We should not be looking only from a performance point of view, but also from a security point of view... Which again makes me wonder... If we have more than 1 CPU VP, and we know that we have more than one core, why do we need MULTIPROCESSOR? Informix …
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…
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…
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: Change next extentsize for indexes
> Date: Tue, 8 Dec 2009 13:58:13 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: Change next extentsize for indexes > > pow wrote: > > Hi, > > > > Is there a way to change the next extent size for indexes similar like > > for tables? For tables t…
Must see presentation at IOD
Have you ever tried to figure out how to tune your IDS instance without taking the risk of having an adverse impact on your production servers? Have you ever tested a new configuration or schema on your development or QA servers only to find out that performance was very differen…
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.…
11.5 - Dbimport performance
OOO OOO OOO, another idea! You created the dbexport in 9.40! In 11.50 creating indexes includes generating basic medium data distributions and low statistics information about the index keys and the index that's being created. This is faster than doing the stats separately from …
5 Reason why you would try a fake blowjob ( Verry FUNNY !!! )
The AutoBlow is a SexToy that is new on the market , look at the 5 top reasons why you wold buy the machine ( www.roboticblowjob.com/BlowJobMaleSexToy) : 1.The Autoblow is Automatic. The Autoblow is the world's first robotic blowjob machine, meaning that you can enjoy a hands-f…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
ER Error Enterprise Replication
Enterprise Replication is giving the following message when I do a simple cdr list server ndl12:ndl12a common_reporting$ cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------…
IDS hangs; IBM diagnoses resident memory problem
On Jan 15, 2:09 am, superbo...@t-online.de wrote: > Hello Ian, > > i do not agree with you on that, have seen situations where setting > resident to 1 or -1 or -2 > made performance from not existing to really good; > specially on systems with a lot of filesystem io > not all sys…
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…
Smoke and mirrors...
On Oct 9, 4:48 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > > >> Have you ever done an audited benchmark? > > > Nope, just an unaudited one for a customer where I had to sign a > > couple of NDAs with the companies involved because they didn't want > > the numbers re…
IDS 11 Performance Tuning
The only big changes between tuning for 9.40 and 11.50 is that since 11.50's checkpoints are true non-blocking (not FUZZY - but full checkpoints that do not block updaters) you can increase the LRU_MIN_DIRTY and LRU_MAX_DIRTY significantly to take advantage of the more efficient …
solaris 10, kernel parameters for ids 9.40
Hi, I'm testing my instances in a server with solaris 10. I read release machine notes And it says: b) On Solaris 10, all System V IPC facilities are either automatically configured or can be controlled by resource controls. The following kernel parameters are either removed…
using onbar from two different instances
Hi, thanks a lot for the clues, we almost got the answer: if fact, there're 2 bp.conf files on each node: one in the $INFORMIXDIR, an a second one on / directory (don't ask me why), which is identical (in the case that only one INFORMIXDIR is needed), to the one on INFORMIXDIR. B…
Re: Hands-free Administration
There are lots of ways to look at the cost of administration and how various products will respond. Here's where Informix products excel: set it and forget it - lots of responses to this. Just to reiterate, its not about the admin here, but about the reliability of the product...…
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…
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…
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…
Tuning IDS 7.3 TC9
Hi, I do not have any support from Informix. My latest IDS I have is IDS 7.31 TD1, but I did not install last time. I have not intention to upgrade to latest IDS and just want to maintain current version or upgrade to 7.31 TD1. Please advise. Warmest Regards Steven Tay ----…
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 ?…
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…
Should I wait for IDS 11?
Richard Spitz wrote: > Hi Informixers, > > we are presently installing a new database server to replace our old machine > running IDS 7.31 (BTW: without any major problems since 2001). In the process, > we were planning to upgrade to IDS 10. > > However, since IDS 11 ("Cheetah") …
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…
Re: Out of Box Experience for Cheetah.
Martin, You bring up several very valid points, and I commend you for taking the time to write more than one or two sentences. I think there can be an assumption of who is installing the software, it's not going to be done by my grandmother, it's going to be done by somebody wh…
Re: Out of Box Experience for Cheetah.
Martin Fuerderer said: > OTC wrote on 17.03.2007 16:25:19: >> >> Tool said: >> > If the assumption is to install on Linux, then one could simply walk >> > through >> > the boot up messages, such as what dmesg puts out, parse CPU > information, >> > or >> > also parse /proc/cpuinf…
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…
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…
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: 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...…
Onmode -F
jpierrot@ch.... wrote: > Hi Guys, > Are there any perf issues related to running onmode -F too frequently. Your > answers are greatly appreciated! There are overheads associated with allocating a new segment. If your applications are using that memory regularly, then it is not a…
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.…
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 …
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.…
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 …
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…
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: 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: 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…
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: Informix to Oracle Migration
rkusenet wrote: > "Data Goob" <datagoob@netscape.net> wrote > >> The downside is that the development team must know how to provide >> transactions >> that do not block readers without help from the database engine. I've >> worked >> in one system using SQL-Server where this is …
Re: Informix to Oracle Migration
rkusenet wrote: > "Data Goob" <datagoob@netscape.net> wrote > >> The downside is that the development team must know how to provide >> transactions >> that do not block readers without help from the database engine. I've >> worked >> in one system using SQL-Server where this is …
Re: When Informix dynamically allocates logical logs, do they dynamically unalloc?
NormaJean Sebastian via DBMonster.com wrote: > Hi all, > Haven't been tuning in much... that's the hazard of not getting the posting > directly to my mail-box anymore... > > anyway... > > I have seen IDS 9.4 (64 bit on Solaris) dynamically allocate locks. > It will do so, but not…
Re: When Informix dynamically allocates logical logs, do they dynamically unalloc?
NormaJean Sebastian via DBMonster.com wrote: > Hi all, > Haven't been tuning in much... that's the hazard of not getting the posting > directly to my mail-box anymore... > > anyway... > > I have seen IDS 9.4 (64 bit on Solaris) dynamically allocate locks. > It will do so, but not…
When Informix dynamically allocates logical logs, do they dynamically unalloc?
Hi all, Haven't been tuning in much... that's the hazard of not getting the posting directly to my mail-box anymore... anyway... I have seen IDS 9.4 (64 bit on Solaris) dynamically allocate locks. It will do so, but not unalloc them. for example, if i have 1 mill locks, and th…
When Informix dynamically allocates logical logs, do they dynamically unalloc?
Hi all, Haven't been tuning in much... that's the hazard of not getting the posting directly to my mail-box anymore... anyway... I have seen IDS 9.4 (64 bit on Solaris) dynamically allocate locks. It will do so, but not unalloc them. for example, if i have 1 mill locks, and th…
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…
FW: Oracle ?
> One of my biggest questions - why does every Oracle dba I speak to, say > that fragmentation of tables / too many extents (non-contiguous space) > does not matter. Surely that should still matter, no matter which > database you use ? Nobody is saying that fragmentation is not …
RE: Informix and Datastage
I'm not sure if this can be tuned, but the term to look for, is "parallelism" in Datastage Parallelism The DataStage engine exploits multiple CPU environments by automatically distributing independent job flows across multiple processes. This feature ensures the best use of ava…
Re: ER and inplace upgrade 7.31 to 9.40
Andrew Hamm wrote: > > Hi folks > > I need to upgrade 7.31 to 9.40 on servers which partake in Enterprise > Replication. We did a test server, and it barfed because of a few things: > Andrew, please specify 9.40 in more detail. You *should* upgrade to 9.40.xC5W1. We are glad to…
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…
Re: DB Tuning...
On Fri, 30 Jul 2004 06:20:11 -0400, Ben Thompson wrote: > Art S. Kagel wrote: > >> Tuning is pretty good. Here are your metrics: >> >> BR = (24306 / (32278143 + 622031)) * 100.00 = .0700 ! Excellent BTR = >> (((32278143 + 622031) / 100000) / 61.817) = 5.3221 ! On target …
DB Tuning...
With the light of query tuning, lately, I've decided to submit my server's config for some review ... to see if someone would be willing to help me tune it a bit. Without further ado -- here it is. It's a dual AMD Athlon XP 2400 (I believe) running Linux Software RAID w/ Mirror…
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…
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 …
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.Extents & Indexes
Sushil Shir.... wrote: > Hello Everybody, > > Env : 9.30 uc3 AIX 5.1 > > 1) Is there any limitation on the first extent ? > > This is the current scenario. > > Dbspace name - xyz > Data dbspaces - 8 (each 2gb * 2 chunks) > Index dbspaces - 4 (each 3 gb) > Fragmented by round robi…
Perfomance Tuning
I have IDS 7.31 running on HP-UX 11.0 and 4 Gig of memory. I have a 40 Gig database with on average 260 users and at peak about 315 users. I want to tune my database , as it has shown signs of slowing down recently. Checkpoints are taking on average 10 seconds,under normal proce…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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.…
Re: KAIO: out of OS resources
jorge valenzuela wrote: > Hi all: > > Recently I added a new dbspace to Informix Instance. Since that I got the > message > > KAIO: out of OS resources, errno = 11, pid = 26288 > > every 30 seconds in the log file. > > > I had configured IFMX_HPKAIO_NUM_REQ variable to 1000 so I…
Re: Certification
IBM Informix Certification for v7.x is easy. Have you tried v9 (see below) http://www-1.ibm.com/certify/tests/sam660-612.shtml john.chantha@worldwinner.com IBM Informix Certified DBSA v9.x "Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:<bjqhfu$mbe$1@terabina…
Re: Certification
Leonid Vorontsov wrote: > Hi all! > As far as i understand from > http://www-1.ibm.com/certify/certs/ixseisa7.shtml > i should pass 3 tests for Informix certificat. > Do you can advise me where i can get test examples for better preparing? Erm.............., have you tried: ht…
Re: Physical Logging performance
R�diger M�hl wrote: > "Mark D. Stock" <mdstock@mydassolutions.com> wrote: > > >>R�diger M�hl wrote: >> >>>Good morning everybody, >>> >>>some time ago, I found the tip, that the pages/io should be >>>less than the bufsize (around 75%). Is that true? >> >>Certainly 75% is a good …
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: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
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: memory increase
Anderson Deluiz wrote: > Hi all, > > I'm not an Informix DBA but I want to check if what our DBA told me > about configuration on Informix after increasing memory on our AIX > 4.3.3 box is true. The version of Informix is 7.31UC4, I think. > > Is that true that after adding physi…
Re: checkpoint
rkusenet wrote: > "Franklin Tang" <franklin@macauslot.com> wrote : > >>Dear all, >> what is the impact to increase the CKPTINTVL value. Any side-effect??? >>If my system crash, do I lose more data because the buffer doesnt get fushed >>by the checkpoint action??? I know the LR…
Re: checkpoint
rkusenet wrote: > "Franklin Tang" <franklin@macauslot.com> wrote : > >>Dear all, >> what is the impact to increase the CKPTINTVL value. Any side-effect??? >>If my system crash, do I lose more data because the buffer doesnt get fushed >>by the checkpoint action??? I know the LR…
Maxlen exceed 25
Madison Pruet wrote: > KAIO is a form of async IO. Adding additional AIOVPS won't help as the > bulk of the work is being done by the OS. I think Jack was replying to Milena Ilieva, who is not using KAIO, not the original poster Franklin Tang, who is. x-) But I could be wrong. …
Database sessions!
Hm ... Is operating system doesn't close sockets automatical on timeout? I think you must to tune your OS. What OS you'r using? Sergey. In article <960oqi$p15$1@nnrp1.deja.com>, Murat YILDIZ <murat-y@usa.net> wrote: > Is there a way to close idle database sessions after a c…
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…
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?…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
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.…
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: Informix logfiles truncating
No. If the engine sees that LTAPEDEV is set to /dev/null in the ONCONFIG file at startup (or by using onmonitor when the engine is online) it understands that you want to deep-six the logfiles and will automatically free each logfile as it fills. Art S. Kagel Valeriy Tsuryk wr…
FET_BUF_SIZE or How do I optimize cursor reads?
Please see comments below. ram_cnc wrote: > In article <8iqgv9$b0h$1@pollux.ip-plus.net>, > "EA" <appshome@yahoo.com> wrote: > > I am trying to optimize the performance of an ESQL/C application. I > was > > planning on changing some of my standard open cursor-fetch-close > cu…
Re: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
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…
Re: Single CPU Performance Problems?
Addition to all the good people's comments, you should look into Sun Box more closely.. What I have noticed in your onconfig file; most of them you still kept it as default... Is this parameter same on both NT and Sun box..? - If it is so you should tune Kernel of…
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…
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…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
Informix compared to other RDBMS
Brian Winant wrote in message <374C298B.6F30540C@bdsinc.com>... >What are the advantages / disadvantages of Informix compared to other >database systems such as Oracle, Sybase, DB2, etc? >Any help would be appreciated. > >bwinant@bdsinc.com > I found Informix to be very similar t…
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?…
Re: Informix and HP AutoRaid
Carlson@WHSmith (carlson1@bellsouth.net) wrote: : I guess that's a problem with AutoRaid . . . my data might be under : RAID5 or RAID 1 or RAID 0. : I'm still curious if any one out there is actually using it. It sounds like you need to carefully read over the HP documentation t…
Re: Opinions on Informix
blacklungs wrote: > > > Basically means that Oracle can be compared to a stick-transmission car, and > Informix to an automatic-transmission. No, Consider Informix an electronic shifting versus Oracle a manual clutch. Informix is a sports car that if not tuned properly, you cr…
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…
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).…
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…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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…
Re: Clients remaining locks when connection to server is broken
In article <3603b1bc.105461075@news.siemens.at>, johann.luczanich@siemens.at wrote: > Hi Comrades, > > how can I kill automatically (I know onmode -z) sessions remained by > clients (e.g. MS-Query, ...) that lost connection to a server, > for example, PC users shut off the powe…
Re: Infromix & Data Warehousing Solutions
Dough Metacube Query Optimizer is a tool that as you may Know, is targeted to analyze a specific Multidimensional Model, it actually creates a Matrix for every combination from the Model and based on some methodology will determine what will be the TOP N (You tell it how many) A…
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: 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…
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…
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…
Re: For The Gurus: On-The-Fly aggregation vs. end-of-day aggregation
In article <19980305164801.LAA09011@ladder03.news.aol.com>, SaTriGuy <satriguy@aol.com> writes > >>Heres a question for the DB Gurus (you may need to read it closely) >> > >Well - don't know if I qualify for this response, but here goes. > > >> >> >>An application has 10 threads,…
Re: For The Gurus: On-The-Fly aggregation vs. end-of-day aggregation
>Heres a question for the DB Gurus (you may need to read it closely) > Well - don't know if I qualify for this response, but here goes. > > >An application has 10 threads, each of them reading about 1 gigabyte > >records off the network in a constant stream. Each record is abou…
For The Gurus: On-The-Fly aggregation vs. end-of-day aggregation
Heres a question for the DB Gurus (you may need to read it closely) An application has 10 threads, each of them reading about 1 gigabyte records off the network in a constant stream. Each record is about 100 bytes in length and has a composite key (multiple columns make the u…
Re: change log size
LAM Chi-fung wrote: > > Hello, I would like to ask how can I change the log size of Informix ? > (point me which manual to read is o.k. :> ) > Since I perform a lot of search, comparing and the log 'full' very > quick. I don't want to do 'ontape -a' in the middle of my job. (Our …
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
Re: IBM AIX Kernel parameter limitations
Mikey, your nuts! Anyway, I'm not the system administrator, I'm the DBA. The System Administrators get to make the hardware decision and don't really care about my input, but since I had heard compliants from other users I just wanted to see if this was going to be a potential …
Turn-Key implemation of Jim Gray's Benchmark Handbook
If you are interested in looking a fully functional evaluation copy or simply want more information visit our website (www.csrad.com). Brian Butler and Jim Gray are currently working on the next edition of the Benchmark Handbook, and this software will be included with the book …
Re: SQL Server vs INFORMIX
Ing. Melvin Perez Cedano wrote: > > Hello Informixers. > > Anybody knows about any project started with SQL Server that have been > failed. I have a customer evaluating SQL Server vs INFORMIX and I know > all the technical advantages of Informix, but I would like to present a > r…
Re: SE, Online and ESQL/C Info
"Linda D. Cornell" <ldc@eskimo.com> wrote: :I am trying to get registered in some training classes since Informix is :new on our site. I've been web-surfing at their training site, but I'm :not sure what I need in what order. : :We're running a large turn-key application and I …
New Benchmarking Tool - Beta Users Request
Hello, I'm looking for server-savvy people to run our software against their servers. It can provide great performance tuning and capacity planning information on their server applications. The product, Benchmark Factory 97, is like a carousel CD player where each CD is a differ…
New Benchmarking Tool - Beta Users Request
Hello, I'm looking for server-savvy people to run our software against their servers. It can provide great performance tuning and capacity planning information on their server applications. The product, Benchmark Factory 97, is like a carousel CD player where each CD is a differ…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <LtWjwJALCpYzEwnU@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > > In article <861943179.18332@dejanews.com>, Brenda Muller > > > >Oracle's product is Oracle Parallel Server (OPS), and Informix's > >product is Informix XPS. I only have direc…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <861943179.18332@dejanews.com>, Brenda Muller <BMReed@aol.com> writes >In article <5j6eju$h25@omni2.voicenet.com>, > gray@voicenet.com (Scott Gray) wrote: >> >> In article <33538a45.29051694@news.jax.mindspring.com>, >> Reid Fleming <RFleming@aol.com> wrote: >> >Dave …
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
Re: 7.22.UC1X2 Performance tuning questions....
In article <jlumbleyE80sEz.DBu@netcom.com>, Joe Lumbley <jlumbley@netcom.com> writes >tony edwards (tony.edwards@bellsouth.co.nz) wrote: >: Team, >: We have recently upgraded our HP-UX 9.04 / 5.07 to HP-UX 10.20 / >: 7.22.UC1X2. Here is some information about the system >: c…
Re: Suggestions for improving the 7.x OnLine Engine installation and configuration
Nils Myklebust wrote: > David Williams <djw@smooth1.demon.co.uk> wrote: > > :>What would you like to see improved in the 7.x ONCONFIG and operation? > : > : Automatic creation of sqlhosts, automatic addition to /etc/services. > : Program to verify the about (gets $INFORMIXSERVE…
Re: Suggestions for improving the 7.x OnLine Engine installation and configuration
David Williams <djw@smooth1.demon.co.uk> wrote: :In article <333560A4.60CB@mindspring.com>, Tim Schaefer :<tschaefe@mindspring.com> writes :>To all: :> :>I'm interested in what DBAs actually think about the 7.x Engine, :>specifically the installation process, and configuring the…
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…
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…
Re: Why does 5.04 lock up when logs fill?
tom dorgan wrote: > > I guess the subject says it all. the server just quits and you have to > restore the database? This is what our admin people are doing, anyway > and its a 6 hour process and all you get is what you had on your last > backup. Doesnt seem like the last word in…
Re: storing C++ objects in RDBMSs
Adel Shrufi wrote: > > Hi Folks, > I am looking for feedback or past experiences on how to store C++ objects > in an RDBMS, e.g. Oracle or Informix. I know the ideal way would be to > use an OODBMSs, which I have personally done and found to be great. > However, RDBMSs still rule…
Re: Informix Optimiser: Should I use it?
Fire your software supplier. They basically don't have a clue. One of the main points about using a relational database is to hide this level of complexity from users and developers. You tell the engine what to do, it figures out how to do it in the most efficient manner. Fiv…
Re: DATAMANAGEMENT TOOLS
In article <43urn4$bm8@cssun.mathcs.emory.edu> lmarther@us.DHL.COM (Lou Martherus) writes: >From: lmarther@us.DHL.COM (Lou Martherus) >Subject: DATAMANAGEMENT TOOLS >Date: 22 Sep 1995 13:28:04 -0400 >Hi Informixers, >Does any of you know of any graphical Informix >datamanagement…
Re: Informix & BMC Software Patrol
In article <zackaDF628J.M5r@netcom.com> zacka@netcom.com (Theodoric) writes: >From: zacka@netcom.com (Theodoric) >Subject: Informix & BMC Software Patrol >Date: Tue, 19 Sep 1995 19:02:43 GMT >We are using Informix On-Line here and we are considering trying the >BMC Software uti…
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…
Dbexport/Dbimport problems
>> >> tony@bilpin.co.uk (Tony Desborough) Writes.. >> >> Hi, >> >> We have a production database that has been live for about a >> year. Application performance on this database has been fine. >> >> As the number of extents for some tables was becoming excessive, >> a full dbexpo…
Re: Dynamically Changing Graphics
->Subject: Dynamically Changing Graphics ->Date: Thu, 07 Jul 94 09:00:24 GMT ->From: greg@gsesco.DIALix.oz.au (Greg Wake) ->Organization: Geographe Software Engineering ->To: informix-list@rmy.emory.edu -> ->I have a number of PC's running over a TCP/IP Network to a Unix ->box ru…
Dynamically Changing Graphics
I have a number of PC's running over a TCP/IP Network to a Unix box running Informix. I also have Q+E and Inet V5.01 to provide access to the database from within my Windows Applications. Using this facility through Microsoft EXCEL is absolutely excellent given the graph capabi…
Re: Hyperscript tools
ramsub@miel_019.miel.mot.com (`subbu`) writes: Greetings. HyperScript Tools has been on SPARC (SunOS 4.1.3 and Solaris 2.2) since last year. I have (and enjoy) both platforms. Performance is better on a SPARC IPX than a 486DX33 - both running 16 or 32 Mb RAM. The only compla…
Re: Hyperscript tools
Thanks to everyone who helped me with opinions/tips on Hyperscript Tools - Could not reply personally to some of them because my mailer refused to accept certain address formats. Well, we are still evaluating the development environment that Hyperscript provides, but performance…
Re: informix SE vs Online 5.x
->From: davids@Software.Mitel.COM (David So) ->Subject: informix SE vs Online 5.x ->Date: 8 Jul 93 13:39:42 GMT ->Reply-To: davids@Software.Mitel.COM (David So) ->Organization: Mitel. Kanata (Ontario). Canada. -> ->Hello, I am trying to do a comparison between SE and ->online, an…
INFORMIX USERS CONFERENCE -- Corrections
INFORMIX WORLDWIDE USER CONFERENCE Update on Trip report. In a recent posting I stated: >The next release of INFORMIX On-LINE, Version 6, is to be announced >soon. Two phase commit, stored procedures, more online transaction >speed and power, and other features are included wh…