Oninit® Archive
Results for “onstat -g iof”
CHK REQ times suddenly getting very long
Hi Clive, At a guess as you mention the large storage footprint, something related to: IC98458 AN INCREASING NUMBER OF CHUNKS CAN INCREASE THE DURATION OF AN ONMODE -C BLOCK This was reported by me way back in 2013 and there is some sort of fix in 11.70.xC9. Given it was thirteen…
Block during checkpoint
Hi, As Art said, the info in the online.log message may be an indicator of checkpoint slowness, but you NEED to view onstat -g ckp to have a final diagnostic on what is happening. A long checkpoint may be acceptable if you have low values (i.e say below 0.5 secs or less) in the W…
IDS 12.10 - Query Slow
You can certainly use SET EXPLAIN for the queries against temp tables, that works just fine. Can you run the queries under SET EXPLAIN on both the old and new servers to get both query plans? I don't know the HPUX Virtualization platform, but in general virtualized environments …
srt* files PSORT_DBTEMP DBSPACETEMP strange
Hi, DBSPACETEMP are in the onconfig and the engine has been restarted afterwards. Yes the counter changes within the onstat -d/-D but quite small portions (and i know that programmers using A LOT of temp tables. 70000102ff72828 100 5 25 20834672 20178684 /usr/informix/dbs/temp…
RE: Re: onstat -g iof sanity check [36143]
John what version of 11.70 did the onstat -g ioh come in?? Bruce Simms Data Base Services TALX, Provider of Equifax Workforce Solutions 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 Cell (314) 496-6883 FAX (314) 983-3238 Bruce.Simms@Equifax.com IBM Champions -----Or…
onstat -g iof sanity check
onstat -g iof output ... The "avg. time" field (under each chunk) is in milliseconds, correct? So a value of 0.0860 = 86ms? I'm seeing some shocking numbers but want to confirm first. IO/s vs. service times are inverted, which would make sense. What are some baseline metrics fo…
onstat -g iof: gfd and chunk number
Greetings. I am *SO* sure I have asked this question before but I can't locate it within the forum so here I go, perhaps again. When I enter the command: onstat -g iof, the first line of each chunk's I/O stats looks something like this: gfd pathname bytes read page reads bytes…
fast recovery
The only monitoring you can do is to run onstat -D, onstat -g iof, and onstat -u to see IO activity. In the future, besides remembering to alter the table to RAW and inceasing the number of recovery threads in your ONCONFIG file, try using my dbdelete utility for large deletes. …
Input/Output Operations
Anyone know a command that will give the Input/output operations/second(IOPs) that an Informix 11.5 instance is being asked to handle? Please understand that what I'm asking for is different than the read/write times returned per chunk from an onstat -g iof command. That command …
onstat -g ath
if ! kaio && ! auto aiovp then check to see if you have enough aiovps configured. onstat -g iov , the last few should not be relatively busy (< 1.0 i/o per sec.) usual suspects : check for hot spots on disk (onstat -g iof; onstat -D). check for seq scans (onstat -g tpf | awk '…
Mutex wait
40GB of buffers for 350 users? Are they all being used? In the onstat -P and onstat -g buf reports, are the lots of buffers in the 'other' column for partnum zero? Separate issue: I was suspecting LRU contention, but with 512 LRUs in each of three buffer pools, that's unlikely. …
Re: Onload, the "fast" alternative
Hello Neil, Did you check if stuff is physical logged ??? onstat -l during the load and maybe onstat -g iof etc. Superboer. On 17 mrt, 21:23, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Art Kagel" <art.ka...@gmail.com> wrote in message > > news:mailman.838.1300203605.1071…
onstat -l
Thanks Art. The service times in iostat -g iof are low, 0.0059, or 0.0060 for the logical log chunks. However we do rotate through the log buffers very quickly, although I never see the bufused for the logical log buffers go higher than 2, however given the statement/transactio…
Re: KEY PERFORMANCE METRICS
onstat -g iof will give you IO/sec average per chunk file. The total IO/sec for all chunks is more difficult. It will be somewhere between the average of those averages and the total of all of them. Transactions per second you will be better off getting from your applications.…
What sysmaster table?
Art Kagel Wrote: ============================================================================== Folk: Does anyone know if the information on the onstat -g iof report for the IO service times for each device/chunk/file are available in sysmaster at all? I can't find that informat…
Re: onstat -g iof
Please check because I'm talking without looking at any documentation: kaio_reads/writes are I/O operations. Each operation can read/write more than one page. I/Os per second is a nasty number... Why? As far as I remember it's the number of I/Os done divided by the time the inst…
tempdbs in raw or in filesystem
I have two temp dbspaces on same disk. One is using like raw devices with direct I/O and another like file in Linux file system. Both of them have almost same number of read/write but, using onstat -g iof command for monitoring system, looks like temp dbspace in file system is 10…
onbar restore hanging
Hi, Do onstat -g iof moving or not on individual chunks? rgds schillache…
onbar -r -n hangs in cold restore of rootdbs
Paul: Just an idea, but informix SAP systems generally have a large amount of space dedicated to physical and logical logs. During the restore process informix must fill the log file with zeros (this is so it does not see old ghost recovery data as valid data). I would check an …
Full Proof way to determine if ontape is restoring
Onstat -D or onstat -g iof are the only ways to monitor the progress of a restore, unfortunately. Art S. Kagel Oninit On Mon, May 12, 2008 at 3:47 PM, WILL LANDSTROM <willlandstrom@yahoo.com> wrote: > Hey sorry for this basic question. IDS 9.4 databases. When I run ontape -r >…
Activate dynamic explain
Hi all, To analyse a user query I tried to activate dynamic explain using onmode -Y <ses> 1. Using onstat -g ses I found that dynamic explain had been activated (on), however I did not find any sqexplain.ses.out file created. When I issue onstat -g iof I see the particular file …
Re: Anybody seen a very fast wild cat out there?
david@smooth1.co.uk wrote: > > Yes, can we get these in the documentation? And a way to view all > this information via onstat/SMI? Check onstat -g iof and onstat -g ckp (new option). I believe (may be wrong), that they contain much of this information. Not sure if it's in …
sysmaster question
Jack, This is to be expected. There are other I/O activities that take place at the chunk/dbspace/disk level that do not pertain to any specific table. Look for John Miller III presentation on Understanding Onstat. I think it was a chat with the lab last year so it will be…
Re: CKPT REQ stops ontape -r recovery
Thanks to Norma and Martin for their efforts here. But it turns out the problem was not as I perceived and presented it. The state of CKPT REQ is apparently a common phenomenon during recovery. When I later reran the recovery (after some fixups) it got into that state a while …
CKPT REQ stops ontape -r recovery
Greetings, Family. I am trying to "clone" a server from the ontape backup set of another. It was going great for about 11 hours and then seems to have stopped all actvity. From the online.log: 01:20:38 Maximum server connections 0 01:32:39 Checkpoint Completed: duration was…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
io/sec
I am on IDS 9.4.TC3. I would like to get the io/sec from the sysmaster table instead of having to look at onstat -g iof. Does anyone know how to do this? Thanks. Lennie Informix DBA Information Technology Tax Team Lake County, IL O: 847-377-2092 C: 847-309-7718 Math illiterac…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: > Ups, sorry.. here it is > ***ONSTAT -g iof*** > > IBM Informix Dynamic Server Version 9.40.FC4 -- On-Line -- Up 06:16:34 -- 943248 Kbytes > > AIO global files: > gfd pathname totalops dskread dskwrite io/s > 3 /dev/rlvinfx01 8 …
Re: high buffer wait ratio
Hi all, Thanks for the advise given to me. I have made some changes as below and seen some improvement on the database engine. 1)Increase Buffer by double. 2) Reduce the RA values by half. 3) Reduce the LRU_MAX and MIN to 1 and 0. At the same thing, we also going to re-configu…
Do I need more KIO's
You've got virutally no buffers, only 6000. Without knowing how much memory you have in the box I look at running this to 50000, or even 100000 and see what happens I'd set the tapeblk to 1024 instead of 16 Do you really want your logs to be thrown way? ltapedev = /dev/null I'd…
RE: onstat -g iof
Hi onstat -g iof will give u disk I/O statistics HITEN -----Original Message----- From: Vaclav.Boura@cpp.cz [mailto:Vaclav.Boura@cpp.cz] Sent: Tuesday, September 30, 2003 4:22 PM To: informix-list@iiug.org Subject: onstat -g iof Hello all, when I perform onstat -g iof I see 8…
RE: onstat -g iof
Hi onstat -g iof will give u disk I/O statistics HITEN -----Original Message----- From: Vaclav.Boura@cpp.cz [mailto:Vaclav.Boura@cpp.cz] Sent: Tuesday, September 30, 2003 4:22 PM To: informix-list@iiug.org Subject: onstat -g iof Hello all, when I perform onstat -g iof I see 8…
Re: onstat -g iof
Vaclav.Boura@cpp.cz wrote: > Hello all, > when I perform onstat -g iof I see 82 sqexplain.out at the end. What does > it mean ? > 84 > sqexplain.out > …
RE: onstat -g iof
It also puts a big performance overhead on your system - slows it down. Don't use it unless totally necessary. -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, September 30, 2003 3:04 PM To: informix-list@iiug.org Subject: Re: onstat -g i…
onstat -g iof
Hello all, when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it mean ? 84 sqexplain.out 86 sqexplain.out …
onstat -g iof
Hello all, when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it mean ? 84 sqexplain.out 86 sqexplain.out …
onstat -p all zero
Thanks for your reply Jonathan Leffler, I do have a performance problem, some users have complained of 'slows' with the OLTP part of the application. But this hasn't been quantified yet. Without an accurate definition of 'slows' I decided to investigate the performance anyway. T…
Re: Why is rootdbs busy?
The databases are defined in rootdbs, tables defined in lots of chunks. I'm not sure how to read the output of onstat -g dic. It appears that we have set DD_HASHSIZE to 501 and DD_HASHMAX to 4. Very few of the entries currently have a size of 4. The system is relatively idle at t…
RE: Why is rootdbs busy?
Have you moved your logical logs and physical log into different dbspaces? If not, that will explain high I/O activity in rootdbs. -----Original Message----- From: B. Dana [mailto:bgdana@hotmail.com] Sent: Tuesday, August 29, 2000 16:13 To: informix-list@iiug.org Subject: Why i…
Why is rootdbs busy?
According to onstat -g iof, rootdbs appears to be the busiest chunk in the system with 10 times more dskwrite than any other chunk. The performance guide states that "When you do not specify dbspaces in the DBSPACETEMP parameter or the client DBSPACETEMP environment variable, Dyn…
RE: RAW DEVICE IO
sar -d 1 60 will show the average activity every second for 60 seconds per partition/slice for all disks. > -----Original Message----- > From: Bantilan, Artemius Ian [mailto:I_Bantilan@islacom.com.ph] > Sent: Tuesday, August 22, 2000 3:39 AM > To: 'informix-list@iiug.org' > Su…
Performance Monitoring/Tuning
when you run onstat -p and look at the output , what are the numbers for read cache, and write cache? are they below 90? if so, there probably is something you can do to increase the cache performance. by adding more buffers, you might increase the read cache numbers. if the writ…
RE: Why the dskreads and dskwrites from onstat -g iof and ioq do
Hello!!! Can I have some attention, please.... Did anybody understand my question???? Shehla > -----Original Message----- > From: Arshad, Shehla [SMTP:SArshad@purolator.com] > Sent: Wednesday, May 10, 2000 12:39 PM > To: 'iiug' > Subject: Why the dskreads and dskwrites from ons…
Why the dskreads and dskwrites from onstat -g iof and ioq do not
I would like to know why the dskreads and dskwrites from onstat -g ioq and onstat -g iof do not match. I ran both commands at the same time but still on some gfds there is a big difference. Can anybody help us understand the difference? We are running ID 7.30.FC7 on HP-UX 11. Ou…
Re: Using iostat tune informix databases
You can use 'onstat -g iof' to see where the database is writing to, and then take the appropriate steps (move table/dbspaces, add spindles, ...) to correct any bottlenecks. iostat and vmstat are useful, but all they tell you is that a process is being piggy. You need to go to …
Contention on a table
ibogorad@yahoo.com wrote: > > Folks, > > I broke my head over this one. > So, I have this table in a third party application. The table has row > level locking, contains around 400000 rows of 220 bytes each. > > The way it behaves under the load is unique to this table only, the …
Re: NOAGE on hpux
From: "Craig A. Sharp" <csharp2a@earthlink.net> > >I am the Unix Administrator for my company. We currently run an >Informix database server on an HP9000 system running hpux 10.2. >I have been asked to install the patch that provides the NOAGE parameter >for Informix. > >Current…
fragment by expression question
"MATTHEW H. DEVLIN" wrote: > > why are all fragments being scanned? I thought that fragments would be > eliminated based on the expression and after not seeing fragments > dropped when querying on just ia_group_id I figured i would use the > exact expression used in fragmenting …
Database monitoring
onstat -D & onstat -g iof will tell you which dbspaces are being hit hardest. onstat -g ppf (if TBLSTATS is set to 1 in the ONCONFIG file) to track table usage. onstat -d to track available space by chunk from which you can calculate the results by dbspace (see mention of dbs…
Stuck in FAST RECOVERY
"Gregory P. Schin" wrote: > > Hi, > > I have IDS 7.31.UC2A installed on Solaris and it has been running fine > for over 1 month. I deleted some data then dropped a few primary keys > on some tables and then added unique indexes. Then there was a power > hit and the system rebo…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
In article <KSN_3.11459$K%.256066@news.tpnet.pl>, Piotr Wróblewski <ptrwrb@kki.net.pl> writes >I am running IDS 7.30.UC2 server on HP-UX10.20. >My statistics for G50 says, that millions of disk writes go through 'aio', but TRUE. >when we compare 'onstat -g iov' with 'onstat -g…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
In article <KSN_3.11459$K%.256066@news.tpnet.pl>, =?iso-8859-2?Q?Piotr_Wr=F3blewski?= <ptrwrb@kki.net.pl> wrote: > I am running IDS 7.30.UC2 server on HP-UX10.20. > The machine is a single-processor G50 uccupied by about 30 users, > so the 7.30 server does not run as fast as On…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
>My statistics for G50 says, that millions of disk writes go through 'aio', but >when we compare 'onstat -g iov' with 'onstat -g iof', the sum of disk writes >(-g iof) is nearly equal the count of 'kio' disk writes (-g iov), >and similarly for disk reads. There is bug in Informi…
Re: Physical Log size
Link, David A. <DALink@West.com> wrote in message news:7tjlri$ra$1@news.xmission.com... > > I have an OLTP database which I need to keep the checkpoints below 5 > seconds, however, my users need to load millions of records periodically. > The database needs to be available 7x24. …
Re: write cache / NETTYPE
>From: "Obnoxio The Clown" <obnoxio@hotmail.com> >To: Valerie.H.Webber@m1.irs.gov, informix-list@iiug.org >Subject: Re: write cache / NETTYPE >Date: Fri, 24 Sep 1999 13:46:43 BST > >From: Webber Valerie H <Valerie.H.Webber@m1.irs.gov> >> >>How important is the % Write cache on th…
Re: Linux4GL
In article <37E7CB1A.CCA6CB89@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Howard Soper wrote: >> >> Can someone tell me which library rpm's need to be installed to be able to >> use Informix 4GL (C4gl or r4gl with custom runner ). > >That depends on which Linux rel…
Re: Linux4GL
Howard Soper wrote: > > Can someone tell me which library rpm's need to be installed to be able to > use Informix 4GL (C4gl or r4gl with custom runner ). That depends on which Linux release you have. For some you need nothing. For others, using the egcs compiler, you need the g…
Performance problem
Arvind Sharma wrote: > > Hi all, > Thanks to Art and Jonathan for all their help. We were able to > complete our project and move to production. But we found one problem > there. The system seems to be very slow whenever it accesses DB. It used > to work fine in the test envi…
Tuning Informix 7.2.4
Webber Valerie H wrote: > > Hi All, > > Can anyone take a look at the ONCONFIG file and the output of ONSTAT -P, > ONSTAT -M and part of ONSTAT-G and make some tuning recommendations. This is > running 7.2.4 on a Pyramid UNIX machine with 512M of memory, 4 CPUs and a > 12K line …
7.31 upgrade problems
Thanks for all of the tips. The `onstat -g iof` showed that the vast majority of I/O was occurring on the dbspace that contained all of the tables (~33 IO/sec). The dbspace that came in second was the index dbspace (5 IO/sec). The NUMAIOVPS was also set to 2, so that was not h…
Cleaners
Stephen Faehn wrote: > > Please forgive me if this is posted twice > ----------------- > Online 7.24UC3 > Solaris 2.5.1 > > Given that Cleaners are assigned to chunks in the order that the chunks > are created (and I don't know the order) how can I determine which cleaner > from …
Re: Temp DB space question
Temp size depends on various variables including size of your database and database server and space available, but no you should not combine your temp dbspaces into one. They are all used in parallel. While the server is in use try running onstat -D and onstat -g iof to see th…
onstat -D vs onstat -g iof
Informx gurus: --------------------------- This is a copy of a post that I previously send, however seems that because of the problems with the informix-list not many people had the opportunity to read it. I am sorry if you already read this message. ----------------------------…
onstat -D vs. onstat -g iof
Informx gurus: Could some one explain the output of onstat -D and compare it with the output of onstat -g iof? On my online 7.23 running on AIX 4.2 I get the following for onstat -D: address chk/dbs offset page Rd page Wr pathname .... 400382c8 2 2 1 40261 303…
onstat counter size
Could anyone tell me at what value the onstat counters wrap. I am particularly interested in the following: onsta -D page I/O for chunks onstat -g iof disk I/O for chunks onstat -p server profile (I/O, ISAM, CPU) onstat -g glo virtual processes From observation…
Re: informix mirroring
Robert Higgins wrote: > i am having a problem with disk i/o - i am currently utilizing an ibm ssa > with 8 disk (4x4) with informix mirroring > when i run an iostat (aix) it shows my hardest hit drives are the ones that > are mirrored. i have hardly any hits on the regular disks…
RE: Help - 567: Cannot write sorted rows. 28: No space left on device.
Himnesh, The ORDER BY clause will create temporary file(s), the following precedence applies: * PSORT_DBTEMP environment variable * DBSPACETEMP environment variable * DBSPACETEMP configuration parameter ( onconfig file ) * /tmp You must point to a valid temporary dbspace for D…
RE: Table io rate
Hi All ! onstat -g iof is used to show chunk I/O activity, as the dbspace is not listed use onstat -d to find it as long as both are listed in the same order. This would show table i/o statistics if you specifically create only that table in that specified dbspace. Anoher meth…
Re: Table io rate
At 11:38 AM 1/15/97 -0700, Sean Wong wrote: >Can somebody give me answers on following questions: > >1. How can I find out disk io, e.g. read/write access for a given table >2. How can I find out disk io, e.g. read/write access for a given process Jon C. Vemo (jvemo@cyberspace.…
RE: Table io rate
Sean Wong wrote: > Can somebody give me answers on following questions: > >1. How can I find out disk io, e.g. read/write access for a given table >2. How can I find out disk io, e.g. read/write access for a process Jon C. Vemo (jvemo@cyberspace.com) replied: ------------------…
Re: Oninits Running Amok...
OK - got some more info...it looks like the only time the CPUVP's run amok is when our Powerbuilder client connects across a slow (dialup) IP link and is downloading client code changes from a table (Select...) that contains updated app code in BLOB's. This would explain the lac…
Re: Oninits Running Amok...
In article <31D9457E.5C90@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> writes >We have 7.13.UC2 running on Solaris 2.4 w/ 2 Sparc CPU's. I occasionally >see both CPU VP's chewing CPU like crazy, yet there's few if any Buffer >Reads or any other evidence of productive work goin…
Re: LRU writes
brian, we should keep this either as private e-mail or just to the list, as i get two messages for everything that gets send out! not a big deal, but kind of a pain. the advantage of the list is that other people can see it and throw in ideas. it can be difficult to diagnos…
Re: table usage profile in 6.x 7.x
Saeed Talebbeik (saeed@sap-ag.de) wrote: : Folks, Is there any statistics kept within the online 6.x or 7.x : system that shows how many I/O operations have been performed : on a particular table? The question that I want to answer is to : run a benchmark on my application and fi…