Oninit® Archive
Results for “QSTATS”
Current Role
Thanks Art, We'll have to parse the output from onstat -g ses 0. dk…
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 …
script to check status of dbspaces & chunks
Can anyone please share DBmon (with onstat -d) script ?…
sysrstcb
Thanks Art. So the only way to look the session and the table is use onstat -g opn to get TID then, search for SID at sysrstcb?…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Hello Andreas, SMI tables sysmaster:syssqltrace[_*] show me „the past" and are very useful for history analyses and similar. When I am trying to find reasons why systém is „slow" currently, onstat -g ses [Aa]ctive, onstat -g ses [Rr]unning, onstat -g spf and in 14.10 onstat -g to…
SMI equivalent of onstat -g spf
True, but also applying to onstat -g spf, afaik. ------------------------------ Andreas Legner ------------------------------…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help. Arr ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
onstat -g ses returns "Changing data structure forced command termination"
HI, I was asking about: " there is a couple of other onstat output problems with changing structure ( onstat -g top session cpu|bwr|bfw, onstat -g top sessmem gro which I observed) or incorrect output (onstat -x). We asked to fix as well." Do we have APARs for these? ------------…
flags (onstat -g ses)
Primary thread for the session https://www.oninit.com/onstat/pda.php?id=onstat%20-g%20ses Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC…
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 ------------------------------…
How to tell if logs are caught up in HDR
Thanks I will check the message log. What in particular am I looking for in the information given in onstat -g dri ?…
SEQSCANS Counter in sysptprof
To find your query turn on sqltrace in low mode. You can then search for the part number of the table in the query plans displayed by 'onstat -g his'. Bear in mind that 'onstat -g ppf' reports part numbers in hex and 'onstat -g his' uses decimal. Ben.…
Misconceptions about Update Statistics
- Drop statistics of a columns followed by collecting high mode statistics for the same column for every indexed columns - After that, update statistics for procedure - This routine repeats for every database of the instance. So I developed a system with database execution queu…
Backup Help
When I ran onstat -, it says Blocked: LAST_LOG_RESERVED4BACKUP When I ran onstat -l grep C-, it gives me U---C-L…
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…
overzealous checkpoints
onstat -g ckp (or look at sysadmin:mon=5Fcheckpoint if the problem is=20 further in the past.) -> what's triggering these checkpoints (Trigger in onstat, type in monitor = table) ?…
CDR DS CDRD_xx thread is aborting
Your stable storage SBLOB for the receive queue was probably unlogged so when the fail-over occurred the transactions were not complete. While it might look scary, it is probably not a real issue. Items are placed in the receive queue only when the receive memory buffers become …
IDS not writing to online.log
Also, onstat - always has the same output…
LRUS_MIN MAX DOES NOT WORK
When dirty buffer is over 4000 (resulut of onstat -R), I check onstat -F and I found that my 8 cleaners are in state "I".…
False non-exclusive access when select a table
Hi Andreas, onstat -g opn previously saved (namely before restart) doesn't show any records for the partnums of table's indices. The partnums (for the table and indices) are in the outputs of onstat -C all and onstat -g ppf. Thanks. Roger…
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…
Enable or Apply Auto Update Statistics
Hi All, Here is email communication between Ben and myself. I hope this will help someone who really want to play with AUS feature. -------------------------------------------------------------------------------- ---------------------------------------------------------- Hi Ben…
Process exited with return code 0
Folks, IDS12.10 FC4, Redhead Linux. I believed I saw this error before and can not recall its answer or explanation. /usr/informix/etc/alarmprogram.sh is the original script( no touched). It was quite before, just started to complain two days ago after the instance bounce . Ot…
Move sysadmin database
More info from log. Frank 14:41:41 Maximum server connections 173 14:41:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2098, Llog used 16042 14:42:42 SCHAPI: thread dbWorker1 task mon_checkpoint(7-14406) shutting down 14:42:42 SCHAPI: thread db…
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…
SCHAPI table estimate_compression
Folks, IDS12.10 FC4, Redhat Linux Just curious about the automatic " SCHAPI Estimate Compression..." info in the online log. Why did it estimate compression automatically? Really needed ? Apparently, Informix does not compress tables automatically. Thanks Frank 4:28:05 Check…
CDR question on big transaction
In the source side, 'onstat -g nif' show the state is 'RUN,BLOCK'; In the target side, 'onstat -g nif' show the state is 'RUN';…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Setup HDR
the onstat -c|grep STACKSIZE is : priamry : STACKSIZE 64 secondary : STACKSIZE 64…
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…
CDR_LOG_LAG_ACTION shutdown issues
Hello, I have an Enterprise Replication setup in a lab environment, and I am specifically testing to see if setting CDR_LOG_LAG_ACTION to shutdown will turn off replication when the replay position is in danger of being overrun. I have three 256MB logical log files, and I pulled…
onstat -g osi
onstat -g osi neat command does not appear to be documented anywhere Is it ?…
WL -244 Could not do a physical-order read to
Hi Gurus, I would like to ask your assistance on isolating the problem encountered below. The application team is trying to isolate what caused the problem -244 in Weblogic Apps Server side. I have already verified the indexes and also done update statistics of the tables concer…
ER network replication state
Hi Madison, that the problem is on the target would explain that we have the same problem on the 2 source servers. But why we cannot see anything on the receive queue? There was no spooling. Or 'full receive queueu' means only the memory queue has to be full to get this blocking …
ASF Echo-Thread Server: asfcode = -25582 oserr = 4
01 Logical Log 2976 Complete, timestamp: 0x4b72b5ad. 03/29/13 11:13:03 Logical Log 2976 - Backup Started 03/29/13 11:13:07 CDR Spool transaction queue completed 03/29/13 11:13:15 Logical Log 2976 - Backup Completed 03/29/13 12:11:08 Logical Log 2977 Complete, timestamp: 0x4bd674e…
Enterprise Replication recovery slow on Solaris
I do not recall if update statistics was run on the backup, but we have a script that is run periodically out of cron that is tuned to our application to run update statistics on the primary. Unfortunately, I did not realize until now that this cron job is disabled on the backup.…
Re: ER issue
Yes - basic checks look good - although onstat -g nif shows run/blocked on server 1 [informix@psdb01spr logs]$ onstat -g nif IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 9 days 08:37:50 -- 20724404 Kbytes NIF anchor Block: 0x7d2f0ad8 nifGState …
ER issue
I have two IDS 11.7FC7 servers replicating data. I have ER replication between the two, all data changes are made on server 1, recently it appears that data has stopped moving to server 2. The sendq on server 1 continues to grow, while the recvq on server 2 appears to be stuck…
problem with IDS 11.70FC4 and RedHat 5.6
Hi, What is the output of onstat -g seg ? Its good to tune VP_MEMORY_CACHE_KB 10240 also. rgds schillache…
Scheduler Status
original post: IDS 11.7 I know how to stop and start the scheduler: execute function task ("scheduler start"); execute function task ("scheduler stop"); ..... but how do you check the status, to see if it is running or not ? Response: You can run onstat -g dbc If you see …
ER queue question
Hi, we are using ER to replicate some tables from one to another database server. Version on both is 11.70.FC5. Now I see some replicates where the QUEUE SIZE does not change. My experience is that the QUEUE SIZE always tends to zero. cdr list repl | grep QUEUE QUEUE SIZE: 0 …
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…
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 …
Wait and Queue statistics
Can anybody provide clues on how to interpret onstat -g wst and onstat -g qst output please? I looked at the standard documentation but not much useful. Thanks, idos…
ph_task scheduled tasks
onstat -g dbc output is "Database Scheduler is Disabled.". How can this be enabled? -Prasad…
Informix process reads a lot of pages
I try onstat -g ses and onstat -g ses <session id> but results was: IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line (Prim) -- Up 8 days…
ER RQM error in IDS11.50 FC8
Madison or all ER experts, We have three sites by ER replicated with UpdateAnyWhere. This is a brand new installation and ready to be operational soon. We are doing some testing and saw the following types of RQM error in online log( see below logs) frequently when you run cdr …
ER error
Sorry Karl, for any confuse. Build Version: 11.50.FC8 Build Number: N198 Build Host: vidar Build OS: Linux 2.6.9-34.ELsmp Build Date: Fri Nov 12 21:58:33 CST 2010 GLS Version: glslib-4.50.FC11 I wish the info now is more clearer. The following is log info generated by a cdr st…
Get instance names from PIDS?
On Apr 21, 2:45 pm, Jack Parker <jack.park...@verizon.net> wrote: > onstat -g dis > doh <facepalm>…
IDS 11.50/AIX 5.3 Slowness Issue?
Bob, On Mon, Apr 11, 2011 at 4:36 PM, rroussey@comcast.net <rroussey@comcast.net>wrote: > How many LUNs are you hitting? How many dbspaces / chunks are on those > LUNs? > Does Compellent have a utility to show queue depth on the SAN? You may have > too many threads hitting a lo…
ER errors after 11.7 FC2 upgrade
I'm confused. Are you on IDS 10 or 11.7? Why don't you send me a dbexport of your syscdr database --- assuming that the queues are currently empty... From: "JARED HEATH" <jared.heath@sbcglobal.net> To: ids@iiug.org Date: 03/31/2011 05:58 PM Subject: Re: ER errors after 11.7 F…
sysmaster query
Hi, Is there any sysmaster query which is substitute of onstat -g ses <session id> command ?…
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…
IDS v11.10 hang: no error / logicalLog not full
what does onstat - look like? Is the server waiuting on something to finish?…
RE: Enterprise Replication help - urgent
PMR logged - 03969,999,796 - now I wait for IBM to ring back :) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Tuesday, 24 August 2010 2:45 a.m. To: ids@iiug.org Subject: Re: Enterprise Replication help - urge…
RE: Enterprise Replication help - urgent
Thread 205 is gone (disappeared with the engine bounce) As it was heading into the night here in New Zealand, I threw a whole heap of space at the smart blob space and said "sort it in the morning". My first task when I get in to work (about an hour away) is to raise a case with …
Enterprise Replication help - urgent
Hi, I have two machines, RHEL4, IDS 11.50.UC5X2 is a ER Leaf node, RHEL4 IDS 11.50.UC5 is the ER Enterprise node. The leaf node is in collect mode and won't transfer any data back to the ER node (we have replicates running both ways and neither are processing at the moment). I ne…
Enterprise Replication help - urgent
Hi, I have two machines, RHEL4, IDS 11.50.UC5X2 is a ER Leaf node, RHEL4 IDS 11.50.UC5 is the ER Enterprise node. The leaf node is in collect mode and won't transfer any data back to the ER node (we have replicates running both ways and neither are processing at the moment). I ne…
onstat -g rea
exist a query over sysmaster with similar output of 'onstat -g rea' or 'onstat -g act'?. Thanks…
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…
soctcppoll and soctcplst
Hi, What is the difference between a thread called soctcppoll and soctcplst ? I'm confused with the output of onstat -g ath…
How to check informix DB bottlenecks
Hi All, How to check the informix tables for bottlenecks? i am having problem our database and the user are explaining that it is a DB problem. I verified the logs and there's no valid error on the log file... I've used onstat -g sql, onstat -g ses, onstat -g lmx, onstat -k for…
onbar restore hanging
Hi, Do onstat -g iof moving or not on individual chunks? rgds schillache…
how to analyze bottleneck in informix db
Hi All, I'm curious about on how to analyze a database which has bottlenecks... On my perpective, i'll do the ff: 1. onstat -u -- to check what user. 2. onstat -g ses -- to check the current session. 3. onstat -g mem -- to check the memory. 4. onstat -k; to check the processes …
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 ---------…
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 …
onstat -g arc select statement
Hi All, is the someone who knows the onstat -g arc select statement equivalent? Thanks,…
Help with debugging Queries
Yes, in the output from onstat -k you see a column called owner. You can grep this value from an onstat -u output. The output from onstat -u will include session ids (I think in column 1 but I can't run the cmd right now) that can be used with onstat -g sql to determine what sql …
Raw devices softlink to dbspaces were lost
You have an onstat -d output? then you have the link paths... unless I am misunderstanding you. MM…
too many open cursors in one table
For a queue table like that, assuming the number of rows is about the same from one day to the next, I would run an UPDATE STATISTICS LOW... DROP DISTRIBUTIONS after the load at 8:30 and NOT anytime between the delete and the reload. Without distributions, IDS will use the older …
Table accessed
I am pretty sure that version of Informix has the onstat utility. When a session connects to the database look at the output from onstat -g sql, locate the session id of the connected user and then run onstat -g sql <session id>. If the user is accessing a table it will show up t…
onstat shows memory held by finished sessions
Hi, I am using IDS 11.50 on HP-UX 11. The onstat -g ses shows the sessions which are complete. For example the program is finished but still the onstat -g ses shows insert session. The session details show it as "current SQL statement". Is the session still holding the memory? I…
I/O writes
Thanks a lot. It got me out of confusion. And do you hinkthat I/O queue length are not bad? Here are recent messages found in online.log ------------------------------------------------------------------ 07:35:02 Logical Log 27846 Complete, timestamp: 0x5a4d390a. 07:35:02 Process…
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…
Question about ISAM reads vs output of onstat -u
Environment: Informix 7.31 S.O. HP-UX 11i The ISAM reads (output of onstat -g ppf) and disk reads are the same ? I followed the next steps: 1. session a: onstat -z 2. Session b: I run a query in dbaccess 3. Session a: onstat -g ppf | grep 0xb00091 (a particular table reads in…
Migrating from IDS 9.40.UC6 to 11.50.UC3
onstat -g ath ? onstat -g stk all ? What IS going (on)?…
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/…
temporary table display problem in 'onstat -g sql'
Please provide the output of onstat -d from these two instances…
slow connections
> My idea : > > - OS level such as kernel parameter, error log from system > , i/o busy > - Network level such as network card errors , network log > > For IDS : > - Check point duration and check point interval (system will be blocked while doing checkpoint) > - try to change > …
ontape -r suddenly very slow
During the restore, using onstat -D, see if you can determine a specific dbspace/chunk that is having issues. Mike…
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…
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: stuck on checkpoint
Hi, Whats the output of onstat - and onstat -m command? Try to give ontape -a command, if its blocked for checkpoint.It will take logical log backup clear the Blocked CKPT.…
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;…
Raw Device setup on SAN disks - suggestions?
Unfortunately, 1 LUN = 1 queue (for all reads and writes). IDS is multi-threaded. The "many physical disks" does not overcome the 1 queue in my experience. I would suggest multiple smaller RAID 10 LUNs so IDS can pump the data through multiple queues. Bob Roussey Unix / Informix…
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…
Re: Replication Newbie Question
On Feb 16, 9:15 am, "Laurie Gustin" <LGUS...@utah.gov> wrote: > I learned that one possibility for replication delay may be that I am replicating data from a blobspace, and that process was very slow. That seemed ok, except that now the send q has been growing for over 24 hours…
Re: Replication Newbie Question
Check the queue stats using onstat -g rqm at source. And receive stats using onstat -g rcv on target. Although servers are active, check if replicates are active using 'cdr list repl' and verify the state. Regards, Nilesh "Laurie Gustin" <lgustin@utah.gov> Sent by: informix-li…
Replication Newbie Question
IDS10 FC5 HP-UX 11.11 I have a quick question about replication. I have ER running between two servers and the queue on the sending server just keeps getting larger. It appears that the 2 servers are communicating, but how do I get the queue to write/flush so it doesnt just k…
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 …
Command to tell the age of a lock
This morning was asked "How can I tell how long a lock has been held?" I rifled through onstat -k, onstat -g ses (sesid) and onstat -u, but didn't find anything that told me the "age" of the lock. Is there a command that will do that? DT…
record locked
a combination of onstat -k and onstat -u…
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…
CDRGfan and Database crash
Hi All, MASTER: TARGET: IDS 10.0.UC3 IDS 9.40.TC6 ELAS3 (Kernel 2.4.21-4.ELsmp) Win 2K3 DELL PE 6600, PERC4/DC We had a DB crash. Oops !!!! Logged the issue with IBM thorough our ap…
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…
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.…
Track a session to a Buffer
Hi All, I just had a case where onstat -u returned a 'B' as the first flag in the second column for over 100 sessions. The wait column for all the sessions had the same hex number. Is it possible to track down the session that is causing all the others to wait? I tried onstat…
AW: Multiple instances
>use onstat -g env Very cool, I did not know this. Thanks.…
How to get ip address of client ?
Hi guys, is there any way to obtain ip address (not a symbolic name) directly from server ? onstat -g ntt returns symbolic name, onstat -g dmp <hex addr> netsch_t - the same. Any ideas ?…
Informix database filling up rapidly
Run onstat -u and onstat -g ses for each session. There must be an application creating temp tables or doing queries that take a long time and are not using indexes.…
Re: Informix questions
What he said.... I believe onstat -d shows an S against smart blob spaces.…
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?…
engine blocked for Long TX
Well what is the output from onstat -m? and onstat -l? Does the output from onstat -l change? If you have lots of small logical logs you should be able to see the flags change on them as they get applied. What does onstat -x give?…
Re: Oninit from cron leaves engine in permanent fast recovery
When it hang what does the online log say? What does onstat - say?…
Error Dopping Temp DB Space
How does it show up on 'onstat -d update'?…
Transaction Rollback
onstat -x…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com wrote: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also updated. > When I tried to look in to the I/O activity, I could find that kio is > having maxl…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com wrote: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also updated. > When I tried to look in to the I/O activity, I could find that kio is > having maxl…
Re: very high "mt yield 0" on IDS 9.40
"rvb" <rvbon@gmx.de> wrote in message news:6e9a0040.0503030106.178fac00@posting.google.com... > looking at the wait statistics of my IDS 9.40 I find an ever > increasing value for the "MT yield 0" condition. > > Up to my knowledge this means that threads are doing busy waits for …
very high "mt yield 0" on IDS 9.40
"rvb" <rvbon@gmx.de> wrote in message news:6e9a0040.0503030106.178fac00@posting.google.com... > looking at the wait statistics of my IDS 9.40 I find an ever > increasing value for the "MT yield 0" condition. > > Up to my knowledge this means that threads are doing busy waits for …
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…
Re: SQL Tracing tools?
"Abdullah Kauchali" <abdullah.kauchali@someplace.com> wrote in message news:cnicmc$spp$1@ctb-nnrp2.saix.net... > What do informix users use to profile (log) SQL statements hitting the > database server? (In MS lala-land, we have the almighty Profiler Tool. > Works well.) We us…
Re: Fatal error in ADM VP at mt.c:12239
Here is another part of the af file: ===========------------- - - - - - - /home/informix/bin/onstat -F: IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 1 days 20:14:49 -- 2549264 Kbytes Fg Writes LRU Writes Chunk Writes 0 8396195 30928…
Re: HDR question
I normally take it granted whatever comes from Madison especially for ER/HDR. Also, not sure if this may help any thing to you. 1. onstat -g ddr 2. onstat -g rqm FULL Hari…
Update statistics performance
Hi all Update Statistic takes a long duration of up to 13 hours to complete, our DB is more than 35 gb. I tried to use PDQ ,PSORT_NPROCS and DBSPACETEMP and the was only a slight improvement i.e from 13 to 12 hours. our IDS version is 17.31 uc5 Kindly advice on how this duration …
Upgrading the IDS from 7.31 FC2
Some hints to avoid migration issues when migration InPlace: PHYSLOG should be plenty (minimum 200 MB, 1 GB for large systems) LOCKS should be at least 4x(max(count(sysobjstate),count(syscolumns))) Do oncheck -cDI before migration Do "update statistics low drop distributions" be…
Re: query performance tools
"Richard Kofler" <richard.kofler@chello.at> wrote in message news:40C211D6.35DCC9D7@chello.at... > Give onstat -g stm a try! Huh?…
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…
What do session statuses mean?
What does a status of "cond wait(await_MC1)" in onstat -g ses mean? Thanks Andy…
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
how to use onstat -P
How to use onstat -P(not -p) to tell informix server's performance question:? -- Posted via http://dbforums.com…
Onstat -d output for 32bit 9.40 version (9.40.UC*)
Can someone provide me the output of the onstat -d command for a 32 bit version of 9.4? Thanks in advance.…
[HELP] What my Informix is doing?
On 11 Sep 2003 02:54:04 -0700, steven@steven4u.net (steven) wrote: >My system is SCO OSR5 + Informix Online 7.x with 128M ram. The >database is created w/o loging. > >Is any method here let me know what the Informix is doing? > Try with some "onstats": onstat -p onstat -u ons…
Re: Disks for informix
Mark, According to onstat -d, none of the other chunks have an offset (well they do but it's 0).…
replication
tomL wrote: > > Is there a command that will return what type of replication is being > run? If you run onstat - then if you see something like: Informix Dynamic Server Version 7.31.UC5 -- On-Line (Prim) -- Up 62 days 20:28:42 -- 53248 Kbytes or Informix Dynamic Serv…
Dropping distributions after upgrade
John I think you are hitting a known bug:- Bug 157747 UPDATE STATISTICS LOW WITH MANY DELETED BTREE ITEMS CAN CAUSE SEVERE PERFORMANCE DEGRADATION - resolved 7.31.UD6 After the upgrade update statistics had been run; not only did this take an inordinate amount of time, this als…
Who are the most active users?
You probably right it look like it does not work on NT Uri Merrill, Douglas D. wrote: >The instance has been restarted twice since I made the change and I still >get zero rows returned. Does this not functio on NT? > >-----Original Message----- >From: Uri Haham [mailto:uri@com…
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 …
FW: Queue statistics
On HP I just add the following entry to the onconfig file - WSTATS 1 You will have to shutdown and restart the database of course Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Beh…
Queue statistics
Hi! What should I do to enable queue and wait statistics ( those shown with onstat -g qst , onstat -g wst ) ? I have IDS 2000 V 9.20 on an Unixware 7.1 box . Thanks. Sorin Ifrim…
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 …
SET LOG question
Art S. Kagel wrote in message <3A5E291C.A9FCC7A7@bloomberg.net>... > >> Does the server write imediatelly the transactions to disk only for that >> session, or for all sessions ? > >Well..... If ANY database is Unbuffered Log Mode and a transaction against >a table in THAT datab…
Re: 7.31 performance problem
Yes I have. KT > Have you run update statistics? onstat -p shows a lot of sequential scans.…
Re: CLEANERS
In article <3a2d750a$1@news.iprimus.com.au>, "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > William Rice wrote in message <90isbi$1j4$1@nnrp1.deja.com>... > >In article <3a2c1dd0@news.iprimus.com.au>, > > "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > >> hanna_shaw@my-deja.c…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
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 …
FW: Performance dive over time
You are right about too many CPU VPS. I currently have 7 on a machine that only has 4 physical cpus - don't ask. We've been having performance problems since we migrated to this machine on August 04. We are also running with an Informix patch and not the standard oninit anymore.…
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…
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…
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…
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: Load Performance problems
Hi ! QSTAT ? what does it do ? I didn't find it on my onconfig V7.30 and TBLSPACE_STATS 1 What is it for ? tablespace statistics ? where do they go ? so, better to 0 ? Regards, Manel Falcó > >>QSTATS 1 > >Do you really want this on? > >># Read Ahead Variables >>…
Load Performance problems
The parameters that control this are CKPTINTVL and PHYSFILE. You will not be able to eliminate checkpoints altogether unless you are willing to make PHYSFILE 125% of the number of pages that will be updated during the load which is unreasonble. You could however, make CKPTINTVL…
RE: Performance Issues
A couple of notes. I do not have any experience running informix on NT, just UNIX. Read up on all of these parameters before setting any of them. If you have any questions about them, post them to the newsgroup or email me. 2000 BUFFERS is way to low. Is the database the only …
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…
What Informix Version?
You get the informix data by typing 'onstat' on your command line. The header provides all the info you need.…
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?
Hey, so I am a copy cat. I never claimed anything I said was original Will >===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> ===== >From: William Rice <ricew@operamail.com> >> >>onstat -c >>onstat -m >>onstat -d >>onstat -D >>onstat -p >>onstat -P | tail -5 …
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…
onstat -g Question
Yuri Dovgart wrote: > Use onstat -g arc. This must help. Note that backups to /dev/null will also be "recorded". Rudy…
Posting from the Informix-list
onstat -g ntd Nona…
Why sequential scan???
Jeff Larsen wrote in message <38b5bbb8.288523384@client.ce.news.psi.net>... >mars1972@my-deja.com wrote: > >I think you might have something here. This is a highly volatile >table (a real-time message queue), so the statistics would be meaningless >anyway. Thankfully it stays s…
Finding CPU hogs
Is there any way to determine which user session might be causing oninit to hog the CPU? Can any of the onstat -g commands help?…
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. …
Re: Strange advises
It sounds like what your basic questions are is "Do these suggestions make sense?" and "What can I do to improve performance?" > The first is "You have KAIO running. We are aware that this feature is > causing > performance problem with Informix implementation. Recommend to n…
Bufwaits and Foreground Writes
Got to toss in my $0.02US. Everyone is giving you basically good advice, except those Informix guys (maybe I should give a Performance Tuning class for Informix consultants and trainers!). I just wanted to add the weight of my opinion so you take this good advice. Read on. "B…
hash buckets
Hi all, please what does it exactly means the "hash buckets" in the bottom of some output of the utility onstat (onstat -k for exemple ) 74 active, 100000 total, ??? 52768 hash buckets ??? thanks for any help…
Re: upgrade to IDS 7.30 UC2-1
From: "Ralf Peters" <RalfP.remove.@marlows.com.au> > >After we upgraded to version 7.30 UC2-1 IDS running under DG/UX 4.20, the >engine seems to run like a dog , nothing else has changed. it seems that >after running update statistics it is even worse . > >ONSTAT - R >Informix …
upgrade to IDS 7.30 UC2-1
After we upgraded to version 7.30 UC2-1 IDS running under DG/UX 4.20, the engine seems to run like a dog , nothing else has changed. it seems that after running update statistics it is even worse . ONSTAT - R Informix Dynamic Server Version 7.31.UC2 -- On-Line (CKPT REQ) -- …
Last parsed SQL statement
When onstat -g sql <sessionid> is executed is gives the Last parsed SQL statement. Is there anyway of querying the sysmaster database to get this statement?…
onstat -g mem
Please where can i get some explanation about onstat -g mem…
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.…
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: …
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é…
Q: Counters reset for onstat
The counters for the output of the onstat commands get reset every so often. What controls these #'s being reset? How often do they reset? The arguments that I am looking at are: onstat -g iof onstat -g ioq onstat -g iov Sent via Deja.com http://www.deja.com/ Share w…
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 ___________________________…
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: HP-UX 10.20 , Informix 7.30 - advice needed
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_01BEA390.33834894 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit ****** Message from InterSc…
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…
Effect of disk striping on disk layout
Are you using kaio? (You can check this by running onstat -g ioq - if there are kio vps listed then you are). Neil…
Index, Foreign Keys, and Fragmented Tables?
Russell Bierschbach wrote: > > My database currently has two large tables (and a couple hundred small > ones). I'm in the process of moving the database to a new server, and > fragmenting these large tables accross several dbspaces at the same time. I > saw previous posts about…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
partition profile
Hai.. All.. When I type onstat -g ppf, I found Partition profiles disabled Does anybody know about this ?…
Re: The last executed SQL statement
Once again to add to the Clowns' reply. run onstat -u and look for the userid in question, this will show y ou which sessionid to use in the onstat -g..... Terry Obnoxio The Clown wrote: > >How to obtain the last executed SQL statement? > > If you're using IDS, onstat -g …
Re: The last executed SQL statement
>How to obtain the last executed SQL statement? If you're using IDS, onstat -g sql <sessionid> or onstat -g ses <sessionid> HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
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…
Any one know this?
Doug McAllister wrote: > > In whatever shell you are using set a variable equal to `onstat -|grep > OnLine|wc -l` > if the variable = 1 then the engine is up and running. You mean: onstat -|grep "On-Line"|wc -l Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 00:43…
Re: Slow Process
>Informix 7.30 >Hp 9000 unix >4 Proc. >1 gig RAM >2 db instances of 14 gig each (approx.) >Application: Elite Legal Billing System >Process: Proforma Generation > >We recently upgraded from 5.10 to 7.30. Everything is running >smoothly with the exception of "proforma" generati…
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…
Script to find 'active' IDS 7.2x threads
Here is a script we have used to track 'active' threads in IDS 7.2x . We have it linked to onstat-u and onstat-ur so we can have it repeat or not. S.W. wilcoxon@pioneerplanet.infi.net -------------------------------Cut Here------------------------------------ #!/bin/sh # # Do a…
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…
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…
seqscans (onstat -p)
What does mean seqscans in onstat -p ? Thanks Cajt…
Re: latch/lock , buffer - questions.
Sadagopan, Sathish wrote: > > Hi All, > 1) When a thread needs a buffer to read in data , does it acquire any > latches/locks.How is the allocation done ? This is all explained in the Administrator's Guide. Basically the thread hashes into the LRU queues selecting a queue at …
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…
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: queue statistics
Sadagopan, Sathish wrote: > > Hi, > The qst option of onstat says "queue statistics not enabled".How to enable Q > statistics ? There is an environment variable that has to be set in the engine's environment at startup that enables stq and wai statistics recording. These are dis…
queue statistics
Hi, The qst option of onstat says "queue statistics not enabled".How to enable Q statistics ? TIA Sathish…
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…
onstat -g dic
Someone knows what is the result of onstat -g dic ?? Thanks.…
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: Update Statistics
Robertson Lee NTSE wrote: > > All, > > I have been left a large script by the Informix DBA to run. It does an > update statistics (low, medium and high) on all of the tables in the db. > > Is there any way I can monitor how this is doing as at the moment it is just > sat in dbacc…
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…
Re: Get Server Version, Programmatcially
Dave, You also can use 'onstat - ' to get version. It is a command and not a function. Depending on what language you are using to get the information. Howshinn…
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…
Performance & PDQ et al...
We have several update process that are currently very slow, (~ 12 hr each) And have enabled PDQ but no table fragmentation yet. Here is our onstat -g mgm output. Interesting that I note, there is not many contention with the PDQ, and very little I/O loading and have free CPU re…
onstat -p seqscans
Hi, Does anyone know if the seqscans in an onstat -p increments for sequential scans on temporary tables ? Cheers, Tony.…
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: Undocumented oninit variables
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. ----------------------------------------------…
Re: excessive latch waits
In article <5k3eeg$s0h@cssun.mathcs.emory.edu>, Mark Steele <msteele@firstam.com> writes >Got a little problem. I am running Informix 5.01.UD3 Online on an IBM >RS/6000. Lately we have seen some performance problems. Then looking >at tbstat -u, I am seeing an excessive amount …
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…
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.…
Re: What do you know about the btclean thread
The btclean cleans up the index entries which have been marked for deletion. It is normally asleep untill it is activiated by another thread. There is a queue containing a list of all leaf pages which have items marked for deletion. When the btclean thread is activated, it runs…
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…
Re: Executing stored procedures - performance problem
Oleg V. Besedin wrote: > > recently we found a kind of interesting behaviour of our Informix system. > Stored procedures which normally work within 2 - 3 minutes started > to take 8 - 9 hours to complete (180 times performance drop - ha-ha). We recently had a drastic performance…
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…
Re: LRU writes
On Fri, 3 May 1996, Mickey Mestel wrote: > first of all, have you migrated from another version, where you have > something to compare it with? that is an important point. We came from 5.x > the next question is, have you run update statistics on your > databases, (especial…
Re: LRU writes
brian, > > response time, that is pretty much the end goal. > > Our response times suck! first of all, have you migrated from another version, where you have something to compare it with? that is an important point. the next question is, have you run update statistics on yo…
Re: Peformance degradation
In my experience striping disks used by OnLine should be avoided. The problem is that you lose control over the positioning of the data. You may have by the reorganisation, arranged your data in contiguous extents but has your striping software actually placed the data in phy…
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…