Oninit® Archive
Results for “WSTATS”
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 …
Getting Perl module DBD::Informix off the ground
I will likely post this on the mailing list dbi-users@perl.org but at this time I don't know if that list still being supported. So I post here first, for that rarified special group of DBD::Informix users. I got my management to allow me to download DBD::Informix on one of our h…
How to monitor wait conditions and times
QSTAT and WSTAT add a ton of overhead when they are enabled. Not for the faint of heart! Only to be turned on to diagnose specific problems and only for a fairly short time! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: htt…
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…
Optimising index builds
> On 19 January 2014 at 11:10 NEIL TRUBY <neil.truby@ardenta.com> wrote: > > >> Is DS_TOTAL_MEMORY set high enough to permit significant in-memory sorting? > > I changed DS_TOTAL_MEMORY to 300GB and reduced BUFFERPOOL to 160GB. Now > nothing gets written out to the DBTEMP_SORT fi…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
IDS 11.50/AIX 5.3 Slowness Issue?
Could you post the $ONCONFIG and "onstat -g ioa"? Also setting WSTATS in $ONCONFIG before running the tests and onstat -g wst (before closing the sessions) could help to understand why the queries take time. Something that will definitively increase the performance in "UNLOAD ...…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
windows-1252?Q52=45=3A=20=6F=6E=73=74=61=74=20=2D=
WSTATS 1 ----- Original Message ----- From: Jacques Lapeire <ids@iiug.org> To: ids@iiug.org At: 10/24 17:32:53 Hi Gary, Here are my notes about WSTAT, I never used it myself. Maybe it helps you out. Best regards, Jacques Lapeire WSTATS is an undocumented parameter that can …
windows-1252?Q52=65=3A=6F=6E=73=74=61=74=20=2D=67=
You need to set the under documented ONCONFIG parameter WSTATS to 1 Art S. Kagel ----- Original Message ----- From: Gary Price <ids@iiug.org> To: ids@iiug.org At: 10/24 15:45:35 I'm trying to run onstat -g wst to get some wait stats; the command returns a message "Wait statist…
onstat -g wst setup
Hi Gary, Here are my notes about WSTAT, I never used it myself. Maybe it helps you out. Best regards, Jacques Lapeire WSTATS is an undocumented parameter that can be set to 1 to collect waiting statistics. Causes some overhead, must be set to 0 again afterwards (needs restart…
Informix session VS 'oninit' CPU usage
NOTE: I have just done the Informix Internals course You could set WSTATS 1 in the onconfig file and run onstat -g wst and look at the run time per thread. Of course all this getting the current time every time a thread moves from the run queue to the ready or wait or sleep …
Performance degradation through wstats
I want to be able to use onstat -g wts and onstat -g qts. So, i added to my onconfig in my test environment: WSTATS 1 QSTATS 1 I tested some typical queries, statements and transactions and measured the execution times. The resulta are, that with WSTATS and QSTATS activate…
RE: Index problem
> -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Holger Steinestel > Sent: Thursday, July 07, 2005 10:41 AM > To: informix-list@iiug.org > Subject: Re: Index problem > > I'll be back tomorrow with the new indices…
Alpha Tru64 IDS 9.40.FC5 - Faster System Runs Slower
If network configuration is the problem, then one would have to assume, that the third configuration on IDS on royale / application on royale would use some sort of loopback through the Network! (instead of the virtual local loopback device) You may want to check the connection …
Re: HPUX: Unsat. reference 'finite' with CSDK 2.70
Jonathan Leffler <jleffler@earthlink.net> wrote in news:qRN0e.3415$gI5.540@newsread1.news.pas.earthlink.net: > Andreas S wrote: >> we have a HPUX 11.11 system with database 7.23 >> When trying to build the Perl module DBD-Informix or >> when compiling/linking our own ESQL/C appl…
Re: HPUX: Unsat. reference 'finite' with CSDK 2.70
Jonathan Leffler <jleffler@earthlink.net> wrote in news:qRN0e.3415$gI5.540@newsread1.news.pas.earthlink.net: > Andreas S wrote: >> we have a HPUX 11.11 system with database 7.23 >> When trying to build the Perl module DBD-Informix or >> when compiling/linking our own ESQL/C appl…
IDS 7.31.UD1 hangs
Hmm, Have you contacted your support provider? 7.31.UD1 is well old. Get yourself onto 7.31.UD8 and see if that resolves the problem!!! "Denis Melnikov" <dm�lnik@regent.ru> wrote in message news:<chhk87$h2a$1@n6.co.ru>... > Hi, all! > > The engine hangs regularly: it stops c…
4GL extremely slowed down after migration
Dear Mr Krstic, It is not possible to determine the problem with the information you send. What processes are using the CPU ? I guess it's the oninit(s) . What is the oninit doing? You may start with 'onstat -g act' to monitor the system for a while. What are the Informix thre…
wait statistics - meaning of mt yield
If wait statistics is off the onstat -g ath output knows a state "sleeping forever". Threads enter it if they wait for something to happen in some other thread. The other thread is responsible to wake them up then. This state is used for many different things. Among them are wait…
A Sleeping Thread - Or is it?
Kevin, Yes, it's probably undocumented. Its main purpose is to enable the collection of thread run statistics data, output using "onstat -g wst". The changed "onstat -g ath" output is only a side effect. This is what it does: Every time a thread changes scheduler status (ready,…
Bloody ERP schema
Update stats? Also, the optimiser is prone to change its workings between releases, and we always receommend to clients that it's very important to test out critical processes on the new release *before* upgrading... "Oxow" <oxow@yahoo.com> wrote in message news:d169ee4.03051819…
Who are the most active users?
Merrill To get the most cpu consuming session do the following: 1. Add WSTATS 1 to onconfig 2. run the following sql from sysmaster select s.sid,username,hostname[1,12],tty[1,14],pid,sum(cumtime)/1000000 cpu_time from sysseswts w, syssessions s where reason="running" and s.sid =…
building perl DBD::Informix on 9.21
I'm trying to build perl DBD::Informix 1.00.PC1 and it fails to pass tests: perl Makefile.pl make make test t/t83oconn..........ok t/t90ius............Null pointer for lvarchar at /usr/lib/perl5/site_perl/5.005/i386-linux/DBI.pm line 1105. ok t/t91udts...........DBD::Informix::…
FW: Queue statistics
In article <940qlh$b9l$1@news.xmission.com>, Dirk Moolman <dirkm@reach.co.za> writes > >On HP I just add the following entry to the onconfig file - > >WSTATS 1 > Yep, this is for wait stats, add QSTATS 1 for queue stats > >You will have to shutdown and restart the da…
Re: DBI/DBD test fail
On Wed, 1 Nov 2000, Maria Wilson wrote: >Jonathan, > I'm hoping you can help with this DBI::DBD installation problem. >I'm really new with this module so be nice! When I run the make test - >I'm getting the following errors.... >btw - I'm on Solaris 7, Perl 5.004 DBD 1.0 DBI …
DBI/DBD test fail
Jonathan, I'm hoping you can help with this DBI::DBD installation problem. I'm really new with this module so be nice! When I run the make test - I'm getting the following errors.... btw - I'm on Solaris 7, Perl 5.004 DBD 1.0 DBI 1.14 t/t90ius............Null pointer for lv…
Insert performance is poor
Tony Flaherty wrote: > >TBLSPACE_STATS 1 > > This has a huge (allegedly 20-30%) processing overhead, it should be turned > of (0) unless you are trouble shooting a specific problem. > This is'nt quite right. TBLSPACE_STATS hardly affects performance (but allows you to retrieve…
qstats,wstats
I am looking for some detailed explanation of the QSTATS and WSTATS output. Anyone know of a document explaining the output of these commnads?…
Re: NOLRUPRIO / LRUPRIORITY IDS 7.31_UC2
From: mattb5@ozemail.com.au > >I am after some more information and advise regarding the LRU priority >bug mentioned within this newsgroup. > >We are running IDS 7.31_UC2 on a 10way HP T520, 1.75 Gb RAM running >HPUX 10.20 with KAIO enabled and NO_SUBQF=1 set. > >I am able to kee…
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: wait statistics
From: "Ben Draper" <bdraper@mathworks.com> > >Are there any performance hits with enabling the stats? Yes, of the "how long is a piece of string" variety. > >Boy, that was about as helpful as one of my posts....he knows he has to >turn > >them on, he wants to know how! > > > >W…
RE: wait statistics
Yes. I have never done any testing to find out how expensive. Chances are if you are having problems with contention, this would make it worse while the stats were on, so you would need set the expectations of the users. As a temporary measure it seems like a fair price for bei…
Re: wait statistics
Are there any performance hits with enabling the stats? > >Boy, that was about as helpful as one of my posts....he knows he has to turn >them on, he wants to know how! > >WSTATS 1 > >in your onconfig. >________________________________________________________________________ >Get…
RE: Bufwaits and Foreground Writes
Art, Thank you for your recommendations. I do have some follow-up questions and comments. Rick > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Sent: Friday, December 31, 1999 8:54 AM > To: informix-list@iiug.org > Subject: Re: Bufwaits and Fore…
FW: :Informix-0.62
This site has it (which is a perl/linux site): http://www.medusa.fluff.org/rpms/medusa/utils/perl-5.00503-2.armv3l.html You are running perl for your version of linux? -----Original Message----- From: Stephen Faehn Sent: Thursday, December 16, 1999 1:28 PM To: 'tslusser@bigfoot.…
RE: :Informix-0.62
Looks like DBD-Informix-0.61_02/t/t00basic.t is crashing. It's opening file /usr/lib/perl5/5.00503/Test/Harness.pm and attempting to require the following file 'wait.ph'. But, wait.ph isn't on your system. In fact, I don't have it on my system. -----Original Message----- From: t…
DBD::Informix-0.62
Hi everyone, I am using DBD::Informix-0.62 to connect to Informix Online Server 7.23. The server is on a Solaris 2.6 machine. I am trying to use the DBD drivers on a linux machine to connect to the solaris machine. I have compiled the DBD drivers successfully and run the esql…
Re: Informix connection trouble in urgent situation
On Mon, 13 Dec 1999 17:03:31 +0800 in comp.lang.perl.misc Robert Shen wrote: > Environment: > Informix Dynamic Server 7.30 (on SUN Solaris 2.6) > sdk_210uc3_linux (on Linux) > DBI-1.13 (on Linux) > DBD-Informix-0.60…
SMI to Detect a Stalled Checkpoint
In article <7uq7d7$7fp$1@nnrp1.deja.com>, Jacob Salomon <JSalomon@bn.com> writes >(Re-Send - first post seems to not have taken) >Hi Family. > >I have been following some threads regarding checkpoints taking as long >as *20 SECONDS* (gasp). OK, the guy with the 80 second checkpo…
Wait reasons
Hi Andrew, well, i've been testing a lot with wait statistics. Here's what I've found out: Some of the wait stats seem to be ok; however at some point in time, some values change to 4295.0s. An example of onstat -g wst: kaio 14 yield forever 3508401 186351 4295.…
Wait statistics on NT
Hi group, i'm using some "onstat -g wst"-output (or some queries to sysmaster:sysseswts) to check which sessions in our development-environment are the "baddies". This works fine (as long as WSTATS (undocumented ONCONFIG-Parameter) is set on our UNIX servers. However in our NT-…
RE: Measuring CPU and I/O
Hi What about: 1. Login as "userX" 2. Issue onstat -z to zero all your profile counters. 3. As userX, issue sql statement #1 4. Inspect the cpu time, #reads, #writes, etc using the relevant onstat commands. 5. Repeat steps 2..4 for each remaining statement you wanna profile Of…
DBD::Informix-> make test fails
Hi all, I'm trying to install DBD::Informix on a Redhat 5.2 box running SE 7.2. I cannot get past this 'make test' and will appreciate any suggestions. TIA, Nitin. ################# Output of perl Makefile.PL ### [root@web DBD-Informix-0.60]# perl Makefile.PL Configuring DBD::…
Re: DBD Informix HP/UX make test problem
elemgee@my-dejanews.com wrote: > > The make test step in DBD-Informix-0.60 reports all tests failed because > the Dynaloader reports that it cannot find a file. Below is a sample of the > output from 'make test' > > at (eval 1) line 2 > > at blib/lib/DBD/InformixTest.pm line 74…
DBD Informix HP/UX make test problem
The make test step in DBD-Informix-0.60 reports all tests failed because the Dynaloader reports that it cannot find a file. Below is a sample of the output from 'make test' at (eval 1) line 2 at blib/lib/DBD/InformixTest.pm line 74 dubious Test returned status 215 (wstat 550…
Re: queue statistics
In article <6ngrh3$j6f$1@news.xmission.com>, "Sadagopan, Sathish" <sadagop0458@att.com> wrote: > > > Hi, > The qst option of onstat says "queue statistics not enabled".How to enable Q > statistics ? > TIA > Sathish > another reply explains what you need in your $ONCONFIG file.…
Re[2]: queue statistics
This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable In the $ONCONFIG file, set QSTATS to 1 for onstat -g qst to work, or=20 WSTATS to 1 for onstat …
Re: logical logs
At 06:42 PM 12/11/97 EDT, you wrote: } } }Hi } }I am running Online 7.23 on HP 10.20 } }Why was logical log backed up every 2-3 minutes? Under normal circumstances, you may have had Continuous Backup on, which would backup any freed logical log as it's available for backup. In …
FW: logical logs
Hey bro, > >Hi > >I am running Online 7.23 on HP 10.20 > >Why was logical log backed up every 2-3 minutes? >Is there any hint not to make that backup too fast? >Here is the info... I'm not certain if there is much you can do about how often you use logical logs but you can certa…
Re: Undocumented oninit variables
Hi, Jeff Craig wrote: > You can put two settings in your onconfig file as: > WSTATS 1 > QSTATS 1 > > Then, issue onstats -g wst or onstat -g qst to view wait and > queue statistics. If you make any headway in understanding > what they tell you, please post me back. You may al…
Re: Performance advice
In article <33AD00E4.1FF58E42@weideneder.de>, Stefan <stefan@weideneder.de> writes >Hi, > >first of all, Informix never writes simultanously to different logical >logs. It makes sense to split all logical logs and your physical log However it can be writing to one logical log a…
Re: Performance advice
Hi, first of all, Informix never writes simultanously to different logical logs. It makes sense to split all logical logs and your physical log across different disks. Best solution is to store all the logical logs on a very fast, seperate disk. In order to write parallel to yo…
Re: Index clustering and performance
In article <3259EA83.66D30FD7@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >Land, Todd wrote: >> >> I remember a thread from long ago . . . can you refresh my memory? >> >> My database performance is declining, and my DBA wants to dump and reload >> the…
Re: Index clustering and performance
Land, Todd wrote: > > I remember a thread from long ago . . . can you refresh my memory? > > My database performance is declining, and my DBA wants to dump and reload > the database, hoping that will help. > > Isn't there something I can do to my indices (re-cluster?) to regain >…
Re: tbinit in debug mode?
David Williams wrote: > > In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley > <jlumbley@netcom.com> writes > >zsun@br00dbss.med.osd.mil wrote: > > > >: Hi, > > > >: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an > >: un-documented option to ru…
RE:debug mode, undocumented features, etc.
}In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley <jlumbley@netcom.com> writes }zsun@br00dbss.med.osd.mil wrote: } }: Hi, } }: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an }: un-documented option to run tbinit in debug mode, unfortunately t…
Re: debug mode, undocumented features, etc.
Jeff Craig (settler@hobbes.dbintellect.com) wrote: : I'm running 7.12.UC3 on an SGI Challenge XL, and I get waitstats : (onstat -g wst) and queue stats (onstat -g qst) by setting the : following in the onconfig: : WSTATS 1 : QSTATS 1 What do you find this does to your performa…
Re: tbinit in debug mode?
In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley <jlumbley@netcom.com> writes >zsun@br00dbss.med.osd.mil wrote: > >: Hi, > >: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an >: un-documented option to run tbinit in debug mode, unfortunately th…