Oninit® Archive
Results for “onstat -H”
Need advice on compiling dostats utility
Hi Art, When I ran this command (dostats 2 -h prdweb -m -v 2 -e -d ALL -Q 20 -p -P 0 -w 60), I got two warnings that I don't really understand why: dostats says "Extra arguments ignored!", I checked the syntax, I don't see any reason why it gives that warning. 2. it says "Only St…
Long transaction message discusses a strange number
Hi, I hade the same problem, I simulate a Longtansaction and at the end I create this script to monitor it. this will find sessions with Longtansaction, and write all ses information once to log file . good luck //Layth #!/bin/bash LOGG="/var/informix/log/db_longtx.log" CDATE=$(d…
monitoring session memory
Onstat –g afr can be useful as well…
onstat statement
Dears, Kindly let me know if I run onstat - g stm command to check current sql statement which give the Session ID but sometimes if I try to kill the session by onmode -z <id> , it doesn't kill the session. So do I need to connect the session id with onstat -k session id ? kindly…
Block during checkpoint
HI Here I attach the onstat -g ckp output plus onstat -d // ------------------------------ ABeMie ------------------------------…
Problem with backup
Original post: Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thank Response: The answer is possibly. At the start of every backup, the server…
keep-alive in sqlhosts
Fernando, Andreas, we use Solaris 10 and as you said the interval is 2H. The command to show is /usr/sbin/ndd -get /dev/tcp tcp_keepalive_interval. You will see milliseconds. In our case 7200000. Yes, we'll try it. k=1 is part of the comma separated options list in fifth column…
IDS not writing to online.log
Also, onstat - always has the same output…
sysmaster tables for onstat -u and onstat -g ath
Greetings. In my quest to produce Perl scripts that consolidate the output of onstat commands, it has been mostly straightforward to break up a line into into its component pieces of data. For example, onstat -u, every line has exactly one string in every column. Not so for som…
onstat -a order
Hi All, On Informix v.12.1, what is the order of the results for 'onstat -a'? Our file is 234MB large, so I'm breaking it down into the individual pieces. I've gotten to the 'onstat -g all' section, but am stuck on the section with the heading: Thread Thread id Cancelled I/Os C…
onstat -d
I am sure it must exist Does someone have a script to give a pretty layout of onstat -d ............. The dbspace, and following that the chunks belonging to that dbspace ? My company decided not to stick to naming conventions, and now I am trying to match dbspaces with chunks …
Re: RE: Which session is using the most cpu resour
since 11.50 there is also an onstat available for that purpose - onstat -g cpu…
onstat -d
Hi, I see a line in onstat -d output that say metadata Size Free Bpages Metadata 17324 4005 17324 I see the free space was drastically reduced when I run cdr commands. My question is, what will happened with that space if it gets empty ? Thanks in advance. --001a11c11a8c11f…
Stuck transaction
Hi all!!! SUCCESS!!!!! After all these months, we got tripped up by this transaction while trying to upgrade to Informix 12. After the install, running 'oninit' caused a Fatal Error that the engine had found an open transaction from the previous version and could not complete. …
Stuck Transaction with BTS!
Bounce the instance. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other…
Onstat -d
Hi, Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs has from 2 to 8 free pages less. Why this happend? Enviado desde mi iPhone…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
onstat & SMI
Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.…
LRU Queues - more or less
onstat -F shows 0 LRU Writes…
RSS with DELAY_APPLY is dog slow!
On Nov 10, 2:52 pm, Nick <milesnmi...@gmail.com> wrote: > Hello, > > Does anyone have experience with RSS and the DELAY_APPLY feature? > > I am running tests, with the end goal to find the best HDR or RSS > setup that will minimize the performance impact on my primary db > server…
Onload, the "fast" alternative
On 15/03/2011 14:23, Neil Truby wrote: > 11.5FC8W2 on Linux > > I'm doing a 9.40 upgrade to 11.5 on a smallish database, around 100g. I > want to unload and reload the data too, as the dbspace layout is dreadful. > > timings so far: > dbexport 2h 20m > dbimport 10h > > So I thou…
onstat -l
I'm seeing a couple of extra lines in the output of 'onstat -l', which I can't find documented in the 11.50 administrators guide and references. The lines in question look like this: Buffer Waiting Buffer ioproc flags L-1 0 0x1 0 L-2 0 0x1 0 The exact lines varies (L-1 through…
Re: how to terminate global transactions?
On 28.06.10 11:19, Davorin Kremenjas wrote: > On Jun 27, 6:51 pm, Frank Langelage<fr...@lafr.de> wrote: >> On my Informix instance I have two global transactions holding some >> locks. See onstat -G and onstat -x output below. >> How can I get rid of them? >> Also after a server…
how to terminate global transactions?
On my Informix instance I have two global transactions holding some locks. See onstat -G and onstat -x output below. How can I get rid of them? Also after a server reboot they are still there. onmode -Z <address> or onmode -H <address> do not work (see below). IBM Informix Dynam…
onstat -g ses output
Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I am interested in knbowing what this output section means: Host variables : address type flags value ---------…
Re: Informix RESIDENT and Solaris 8 and 10 swap usage
On Jun 29, 10:17 am, Koya <chav...@gmail.com> wrote: > On Jun 29, 8:42 am, Eric Rowell <erow...@gmail.com> wrote: > > > > > > > Koya , > > Wish I still had access to my old Solaris systems (past live), this is > > what I remember. > > > There was a change to the mapping a…
Informix RESIDENT and Solaris 8 and 10 swap usage
On 26 June, 20:55, Koya <chav...@gmail.com> wrote: > Hello all, > > I have the follwoing question about RESIDENT and swap usage in > Solaris. > > My understanding is if we set RESIDENT value greater than zero, swap > should not be used. If this is corrent, do you have any idea w…
onstat -g iov
No doubt the real answer is RTFM. But, can anyone give me or point me to a good description of the i/o -wakeup ratio, and why 0.5 is "good"?: onstat -g iov -r 5 IBM Informix Dynamic Server Version 10.00.FC8W2 -- On-Line (Prim) -- Up 81 days 06:27:37 -- 46892464 Kbytes AIO I/…
size in MB written on disk
Hi, using iostat command will you get realtime data by every disk or volum of your system. Also you can schedule "sar" command to retrieve disk statistics and visualize it on a workstation. Also you can get valuable data about disk activity via snmp with "ucd/net - Device I/O" C…
If there were no onstat...
IDS v10.00.UC8 Solaris 8 6-1, 175 Bats: Left Throws: Right Born: 11/17/1967 in Independence, MO. Pretend there was no onstat -x (or any onstat) to get info about open transactions. You wanted to find out if there were any open transactions in a logical log file older than the cu…
Test Restoration failed
Bet you three chocolate dipped donuts that your 'test' system has RAID5 disks under the chunks you created while the 'dev' system is using RAID10. Art On Fri, Aug 8, 2008 at 4:38 AM, VICKY H <vickykh26@gmail.com> wrote: > Finally i reinitialized the test instance and started t…
understanding oncheck -pp
Thanks Mike, Here is the excerpts from the af.xxxxxxx file - ***** 11:08:29 Assert Failed: Page Check Error in btcurrent:bad current page 11:08:29 Who: Session(16, informix@DV11, 3743, 10b013e98) Thread(45, sqlexec, 10afd38f0, 1) File: rsdebug.c Line: 1057 11:08:29 Results: Po…
3 parameter/onstat questions
I just got off the chat-with-labs with John Miller. He left me with 3 questions I am hoping to get more info about, having failed to get anything useful from the version 10 docs. I'm on ids10.0.fc5. 1) He strongly recommended having the chunk mode set to expanded 'always'. He sa…
"tty" column in onstat -u
(HP-UX 11i, IDS9.30HC5) Just a comment, really, and wondering if this is the same on other systems? Doing a remote dbaccess query from one box to another, I've found that when I do an 'onstat -u' on the target machine, under the 'tty' column it shows the tty of the session on th…
Ip for a network session
onstat -g ses look under "hostname"...…
Re: tblsnum in onstat -k
Sounds good... select * from syslocks.... is easier.. Superboer way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html On 6 dec, 01:30, mohitanch...@gmail.com wrote: > Version IDS 10: > > Is following sql correct to retrieve associated table for that lock…
tblsnum in onstat -k
Version IDS 10: Is following sql correct to retrieve associated table for that lock listed in onstat -k: select * from sysptnhdr where hex(partnum) = tblsnum; or select * from systabnames where hex(partnum) =tblsnum;…
tty value
HI, Guys, I am wondering the TTY values from onstat -u. It is normally a number, but the folowing looks..... Any idea? AIX 5.3, IDS10 UC5 Tahnks, Frank IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39 -- 77088 Kbytes Userthreads address flags sessid …
onstat -p
Dear forumers, Attached is the "onstat -p" command : Do you think my bufwaits is high ?? Or is there anything significant from this information that need attention for performance reasons ? -------------------------------------------------------------------------------- ------…
onstat -p
The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagr…
onstat -a runaway process
Greetings, family (if y'all haven't disowned my by now ;-) We have a problem (so what else it new) with onstat -a: we have a script that periodically runs onstat -a and oncheck -pe. The onstat occasionally starts to eat CPU and the user calls us DBAs to kill the process. If s…
monitoring load
IDS 10, RedHat Linux Which onstat tells me that there are threads waiting to be processed? - onstat -g wai or - onstat -g rea TIA. Bob…
Onstat Reference
It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11 changes will be in place when the V11 Beta goes public. I'm happy to be told where they are wrong. If you like it then use it, if you …
running onstat commands against a shared memory du
Hmmmm. df -h tells me I have 17GB available on the partition where the shmem dump files resides. -Peter Clifton Bean wrote: > All I know is on my box (AIX 5.2): > #define ENOSPC 28 /* No space left on device */ > > I used to work at Informix and they had us doing that command …
XA Transaction blocking server
Hi, we encountered a problem on our development server, which lead to a blocking IDS 10.0 instance: We made a XA-Transaction containing two datasources on different IDS instances. For some reason, the transaction was aborted: 18:48:35 Aborting Long Transaction: tx 0x10f151398 no…
record locked
a combination of onstat -k and onstat -u…
Re: tricky performance problem on DELETE
Any triggers on that table ? How about any constraints ? Can you see the sql running or is it waiting on something ? ( onstat -u , onstat -g sql, onstat -g ses ) ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fweller…
RE: Reducing checkpoints
-----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of TBP Sent: Tuesday, June 20, 2006 3:13 PM To: informix-list@iiug.org Subject: Re: Reducing checkpoints Superboer wrote: > hope NO RAID 5 NO RAID 5 NO RAID 5 > > fo…
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…
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
who locks a record?
onstat -k followed by an onstat -u…
Onstat -g sts
Hello all, I have this problem : 01:08:38 Found during mt_shm_free 4 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) 01:08:38 Bad block header 0x7000000f7fd1000 blk-64 07000000f7fd0fc0: 00000000 00000000 00000000 00000000 ........ ........ 07000000f7fd0fd0: 00000000 00000000 0…
/usr/informix/bin/onbar[84]: 22716 Memory fault
On Mon, 6 Mar 2006 16:47:09 -0500, Darren_Jacobs@carmax.com wrote: > >Greetings, > >I'm getting the above error when running onbar from a script. Does anyone >have any ideas? > >9.40 FC2 >HPUX 11.11 > >set -x output from script: > >+ [ ! -f /usr/informix/logs/db_archive.log ] >…
HP-UX KAIOON
Shouldn't there be any kio vp's in then onstat output?…
Re: Track a session to a Buffer
onstat -b/-B/-X would be your friends.…
Re: MGM Mutex Locks hangs the system
What OS and version? What Informix version? What mutex locks? onstat -g mgm gives? onstat -g lmx gives? onstat -s gives?…
Re: IDS 10 erratic run times
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:3pliprFb403pU1@individual.net... > IDS 10.0FC3 on Solaris 2.9 > >>> This is a brand new server which we are preparing to migrate a v9 system >>> to. > Over the past few weeks I have run multiple dbimports from more-or-le…
RE: IDS 10 erratic run times
No, not much help, but thanks for sharing your story with us. We enjoyed it. --- "Hamilton, Jerry" <hamiltoj@fleishman.com> wrote: > I'm seeing the same problem with my v9.4 update > statistics jobs too. > I've had the same eight Update Stat jobs that run in > about 3.5 hours, …
RE: IDS 10 erratic run times
I'm seeing the same problem with my v9.4 update statistics jobs too. I've had the same eight Update Stat jobs that run in about 3.5 hours, in parallel, on a 9.21 system for years. On my 9.4 system these same jobs, running in parallel, take almost 7 hours to run. I never had the…
Re: IDS 10 erratic run times
On Mon, 19 Sep 2005 01:01:44 +0100, "Neil Truby" <neil.truby@ardenta.com> wrote: >IDS 10.0FC3 on Solaris 2.9 > >This is a brand new server which we are preparing to migrate a v9 system to. >Over the past few weeks I have run multiple dbimports from more-or-less the >same data so…
IDS 10 erratic run times
IDS 10.0FC3 on Solaris 2.9 This is a brand new server which we are preparing to migrate a v9 system to. Over the past few weeks I have run multiple dbimports from more-or-less the same data source - certainly the same schema - but the import time varies widely. The fastest I've…
Error Dopping Temp DB Space
How does it show up on 'onstat -d update'?…
Transaction Rollback
onstat -x…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
onstat -p
We are running IDS 9.3 on Tru64. Most of the onstat -p statistics quit being accumulated 3 days ago and I = have no idea how to restart accumulation without restarting the = instance. What/how causes the stats to not accumulate? How do you begin accumulation again? Copy of onst…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
error -229 with php
Hi, I'm using Informix 9.40.UC2 on Redhat Fedora, apache 1.3.29 and php 4.2.1 Everythink works fine, but then I tried the following: $conn=@ifx_connect("database@server","user","passwd"); define("DB",$conn); $sql="select * from myview "; $sql.=" where rna_text = \\"bla…
Onstat -D / onstat -u mismatch
IDS 9.21.UC6, Solaris 2.8 building an ETX index, into logged smartdbs, onstat -u shows the nreads column ticking up. The nwrites is remaining at zero. Onstat -D shows heavy reads on one smartdbs where the data is, and heavy writes on smartdbs where the index is heading. onstat…
Re: Remote LONGTX with no userthread in 9.30 UC6 W4
rdtbra wrote: > Hello all. > > We use here IDS 9.30.UC6W4, running in SunOS 5.7. Both Informix and Solaris are > 32 bits. For the second time we have reached a situation where the instance > shows a LONG TRANSACTION marked with flags --H--G and userthread 0. When this > instance …
Re: database restore with ontape -r on Informix Online Dynamic Server
David Williams wrote: > "Colin Bull" <c.bull@videonetworks.com> wrote in message news:btmcr4> That > will make it a lot tidier, should be able to use a case statement. > >>I will revise next week sometime. >> > > > http://www.smooth1.demon.co.uk/ifaq06.htm#6.33 > > 6.33 What sta…
RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux
"Colin Bull" <c.bull@videonetworks.com> wrote in message news:btmcr4> That will make it a lot tidier, should be able to use a case statement. > I will revise next week sometime. > http://www.smooth1.demon.co.uk/ifaq06.htm#6.33 6.33 What status codes does onstat return? On 21st …
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
What's in my buffers script
Ever wonder what tables are in your buffer cache and how many pages each are contributing? Onstat -P too terse and onstat -B too voluminous? Try this script: Art S. Kagel ########### CUT HERE ############ #!/usr/bin/ksh which nawk|fgrep "no nawk in" >/dev/null if [[ $? = 0 ]…
RE: ALTER FRAGMENT goes walkabout
Are the indexes in the same dbspace as the data? If so, I'd guess that dropping the indexes frees up lots of space, making for less extent hunting/allocation when the table and indexes are rebuilt. Just a guess... HTH, Paul Mosser -----Original Message----- From: Neil Truby […
ALTER FRAGMENT goes walkabout
IDS 9.21 FC4 on HP-UX 11.11 Can anyone explain to me how ALTER FRAGMENT ... INIT IN DBSPACE actually does its stuff? I've a 32GByte table which I want to reorgainse, to get all the free space contiguous. I can't use HPL, as there is a known bug in 9.21 that makes the unloads (…
Re: Bad performance
Put the following into /etc/rc.local test with /sbin/hdparm -t /dev/hda and /sbin/hdparm -T /dev/hda /sbin/hdparm -c1 -d1 /dev/hda .... /dev/hdb .... /dev/hdc It will get a tremedous speedup on ide drives, because you have activated 32 bit and dma mode. It off on d…
Re: Bad performance
You need to look at your SQL and how it is being optimised. Without that there is nothing useful about the diagnostics you posted. Andy "R�diger M�hl" <ruediger.maehl@web.de> wrote in message news:<Xns939D664E7CD70ruedigermaehlwebde@193.101.67.2>... > Hi folks, > > we have …
Bad performance
Hi folks, we have three servers running Linux (SLES7) and Informix 9.30 (2x) and 9.21 (1x). A developer has run a script against 9.21 and it worked fine and performantly. Now running it against the 9.30ies shows a very bad performance. Has somebody perhaps an idea of what is th…
onstat flags
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPa…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
RE: onstat
On Tue, 30 Jan 2001 dr_pablo@my-deja.com wrote: >> I have seen vendor-supplied scripts, which use the following >> exit codes from "onstat". I do not know where they are documented. > >Here's the URL to the FAQ page containing the info: > >http://www.iiug.org/resources/faq/ifaq0…
RE: onstat
I got this email awhile back: >PEOple, > >For those of you who do not know, it is very tough to determine the *real* >status of IDS. "onstat -" will return, stating that the server is "online" >but many times it is in the process of a "fast recovery", etc. In >addition, "onsta…
RE: onstat
The exit codes were posted into a FAQ at the IIUG web site at one time. Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] Sent: Monday, January 29, 2001 11:17 AM To: informix-list@iiu…
RE: onstat
Hi Bernstein. Please visit following site. >exit codes from "onstat". I do not know where they are documented. http://www.informix.com/informix/iuc/ppt/ts_ids.ppt And search "onstat". Regards. -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion …
Re: onstat
At 11:17 01/01/29 -0500, Bogdan Neagu wrote: Hi Bogdan. When the meaning of the question is different, I'm sorry. onstat returns the following. The server status is expressed as a number 0 Initialisation 1 Quiescent 2 Recovery 3 Backup 4 Shutdown 5 Online 6 Abort Regards. >…
RE: onstat
I have seen vendor-supplied scripts, which use the following exit codes from "onstat". I do not know where they are documented. integer inf_dwn1=255 # Informix mode is down integer inf_dwn2=-1 # Informix mode is down (60_USAP2) integer inf_init=0 # Informix mode is Initia…
onstat
Hi all. I was told by our DBA that onstat has different exit codes depending on the engine's mode (or mood). So, if I test $result (in C shell) or $? (Bourne / Korn shell), I should get a numeric value. My tests show 1=Quiescent, 5=On-Line. Does anyone know what these values …
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
bug in onstat -t ?
onstat -t gives following output (look at column npages): Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident 17 c0000000995f8908 0 1 100001 10000e -9223372036854775558 250 0 0 5 0 120 c0000000995f8d78 …
Onstat -P
Hello all, I am hoping you can clear up something for me. I am curious about the onstat -P command. The Admin Guide/Manual for 7.3x has one pithy statement about "display for all partitions the partition number and break up of pages in the buffer pool belonging to the partitio…
onstat on IDS2000
Hello all IHAC with IDS2000 ans the output of onstat -d is the following : Informix Dynamic Server 2000 Version 9.20.UC3X4 -- On-Line -- Up 6 days 16:59:45 -- 459440 Kbytes Dbspaces 500d1d08 6 8001 6 1 N S informix usersbs0101 Chunks address chk…
dbcopy and shm
cyclonejls@my-deja.com wrote: > > Can dbcopy use a shared memory connection? When I run dbcopy using a > shared memory connection, I get the following error: Dbcopy uses a separate connection to a database server for each side of the copy. That is why it can copy between datab…
onstat -u
I have a telnet user who consistently is walking out the door without logging off. Here's how I assume I should go about killing the user, with the problem listed below. 1. Do a who -u | grep username (identify tty port) 2. Do a onstat -u | grep username (to identify session i…
Re: Onstat
Are you executing onstat with -r 1 option? It happens sometimes. Try with -r 5 option. Vinod Bhansali --- Srinivas Sreekumar <SRINIVAS_SK@inf.com> wrote: > Hi all, > > I recently installed Informix dynamic server > 7.31.UC6 on HP UX 11.0 > > I am getting an error while running …
RE: Onstat
I had a low value for the shared memory kernal parameter for my unix server. When I increased it it started working.. Thansk, Srini -----Original Message----- From: Marat [mailto:maratkotik@mail.ru] Sent: Monday, May 15, 2000 7:41 PM To: informix-list@iiug.org Subject: Re: Onst…
Onstat
Hi all, I recently installed Informix dynamic server 7.31.UC6 on HP UX 11.0 I am getting an error while running onstat. "Changing data structure forced command termination. " can someone interpret this message for me and tell me the action to be taken. Thanks, Srini…
onstat -p
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
RE: rootdbs size?
From: William Rice <ricew@operamail.com> > >onstat -c >onstat -m >onstat -d >onstat -D >onstat -p >onstat -P | tail -5 >onstat -R >onstat -F >onstat -g seg I feel like I'm stuck in a time loop! ______________________________________________________ Get Your Private, Free Email a…
3rd Party Tools???
We had a 90 day eval of BMC Patrol, which was running with IDS 7.3. We discovered that it crashed our engine periodically, so we un-installed it. (I can only hope that BMC has since fixed that bug....). BMC is very expensive -- at our shop, the BMC licenses, maintenance, and s…
Posting from the Informix-list
onstat -g ntd Nona…
onstat -u
I am running Informix 8.2 on HP-UX 11.0. When I issue onstat -u command it shows the following: address flags sessid user tty wait tout locks nreads nwrites Under flags option: There are seven flags, the Seventh place flag is I know B,C,D,F; but it also shows M sometime. …
Setting up Rootdbs on a raw disk
In article <850qbs$lje$1@news.xmission.com>, Anne Shelp <shean@mcdss.co.gov> writes > >Hi all, > >I got the part about setting up databases on raw files. I understand that using >links is the way to go. What I am >having problems with is actually getting it to work. I created a l…
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 …
onstat & SMI
Hi, does anybody knows what query (queries) I must run to produce same output as onstat -u command? I'm not sure for flags, which fields in SMI represents those flags. Thnx in advance.…
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: write cache / NETTYPE
From: Webber Valerie H <Valerie.H.Webber@m1.irs.gov> > >How important is the % Write cache on the onstat -p (listed below)? I read >you should shoot for 85%..... ours is very low... 8% and sometimes 0%. How >do you tune the database for write cache. We do mostly reads and inserts…
write cache / NETTYPE
Webber Valerie H wrote: > How important is the % Write cache on the onstat -p (listed below)? > I read you should shoot for 85%..... ours is very low... 8% and > sometimes 0%. How do you tune the database for write cache. We do > mostly reads and inserts and very few updates. >…
Sizing DBSPACETEMP
Any one have any suggestions on sizing the database temp spaces? What option for onstat or Unix command do you use to monitor db temp space? thanks in advance!! Val Valerie H. Webber Valerie.H.Webber@m1.irs.gov 704-569-1002 x107…
RE: BUFFERS
Hi Valerie. Different problem. The problem for 128, apparently fixed at least in 7.31, was harmless. The problem with LRUS=64, and possible also 96, is quite harmful causing the bufwaits reported in onstat -p to increase by 5 to 10 times what it would be for 63 or 65. This on…
Onstat command
This is a multi-part message in MIME format. --------------DE4F14609E17179D45AF0716 Content-Type: multipart/alternative; boundary="------------73DD82890539D87E4735A41C" --------------73DD82890539D87E4735A41C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: …
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 …
Re: FW: Upgrading from version 4.1.2 to 7.2.4
Valerie IMHO, your question is too general. Monitoring tools are mainly onstat (and oncheck to check for disk structures). I would take a quick look at the online log (onstat -m) and do an onstat -p for profile information and post these here for help. HTH Sujit Webber Valerie…
onstat -z
Is there any way to tell the last time someone ran "onstat -z"? This seems like it should actually be logged in the online.log file rather than having to rely upon my fellow DBA's to communicate the fact that they reset things. Especially when I have to monitor hundreds of syste…
onstat
Hello after executing an onstat following message appears in the first lines: "Changing data structure forced command termination" What does this mean? Why does the Profile (as in a normal onstat) not appear and the onstat view only shows me the sessid? Regards André…
RE: Performance Problems with 7.30.UC7XB
Are these page flags set properly if you perform an UPDATE STATISTICS on all tables? The Informix Migration Guide suggests that such an task be undertaken as part of the upgrade. -----Original Message----- From: Dominic Binks [mailto:dominic.binks@aethos.co.uk] Sent: Wednesday,…
Re: Performance Problems with 7.30.UC7XB
Dominic Binks wrote: > > "Agnew, Doug" wrote: > > > > Phil, > > > > The database has been performing fairly well, at least not exhibiting the > > behavior that we are seeing now. We have just recently changed from > > 3.1h SAP kernel to 3.1I kernel and as a result moved from 7.24…
onstat options....
Hi Users, Which is the best site(s) / Book(s) to explain in detail all the columns of different options in onstat. There are a few changes in onstat results from 7.2x to 7.3.... so need something which explains all these. Thanks in advance, Pramod ___________________________…
Re: onstat
In article <7hpivn$l4u$1@news.gte.com>, michael.talbot@telops.gte.com says... > Hello, > > Question from a unix/informix neophyte: > > > > When I issue the onstat command I get the following reply. Does anyone know how to resolve this? > > /tmp-> onstat > shared memory not initi…
Re: onstat
Either the environment variable INFORMIXSERVER is not set (or isn't set to the correct value) or the Informix database engine is down. What is the value of DBSERVERNAME in the ONCONFIG file? John Carlson Informix DBA WHSmith USA Hello, > > Question from a unix/informix neophyt…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
onstat columns
Does anyone have a listing, even partial, of on onstat command column meanings? Informix's references are completely unhelpful, or nearly so, in describing, for example, what the "q-limits" column of "onstat -g ntd" means or how it's calculated, except for saying that the comman…
Re: onstat -u / onstat -g ses Problem
Informix Netherlands advised to start the database with the environment variable SINGLESEG_OFF=1. Try it! Regards Hans Bosma Database Administrator NCCW(Netherlands Ing Thoralf Bihlo wrote: > > I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server > 7.30 UC6. >…
REQ: Problem with onstat -u / onstat -g ses
I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server 7.30 UC6. My SHMVIRTSIZE is 32k and onstat -g seg shows that I have just one Segment. When I try an onstat -u or onstat -g ses I get the Error: >Changing data structure forced program termination< during the …
onstat -l
When my machine is blocked in a CKPT, onstat -l shows ... Buffer Waiting Buffer ioproc flags L-1 57c6ab54 0x1 0 L-3 57c69884 0x1 0 ... which is not documented anywhere. I can guess what it means, but does anyone know what exactly it means (and what flags ar…
RE: onstat -t
onstat -t shows tblnum in hex. So you can link it with hex(partnum) of systabnames to get your tablename. HTH Sathish -----Original Message----- From: David Tamburin [mailto:david.tamburin@protegrity.com] Sent: Wednesday, January 27, 1999 4:16 PM To: informix-list@iiug.org Subje…
onstat -t
Hello, Is there anyway to tell what the actual tablenames are when you execute a onstat -t ? I know that tblnum is the tablespace number, but what can this be related too to tell me something useful? Thank you david.tamburin@protegrity.com david Tamburin…
Re: Online command to get status
In article <367EC431.ED304417@calva.net>, "J.-M. Gimenes H. Zalkind" <jmg-hz@calva.net> wrote: > Hi, > > I am running Informix 7.23 UC5 on Solaris 2.6 > > I need to know an Informix command (quick online command I can include > in a script) to get status of Informix server (Qui…
Re: Online command to get status
onstat - J.-M. Gimenes H. Zalkind wrote: > Hi, > > I am running Informix 7.23 UC5 on Solaris 2.6 > > I need to know an Informix command (quick online command I can include > in a script) to get status of Informix server (Quiescent, On-Line, > Recovery...). > > I thought first a…
Re: Online command to get status
J.-M. Gimenes H. Zalkind (jmg-hz@calva.net) wrote: : Hi, : : I am running Informix 7.23 UC5 on Solaris 2.6 : : I need to know an Informix command (quick online command I can include : in a script) to get status of Informix server (Quiescent, On-Line, : Recovery...). : : I thought…
onstat -u
I was running an 'onstat -u' command and have been receiving the following message: "changing data structures forced command termination" I was wondering if any of you have seen this message and might know what it means and how to correct it? David Meyer Guerilla Software…
Re: onstat -h
In article <jlumbleyEytwzI.L2n@netcom.com>, jlumbley@netcom.com (Joe Lumbley) wrote: > > Does anyone have any info about the meanings of the output of the > onstat -h (hash chain info) in IDS 7.3? It's not in the hardcopy or in > the 7.3 Admin manual, and I'm trying to documen…
onstat -h
Does anyone have any info about the meanings of the output of the onstat -h (hash chain info) in IDS 7.3? It's not in the hardcopy or in the 7.3 Admin manual, and I'm trying to document it. Thanks, joe -- -------------------------------------------------------------------------…
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 commands
Does anyone know of a source that describes all of the onstat commands? The 7.x manuals are pretty good, but some of the explanations are a bit brief. ==================================================================== Harold Luse Phone: (970) 491-4120…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
Re: onstat
Gabriel Weisz wrote: > > I tried to run onstat not as user informix and i got > onstat:Share memory:permission denied. > The env. looks fine , the informix server is up. > I am running 7.23. You have to have Informix priv. to run onstat ? No. Check the permis…
onstat -t output
Hi, The output of onstat -t shows zero in the column 'nrows' , whereas ' nused ' and 'npdata' have non-zero values . Why is this so ? TIA Sathish…
Onstat -R
Can someone explain the onstat -R headings.. Is the percentage free or used. Been digging thru the texts.. examples but little explanation? INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- 36320 Kbytes 8 buffer LRU queue pairs # f/m length % of pair…
Novice needs tuning help!
Hello, I've included a zip file of an onstat -a. Can anyone tell this informix novice any obvious problems or changes I can make to improve performance for my OLTP application? I'm running Informix Online 7.22 on a Sun SPARC Ultra-2 with 128K RAM (Solaris 2.5.1). Thank you! …
onstat -g ...
Hi guys, Where I can find explainations about the output format (headers and key words) reported after executing onstat -g ... In the Informix Administrator's Guide there is an explaination of all other options of "onstat", but for "-g" option I did not find detailed informati…
onstat -k
Thanks to everyone who answered the onstat -k tblsnum question. I appreciate it. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-1275 Colorado S…
onstat -k
How would one link the tblsnum field of an onstat -k with a table name? Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 3008c64c 0 4004a354 0 HDR+S 100002 230 0 3008c680 0 40042814 0 S 100002 22f …
onstat -u
Here's a good question. Sample: 4004d214 Y--P--- 4999 dbolte 91 40c936d8 4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 4004e314 Y--P--- 5023 hwhite 77 40006f8c 0 …
onstat and tbstat
Hi, We have just upgraded from 5.x to 7.x. Those tbxxxx files are now onxxxx files, but they still exist lots of tbxxxx like tbstat, tbmonitor, and so on, are these files different from the new version onstat and onmonitor or they are the just the same but with different names??…
Re: (CKPT REQ) ?????
W. H. SMITH wrote: > > Barry Lemrow wrote: > > > > I have been experiencing problems where the database locks up. The onstat > > command banner contains this: > > > > INFORMIX-OnLine Version 7.21.UD3 -- On-Line (CKPT REQ) -- Up 6 days > > 05:13:28 -- 175552 Kbytes > > Blocked:…
Re: onstat -d,onstat -D
I believe 1001 indicates that the dbspace is a blobspace. I know that 2001 indicates that the space is a temporary dbspace. "Tony_Reynolds(Accounting & Purchasing System") wrote in message <67972r$caj@cssun.mathcs.emory.edu>... >Can anyone tell me the difference between a dbspa…
Re: onstat -d,onstat -D
I believe it in indicates that table in dbspace has been dropped. -Lin "Tony_Reynolds(Accounting & Purchasing System") <tr-2959@mail.necgroup.co.uk> wrote: > Can anyone tell me the difference between a dbspaces address with a > flag of 1 and a dbspaces address with a flag of 100…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Onstat Utility
Hi, I'm using onstat -g ath and see threads that are slleping forever. What could this be? Are users not exiting properly from Informix? How do I kill these processes. Thanks Bob…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
RE: Exit status of onstat
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_000_01BCD349.F0C6E050 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Is there anyway to run "o…
Re: Logical logs are backed up but seen as not freed in onstat -l
In article <3399DA10.C5B@columbia.edu>, Boris Niyazov <ban5@columbia.edu> writes >I've just upgraded my Online 5.07 to 7.22 DS (Solaris 2.5.1 Sparc). >What I am noticing that while I am runing continious backup ontape -c, I >see that logical logs are backed up ok , but they appea…
Onstat question
When we use the Onstat -u , sometimes we get this display: onstat -u INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 332c020 ---P--D 0 inf…
Re: onstat options
Mark H. Preston (markp@mamasita.rose.hp.com) wrote: : Hi, : What are the best indicators of response time, trans/sec, and general : load for monitoring an informix database... using the onstat program? : Any help would be appreciated. Thanks : Mark~ Hi Mark ... Here is a sa…
onstat options
Hi, What are the best indicators of response time, trans/sec, and general load for monitoring an informix database... using the onstat program? Any help would be appreciated. Thanks Mark~…
Re: onstat
Steve Romankiw wrote: } } In onstat, what does "total" refer to. } } . } . } 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } 0 } 13 active, 128 total, 44 maximum concurrent } } Thanks. } } Steve Romankiw } Executive Risk Inc. For Online 7.1, the total fi…
Re: onstat
Carol Davies wrote: } } Steve Romankiw wrote: } > } > In onstat, what does "total" refer to. } > } > . } > . } > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } > 0 } > 13 active, 128 total, 44 maximum concurrent } > } > Thanks. } > } > Steve Romankiw } >…
Re: onstat
Steve Romankiw wrote: > > In onstat, what does "total" refer to. > > . > . > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 > 0 > 13 active, 128 total, 44 maximum concurrent > > Thanks. > > Steve Romankiw > Executive Risk Inc. From the Informix Administrat…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
onstat documentation
Does anybody have any good documentation for onstat? In case it varies to much from one version to the other I have online 7.11UC1. thanks…
ONSTAT question
Hi there. onstat -u (version 7.1) sometimes shows a user thread with position 1 of the flag field set to Y. The Informix manual says it means "Waiting for condition". I cannot find anything else. What is a condition, and why is my thread waiting for it? Thanks for any help Ba…