Oninit® Archive
Results for “onstat -g ath”
onstat -g ses returns "Changing data structure forced command termination"
Hello, I installed a new informix server version IBM Informix Dynamic Server Version 14.10.FC9 running on a RedHat Enterprise Linux 8.4 VM machine. I noticed that every time i run the command onstat -g ses <sessionid> i receive the following message: Changing data structure force…
onstat -g opn: What sysmaster tables will get me this info?
Look at filefd column – I think that links to something that will provide the isfd from onstat –g opn and then the partnums Cheers Paul ------Original Message------ Paul replied privately but I think this should opened up for the sake of community knowledge: Paul suggested use of…
Backup Help
can you post an 'onstat -g ath', please? From: "BENJI LONG" <ruggedmouse@hotmail.com> To: ids@iiug.org Date: 09/13/2017 05:37 PM Subject: Re: RE: Backup Help [39826] Sent by: ids-bounces@iiug.org Hi Mike, no i am using ontape. I ran: ontape -s -L 0 -t STDIO >/opt/informix/full…
IDS not writing to online.log
yes, I can't see logical logs and checkpoints in online.log. What should I look for in onstat -g ath and stk ?…
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
Only -g all is printing this info, right after -g ath - no separate=20 onstat option for this. HTH, Andreas From: "MICHAEL HOFFMAN" <offdisc@gmail.com> To: ids@iiug.org Date: 22.03.2016 00:34 Subject: onstat -a order [36806] Sent by: ids-bounces@iiug.org Hi All,=20 On Informi…
Poor performance on VMWare
Hi Javier, Very interesting (and topical) topic. Interesting to note SRVR1 is on RH 5.3 and SRVR2 is on (virtual) RH 6.3 From onstat -g ath, do you see "kaio" in both servers? When you start up the engine, there should be quite a few messages reported up to "On-line mode" ...…
onstat -g ath
In the vp-class column of onstat -g ath output, some of the entries has an asterisk appended (i.e. 1cpu*). What does that signify?…
Re: HDR and ER Running Together
Original post: Particularly Jacques or Madison I've had this situation four or five times now, HDR has restarted sending updates as soon as the secondary engine has been bounced, but this is obviously a manual process and suspends ER for the duration of the HDR catchup. I will …
onstat -g ath
Can someone point me to a doc explaining what the status of IO Wait means with the above onstat command. I have attempted to explain it to my Unix admins, but they just don't get it...and claim the San never is busy... Thanks in advance ... Peter Logan Senior Database Administr…
Mutex wait
Hello All, IDS 11.50.FC8W2 on HP-Unix Reposting this issue as I did not got any response for my earlier thread and yesterday we again saw a near outage due to mutex waits in the database. We experinced some dip in our performance(load jobs) and while checking the user I saw qu…
Mutex wait
Hello All, IDS 11.50.FC8W2 on HP-Unix We experinced some dip in our performance(load jobs) and while checking the user I saw quite many sessions with S- flag indicating these were waiting on mutex. I checked in onstat -g ath and found the following different waits: 8815514 c00…
IDS tcp listening port on RHEL 5
On Nov 22, 12:53 pm, June Nebab LKINY <jne...@idealcut.com> wrote: > I tried different tcp port numbers (ex: tcp 6975; tcp 55001) for my new IDS 11.7 UC 1 GE to listen to on RHEL 5 but i'm not able to connect to it using OAT or even "telnet hostname portnum". > > service iptables…
Queries waiting for mutex
Thanks for the reference Frank. I suppose I'm not the only one who got the wrong impression from the Admin Reference documentation on onstat -g lmx stating that the holder column was the "Session ID of the thread holding the mutex". Sounds like the holder column is Thread ID and…
wait for mutex ... IDS hang....
Frank wrote: (4) mutex holder ??? it shows session 88852, but onstat -g ses 88852 shows nothing ( see below) informix@dora $ onstat -g lmx IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 4 days 03:03:29 -- 2120544 Kbytes Locked mutexes: mid addr name holder lkcn…
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…
Monitor HDR
On Apr 14, 11:40 pm, Mo <mohitanch...@gmail.com> wrote: > Informix 11: > > We run HDR and I see waits on logbf0, logbf1. I think it's something > to do with log shipping to secondary node. Is there a way to look at > to make sure that log shipping is not the issue why I see some …
Migrating from IDS 9.40.UC6 to 11.50.UC3
onstat -g ath ? onstat -g stk all ? What IS going (on)?…
b-tree scanner tuning and expected behavior
On the instance that now has a 'normal' CPU usage, I stopped the single one that was running and started 8 threads with: onmode -C start 8 onmode -C threshold 2000 That's it; now, the filtered output from onstat -g ath is: juanclu1-[PROD]-(db1):~ $ onstat -g ath | grep btscann 72…
Re: Connections to Informix hang then clear after a short time
On 11 Jun, 19:06, BBoard...@wernervas.com wrote: > Running IDS10.FC5 on AIX6.1 TL00 > At different times during the day new connections to the Informix > engine hang. Either TCP or SHM. > > A little history. > This instance was on a Windows environment when this problem first > s…
Re: Monitor sessions
>> onstat -g tpf | tr -s " " | sort -nr -k 16 | head > onstat.tpf.out >> for i in `cat onstat.tpf.out|cut -d " " -f1` >> do >> if [ $i -gt 0 ] >> then >> echo "------ LOGICAL LOG $i START" >> user_add=`onstat -g ath|grep $i|tr -s " "|cut -d " " -f4` >> if [ `…
Long Transaction
Version: IDS 10 How can I track "tx" in following message: "Aborting Long Transaction: tx 0xc0000001f4b64938". Is "0xc0000001f4b64938" the user address that comes in onstat -u ? I am trying to track which process caused the long transaction. I have a script that runs every 15 mt…
Re: rstcb
On Oct 10, 3:31 pm, zok <Hrvoje.Zoko...@gmail.com> wrote: > On 1 list, 18:46, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Oct 1, 12:15 pm, mohitanch...@gmail.com wrote: > > > > Version IDS 10: > > > > In different onstat output I see "tcb" and "rstcb". I am not sure …
Re: Display servicename/port no. of listner or user thread
On Sep 13, 5:39 pm, mohitanch...@gmail.com wrote: > Version: Informix 10 > > How do I display which listner or user thread is listening to which > port. I am looking for something that tells me which thread is using > ports/service names listed in sqlhosts. > > I tried onstat -g …
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
Re: NETTYPE NET/CPU
On Aug 9, 12:10 pm, Mark Jamison <maj...@yahoo.com> wrote: > ----- Original Message ---- > > Makes it more clear. However, I have few more questions: > > >1. If an application runs on the same box as Informix then does it > >connect through socket or uses shared memory directly. …
Informix Replication?? - Help
If ER is running you'll see threads named CDR* in the onstat -g ath output. If HR is running the heading line of any onstat output (say onstat - -) will say Primary or Secondary and the return code from onstat will be something other than 5 (2? don't remember). Art S. Kagel ---…
IDS 10.00.xC6 performance
Use 'onstat -g ath' multiple times to see if relevant Ix threads (sqlexec) are doing what they should be - running. If they aren't (and if they aren't 'ready' frequently), then they're waiting on something; either you're seeing already from this onstat what this might be and can…
IDS is busy all the time
Hi, I need a hint. Maybe somebody has had the same or a similar problem: We have an IDS 10 Server which has been running with a load of about 15 % until some days ago. Suddenly (without a config change), the load is > 50 % all the time. We shut down the engine and the load went…
Re: oncheck -cc hangs
Floyd Wellershaus wrote: > Any idea why we can't get an oncheck -cc on our big database ? > We have 5 instances on this box, one of them is a terabyte, with about 80,000 tables. > Oncheck -cc runs perfectly on all of them except the big one. It seems to just hang there. After 2 d…
onstat -g ath
Where I can found a documentation for the column "status" of this output? example: cond wait netnorm on a other screen with "onstat -g sql [sid] -r 2" I see many SQL command. C:\\\\>onstat -g ath | grep sql File STDIN: 35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec 37 1d…
Re: Informix session VS 'oninit' CPU usage
Thanx everybody for the feedback. Unfortunately I cannot use the SET EXPLAIN as Ben suggested since the executed statements are encapsulated inside an application that is executed by the users. However, I will try to mix what you suggested with other suggestions for the same kin…
Re: Long checkpoint woe
Make sure the KAIO is working. onstat -g ath | grep -i kaio will show if kaio is working, you should have I kaio thread for each NUMCPU defined in your onconfig. Does onstat -g ioq show any values in the "len" and "maxlen" for any gfd's? Post it if unsure. Post onstat -d and ls…
RE: Track a session to a Buffer
Hi Zev. You mean the following ? Userthreads address flags sessid user tty wait c000000007c17338 B--PR-- 175155 testdb - c000000000e104b8 If this is correct, probably btscanner is holding buffer. onstat -b -> onstat -g ath -- Tsutomu Ogiwara fro…
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…
Re: Oninit from cron leaves engine in permanent fast recovery
Also check the release notes....under $INFORMIXDIR/release. On AIX do you need to create a KAIO device (aiodev??) or something. And run something like strload? Make sure NOAGE = 0 in onconfig as it may not be supported. Check RESIDENT = 0 in onconfig as I have seen it not suppo…
Odd sockets errors
Hello all, We received many errors this morning - errors which I have never seen before. The errors are: 07:48:51 (3012493) sockets error - registering a file 07:48:51 listener-thread: err = 0: oserr = 0: errstr = : The tcp threads looked normal in the onstat -g ath output. An…
orphaned lock process
you might see the btcleaner in action; onstat -uk and onstat -g ath may tell you. try run update stats for this table superboer.…
orphaned lock process
you might see the btcleaner in action; onstat -uk and onstat -g ath may tell you. try run update stats for this table superboer.…
RE: Informix 7.23 connection problem
> Our NETTYPE is set: > > NETTYPE tlitcp,1,100,NET > NETTYPE ipcshm,1,250,CPU Change these settings somehow (to NETTYPE tlitcp,1,60,NET for example), change some other parameter, like LOCKS (add 1000 more locks, it should not be very harmful), restart yor informix server, and se…
Re: psort used ?
"Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:<ZaLZc.234545$qp1.12220489@phobos.telenet-ops.be>... > Hello everybody, > > I enabled the psort_nprocs and set it too 8. > Is there any way I can monitor the psorts ? I want to know if they are > effectively used. >…
Re: Urgent replication problem
Bjorn, 9.21TC3 is a fairly old release at this point. Have you considered migrating to a more current release level? I know that 9.4 received quite a few HDR fixes. "Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:C0PUc.218383$BL6.10847290@phobos.telenet-ops.b…
RE: Urgent replication problem
Bjorn, 1. What is 'onstat -g dri' on both machines? 2. Is there netwotk connection (netstat -a) between machines? 3. Are there HDR-specific messages in 'online.log' on both? 4. Is there activity on primary? 5. What are logical log positions (onstat -l) on both? 6. Are onconfig's…
Urgent replication problem
Hello everybody, today we brought our dbase down to finetune our onconfig. After it, it couldn't get started anymore. So we placed our old onconfig back. Everything was fine again except that our secondary stayed in fast recovery mode. It was very long so we supposed that ou…
RE: cannot drop index
Malcolm, Is it possible, that smth like 'update statistics' is running at the same time, or another 'alter table' from a different session? Do You have HDR? Did You 'set lock mode to wait...'? ------------------------------------------ Alexey Sonkin > -----Original Message----…
RE: cannot drop index
Very clever. It didn't work on my system, maybe a difference in versions. The partnum comes out of sysmaster with hex values A through F in uppercase and in onstat -g opn in lower case, so the grep partnum in line 9 never picked up anything. Anyway, I hacked it up a little bit …
RE: cannot drop index
Malcolm, I think they all did get your point :-) Agreed you can't lock a database object without putting at least a shared lock on the object, but this is Informix were talking about here. It appears that, altought no user session has a lock on the object, it may be that some "…
Re: Re: cannot drop index
Some better filters...with $tid and $rstcb... tabname=f4uhlp echo "select hex(partnum) from systabnames where tabname = '$tabname'" | dbaccess sysmaster | grep "^0x" | while read partnum do onstat -g ath | grep "^ [1-9]" | awk '{print "-g opn",$1}' | onstat -i | grep $par…
Re: cannot drop index
You might try to find the session using something like, tabname=f4uhlp echo "select hex(partnum) from systabnames where tabname='$tabname'" | dbaccess sysmaster | grep "^0x" | while read partnum do onstat -g ath | grep "^ [1-9]" | awk '{print "-g opn",$1}' | onstat -i | g…
Re: Lock error on trigger creation
> 1) Look for the thread that has the partition open: > onstat -g ath | grep "^ [1-9]" | awk '{print "-g opn",$1}' | onstat -i | > grep "0x00100067" I should have mentioned that you need to look at the Ocount (how many times the partition is actually open to the thread) from the…
Re: Lock error on trigger creation
Thanks guys. I didn't realise you could acquire some kind of resource which blocks access to a table without a lock getting created. Where is this documented? Also onstat -g opn - Where should I be looking in the documentation for this? It's not in anything I've downloaded. Al…
Re: Lock error on trigger creation
Hi Andy, Since you already have the hex(partnum), here is one way you can find the pesky session: 1) Look for the thread that has the partition open: onstat -g ath | grep "^ [1-9]" | awk '{print "-g opn",$1}' | onstat -i | grep "0x00100067" 2) Once you got the thread (ie 5228)…
Re: Stored Procedure Performance
Joe, If you can do the following to obtain a stack trace of the server thread I might be able to tell you more: Use onstat -g ath to look at the state of the thread (Repeat it a couple of times to get an impression of any changes in state). If the state is running and you are …
KAIO statistics
In article <95qae6$bbh$1@nnrp1.deja.com>, Dr. Pablo <dr_pablo@my- deja.com> writes >I am built a small test database server to test KAIO. >What does it mean when one KAIO is doing nothing and one KAIO has done >everything? > >Here is onstat -d and onstat -g ioq > > >AIO I/O queu…
RE: no tli vp class
Run onstat -g ath, and look for the tli poll (tlitcppoll) thread. If you did not specify anything in the NETTYPE parameter the tli poll thread will be running in the CPU vp. If you want the tli poll thread to run on a TLI vp, specify it in the NETTYPE parameter. Example: NETTYP…
Logbackup failed - A Log backup is already in progress
I can't run my logical log backup because it comes back with the following message: "Logbackup failed - A Log backup is already in progress". when you run onstat -g ath | grep log, there are two threads runnings and they are: aslogflush and logbackup. How do I get rid of logback…
About AIOs vp ...
Hi, Do the AIOs vp lunch treaths as CPUs vp do ? According to onstat -g ath, #AIOs threaths seem to be equal to #AIOs vp. Regards, Manel Falcó…
RE: HELP AGAIN ...
In article <8fg29u$2aa$1@news.xmission.com>, shahid.mehmood@aku.edu writes > >No, it is not synonym or view! it is definitely a table, here is the schema >of the table ... Try onstat - Is the server On-line and not in Fast Recovery? onstat -g ath are there any sqle…
KAIO in AIX
> I have a question though, I looked into the onconfig file, and saw that > the NUMCPUVPS is set to 1, and I have around three KAIO running. > Is this a bug or something? Here's a dump of onstat -g iov Addition to the Art's answer : If you will also look into the 'onstat -g ath…
Re: IDS7.31 upgrade conversion
In article <88n0m3$7vd$1@nnrp1.deja.com>, roswil@my-deja.com writes >How do you know when the last conversion is done when upgrading to >IDS7.31 ? The last conversion, " external conversion " , does not >display a completion message. > >aThe last lines are : >Internal conversion…
Re: Receiving "Changing data structure forced command termination." from
All that usually means is that the system tables were in use when the onstat command was issued. If you retry the command immediately after receiving this message, you should get the output that you are looking for. SC > Thanks Sanjeev. > > Unfortunately, fuser didn't show any…
RE: Receiving "Changing data structure forced command termination." from onstat!
Bryan This could be normal activity because the SMI tables are being changed at the time you requested information (onstat) from them. The message is information only, telling you that you dont have all the information available. There was a bug in early 7 engines (e.g 7.14) w…
Receiving "Changing data structure forced command termination." from onstat!
Getting a "Changing data structure forced command termination." message when executing onstat (-g ses, -g ath, and others). oninit is running at ~98% of CPU (via "top"), so system is busy, but can things change that fast?!?! What makes me more nervous is that I receive a "Memor…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
>My statistics for G50 says, that millions of disk writes go through 'aio', but >when we compare 'onstat -g iov' with 'onstat -g iof', the sum of disk writes >(-g iof) is nearly equal the count of 'kio' disk writes (-g iov), >and similarly for disk reads. There is bug in Informi…
KAIO with Solaris 2.6
From what I have understand, KAIO is off by default. The release note of my Informix (7.30UC5) running on a Solaris 2.6 (SunOS 5.6 Generic_105181-11 sun4u sparc SUNW,Ultra-250) tells me KAIO is supported. I have several raw devices but also some cooked files. (raw devices …
Re: onstat -g iov
Pramod Dhumal wrote: > > Hi users, > > Is it possible to configure the number of kio vps shown by "onstat -g iov" Those are not VPs, but threads, as shown in: onstat -g ath |grep kaio One KAIO thread is run on each CPU VP, so the only way to change the number is to change the…
oninit trace to user
Since oninit will run many Informix threads, it would be difficult to determine which thread is running on which oninit. My guess would be that some combination of onstat -u, onstat -g ath, or onstat -g ses would give you what you need. John Carlson Informix DBA WHSmith USA js…
How do I monitor a checkpoint thread?
I've been reading a lot lately about the debate over whether to run the soc poll threads on CPU or NET vp's. Art Kagel's argument for NET discusses the possiblity of the checkpoint thread hogging CPUVP #1 unless there are no page cleaners available. Is there a way to see the ch…
Re: ODS 7.20 with KAIO on SCO 5.0.4
Kai Shen wrote: > > Hi, > > this may be off-topic, but I don't really know where to post. > I have a SCO 5.0.4 server with Informix 7.20.UC3 installed. I would like > to try using KAIO, and the release notes say, I have to install aio and > suds, which I (supposedly) did. > Then …
ODS 7.20 with KAIO on SCO 5.0.4
Hi, this may be off-topic, but I don't really know where to post. I have a SCO 5.0.4 server with Informix 7.20.UC3 installed. I would like to try using KAIO, and the release notes say, I have to install aio and suds, which I (supposedly) did. Then I set KAIOON=1 and reinit Infor…
Re: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
Re: 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. > > The "sleep forever" threads are threads that will be remain dormat until they are activated by some o…
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: Status in onstat -g
>We have Informix 7.10 running on a SCO Box. > >I did an onstat -g ses ## and got a status of "mode wait(netnorm)". Does >anybody have an idea what this means? > > Basically that you are using tcp to communicate with the engine and that the engine is currently waiting on the cl…
Re: Oninit processes running away with process time
Robertson Lee NTSE wrote: > > Hi, > > We are running Informix 7.13 on HPUX 10.01 and we are currently > experiencing a problem with 2 of our oninit processes. At the OS level > they are eating up a large amount of CPU time. Does anyone have any > ideas as to what this may be or h…
Reply to SELECT too slow
Hi: 1:you should provide your sql statement in details,which maybe a simple select , a join,or subquery ,etc. In different case they will result in different performance. Also you should provide your table schema,index,and sqexplain. 2.I think three fector will affct your perf…
Re: 7.22 onstat -u flags
On Thu, 13 Mar 1997 01:43:49 +0000, David Williams <djw@smooth1.demon.co.uk> wrote: > A condition is a mutex (latch). Look in $INFORMIXDIR/etc/sysmaster.sql > as search for "create table sysconlst". This is "{ Conditions }" and > contains one field "con_nwaits integer, …
cond wait (packet cond)?
Online 7.12, when I do an onstat -g ath I have seen :- cond wait (packet cond) What does this means? -- David Williams…
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
KAIO clarification.
Hello folks, I could use a little clarification about using KAIO under SOlaris. We are running On-line 7.11 under Solaris 2.4. An informix engineer told us that we should set NUMAIOVPS to use more than one AIOVP and this would have a major impact on performance. However: - E…
Re: ONSTAT question
Bashar Chalabi wrote: > 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? A c…