Oninit® Archive
Results for “onstat -g mgm”
flags (onstat -g ses)
John: There can be several reasons for a session remaining in the "ready queue" (aka ready state) for several seconds. Here are the most common that I can think of off the top of my head: It is waiting for some resource like IO, a condition, a latch, a database lock (I believe yo…
DS_NONPDQ_QUERY_MEM not changing
Hi, I don't know why my reply wasn't sent.. @David, I see the messages in online.log that "Value of DS_NONPDQ_QUERY_MEM has been changed to .." but the value doesn't change in onstat -g mgm, no matter what value I set @Fernando , the query shows the new value cf_id 220 cf_name…
IO performance issues
onstat -g mgm IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 11 days 18:00:30 -- 10595476 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 6144 DS_MAX_SCANS: 1048576 DS_NONPDQ_QUERY_MEM: 256 KB DS_TOTAL_MEMORY: 6…
IDS 12.10 on HP-UX- DS Total Memory
You are probably setting this value too high in the ONCONFIG. Do you have it set within 10 MB of SHMVIRTSIZE? From the manual: Set the DS_TOTAL_MEMORY configuration parameter to any value not greater than the quantity (SHMVIRTSIZE - 10 megabytes). ...or perhaps the engine is ch…
RE: moving database tables from one dbspace to ano
To add to Art's recommendations ... DS_TOTAL_MEMORY is a very important setting for maximizing use of PDQPRIORITY. It's the memory allocated for PDQ queries out of the virtual portion and guideline is 90% of SHMVIRTSIZE. The biggest benefactor of this is sort memory. Use SET EXPL…
Optimising index builds
> On 19 January 2014 at 11:10 NEIL TRUBY <neil.truby@ardenta.com> wrote: > > >> Is DS_TOTAL_MEMORY set high enough to permit significant in-memory sorting? > > I changed DS_TOTAL_MEMORY to 300GB and reduced BUFFERPOOL to 160GB. Now > nothing gets written out to the DBTEMP_SORT fi…
Poorly Optimized SQL
Run onstat -g ses and send the output. Also onstat -g stk onstat -g tpf for each thread. Also run xtree and see what the query is doing. Regards, David. On 08 August 2013 at 04:18 Fernando Nunes <domusonline@gmail.com> wrote: > Another question... Since the query is running…
Upd Stat on SP using PDQ Question
Hi Dan, When you use UPDATE STATISTICS with PDQPRIORITY set , it will speed up the creation of your statistics. However, when you do that make sure you separate your tables from your stored procedures. You can set PDQPRIORITY when you run UPDATE STATISTICS FOR TABLE for your tab…
Issue on IMPLICIT_PDQ + BOUND_IMPL_PDQ features
Hello my friends. (Informix 11.70.FC2 on a linux_64 machine) I had configured our PDQ features (since 11.50) like this (onstat -g mgm output): Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 80 DS_MAX_QUERIES: 40 DS_MAX_SCANS: 1048576 DS_NONPDQ_QUERY_MEM: …
CPU usage at 100% Identifying the culprit
Try running onstat -g mgm. It will identify any active sessions that are using MGM memory. These are the most likely suspects. Once you know the session id you can run onstat -g ses to see the session details including the pid and the last two SQL statements it has run. Art Art…
IDS BUFFER POLL CONFIG *NM*
HELDER JESUS schrieb: > Good afternoon > > My Name is Helder Jesus. > I was wondering if there was a formula to configure BUFFERPOOL and SHMVIRTSIZE > correctly regarding the machine specifications of memory and cpu capabilities > > Thanks in advance seeing that this is my first …
RE: temporary dbspace usage
>I open pdq already. >set pdqpriority 100; >select ....; > >in the onconfig file >the parameters are setted >and ds total memory set 4G > >onstat -g mgm monitor the pdq use normally. Did you set environment PSORT_NPROCS? If not, try setting it to 3 or to 4. HTH, Paul M.…
await_MC3 ??? How release a thread?
And you have enough PDQ resources configured? Any hints from onstat -g mgm? What is the status of the other threads when the query is running? And what do you mean by detached index? I now this may sound weird... But sometimes we confuse indexes in their own tablespace with index…
UPDATE STATISTICS Performace Improvement
Hi Anees, It depends on which UPDATE STATISTICS your are using (Low, medium or high or a combination of these for different objects of the database). You can optimize your "UPDATE STATISTICS HIGH or MEDIUM " statement by setting: - PDQPRIORITY to a value > than 0 (Max is 100) -…
how to reduce the PDQ ready queries
Hi, I use PDQ in my application, then use onstat -g mgm monitor the pdq state, Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 3.5 +- 4.4 18 172 Ready 14.5 +- 4.8 21 64 the ready queries always retain around 14, How can i reduce read…
Re: Slow database creation and loading
Hello John, do not set > export MAX_PDQPRIORITY=100 PSORT_NPROCS=6 PDQPRIORITY=100 > FET_BUF_SIZE=32767 make sure you have the shm connection. i do not see any i/o on your tempdbspaces....before you start do a onstat -z can you try setting DBSPACETEMP env var: export DBSPA…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
Re: Informix Guys Help Help Help
Thanks, I'll give it a try. Superboer wrote: > loonnggg shot: > > may be you compiled your spl's (update statistics for procedure) with > pdqpriority set. > when a program execute's it, it'll try to set pdq. > > if your system has switched it of, it will not set pdq but it may c…
Informix Guys Help Help Help
I recently posted this question in this group, with no response. we are having this problem for a long time. And no one (not even IBM) has provided a solution. So here is the question again to all your great informix gurus and hope someone reads this. This happens mainly when …
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: Two table join
If you think I or anyone else is wrong, don't be shy - continue the thread publicly, I promise not to be upset. All of us learn that way. Certainly I have been mistaken in the past and will continue to make errors in the future. You might also try the comp.database.informix group…
Re: Two table join
You have limited control over where sorting and grouping occur. You can attempt to make it more efficient 1 - increase the number of tempspaces up to 2 per cpu (3 per cpu is the max that the engine will use, but that's overkill) You could get fancy and set up RAMdisks as temp spa…
RE: strange behavior in 9.40.FC6
There were 2 defects fixed in the patch. Case #411757 opened with IBM Informix regarding a problem with stored procedure guphrase(pv_assn_num LIST(INTEGER NOT NULL). When executed the procedure is doing a sequential scan of the foassn table as well as scanning the entire index …
RE: strange behavior in 9.40.FC6
Hey, thanks. That fixed it. When I upgraded I ran "dostats -h $DBSERVER -d $DATABASE -p -P 10". That -P 10 was causing the problem. I'm not sure where my head was at when I decided to do that. Shot myself in the foot with that one. I've been floundering around with this pro…
strange behavior in 9.40.FC6
"Bill Dare" <dareb@jevic.com> wrote in message news:1115154586.41877d638e6a36c3447a085ec262c671@teranews... > > I've actually got a patch loaded, 9.40.FC6X2. The server is randomly > allocating multiple scan and sometimes group threads to sessions for no > apparent reason. Onst…
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: PDQ not used ?
Hi Bjorn. Try the following. % dbaccessdemo7 Execute the following sql via dbaccess set pdqpriority 100; select * from customer; Another terminal onstat -g mgm e.g) Here is a results of my test. [tsutoo@bygzam ~]tsutoo731ud7% onstat -g mgm Informix Dynamic Server Version 7.3…
RE: PDQ not used ?
Hello, Thx a lot for your answer. I've checked it out and those queries are filled in. Do you know of any queries or dbase handling which will make the PDQ run for sure ? (Visible in active queries with onstat -g mgm) Or is it because I'm single user on a server with 2 gig of …
RE: Memory allocation failed during query processing -AIX 5.1
you may need to issues few onstat commands (onstat -g seg, onstat -g mgm, onstat -g mem, onstat -u, onstat -g ses, onstat -g sql ) to see what exactly is happening with the query, it may be also possible that the kernel parameters are not set right. you may also set DS_MAX_QUERI…
Re: Slow reposnse
By apparently allowing all your users to gain a PDQPRIORITY of 8 you are limiting the number of concurrent queries to 11. Any that would take the sum of the PDQPRIORITIES above 100 will just sit there at the "gate" and show up in the Ready Queries list. Suggest you: - Set MAXPDQ…
Re: Re: Slow reposnse
Hi Neil, ----- DS_MAX_QUERIES: 10 <<- max DS queries that can run simultaneously is 10 . Queries: Active Ready Maximum 10 11 10 <<- 10 running, 11 are ready (ie waiting). you are most likely competing for PDQ resources . Load Control: …
shahid.mehmood@aku.edu - Email has different SMTP TO: and MIME TO: fields in the email addresses - Re: Slow reposnse
please post 'onstat -g mgm' "Neil Truby" <neil.truby@ardent To: informix-list@iiug.org a.com> cc: Sent by: Subject: Slow reposnse …
Re: Slow reposnse
please post 'onstat -g mgm' "Neil Truby" <neil.truby@ardent To: informix-list@iiug.org a.com> cc: Sent by: Subject: Slow reposnse …
Re: create index stalls entire informix server
Check your PDQ settings. If its not in your environment check to see if queries are using the PDQ Manager using onstat -g mgm. If they are using PDQ, chances are someone started the server with PDQ set. Doing this effectively makes every query that is executed run via the PDQ man…
Severe memory leak in global pool: mgm_query
Hi, everybody, After taking a look at the size of memory pools (onstat -g mem) on our machine, I was shocked : it appeared, that the size of global pool is 138 MB!!! Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line (Prim) -- Up 22 days 14:11:09 -- 1790448 Kbytes Pool S…
AW: Severe memory leak in global pool: mgm_query
P.S. It seems that this problem doesn't reproduce with 9.40 ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Alexey Sonkin > Sent: Thursday, August 14, 2003 12:17 PM > To: 'informix-list@iiug.org' > Subj…
Severe memory leak in global pool: mgm_query
Hi, everybody, After taking a look at the size of memory pools (onstat -g mem) on our machine, I was shocked : it appeared, that the size of global pool is 138 MB!!! Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line (Prim) -- Up 22 days 14:11:09 -- 1790448 Kbytes Po…
Re: FW: PDQ
Dirk Moolman wrote: > > I have 5 CPU VPs, so this shouldn't be the problem. I've been meaning to > read a bit more about PDQ - I've just been a bit busy. > > I touched a little on PDQ in 7.30 I'm now working with 9.21FC1 and have > to just touch up on PDQ again. I did set th…
RE: PDQ
While we're on the topic. XPS 8.31 has implicit PDQPRIORITY. In other words the optimizer can decide what to allocate for your query. cheers j. > -----Original Message----- > From: Dirk Moolman [mailto:dirkm@reach.co.za] > Sent: Wednesday, February 07, 2001 7:06 AM > To: info…
FW: PDQ
I have 5 CPU VPs, so this shouldn't be the problem. I've been meaning to read a bit more about PDQ - I've just been a bit busy. I touched a little on PDQ in 7.30 I'm now working with 9.21FC1 and have to just touch up on PDQ again. I did set the PDQ parameters in the onconfi…
RE: PDQ_PRIORITY parameter!
PDQ is 100 words or less. This may even be reasonably accurate. When you run a query, issue a SET PDQPRIORITY x where x is some valus between 0 and 100; You can also export the environment variable PDQPRIORITY=x I'm not going to try to analyze what you've set it to here witho…
PDQ_PRIORITY parameter!
Note that PDQPRIORITY values of 0, 1 & 2 are special values. 0: No parallelism 1: Minimal parallelism (same as LOW) 2: Lowest setting that give full parallel features. See the Performance Tuning Guide and the Administrators Guide for details. Art S. Kagel Murat YILDIZ wrote: …
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…
Informix/Baan/AIX Performance
"Anderson, Andy" wrote: > > We are experiencing performance issues since upgrading to AIX 4.3.3 from > 4.3.2. The Informix database configuration has not changed and all the > latest patches/fixes have been applied to the OS. We are running on a > AIX4.3.3 / Informix7.31.UC3X1 / …
performance with very active threads
I have some intermittent performance problems with our instance that lead users to complain their programs are running slow. The users mainly run OLTP type programs (we are an insurance company processing claims etc) and most of the time, checkpoint duration < 0 but at certain t…
Process waiting after issuing OPEN CURSOR, onstat shows a thread in waiting condition await_MC1
Unfortunately, the bottom on your onstat -g ses was not provided. Example: Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 13 - stores7 CR Not Wait 0 0 …
Re: lock mode wait 600 ??
What is the output from onstat -g mgm? In article <KyzMDEAYuaK5Ewvj@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > In article <39295041.DA54EA39@teleatlas.com>, Stefan Moens > <stefan.moens@teleatlas.com> writes > > Hi, > > > > We're doing a 'loa…
Re: PDQ PRIORITY
From: Binod Maveli <binod.maveli@jaywir.com> > >I have IDS 7.3 under Win NT., > >In the onconfig file I have set the max_pdqpriority=100 and also I have set >the >environment variable pdqpriority=100, when I see onstat -g mgm it still >shows me the >max_pdqpriority=0. > >Can anyb…
PDQ PRIORITY
Hi All, I have IDS 7.3 under Win NT., In the onconfig file I have set the max_pdqpriority=100 and also I have set the environment variable pdqpriority=100, when I see onstat -g mgm it still shows me the max_pdqpriority=0. Can anybody pls.tell me the reason or help me out ? Th…
PDQ PRIORITY
Hi All, I have IDS 7.3 under Win NT., In the onconfig file I have set the max_pdqpriority=100 and also I have set the environment variable pdqpriority=100, when I see onstat -g mgm it still shows me the max_pdqpriority=0. Can anybody pls.tell me the reason or help me out ? Th…
Re: Fragmented table and PDQ
mars1972@my-deja.com wrote: > > In article <89lig9$1jm$1@news.xmission.com>, > dins dins <dins_d@yahoo.com> wrote: > > > > Hello! > > > > IDS 7.31.UC4-1, on HP-UX.10.20 > > > > I'm trying to use PDQ on fragmented table query. > > With set PDQ SELECT statement works about two > …
Fragmented table and PDQ
In article <89lig9$1jm$1@news.xmission.com>, dins dins <dins_d@yahoo.com> wrote: > > Hello! > > IDS 7.31.UC4-1, on HP-UX.10.20 > > I'm trying to use PDQ on fragmented table query. > With set PDQ SELECT statement works about two > times longer, than without PDQ. > > Environment …
what does info from onstat -g ses xxx indicate here
> The indexes are causing the problem. > > > Current statement name : slctcur > > Current SQL statement : > > select mast_pol_num from pal_obmast where (mast_allocated="N" or > > mast_allocated="Y") and mast_tab_num="329" > > mast_tab_num is indeed indexed but its part of a compo…
Connect to db turns slow?
In article <83o5le$22t$1@news.xmission.com>, rico@wsx.wsex.com (Rico) wrote: > > Hello All, > > Sparc/SunOS5.6 IDS 7.30.UC6 > > I am looking for possible reasons why connecting to the database would get extremely slow. > > Specifically, if I run dbaccess locally on the machine …
RE: Index build speedup
A couple quick items to check. Do an onstat -g mgm and check the DS_MAX_QUERIES, DS_MAX_SCANS, and DS_TOTAL_MEMORY parameters. You may need to increase these. As you adjust one (using onmode) watch your quantum values...you want small quantum values. I usually just work with the …
How many licenses do I need?
In article <80se20$9q4$1@news.xmission.com>, Ortiz Manuel <mortiz@gtireecu.com> wrote: > > 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_001_01BF306A.A18CC68C > Con…
Re: PDQ
Art, I have PSORT_DBTEMP set to /tmp and that is implemented on physical memory, mounted on swap space.Make it, in this case sense to create mutiple directories, /tmp/psort1, /tmp/psort2,.. and set PSORT_DBTEMP to them. I create four indexes in parallel. Does it speeds up to gi…
RE: PDQ
You want to be careful about dumping huge amounts of data down to /tmp if it is really a memory filesystem. Remember they are major difference between a tmpfs and ufs/vxfs etc. I can bring our E10000 12CPU domain to standstill when generating .5GB file in /tmp Paul Watson …
PDQ
I noticed a performance decrease instead of a performance increase when using PDQ with creating indexes. The create indexes are done one/with: * Informix 7.23.UC6 on Solaria 2.5.1. * System: SUN E4000 with 6 CPU's and 5.3 GB internal memory. * Informix has four CPU, NO…
RE: PDQ
PDQ makes a BIG difference on my sysytems when building indexes. > ---------- > From: Sadagopan, Sathish, CFCTR[SMTP:sadagop0458@att.com] > Sent: Monday, March 22, 1999 10:06 AM > To: informix-list@iiug.org > Subject: RE: PDQ > > The number of scan threads to be used durin…
Re[2]: PDQ
Albert: Are you setting PSORT_NPROCS, I seem to remember this helped for building indexes. Kevin ______________________________ Reply Separator ____________________________ _____ Subject: RE: PDQ Author: gursoy.yerli@tmssc.brooks.af.mil at TIME_INC Date: …
RE: PDQ
The number of scan threads to be used during the index build and the amount of memory used are affected by PDQ parameters,Aren't they ? Sathish Sadagopan -----Original Message----- From: Yerli, Gursoy [mailto:gursoy.yerli@tmssc.brooks.af.mil] Sent: Monday, March 22, 1999 9:53 A…
RE: PDQ
Albert, PDQ has nothing to do with index creation. You can not optimize these kind of tasks with PDQ resources. Performance degration during index creation is a consequence of allacation of PDQ resources that is supposed to used by that process. You can de-allocate PDQ resource…
Re: PDQ
From: wisse <wisse@kabelfoon.nl> > >I noticed a performance decrease instead of a performance increase when >using PDQ with creating indexes. > >The create indexes are done one/with: > > * Informix 7.23.UC6 on Solaria 2.5.1. > * System: SUN E4000 with 6 CPU's and 5.3 GB inter…
Re: PDQPRIORITY AND PSORT_NPROCS: How do they work together
ssoman@omm.com wrote: > > Hi all, > IF you set PDQPRIORITY AND PSORT_NPROCS for a query, how do they work in > conjunction with each other ?If there are multiple scan threads working at a > time, do all of the have the same PDQPRIORITY ? Does it actually help setting > both …
PDQPRIORITY AND PSORT_NPROCS: How do they work together
Hi all, IF you set PDQPRIORITY AND PSORT_NPROCS for a query, how do they work in conjunction with each other ?If there are multiple scan threads working at a time, do all of the have the same PDQPRIORITY ? Does it actually help setting both the parameters, or do they counter…
Re: Onconfig Question
Barry asks: >I sent this a few weeks ago and didn't get any responses. I am >rephrasing the heading and trying again. One reason you might not hear back a lot on this topic is because consultants get about US$2,000 per day to answer this kind of thing. It's not in their best i…
Re: Ready Queue
Are you using PDQ? Send your onconfig file as well as the output of t he onstat that concerns you. -Bill } } This is a multi-part message in MIME format. } --------------A4489FA28C25AB102697661A } Content-Type: text/plain; charset=us-ascii } Content-Transfer-Encoding: 7bit } } I…
Re: Ready Queue
John, What are your PDQ settings? If they are set too high one session could be consuming all system resources. jim ______________________________ Reply Separator _________________________________ Subject: Ready Queue Author: "John M. Shoemaker" <John_S…
Ready Queue
This is a multi-part message in MIME format. --------------A4489FA28C25AB102697661A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am having a problem, and so far tech support has not found the answer, so perhaps YOU have it :) With only a handful …
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…
Re: PDQ Not working
Art S. Kagel wrote: > > John M. Shoemaker wrote: > > > > Greatings, > > > > I just received DSA 7.22.UC2 on HP-UX 10.20, and am unable to get > > it to satisfy a Query using PDQ. When I run the same query with > 7.11, > > it works fine. The output of 'onstat -g mgm' shows that …
Re: PDQ Not working
John M. Shoemaker wrote: > > Greatings, > > I just received DSA 7.22.UC2 on HP-UX 10.20, and am unable to get > it to satisfy a Query using PDQ. When I run the same query with 7.11, > it works fine. The output of 'onstat -g mgm' shows that no querys have > run with PDQ on the 7…
PDQ Not working
Greatings, I just received DSA 7.22.UC2 on HP-UX 10.20, and am unable to get it to satisfy a Query using PDQ. When I run the same query with 7.11, it works fine. The output of 'onstat -g mgm' shows that no querys have run with PDQ on the 7.22 engine. PDQPRIORITY is set at 30,…
Re: DSA follies
In article <5jjr7f$gjp@cssun.mathcs.emory.edu>, David Coburn <David_Coburn@wvccg.wvus.org> writes > > > > >Hi. I've been fighting now for two months with a problem. I'm hoping >that somebody else has run into a similar problem and has a >workaround. > >I have an ESQL/C program …
DSA follies
Hi. I've been fighting now for two months with a problem. I'm hoping that somebody else has run into a similar problem and has a workaround. I have an ESQL/C program that declares a cursor with hold and then performs an inner loop to do some updates to various other tables. Th…
Re: DSA 7.22.UC1/HPUX 10.20
Ian, First, if you think you saw this before, you did; the original post went out on 2/20. This sort of showed back up today, along with a note from "Administrator_at_LLCS-MAXIM @ lendlease.com.au" stating that the message wasn't deliverable. So instead it appar…
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: mt.shmpool PANIC
rasto, it helps to post a little background info, to even say that you don't know what specifically was going on when this happened if this was the case. this could be caused by any number of a million things, so with no background info, all one can say is that there was a poss…