Oninit® Archive
Results for “MAX_PDQPRIORITY”
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
Stuart: Yes, RALLOC_MODE is a diagnostic setting only used temporarily on advice from tech support to help them diagnose specific suspected memory issues. It has been known to cause memory allocation issues of its own in the past. You should unset that. Art ----------------------…
Announcing the passing of Stuart Litel
Stuart. J. Litel passed away on April 19, 2025 at his home in Waban, Massachusetts. Stu was the beloved son of the late Joseph and Barbara E. (Sulkin) Litel of Newton, Massachusetts. Robin Chapman was his loving domestic partner for 20 years in Waban. He was a dear nephew to Barr…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
What prevents a RSS to roll forward as fast as its primary?
Your RSS has less memory and fewer cores. It is no wonder why the secondary cannot keep up with the activity on the primary! Are the ONCONFIG settings identical? If not, more reason why it falls behind. Arr ------------------------------ Art S. Kagel, President and Principal Con…
Informix HA Cluster and CM
OK, here's how it goes. You have two servers, a primary and an HDR secondary, call them node1 on host1 and node2 on host2 and you have a single Connection Manager, call it CM1 on host3. The servers each have a TCP and shared memory connection type defined, call them node1_tcp and…
Want to DROP an empty rootdbs chunk
David: No worries. Except for the catalog tables and a handful of others, nearly all of the "tables" in sysmaster are not actually tables at all, but windows in to memory structures which cache on-disk structures. Those, like the chunk table, dbspace table, etc. are what are upda…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Suresh: You do not have enough logical logs defined. Any transaction or combination of transactions that span more than the percent of logical log space documented in the LTXHWM parameter in your ONCONFIG file will trigger the oldest of the open transactions to roll back with a L…
Memory issue on Informix primary server
Amit: Casey's right, it looks like most of the memory allocated is unused. I had missed that. Here's what I think happened. As I said Solaris is VERY SLOW to allocate shared memory, so when a session needed more memory the engine requested another 3GB segment. It took so long tha…
flags (onstat -g ses)
That's the same set of flags as in ' onstat -u ' I'd say. For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one. ------------------------------ Andreas Legner ------------------------------…
Shared Memory
Yes, I would increase SHMVIRTSIZE as long as you are confident that the additional 4GB of memory that were added are "normal" and would be allocated again anyway if you didn't increase it. If the additional memory was an anomaly due to some unusual activity, then maybe increase i…
monitoring session memory
Try this one: > select memused, memtotal from sysscblst where sid = 503; memused memtotal 252728 266240 1 row(s) retrieved. Slightly different from the onstat output, but consistent: onstat -g ses 503 | head -7 IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line --…
RE: Upgrade IDS
Thanks Art and Luis for the competent and quick answer. Now I know what happened and what I have to do. Have a good time. Heinz WESTFLEISCH SCE mit beschränkter Haftung, Hauptsitz: Brockhoffstr. 11, 48143 Münster Amtsgericht Münster: Gen.-Reg. 448 Aufsichtsratsvorsitzender: Josef…
Upgrade IDS
I have encountered that error before, also during an upgrade to Informix version 12.10.XC13 ( from version 12.10.XC7 ). What I think that is happening is that there is a correction to the ph_threshold table, in the check constraints: DBSCHEMA Schema Utility INFORMIX-SQL Version 1…
YIKES! 12.x documentation for onstat -g opn does not match the output
ra column is the current readahead for the instance partp is the memory address of the structure that describes the tablespace i.e. partnum Cheers Paul > Hi Folks. > > I'm tyink I've managed to work around my ignorance of the sysmaster tables > in relation to onstat -g opn. Howe…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
PDQ mixed with OLTP
Hi, First of all good morning to all of the members just want to ask if anyone had done mixing PDQ with OLTP on their database? Our database is mostly OLTP with a batching process running every 12 MN of weekdays up until 3AM, I am wondering if I can use PDQ for the batching proc…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
DS_NONPDQ_QUERY_MEM not changing
SELECT * FROM sysmaster:syscfgtab WHERE cf_name = 'DS_NONPDQ_QUERY_MEM' Check the effective value. On Jan 4, 2018 5:32 PM, "R MICHAEL" <mboncalo@gmail.com> wrote: > Hi, and Happy New Year everybody > > I've tried to increase DS_NONPDQ_QUERY_MEM value because of CPU io wait > i…
Is PDQ only for DSS?
Hello all!! IBM's docs says "Parallel database query (PDQ) is a database server feature that can improve performance dramatically when the server processes queries that decision-support applications initiate." (source: https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/c…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Performance loss for a query after 11.50 >12.10 up
Thanks Cesar! unfortunately no functional index to remote queries involved here only 15 LEFT joins written the 'Oracle way' (just to help...) If I were the Informix optimizer, I would be lost in such a query *lol* Trying to find out where the engine is spending time...…
UPDATE STATISTICS low in parallel?
Original post: Hi Jacques, Thank you for your reply. It's interesting that AUTO_STAT_MODE comes into it at all. I actually have AUTO_STAT_MODE=1 but because I am using a test instance and repeatedly testing I am using "UPDATE STATISTICS... FORCE". I'll experiment with single …
Compacting a dbspace through onunload and onload
For ALTER FRAGMENT ... it will be much faster if you drop any indexes, do the ALTER, then rebuild the indexes w/ PDQ (and appropriate settings). Otherwise we have to maintain the rowids in the index(es) as the data rows move to new pages. Mark Scranton The Mark Scranton Group ma…
IFX_XFER_SHMBASE
Thanks to all that answered. The solution was to change this: BUFFERPOOL size=4K,buffers=100000,lrus=16,lru_min_dirty=20.00,lru_max_dirty=30.00 BUFFERPOOL size=16K,buffers=20000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 to this: BUFFERPOOL size=4K,start_memory=200mb,memory…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
new features about dynamic parameter added in 12.1
Attention, this is not documented. For Informix 12.10, another way you can get the list is to use the cf_flags column on syscfgtab to determine which onconfig parameters are dynamic: SELECT cf_name FROM sysmaster:syscfgtab WHERE bitand(cf_flags,'0x1') = 0 --removes Unsupported p…
Fragmentation Fundamental Question
This seems like a ridiculously simple situation but not seeing the expected behavior with respect to number of scan threads. I expect 3, but only getting 1. IDS 11.5.FC8; cpuvps 16; MAX_PDQPRIORITY 100; Fragments 3 30M row table fragmented by RR. Only getting 1 scan thread on …
opentable memory leak
Original post: No AUTOINDEX as far as I can tell. Turning off PDQ avoids the issue and I can live with this until permanent fix is found. Thanks, Andrew Response: It's a APAR in 12.10.xC5. APAR IT09544. The description talks about auto-index path, but the real trigger is an…
RSS/HDT Sec - Different Query Plans???
This took long enough but we have resolved this issue. DS_TOTAL_MEMORY was set WAY higher on the system with the poor query plan. We were not using PDQ but it affected this query anyway. IBM is putting a defect together to address the issue. thanx for all the replies, dan…
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…
RFE request for session details during virtual shm
Hello. I think this might be a very useful RFE, in order to help us to identify abnormal memory session usage, in OLTP systems of high ammount of concurrent sessions (ad-hoc applications). If anyone like, please vote it... https://www.ibm.com/developerworks/rfe/execute?use_case=…
IO Wait and PDQ
PDQPRIORITY of 4 is low, Informix will allocate a small amount of memory and with PDQPRIORITY that low will not give much if any paralleism. A quantum of memory is DS_TOTAL_MEMORY / DS_MAX_QUERIES and PDQPRIORTY will determne what percentage of the quantums are allocated to the …
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
VERY slow BTS index build
>> Don't remember the thread details. What version? What OS? What is >> VP_MEMORY_CACHE_KB set to? Are you using PDQPRIORITY AND PSORT_NPROCS >> during the build? >> Art Hi Art, Informix 11.5.FC6 running on a Sun Solaris 10 system. PDQ set to 100. PSORT_NPROCS = 8. VP_MEMORY_CAC…
Implicit_PDQ
Oops, I validated the response too fast .... I wanted to add that if your instance is exclusively a decision support instance, setting global pdqpriority is not a bad idea. But please test before rolling out. Eric…
Memory parameters and Workgroup Edition
Effectively MAX_PDQPRIORITY is already set to 0. On the DS_ parameters, wellllllllllllll, the ONLY effect that these have is that DS_TOTAL_MEMORY limits the setting for DS_NONPDQ_QUERY_MEM since the latter is limited to 25% of the former. DS_NONPDQ_QUERY_MEM is the only part of …
Update statistics issue
In your ONCONFIG the parameter MAX_PDQPRIORITY acts as a multiplicative governor for PDQPRIORITY. So if MAX_PDQPRIORITY is set to 50 (ie 50%) then setting PDQPRIORITY in a session to 100 only gets you 50% of the server's resources, setting PDQPRIORITY 50 gets you 25% etc. If MAX_…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Buffer Size and Use
Thank you for explanations. Could I summarize it like this? RESIDENT speaks to the O/S memory management, and does not affect Informix's management of the buffer cache. That is, the two are orthogonal processes. DG…
Optimising index builds
No, sort memory for PDQPRIORITY queries is governed by DS_TOTAL_MEMORY, DS_MAX_QUERIES, and PDQPRIORITY. PDQPRIORITY == 100 will allocate all of DS_TOTAL_MEMORY to the sorts. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.c…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Poorly Optimized SQL
Thanks David. I am ashamed to admit, but I am still a PDQ novice.…
Do not set the PSORT_NPROCS ?
OK, here's the skinny on PDQPRIORITY versus PSORT_NPROCS for index builds and update statistics as I understand it: - If you do not or cannot set PDQPRIORITY to a positive value (ex: Workgroup Edition does not allow PDQPRIORITY) the setting PSORT_NPROCS is the only way to get …
Upd Stat on SP using PDQ Question
Good MOrning All, AIX 6.1 IDS 11.50.FC7 Over the weekend, we performed some DB maint in which we ran upd stats on all tables then SPs using PDQPRIORITY of 20. After turning everything loose, all SPs started running at PDQPRIORITY of 20 flooding the MGM. Performance went out the…
Re: Extract indexes
Hello,, What i want is to extract many. Tables schemas. In a. File. ()without indexes) and the indexes in antoher file. Then i can load the data quickly, set Psortnprocs, and pdqpriority to the max (100 ) and create to indexes. That s the best way i think. To load the data very …
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 …
DB Tuning question
The ONCONFIG parameter MAXPDQPRIORITY just acts as a governor adjusting users effective PDQPRIORITY to prevent users from hogging resources. The effective PDQPRIORITY for a user is governed by the PDQPRIORITY environment variable in the users environment at runtime or by the user…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Physical log size
Art, Thanks for the info. We do have enough buffer cache to effectively buffer most of what will be active at any point, so it really does come down to monitoring the various checkpoint-related stats. It was just really confusing that the message indicated that it would be fas…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Re: Using PDQPRIORITY to throttle certain queries
Sean, a better way to handle this problem would be to start up an SDS secondary server instance (even if you run that on the same machine - assuming you have the memory available for the extra executables and shared memory images) and direct the web site to only query the seconda…
Re: Using PDQPRIORITY to throttle certain queries
Oops... I misunderstand the term "throttle". In theory it could... if the engine decides to use PDQ and you control the resources. But you could achieve more or less the same result by controlling the number of connections from the application server. Regards On Tue, Sep 4, 2012…
Re: Using PDQPRIORITY to throttle certain queries
PDQ will not be used (even if set) if the query optimizer does not consider it useful. Things that will make it possibly useful are (not a full list): - Table(s) is fragmented (PDQ may allow parallel scans) - Query has ORDERS/GROUP BYs - Query plan uses several joins, table scan…
Using PDQPRIORITY to throttle certain queries
Hoping to get some opinions on this. We have a public website that is currently using our main production database (IDS 11.50.FC6). The main query used by the website uses a single table that typically has 50K to 100K rows. The query typically completes in 0.4 to 0.5 seconds. …
Re: SET PDQPRIORITY in an IF...THEN block?
I don't know. Marco is correct as far as it goes, but I'm not sure whether embedded SET PDQPRIORITY commands will do that. One way to check.. create a procedure that selects its sysmaster:syssdblock record before and after the IF statement that selects the SET PDQPRIORITY and w…
SET PDQPRIORITY in an IF...THEN block?
All: I have some SP code that has a SET PDQPRIORITY N directive inside an IF ... THEN block that checks the application configuration table to see whether PDQ is enabled. Can anyone (Art, ideally) confirm whether or not this will actually work to control PDQ and will NOT use PD…
Table order in joins for best performance.
Does the order of tables in a join statement make a difference for optimum performance and memory management? I heard that the last join should be the largest table.…
Use of fragmentaion for tables
If you fragment a table, say by expression, I know that using PDQ will result in the use of parallel scan threads. If your application (it is a third party app) does NOT use PDQ, is it still "useful" (better performance) to fragment tables? Will parallel scans still occur, or wil…
Help about PDQ
Where I put the command set PDQ priority in the application 4gl Thanks Wanderlei…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
WHere did my data go?!
IBM Informix Dynamic Server Version 11.50.FC8W2XB on Solaris: I fragmented a table into multiple dbspaces to see how long it would take. No problems with all this, all 64 million rows fragmented, about 16m into each database: set pdqpriority 95 ; alter fragment on table <tablen…
Problem with identifying root cause of continual m
original post: Hi to all, I have a problem with identifying root cause of continual memory consuming by db-sessions. Our OS: AIX Our IDS: 11.70.FC3 Application layer is Weblogic Application server and the interface is JDBC driver. During investigating this issue I was able to i…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
new feature ? set PDQ with onmode....
Hi Cesar. Onmode command (wf or wm) applies only to the instance configuration (dynamically). If you want to set pdqpriority for a specific session, you must do it inside it´s specific sql command (before and after it´s execution). If you want to set pdqpriority for all sessions …
why phantom pdq message in wee hours?
This involves running IDS 11.70.TC1IE on Windows 2008 Server os. I see this each morning at the same time in the ids log file: 01:11:01 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of PDQPRIORITY cannot be set to 10. It is reset to …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
why does DS_NONPDQ_QUERY_MEM have the prefix "DS"
In Informix Administrator's Reference, I see: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is available for a query that is not a Parallel Database Query (PDQ). My questions are: Now that DS_NONPDQ_QUERY_MEM is for NONPDQ, why does it…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Informix Warehouse Accelerator : Memory usage, nec
Hello, I have some questions to understand well the memory management with the IWA : 1/ How to compute the max available shared memory usage for IWA ? I found this formula with my tests : - MAX Available shared memory = SHMMAX * number of worker nodes If the result is greater…
Introduction to the three designer handbags(Chanel,Coach,Prada)
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
Removing semaphore shared memory segment aborts other informixservers
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Need Help- IDS 11.5 Stored procedures.
Hi, The IDS version IDS 11.50.FC6. I tried setting PDQPRIORITY to 0 and compile the store procedure. But problem still exists. regards Mahesh…
limit on query length in Informix IDS 11.50
Is there a limit on query length in Informix IDS 11.50? If there is one, can it be increased? Also can anyone suggest some information on how to optimize IDS 11.50 for longer queries to make them run faster? We have some Cognos reports that send very long queries to IDS 11.50 …
Re: Memory Management
Neil Truby schrieb: > "Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message > news:mailman.491.1283968374.1071.informix-list@iiug.org... > Fernando, > >>> More memory means you can do more things and yes... 2000 concurrent >>> sessions could be considered small. ;-) > With …
Re: Memory Management
Ian Michael Gumby schrieb: > > >> From: domusonline@gmail.com >> Subject: Re: Memory Management >> Date: Sun, 5 Sep 2010 23:32:32 +0100 >> To: informix-list@iiug.org >> > >>> Thanks all..great information. I agree that 6 Million is not really >>> that big since the big RDBMSs ca…
Re: Memory Management
Ian Michael Gumby schrieb: > > >> From: neil.truby@ardenta.com >> Subject: Re: Memory Management >> Date: Tue, 7 Sep 2010 21:44:37 +0100 >> To: informix-list@iiug.org >> >> "Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message >> news:mailman.480.1283875344.1071.informix-li…
Re: Memory Management
Superboer schrieb: > Hello Fernando, > > I hate to disappoint you, however MS is not easy; try to restore a > complete level 0 backup, you will see what a can of wurms that is. > Besides that monitoring and trying to grab the hottest sql is not > easy(sqlsrv2005); the stuff desc…
Re: Memory Management
On Wed, Sep 8, 2010 at 6:52 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > Fernando, > > More memory means you can do more things and yes... 2000 concurrent > sessions could be considered small. ;-) > I bet you worked a lot with instances with much more than that... > W…
Re: Memory Management
On Wed, Sep 8, 2010 at 6:54 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > If I could talk about some of the stuff I worked on... yes ... memory can > be a concern. > > ;-) > > Honestely I do believe you. But unless those things used Informix it's irrelevant for the discu…
Memory Management
"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message news:mailman.491.1283968374.1071.informix-list@iiug.org... Fernando, >> More memory means you can do more things and yes... 2000 concurrent >> sessions could be considered small. ;-) With more memory you can do things l…
RE: Memory Management
If I could talk about some of the stuff I worked on... yes ... memory can be a concern. ;-) Date: Wed, 8 Sep 2010 13:03:09 +0100 Subject: Re: Memory Management From: domusonline@gmail.com To: informix-list@iiug.org On Wed, Sep 8, 2010 at 12:32 PM, Obnoxio The Clown <obnoxio@se…
RE: Memory Management
Fernando, More memory means you can do more things and yes... 2000 concurrent sessions could be considered small. ;-) With more memory you can do things like in memory database tables for fast response. More memory can be used for advanced processing. (Extensibility that most p…
Re: Memory Management
On Wed, Sep 8, 2010 at 12:32 PM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Ian Michael Gumby wrote: > > > > need parallel processing? Maybe not. Do you need to go beyond 16GB most > > likely unless you have a really small system and support a small number > > of users…
Re: Memory Management
On Wed, Sep 8, 2010 at 12:21 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > > > > From: neil.truby@ardenta.com > > Subject: Re: Memory Management > > Date: Wed, 8 Sep 2010 08:55:11 +0100 > > > To: informix-list@iiug.org > > > > > >From the IBM website: > > Ultimate: US$38,…
Re: Memory Management
Ian Michael Gumby wrote: > > need parallel processing? Maybe not. Do you need to go beyond 16GB most > likely unless you have a really small system and support a small number > of users. What is "a small number of users", though? If your application is well-written (a big "if",…
RE: Memory Management
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Fernando Nunes Sent: Tuesday, September 07, 2010 11:19 AM To: informix-list@iiug.org Subject: Re: Memory Management >IDS can't take advantage of multiple indexes on the same query in any GA…
Re: Memory Management
On Tue, Sep 7, 2010 at 5:18 PM, Fernando Nunes <domusonline@gmail.com>wrote: > > > On Tue, Sep 7, 2010 at 5:02 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > >> Really. >> >> So what's missing from Growth that would want you to go >> Enterprise/Ultimate Ed? >> >> Datablad…
Re: Memory Management
On Tue, Sep 7, 2010 at 5:02 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > Really. > > So what's missing from Growth that would want you to go Enterprise/Ultimate > Ed? > > Datablades? > Table Partitioning? > > Can IDS support the use of multiple indexes on a table within…
Re: {Spam?} RE: Memory Management
Ian Michael Gumby wrote: > Really. > > So what's missing from Growth that would want you to go > Enterprise/Ultimate Ed? > > Datablades? > Table Partitioning? Memory and # CPUS for one thing. Unlimited HA nodes. Compression. Parallelism and partitioning. > Can IDS support the u…
RE: Memory Management
Really. So what's missing from Growth that would want you to go Enterprise/Ultimate Ed? Datablades? Table Partitioning? Can IDS support the use of multiple indexes on a table within a query like XPS can? From: art.kagel@gmail.com Date: Tue, 7 Sep 2010 11:55:18 -0400 Subject: …
Re: Memory Management
Growth Edition can have up to three nodes ER or HDR are both supported. No need for Ultinate Edition just for HA. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my …
RE: Memory Management
> Date: Mon, 6 Sep 2010 17:19:32 +0100 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Re: Memory Management > > Ian Michael Gumby wrote: > > > > > > > From: domusonline@gmail.com > > > Subject: Re: Memory Management > > > Date: Sun, 5 Sep 2010 23:32:32…
Re: Memory Management
Ian Michael Gumby wrote: > > > > From: domusonline@gmail.com > > Subject: Re: Memory Management > > Date: Sun, 5 Sep 2010 23:32:32 +0100 > > To: informix-list@iiug.org > > > > > > Thanks all..great information. I agree that 6 Million is not really > > > that big since the …
Re: Memory Management
On 02-09-2010 20:24, shorti wrote: > On Sep 2, 12:06 pm, Andrew Ford<af...@networkip.net> wrote: >>> ok..then I will give you another chance to redeem yourself.....Can >>> anyone tell me what they think of Informix Performance for a larger >>> database...lets say 5-6 + million r…
Re: Memory Management
On 02-09-2010 18:47, Alexandre Marini wrote: > Ok, I can example this: our larger table has > Number of Rows 441.762.945 > > Our cpu idle times: > 12:30:01 PM CPU %user %nice %system %iowait %steal %idle > 12:40:01 PM all 3.39 0.00 0.39 24.61 0.00 71.61 > 12:50:01 PM all 3.08 0…
Re: Memory Management
On 02-09-2010 18:28, shorti wrote: >> >>> Thank you...this is exactly what I was looking for. >> >> I'm clearly losing my touch. >> >> -- >> Cheers, >> Obnoxio The Clown >> > > > ok..then I will give you another chance to redeem yourself.....Can > anyone tell me what they think o…
functional index - create with parallel sort
Cesar, Are you using PDQ in which level? How are the Parallel Database Query (PDQ) Configuration Parameters in your instance? You should use PSORT_NPROCS and PDQ >1, actually. In my environment to create indexes in parallel I usually use PDQ Priority High, but the MAX_PDQPRIORI…
Re: Memory Management
Ok, I can example this: our larger table has Number of Rows 441.762.945 Our cpu idle times: 12:30:01 PM CPU %user %nice %system %iowait %steal %idle 12:40:01 PM all 3.39 0.00 0.39 24.61 0.00 71.61 12:50:01 PM all …
Memory Management
Hello, I have another question. Again, new to Informix and just doing research for a Linux implementation. Is there a setting that can control the total database memory allowed for Informix to use for all databases and instances (not sure if instance is the right terminology fo…
Query works fine in IDS 10 but crashes 11.5 engine
Jonathon wrote: I'd post what the optimizer has to say, but sadly it never gets that far. It prints out the last query right before this one (which completes successfully) and then the oninit process hangs and the optimizer information for the query in question never gets printed…
PDQ and Growth Edition
I'm doing an upgrade from 9.40 to 11.5. For reasons unrelated to the upgrade process I want to buiold a new 11.5 server and dbexport/dbimport from 9 to 11.5 This is taking much longer than I planned for because I'm using IDS 11.5 Growth Edition, which disables PDQ, so the index…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
optimum usage of resources
By Increasing buffer size as mentioned in previous e-mails Regards, Vaibhav S Dantale ___________________________________________________________ Challenge is source of strength QA Manager, Informix Dynamic Server Information Management Address: IBM India Software Labs, Cell: +91…
Re: ERROR 770 on IDS 11.50 FC6
Hi Omar, I've had the same error, only on version 10, the cause could be completely different in your case. Here the cause was a stored procedure created with PDQ > 0 set in the environment. When the stored proc was dropped and recreated with PDQ = 0, the problem disappeared. H…
Re: Query-Optimizer on HDR-Secondary
Hi folks, I talked to my informix-supporter: Rebuilding the hdr-mirror solved the problem. Regards Markus Bschorer "Markus Bschorer" <mb@worxbox.com> schrieb im Newsbeitrag news:4bd44874$0$6892$9b4e6d93@newsspool2.arcor-online.net... > Hi Art, > > thanks a lot for your answers…
Query-Optimizer on HDR-Secondary
IDS 11.5 FC4 Linux 64 Bit Hi everybody, it seems, that the IDS-Optimizer works different on primary and (hdr-)secondary servers, having identical IDS-Versions. Example: create table wbx_permission ( per_object_id char(20), per_client_id char(10), per_user_type i…
ids query optimizer.
As I understand it, most query optimizers are cost-based. Some can be influenced by hints like FIRST_ROWS(). Others are tailored for OLAP. Is it possible to know more detailed logic about how Informix IDS and SE's optimizers decide what's the best route for processing a query, ot…
Doubt in Update statistics, resolution and confide
Hi Celso, Just for better understand , what update exactly have the performance problem? med ,high or both? what values of resolution/confidence used? The PDQ make all differ with update statistics high, use more memory and they intend to use light scan and avoid the indexes...…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
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.…
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.…
Re: How to estimate query cost before execution
Turn PDQ on You can then limit the resources available to PDQ queries and even I think limit the number of PDQ queries that can run. This will mean that other queries and still run and your slow, complex queries will take even longer. I say bring back SCAFS!…
Update stats impacts insert performance
Hi, Thanks for detailed answer. But still I am a bit confused that; Why do we need to run update statistics low for column "aaa" when we alreayd hve run "high update stats" on this column? As Art said that if PDQPRIORITY is set, PSORT_NPROCS & DBSPACETEMP are no more effective. S…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: Sudden Increase in Checkpoint Lengths
Keith Simmons wrote: > Ian > Yes, same place, same package but only two memory segments, Resident > and 1 Virtual, no change from last restart. In that case I'd have a word with the contract managers. If, for instance, daily invoicing is switched from daily to weekly, which i…
Re: help with sessid
emaus wrote: > Hi all: > > MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority > DS_MAX_QUERIES 20 # Maximum number of decision support queries > DS_TOTAL_MEMORY 4000000 # Decision support memory (Kbytes) > DS_MAX_SCANS 1048576 # Maximum…
Connection manager parametrs
Thanks for following command: oncmsm -r <connection manager instance name> Web URL is no more valid I think: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adr= ef.doc/ids_adr_0116.htm We have two applications with very different load on databases (i.e.,TPS…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Re: Update Statistics
Hello Colin, The "dostats" is a very fine product that would be hard to beat. The only things the might help are "LIGHT_SCANS=FORCE", creating multiple temp Dbspaces on ramdrive (you can use PSORT_DBTEMP for this), use PSORT_NPROCS, DS_TOTAL_MEMORY 4000000, MAX_PDQPRIORITY 100,…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
fragmented table and pdq
In testing we want to play with testing of setting pdq to 5 across the board, we have always run pdq at - except when indexing or updating stats. What we found when pdq is set this sql does not stop at the first 5000 records. IDS is 11.5.FC3 Os is Solaris 10 set pdqpriority 5;…
Question about sysindexes.clust
Have you considered running PDQ with this process? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Meaning of DS_NONPDQ_QUERY_MEM
Dear All.... http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp I refered to this document of IDS 11.1 , and found the following statements: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is a available for a query that is…
RE: threads still running?
Thanks.I see now that that was the problem. The script that updates stats had set pdqpriority 80 at top and never change it before it updated stats for 'routine'. What would be an example of "routines that are known to require PDQPRIORITY set" ? I mean what type of task would th…
Re: Please help optimize a query:
First cut: 1. Update statistics to the recommended levels (see the Performance Guide and John Miller III's white paper) 2. Save SET EXPLAIN output for this original query and all subsequent attempts to optimize it. 3. Why are you forcing the use of a particular index? Let th…
Please help optimize a query:
//QUERY IS AS FOLLOWS: select --+index (s ix_sr2) s.trandt ,sub_min as min ,s.s_class ,s.status ,s.active_dt ,s.exp_dt ,s.canc_dt from status_records s where s.canc_dt >= '08/04/2008' and s.canc_dt < '09/04/2008' and s.canc_dt = (select --+index(y ix_sr2) max(canc_dt)…
PDQ and HPL
I just performed an HPL unload an re-load ona fairly meaty table. It took about 3 hours to re-enabled the indexes. Although I set PDQPRIORITY in the session that started the onpload, it didn't use PDQ. I then dropped and re-created the indexes again, this time through dbaccess…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Informix external directives ?
Dirk Gunsthï¿œvel schrieb: > Hi, > > first you should be able to set the optimizer goal per session using > SET OPTIMIZATION FIRST_ROWS > > secondly how do you see that the optimizer hints (that is what you > mean, right?) are not used? Do you have any helpfull output? > > (I h…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Caching Data to Buffers
Regarding Update Stats - short answer It synchs meta data with your real data, providing the SQL optimizer with the best possible query plan(s). MM…
Opinions on Fastest Token Reference Strategy
Greetings All, I am hoping for some suggestions on the fastest way to cross reference a set of tokens for quick look-up. The current reference has a sample token set of ~ 10 million unique entries that are the basis for the look-up. On a regular schedule (multiple times dail…
PDQPRIORITY
You said "Our db is nearly a OLTP", so the MAX_PDQPRIORITY in your onconfig should be 0 but this won't take effect until you bounce the instance. However, you can dynamically force all sessions running w/o pdq but (I believe) issue "onmode -D 0" ----- Original Message ---- From:…
Re: unkillable sid's
On Feb 29, 4:58 pm, Darren_Jac...@carmax.com wrote: > Here is the stack from the onmode -X: > > 17:51:37 Stack for thread: 309 sqlexec > > base: 0xc000000249ffd000 > len: 69632 > pc: 0x0000000000000000 > tos: 0xc000000249ffecd0 > state: running > vp: 3 > > ( 0) 0x4…
DW query tuning - explain on
OK - I've tried the queries with PDQ set to 0 & 5 in dbaccess, run times are almost exactly the same. One underlying question I have, does this version, of IDS 10.00.FC3X6 (non-XPS) Informix support star transformation?…
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…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: IDS Features - MAX_PDQPRIORITY
Hi DAVID, Thanks a lot for your input I have requested a modification in the documentation. Regarding the last part of your request (HIGH): LOW means 1, HIGH means 100 in IDS. I have requested this to be documented as well. regards Gustavo david@smooth1.co.uk wrote: > On 1 …
Re: IDS Features - MAX_PDQPRIORITY
Hi, Did you find this information in an official Informix manual?. If this is the case please let us know the name and page in the manual to open a documentation defect. Fragment elimination is INDEPENDANT of PDQPRIORITY settings. The following small testcase proves this. Notice…
[Fwd: RE: IDS Features - MAX_PDQPRIORITY]
Just double checked. We're both wrong. With PDQPRIORITY zero no parallelism is enabled. PDQPRIORITY 1 or LOW enables parallel scans ONLY. PDQPRIORITY 2 or greater enables fragment elimination, parallel sorting, and MGM memory use. Art S. Kagel Oninit On Dec 28, 2007 10:47 AM, G…
Memory Performance Tweak
These Settings will fine tune your systems memory, management -at least 512MB of ram recommended, go to start\\run\\regedit -and then to the following key http://software-hacks.blogspot.com/…
Re: IDS Features - MAX_PDQPRIORITY
On Dec 27, 4:36 pm, Dave <In4Mix...@gmail.com> wrote: > Hello, > > Aside from fragment elimination, are there any other features that are > enabled by IDS that result from setting MAX_PDQPRIORITY to 1 (or > greater)?? > > Any help would be greatly appreciated. At PDQPRIORITY 1 o…
IDS Features - MAX_PDQPRIORITY
Hello, Aside from fragment elimination, are there any other features that are enabled by IDS that result from setting MAX_PDQPRIORITY to 1 (or greater)?? Any help would be greatly appreciated. --Dave…
Single vs multi cpu ids
Due to the expense of Informix licenseing I was forced to setup a small 300 million row DSS instance for one CPU. To get any meaningful performance out of this arragement I fragmented all the tables by expression an required the users to include the expression in there SQL's. Thi…
Migrating data between Informix Platforms without
I've had similar issues with Brio reports. One possible fix is to force the report generation to use PDQ. In this way, the BUFFERS are not flushed and you get to use lightscan buffers. I've been able to up the RA_THRESHOLD/RA_PAGES significantly with no ill effects to OLTP and im…
Vendor JAVA Apps eating up Shared Memory.
We have a couple of Vendor JAVA applications that are eating up shared memory every time they execute there SQL calls. They have their owe pseudo session pooling, but each session increases in shared memory and doesn't reuse pre-allocated memory and gets out of hand. They pointe…
Fragement by round robin
On Aug 21, 1:55 pm, mohitanch...@gmail.com wrote: > On Aug 20, 9:12 am, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Aug 20, 12:00 pm, mohitanch...@gmail.com wrote: > > > > Version: IDS 10 > > > > Assuming a box has 15 CPU. And table is fragmented to go in 15 > > > db…
4gl/esql syntax
On Wed, 2007-08-08 at 13:35 -0400, sergio kapul wrote: > looking for correct syntax to create directives inside > queries to overwrite optimizer query execution plan, > to be used in 4gl/esql, I got something that works in straight sql, but it's > ignored when I put it inside of …
long checkpoints on informix
Please post the output from: onstat -m onstat -d onstat -D onstat -u onstat -g iov Sakura.ggxx@gmail.com said: > hi everyone > i recently start to have some long and constant checkpoint > i did lot of change but cant reduce it > i have Informix Dynamic Server Version 9.40.FC2 >…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
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: Slow database creation and loading
johneevo schreef: > This how we are setting pdqpriority from the shell file: > export MAX_PDQPRIORITY=100 PSORT_NPROCS=6 PDQPRIORITY=100 > FET_BUF_SIZE=32767 The above looks good so does the onconfig stuff. (i do assume if you create a backup you use onbar -b -w or external back…
IDS Optimizer Query Plan, declaring and naming indexes
I'm seeing differences in performance for the same SQL being executed on two slightly different databases. Using Set Explain, the difference is when database1 exectues part of the WHERE, it goes down the Index Path for that particular table and it's fast. On database2, the query …
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
query execution plan
As Jack Parker mentioned earlier, there may not be any problem, optimizer just choosing query path based on number of rows. If you are seeing performance problem with one plan versus other, may consider using optimizer directive to enforce the correct path. -Sanjit Chakraborty…
Re: Informix Marketing Brainstorming Forum
TBP wrote: > Although a Single CPU VP does limit many (all?) of the PDQ / > fragmentation side of things. I'm not sure that it does. You can still get fragment elimination and you can still run queries with multiple threads. Regards, Ben.…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Question about Linux VM tuning for IDS
Ian Michael Gumby wrote: > > If Informix acts the way you say, either one of two things. > > 1) You don't have enough memory. > 2) Informix was poorly designed. Not an Informix issue Mickey. Modern UNIX style OS's regard IO cache as primary for performance and feel free to stea…
Re: Question about Linux VM tuning for IDS
Ian Michael Gumby wrote: > > If Informix acts the way you say, either one of two things. > > 1) You don't have enough memory. > 2) Informix was poorly designed. Not an Informix issue Mickey. Modern UNIX style OS's regard IO cache as primary for performance and feel free to stea…
IDS 9.49 UC2 -> UC7 PDQ changes?
Schuran, Sven said: > Hi, > > We changed from UC2 to UC7 on a Linux box with 2.4 kernel. > > With the same configuration, UC7 runs out of memory, but I don't know why. > > PDQ is enabled. When I disable PDQ everything works fine. > One thing, the working sessions nearly all have …
PDQPRIORITY
I would like to give more resources to a query that is run as a SAS batch job, from a scheduled process. When the job is submitted it runs with only 1 thread and a PDQPRIORITY value is not given. Normally when a user submits a query through another thick-client application, the q…
Re: -211 file not open
I wanted to post back an important note on how this issue was resolved for us. If we turned off the PDQ (Parallel Database Query) option we no longer received a -211 SQLCODE with -101 ISAM. Don't know why this is the case. Is there perhaps a defect in the engine in how it tracks …
how to copy large data fast
> > Ian Michael Gumby wrote: >> >HPL? (High performance loader) >> > >> >> He has the data with a table. >> >> So he can do a select from the local database and insert in to the remote >> database, assuming that he can establish a connection to that machine... >> >> >> This woul…
Re: Update statistics for large databases
I believe you have a problem in that you set PDQPRIORITY to 1 before you do an update statistics on the procedures. Informix will run the procedures with the PDQPRIORITY that their statistics were updated with. So all of your procedures will run with PDQPRIORITY 1. Here is a quo…
Re: Pls help to tune my informix engine .. thanks
Henry wrote: > Hi gurus: > > I am using IBM Informix Dynamic Server Version 9.40.FC7 under a 6 CPUs > HP-UX server. > There are 57 dbspaces with a total of 85 chunks. > The informix engine is running very slow recently. > I was not sure whether it is the result of poor tuning or …
Re: query optimize
Devaraj Takhellambam said: > Thanks for replying...The query has been working well and takes just about > 20-30 minutes in the past but recently it has been degraded and took about > 3-4 hours and sometimes 5 hour..so i thought it needs to be > optimized....Thanks.. OK, so how a…
query optimize
Hi, How can I optimize the informix query below- the query uses an OUTER join... select col1, col2, '' col3, col4, A.col5, A.col6, count(*) cout from table A, table B, table C, OUTER table D where A.col9 = B.col9 and A.col7 = D.col7 and A.col8 = 'Y' and …
PDQ on a single processor system
Hi, can sombody tell me if I can benefit from PDQ on single processor system ? According Informix performance guide, multiple treads are started when when PDQ is used, but can i benefit from this wif one physical processor is available only ? I am afraid the extra work to manag…
Informix dbimport blob data slow
> I don't think dbimport uses PDQ so you might want to consider using the > myimport utility available from the IIUG repository which loads in > parallel. I don't think this is exactly the same as PDQ but it may help > speed things up. I think it does for import builds. However…
Re: SAN and dbspace layout.
And don't forget that one day you might like to use PDQ - fragmented tables across multiple dbspaces. Think multiple LUN's, HBA's and how you route your switches if you ever go down this path.…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
IDS 10.0 performance on RedHat
> These are based on multipe runs of a dbimport, and of populating a single > large-ish table then building a couple of indexes thereon, utilising PDQ, > thereafter. how many table fragments? why use dbimport and not HPL or similar to load the table? With dbimport you are likel…
Re: fragment elimination on query
Ben Thompson wrote: > Art S. Kagel wrote: > >> For fragment elimination to take place you have to run with >> PDQPRIORITY >= 1 > > > Are you sure this is correct Art? Here is a query I just ran to check > with PDQPRIORITY set to zero: Apparently not as sure as I once was. John…
Re: Database Encryption
Adam Tauno Williams wrote: > > In our case the application uses the user's credentials to acquire a/the > key from a key repository, and then connects to the database with the > user's credentials and uses the acquired key to get or update data in > the database. The key never l…
Performance issue after 732 to 94fc6 upgrade
See below: > ----- Original Message ----- > From: Doug Fossmeyer <ids@iiug.org> > At: 6/12 20:13:55 > > > Part 2 of posting > > onstat -c > > IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days > 19:54:35 > -- 2325280 Kbytes > <SNIP> > TBLSPACE_STATS 0 # Maintai…
Getting ISAM error 116 during update statistics
Thanks for all your support this problem is solved by increasing the shared memory value in that server :-) On 5/26/06, ART KAGEL, .... <kagel@bloomberg.net> wrote: > > > Increase DS_TOTAL_MEMORY from the default and increase SHMVIRTSIZE to > accomodate > the extra memory. Also …
Dumb DBA mistakes
Don't bring up IDS with the PDQPRIORITY environment variable set on an OLTP system. It was very ugly for me. 3000 users all trying to run queries at PDQPRIORITY of 1. In fact Jonathan Leffler showed a really nice way to bring up the server in his paranoid DBA class in Tampa. Prev…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Recommendation on DBA Tools
Do you have any recommendations on database management tools which helps DBA to monitor and manage the system, and have the flexibility of adding add-ons (bring in other tools, like shell scripts, etc.). Something that would collect and analyze the system performance, monitoring…
IDS - Running temp dbspaces on RAMDISK
Another try could be to increase DS_NONPDQ_QUERY_MEM significatntly: Must be >= 128 and <= 0.25 * DS_TOTAL_MEMORY DS_NONPDQ_QUERY_MEM 65536 # Non PDQ query memory (Kbytes) $ onmode -wm DS_NONPDQ_QUERY_MEM=65536 (IDS 10) Could decrease IO into temp spaces.…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
dostats
Is there a way to have dostats update specific procedures? I would like to set PDQ on several, but not all. Thanks…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Rename Stored Procedure in Informix IDS 7.31
Drop and recreate. Don't forget a) to update stats on the stored procedure afterwards. (And don't have the PDQPRIORITY env variable when you do the update stats or the stored procedure always runs at this PDQPRIORITY!). b) to drop and recreate any triggers that depend upon thi…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
MGM Mutex Locks hangs the system
Could anyone help me with my problem? This happens when users log off the system (on the system we have about 1000 users and hundreds of users will log off at the same time), We see MGM mutex locks P.S. pdqpriority is set to 0…
MGM Mutex Locks hangs the system
Could anyone help me with my problem? This happens when users log off the system (on the system we have about 1000 users and hundreds of users will log off at the same time), We see MGM mutex locks P.S. pdqpriority is set to 0…
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: IFX_FLAT_UCSQ
>> I am sure flattening of uncorrolated subqueries (all, some types? don't know!) is off by default. This is not correct. I am sure that any query can be flattened if the cost says to do it that way. Also read the excellent link that Bill Dare included: http://www.iiug.org/waiug…
Re: update statistics
tomcaml@yahoo.com wrote: > Hello, > > We recieved this message from a cron job over the weekend: > > 564: Cannot sort rows. > > 179: ISAM error: no free disk space for sort > Error in line 50 > Near character position 44 > > > question - does Informix always go straight to di…
OPTCOMPIND
I set to to 0. I have seen loads of questions on here in the past about upgrading to IDS and finding everything running slowly. It appears that sometimes even though 2 should mean least cost the optimizer gets it wrong and will not use indexes. Setting OPTCOMPIND to 0 avoids th…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: IDS Next Version - back on topic
paul@oninit.com said: > I'd like a > > DROP PROCEDURE ALL <SPLNAME> > > but is pure laziness And what would it do? > Obnoxio The Clown wrote: > >> May I commit a heresy here, and try and drag something off-topic back >> onto >> the original topic? >> >> I was just thinking how …
IDS Next Version - back on topic
Obnoxio The Clown wrote: > May I commit a heresy here, and try and drag something off-topic back onto > the original topic? > > I was just thinking how nice it would be to have declarative PDQ built > into stored procedures and views: > > 1. onconfig parameter to enable / disable…
Re: Slow dbexport
try with export PDQPRIORITY=100 for dbexport/dbimport and see if this makes any difference…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: strange behavior in 9.40.FC6
Bill Dare wrote: > 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 a…
RE: Solaris memory management
Dirk, I run 7.31.FD4 on Solaris 9. there is a line in the release notes (filename IDS_7.3) "The maximum size of any shared memory segment is 4294967295 bytes(approx. 4GB)." I use RESIDENT -1, SHMVIRTSIZE 4096000 and SHMADD 2048000 and have 7 segments allocated (total 16Gb). Wit…
RE: Solaris memory management
Dirk, I run 7.31.FD4 on Solaris 9. there is a line in the release notes (filename IDS_7.3) "The maximum size of any shared memory segment is 4294967295 bytes(approx. 4GB)." I use RESIDENT -1, SHMVIRTSIZE 4096000 and SHMADD 2048000 and have 7 segments allocated (total 16Gb). Wit…
RE: Solaris memory management
Hi Dirk. Limitation Solaris 32bit is 4GB(unsigned inteter). Limitation Solaris 64bit is unsigned long. See http://developers.sun.com/solaris/articles/tuning_solaris.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Dirk Moolman" <DirkM@mxgroup.co.za> >To: …
RE: Solaris memory management
Hi Dirk. Limitation Solaris 32bit is 4GB(unsigned inteter). Limitation Solaris 64bit is unsigned long. See http://developers.sun.com/solaris/articles/tuning_solaris.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Dirk Moolman" <DirkM@mxgroup.co.za> >To: …
RE: Solaris memory management
The release notes I am looking at on Sun's site are showing that that parameter is obsoleted, of course then they define it. So maybe this web page will give you what you need. I like the System Admin collection of manuals. http://docs.sun.com/app/docs/doc/806-7009/6jftnqskt?a=v…
RE: Solaris memory management
The release notes I am looking at on Sun's site are showing that that parameter is obsoleted, of course then they define it. So maybe this web page will give you what you need. I like the System Admin collection of manuals. http://docs.sun.com/app/docs/doc/806-7009/6jftnqskt?a=v…
RE: Solaris memory management
My main concern is not Informix, but the limitation in the operating system. I had an AIX system, where I specified lots of memory in Informix, but AIX still had to break it up - could not handle such a large contigous chunk. I was not able to only have one virtual segment on …
RE: Solaris memory management
My main concern is not Informix, but the limitation in the operating system. I had an AIX system, where I specified lots of memory in Informix, but AIX still had to break it up - could not handle such a large contigous chunk. I was not able to only have one virtual segment on …
RE: Solaris memory management
-----Original Message----- From: Martin Fuerderer [mailto:MARTINFU@de.ibm.com] Sent: 11 April 2005 06:57 PM [dirk] owner-informix-list@iiug.org wrote on 11.04.2005 13:35:51: > I am trying to find out what the limit is on contiguous memory in > Solaris. Can I grab one segment of…
RE: Solaris memory management
-----Original Message----- From: Martin Fuerderer [mailto:MARTINFU@de.ibm.com] Sent: 11 April 2005 06:57 PM [dirk] owner-informix-list@iiug.org wrote on 11.04.2005 13:35:51: > I am trying to find out what the limit is on contiguous memory in > Solaris. Can I grab one segment of…
Re: Solaris memory management
Martin Fuerderer wrote: > Dirk Moolman wrote on 11.04.2005 13:35:51: >>I am trying to find out what the limit is on contiguous memory in >>Solaris. Can I grab one segment of 20G, or will Solaris break the >>segment down into smaller pieces ? >> >>For example, if I run onstat -g …
Re: Solaris memory management
Hi, On UNIX systems INFORMIX reserves memory in blocks( this is 8k each one). Your 20Gg of Memory are 20 Gb / 8Kb of contigous blocks. If you see in your onstat -g seg one virtual value, there are one contiguos Virtual segment. Otherwise, remember that INFORMIX manage a RESIDENT…
Re: Solaris memory management
Hi, in general this is configurable in the kernel. Maximum possible configuration may also depend on Solaris version, but I don't know. The kernel parameter may be something like shminfo_shmseg but I'm not 100% sure. Regards, Martin -- Martin Fuerderer IBM Informix Developmen…
Re: Solaris memory management
Hi, in general this is configurable in the kernel. Maximum possible configuration may also depend on Solaris version, but I don't know. The kernel parameter may be something like shminfo_shmseg but I'm not 100% sure. Regards, Martin -- Martin Fuerderer IBM Informix Developmen…
Solaris memory management
I am trying to find out what the limit is on contiguous memory in Solaris. Can I grab one segment of 20G, or will Solaris break the segment down into smaller pieces ? For example, if I run onstat -g seg, can I have one segment of 20G, or is this not possible ? I am using Solar…
Solaris memory management
I am trying to find out what the limit is on contiguous memory in Solaris. Can I grab one segment of 20G, or will Solaris break the segment down into smaller pieces ? For example, if I run onstat -g seg, can I have one segment of 20G, or is this not possible ? I am using Solar…
Cost Estimation for queries
Again optimizer considering BUFFERS/RA_PAGES while considering estimated no of I/Os is not a good idea since buffers are part of volatile memory where at a point of time we cannot be sure how many pages reside in memory satisfying the query for which optimizer is evaluating the b…
Join threads
Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.…
Re: purpose of optcompind and optgoal
calyanram@hotmail.com wrote: > Hi > > what is purpose of these two parameters ? > > regards > s.kalyan I'll answer since I was one of the users pressing for something like OPT_GOAL to be implemented back in the 7.24 days. OPT_GOAL tells the optimizer whether to optimize for the…
purpose of optcompind and optgoal
calyanram@hotmail.com wrote: > Hi > > what is purpose of these two parameters ? > > regards > s.kalyan I'll answer since I was one of the users pressing for something like OPT_GOAL to be implemented back in the 7.24 days. OPT_GOAL tells the optimizer whether to optimize for the…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Multiple virtual segments
Neil Truby wrote: > "Paul Watson" <paul@oninit.com> wrote in message > news:cutjmk$5s9$1@thorium.cix.co.uk... > >>Madison Pruet wrote: >> >> >>>Solaris is not all that vunurable to the IPCSHM issue... >> >>But Solaris is tuned for 4 segments > > > can you exapnd on that please, …
question about pdq memory
If you have a certain amount of memory configured in the DS_TOTAL_MEMORY parameter in onconfig, does that mean your engine reserves that memory only for pdq queries where you have pdqpriority set ? In other words, if you are not running any queries with pdqpriority set, is that m…
Re: SPL DATETIME bug ????
This performance fall off is only on datetimes, if the where clause uses integers then it's fine. If I drop the datetime select into the exec blade the performance is back to 0.3 Art S. Kagel wrote: > Paul Watson wrote: > > The difference is that effectively the second query/s…
RE: SPL DATETIME bug ????
check the explain for both query, I believe they are deferent. In the first query the optimizer know the range of date at optimization time, but in the second it do not. In each query he build deferent query plan. You should force the optimizer to work as the first query using di…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: HPL and PDQ
"Tisha" <loden@networkip.net> wrote in message news:8085cdee.0408240701.35b83299@posting.google.com... > Neil, > > Did you get this to work with onpload in 9.4? I have used HPL alot in > past releases and never gotten it to use the pdq settings for an index > build. My work aro…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: HPL and PDQ
Neil, Did you get this to work with onpload in 9.4? I have used HPL alot in past releases and never gotten it to use the pdq settings for an index build. My work around has always been to build the table with no indexes, load the data using hpl, and then build the indexes in a…
Re: HPL and PDQ
--0__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25 Content-type: multipart/alternative; Boundary="1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25" --1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25 Content-type: text/plain; charset=US-ASCII Content-tran…
Re: HPL and PDQ
> Hi Neil, > > How are u running the onpload. Are you using ipload or onpladm? > If that is the case then we might not be passing these environment > varaibles to onpload. onpladm.…
Re: HPL and PDQ
--0__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462 Content-type: multipart/alternative; Boundary="1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462" --1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462 Content-type: text/plain; charset=US-ASCII Content-tran…
HPL and PDQ
IDS 9.40FC3W2 on HP-UX11.11 I'm running an onpload (HPL) run job which is loading 35m rows to a table then enabling the indexes. The index "enable", which I understand to be an ordinary build in a different jacket, is taking much longer than I'd expect. I can see from the marve…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: how release threads?
make sure when you update statistics for procedure you set pdq to 0...the stored procedures that help facilitatemay be mutltithreading if you do not and the thread count will increase until evetually you get an exception error which might crash the engine.…
Re: Dropped users on AIX 5.1
Hi CKGeier@nwc.edu, That almost sounds like an aging issue. In the a simlilar vein, I had a smililar problem that took me forever to figure out. The DBA here before me had an update statistics script that ran at 100 pdq and within that script he had set "update statistics for pro…
Multiple user threads
Hello everybody, we're using version 9.40.T7 Our max_pdqpriority is 100. Right now, I see much this behaviour with onstat -u. Informix creates plenty of user threads. If I set with the max_pdqpriority with onmode -D to 0. Then I get a single user session which shows me sometim…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Re: PDQ not used ?
Thanks a lot for your help ! I found my problem. I mixed some things up... I set pdqpriority=100 in my sqlstatement (embarassed...).. WinSql didn't give me an error on it. But Right now, it works great ! Thanks a lot ! Bjorn "Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote …
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 ?
Include SET PDQPriority 100; at the beginning of a SQL statement to make sure it runs in PDQ. You can also set environment variable for a job/account to make this setting a little more global.…
PDQ not used ?
Hello everybody, here's our Informix newbie again :) I'm just new in the company and nobody is a real informix specialist in our IT-team, so I try to pull it to me. I know that I should follow a course but we have no time for that cause the new server need to be live in 3 week…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: Memory allocation failed during query processing -AIX 5.1
CKGeier@nwc.edu wrote: > here is what we have in our onconf file: > > # Parallel Database Queries (pdq) > MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority (was 100) > [...] > "Savio Pinto (s)" <spinto@cap.org> wrote: >> have you turned on PDQ?, is the DS_TOTAL_MEMOR…
Re: PDQ memory / non-PDQ memory
sumGirl said: > This is likely obvious, so feel free to treat me like a know-nothing > bimbo. If I must. :o) Actually, I can't. There's no joy in it when it gets offered up on a plate like this. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa g…
RE: PDQ memory / non-PDQ memory
Formally, PDQ memory is not 'reserved' when PDQ is not running. It is accessible to other sessions .... This is theory. In fact, this memory can't be allocated to memory-hungry subsystems, such as buffer cache. If other sessions allocate a lot of memory from the same pool (V se…
PDQ memory / non-PDQ memory
This is likely obvious, so feel free to treat me like a know-nothing bimbo. If I dedicate X amount of memory to informix and set Y available to PDQ - is Y amount available to non-PDQ processes when not in use? Or is it always reserved and sitting around doing nothing when I am no…
multiple userthreads per session
Hi, maybe your environment variable PDQPRIORITY was set to a value greater than zero while you did "oninit" ?…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
PDQ priority
We have an application written in Java (server side JBOSS application server) and would like to give certain users a higher priority. I don't want to set it via the environment variable since that would raise the priority for everyone. It it possible to set the PDQPRIORITY via ja…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
how to tune buffer allocated to index data?
The profile you have (Data 12%, Index 86%) could point to the need to increase BUFFERS. Index pages tend to stick around in memory because they are usually used more often than data, especially in OLTP systems where data is almost always accessed through an index (sometime 2 or 3…
Re: Re: Query Permormance improvement: URGENT
>Nonsense. The order in which the optimiser decides >to do the processing is critical. I Agree, but as long as the optimizer give a plan wich has some _sense_ , which is certain almost all the the time... But in the cases when the optimizer plan is _nonsense_ (statistics et all…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Slow reposnse
Neil Truby wrote: > "Fernando Nunes" <spam@domus.online.pt> wrote in message > news:bve3cb$qvajr$1@ID-161111.news.uni-berlin.de... > >>Did you start the engine with PDQPRIORITY on? >>Apparently even simple queries have several threads... >> >>Are you issuing grant/revoke stateme…
Re: Query Optimization ... Is this all I can get??
The reason your original solution didn't work well is that You needed to have the correct indexes, which you have added and then the outer join query should be better and faster. > Although your first option would work in my case, it would be a mess, > as they would have to be O…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Re: Query Optimization ... Is this all I can get??
Anthony Presley wrote: > > Although your first option would work in my case, it would be a mess, > as they would have to be OUTER joins of the address and phone table, > and the joining of some 100K with 300K with another 150K takes some > time [although, this was my original sol…
Re: Query Optimization ... Is this all I can get??
Yes - (amendment to my own response) - it's usually best to head an index with the most selective column, unless you have lots of queries that only reference the other column(s) or have an ORDER BY or GROUP BY that requires the index to be in a particular sequence. As for UPDATE…
Re: Query Optimization ... Is this all I can get??
Thanks for everyone's advice. Unfortunately, I am using a combination of Java and I4GL (moving everything to Jasper Reports at the moment), and was just using the "FOREACH" as an example. In reality, it is a for loop. I first added the (type, type_id) index, and then did an up…
Query Optimization ... Is this all I can get??
Hello all .... Always with the query questions .... so I come to you once again. 1st -- my textbooks on this subject are rather sparse, and a bit ... un-useful. Anyone have any good links / articles / books on query optimization? 2nd -- the actual problem .... I have a SIMPL…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Re: Informix thread management
OK, but on the other hand I *have* seen very small queries get blocked when for some inexplicable reason IDS calculated a DS_MAX_QUERIES of 6, which is a mystery in itself. (They haven't set the DS values in the onconfig, but according to the calculation in the manual it should b…
Re: Informix thread management
Thanks for a most informative post Art - as ever. On the site I'm on at the moment users often connect with PDQPRIORITY=HIGH and I'm sure I've seen several run at the same time and not get blocked. They just don't seem to get to do much in the way of parallel processing - though…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Informix thread management
On Fri, 12 Dec 2003 07:22:55 -0500, Vijay wrote: > Hi All, > > I have fragmented my database & now want to use the parallel > database feature of Informix.. I read in a document that we need to limit the > database's parallel processing feature because, the more the para…
Re: PDQ and 940
Paul, I am using the same verision 9.40 fc2, Solaris 2.8 and do not see this. Rich "Paul Watson" <paul@oninit.com> wrote in message news:3FCBA46A.2F42895@oninit.com... > Sun Solaris 2.8 64bit > 9.40.FC1/2 > > I can't turn off PDQ unless it's done in the onconfig. Queries > t…
drop a column
Hi, ALTER TABLE <tablename> DROP <column name> ; should do (in most cases). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "GANESH RAM" <ganesh.r@fmr.com> Sent by: forum.subscriber@iiug.org 03.12.2003 10:39 To: ids@iiug.org cc: …
PDQ and 940
Sun Solaris 2.8 64bit 9.40.FC1/2 I can't turn off PDQ unless it's done in the onconfig. Queries that were running under 9.30 now take forever as long and spawn 20+ threads Anybody else seen this -- Paul Watson # Oninit Ltd # Growing old is mandatory Te…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Workgroup Edition or Enterprise
Olmedo Monteverde wrote: > Nope. Between other features, PDQ is not available. Actually, I think it's more subtle than that - Fragmented tables are not available, but PDQ is. Fragmented tables are the premier beneficiary of PDQ with large queries, however PDQ does have other us…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: PDQ
Attachment is missing!!! Gorazd "Rajib Sarkar" <rsarkar@us.ibm.com> wrote in message news:bn8r6t$2v2$1@terabinaries.xmission.com... > > Actually, Obnoxio is kind of right ..:-) Although this parameter is not > new, this parameter has been "upgraded" to accomodate a) More memory…
Re: PDQ
On Wed, 22 Oct 2003 19:14:12 -0400, David E. Grove wrote: Yes! This is why my dostats utility explicitely sets PDQPRIORITY to zero (or a value specified with the -P option) for stored procedure updates regardless of the PDQPRIORITY value in the user's environment (or specified …
Re: PDQ
On Thu, 23 Oct 2003 04:50:06 -0400, Mark D. Stock wrote: > Obnoxio The Clown wrote: > >> David E. Grove wrote: >> >>>>makes a big difference to stuff like index creation and update stats. >>> >>>We learned to be careful with PDQ and UPDATE STATISTICS. >> >> There is a new enviro…
Re: PDQ
Mark D. Stock wrote: > Anyway, thanks for the update. In what version was this parameter > "upgraded"? I think 7.31xC6, somewhere in the 9.30 stream (xC4?) and 9.40. Not too sure of 9.30. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"…
RE: PDQ
Rajib Sarkar [mailto:rsarkar@us.ibm.com] > > Actually, Obnoxio is kind of right ..:-) "Kind of right"? "Kind of right"? Cheeky! :o) -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"…
Re: PDQ
Mark D. Stock wrote: > > Obnoxio The Clown wrote: > >> David E. Grove wrote: >> >>>>makes a big difference to stuff like index creation and update stats. >>> >>>We learned to be careful with PDQ and UPDATE STATISTICS. >> >> There is a new environment variable (DBUPSPACE?) which,…
Re: PDQ
Rajib Sarkar wrote: > > Actually, Obnoxio is kind of right ..:-) Although this parameter is not > new, this parameter has been "upgraded" to accomodate a) More memory for > sorting b) To print out the progress of update stats (explain plan). It's lucky I added the proviso, "Unl…
RE: PDQ
Great paper ! a few months ago i got an error when running update statistics for a very big table : "Not enough space for sorting" ... or something like that . My IDS Version is 7.31.UD1 How can I avoid this error? By Using DBUPSPACE environment Variable ? Thanks in advance …
Re: PDQ
Obnoxio The Clown wrote: > David E. Grove wrote: > >>>makes a big difference to stuff like index creation and update stats. >> >>We learned to be careful with PDQ and UPDATE STATISTICS. > > There is a new environment variable (DBUPSPACE?) which, when used with PDQ > will allocat…
Re: PDQ
> makes a big difference to stuff like index creation and update stats. We learned to be careful with PDQ and UPDATE STATISTICS. In a past job, I had been working mainly with a data warehouse. In that environment, I made constant and effective use of PDQ, and didn't think anyt…
Redbrick Query Optimizer behaving funny.
Hi All, Today I saw very funny behaviour of Redbrick query optimizer where the order in which tables are listed in the from clause is controlling the indexes being used. I am sending the results of explain for both the conditions: CONDITION 1: ============= RISQL> explain …
PDQ
Hi guys, since the price-differences betwen IDS 9.4 and IDS 9.4 WE are not marginal, I wondered, whether it's worth to buy a IDS 9.4 in order to be able to use PDQ. May be it's better, to invest the difference-amount in better hardware. Does anyone of you have expieriences in u…
Re: create index stalls entire informix server
On Thu, 09 Oct 2003 16:41:25 -0400, Steven Kurlander wrote: If the PDQPRIORITY of the index build is 100 or the other user's PDQPRIORITY plus the build's PDQPRIORITY add up to more than 100 then once the index build has started the other query will have to wait for sufficient re…
Re: Product Defect Query no longer available????
On Tue, 2 Sep 2003 09:19:18 -0500, kernoal.stephens@autozone.com wrote: > >https://www-927.ibm.com/software/data/informix/support/pdq/ > >PDQ alive and well! > > Verified . . . .…
ALTER FRAGMENT goes walkabout
Neil Truby wrote: > [stuff] hmmm - is your engine setup in such a way as to encourage PDQ index builds? If so, perhaps the ALTER FRAGMENT is not triggering the much faster PDQ builds?…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
ER problem 9.3.UC2 / linux
My line manager has been doing some experiments with ER on Linux and this may be the problem he experienced. He logged a case with IBM Informix technical support on this issue. Their response is that there is an issue with raw IO and logical logs on Linux. Using cooked files for …
OPT_GOAL setting at 4gl level
Hi, I have checked the manuals about where I can set the OPT_GOAL parameter. Below are the IBM docs, but they do not specify if I can set the OPT_GOAL in the 4gl code. Can anyone confirm if I can set this in the 4gl code? If I must do this at the session/user level, I assume this…
Stored Procedure Performance
On Tue, 01 Jul 2003 12:22:16 -0400, Joe Pacelli wrote: Besides the other suggestions - is it possible that the SPL was compiled with a PDQPRIORITY other than zero? This might cause it to wait for resources when the system is busy. SQL Procedures run at the user's PDQ priority …
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
oninit: Fatal error in shared memory creation
Joe; The most frequent cause of this error is when the shared memory segments you are trying to create when starting the engine already exist. Look in the online log for an error 17 - that means the segments already exists. That means either the engine is already running (run '…
Re: OPT_GOAL
On Tue, 20 May 2003 10:00:30 -0400, Greg Mitchell wrote: Setting OPT_GOAL to zero (or using FIRST_ROWS optimization in SET OPTIMIZATION or optimizer hints) is useful for internactive applications where records will be displayed a few at a time. It makes the app appear to be mor…
informix 9.4 question: PDQPRIORITY and user threads
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_01C31F07.D165AEC0 Content-Type: text/plain; charset="iso-8859-1" We are testing IDS 9.4 against linux Red Hat 7.2. Con…
memory increase
He's right in theory, but not in practice. Informix will dynamically add memory segments up to and beyond physical memory ( into swap space ). But this is not something you want to happen. It's better to plan for the memory requirements and set the initial shared memory segmen…
Re: Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC
Hi 1) As for my experience if you have only DB on your server and you do not have large WAIT IO define all cpu to informix. If you have a lot of users and you are using NET VP check there cpu usage, maybe you should spare one or two cpu for them. 2) Probably the first SQL use i…
Re: Dynamically allocated new extension shared memory
If you are using datablades you will "EXTENSION" memory segments ... "EXTENSION" is memory segment class used within the source. Other classes are RESIDENT, MESSAGE and VIRTUAL. I believe you will see a VX when you do a onstat -g seg in your instance. HTH Thanx much, Rajib Sar…
Re: Dynamically allocated new extension shared memory
If you are using datablades you will "EXTENSION" memory segments ... "EXTENSION" is memory segment class used within the source. Other classes are RESIDENT, MESSAGE and VIRTUAL. I believe you will see a VX when you do a onstat -g seg in your instance. HTH Thanx much, Rajib Sar…
=?gb2312?B?tPC4tDogUmUuIFNoYXJlZCBNZW1vcnkgUGFyYW1ldGVycyBbODA1XSA=?=
The UC portion of the release level means this is a 32 bit build. A 64 bit version is identified as an FC release level. We are running on Solaris 2.6 which is a 32 bit OS. As I understand it, 3.75 GB is the threshold limit on the total amount of memory a 32 bit engine can manag…
RE: PDQ Woes
PDQPRIORITY sets the amount of PDQ resources that will be used by a query. When you set it to 75 it means that it will use 75 percent of PDQ resources (Memory, Threads, etc.). When you run onstat -u you saw multiple threads not multiple sessions. If you run onstat -g sql <sid> fo…
PDQ Woes
OK, so a user job has been running now (we joke not), 2 days on one little select, ok its lots of data. So I kill it, my box was grinding. I run it with MAX PDQ at 10, it crawls, my box crawls. I set PDQPRIORITY=75 (I know, but I'm the admin and no-ones gonna …
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…
RE: PDQ
PDQ gates on CPU VPs as well? Something new. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 3:20 AM > To: informix-list@iiug.org > Subject: Re: PDQ > > > How many CPU VPs do you have? PDQPRIORITY 50 im…
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
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_01C09058.C3BD1BEA Content-Type: text/plain; charset="iso-8859-1" PDQ is a resource. If there is insufficient of that …
FW: PDQ
This is a multi-part message in MIME format. ------=_NextPart_000_0060_01C08E29.BB8B3640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I think it has to do with the type of query I run, that some queries use PDQ and others not ........ Dirk -…
PDQ
This is a multi-part message in MIME format. ------=_NextPart_000_005A_01C08E0D.B35BA2A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I just ran into something very strange. I am running to queries on my system (doing my weekly maintenanc…
HPUX 11.0 memory management and IFMX
IDS 7.30uc7 OS HPUX 11.0 I'm in the process of troubleshooting a minor issue since we've upgraded to HPUX 11.0. When the engine comes up, the following messages show up in the online. log: 13:25:03 shmat: [EINVAL][22]: shared memory base address illegal 13:25:03 usi…
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: …
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
How do I set FIRST_ROWS for client session?
Set the environment variable OPT_GOAL=0 or add a SET OPTIMIZATION FIRST_ROWS in the apps. Art S. Kagel bafarwell@earthlink.net wrote: > > Does anyone know how to set the FIRST_ROWS optimization goal for a > client session (i.e. Windows client using native libraries, setnet) so …
Fw: Redbrick Memory Management & Statistics
----- Original Message ----- From: exformix <exformix@hotmail.com> To: Leonardo F. Cardoso <lfcardoso-nospam@hotmail.com> Sent: Tuesday, November 07, 2000 12:02 AM Subject: Re: Redbrick Memory Management & Statistics > Hi, > > There is no concept of updating statistics in Redbri…
Redbrick Memory Management & Statistics
Hi, How can I control the amount of shared memory redbrick uses? I can�t find any parameter in the configuration file. Another question: Is statistics automatically maintained in RedBrick? Is there some SQL command like "update statistics"? Thanks in advance …
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Maximum Instance
On Tue, 26 Sep 2000, watZki wrote: >Is there a limit on number of DB Instance Online? Not explicitly. Computer resources (CPU, memory, disk) are usually the limiting factors. >Is there a connection w/ my memory? Yes (assuming you're referring to the memory on the computer, ra…
Query Optimization: Wrong execution plan?
Hello All, I have a problem with a query: The query is the join of two tables select * from tab1, tab2 where tab1.pk=tab2.fk There're indexes on both fields (unique index on tab1.pk and indexes with duplicates on tab2.fk). The problem is that the query takes too much time. …
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: (2) Poor Performance with 7.31.uc6
From: "Ty O'Kelly" <tokelly@maxor.invalid.com> > >Obnoxio The Clown wrote: > > > A word to the wise: when you need to do your index rebuilds, set the > > following environment variables: > > > > PSORT_NPROCS=[2 * NUMCPUVPS] > > PDQPRIORITY=100 > > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 #…
Re: (2) Poor Performance with 7.31.uc6
Ty O'Kelly wrote: > > Obnoxio The Clown wrote: > > > A word to the wise: when you need to do your index rebuilds, set the > > following environment variables: > > > > PSORT_NPROCS=[2 * NUMCPUVPS] > > PDQPRIORITY=100 > > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 # i.e., 3 temporary filesyste…
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
Performance comparison btn Informix and SQL Server
Thanks for all the suggestions, I will try them out, and give a summary about the results. P.S. One small question I have now is: optimizing one query brings another one down! :-( At least I have one query which takes double so long as it took before I run UPDATE STATISTICS.…
People Soft and Informix 7.2
Informix DSA 7.2 Platform: Sun SPARC SunOS 5.5.1 4 CPUs Has anyone found it advantages to turn PDQ on with PeopleSoft version 7.01? TIA Cheryl L. Kendricks Sr. Database Analyst H.E. Butts Grocery San Antonio, Texas…
Re:
From: "Bantilan, Artemius Ian" <I_Bantilan@islacom.com.ph> > > I have a table fragmented accross 4 dbspaces. When i do a simple select >using a where clause on an indexed column or any column for that matter, it >is qualified >as a pd query. Should this be the case?? If you h…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Posting from the Informix-list
if you don't like it, just set pdq priority to 0 before issuing the query. Nona >Subject: Posting from the Informix-list >From: "Bantilan, Artemius Ian" I_Bantilan@islacom.com.ph >Date: 10.07.00 04:53 W. Europe Daylight Time >Message-id: <8kbf5g$91e$1@news.xmission.com> > > >He…
Re: DS_MAX_QUERIES & DS_TOTAL _MEMORY parameter
These parameters are used by Informix to determine the amount of resource to allocate for a Parallel Database Query (PDQ) DS_MAX_QUERIES - this specifies the maximum number of PDQ that can be execute at any given time. This parameter is quite subjective based on the number of …
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Data type conversion in query
Does anyone out there know how to force the optimizer/engine to convert data types in a query? I have a query that is joining a CHAR(20) column to an INTEGER column. Right now it is trying to convert the CHAR to an INTEGER which won't work. If I could make it convert the INTEGE…
PDQ and IDS 7.3
benlag@aent.com wrote: > Is their any way I can globally set the PDQPRIORITY variable so that > these users can use PDQ?? You can set PDQPRIORITY environment variable at any client workstation You want. > Benny Lago Leonid Vorontsov…
Re: SE 7.X installation on WIN98 ignore
Please ignore . I was using wrong protocol Thanks stumbde <stumbde@email.msn.com> wrote in message news:... > I am trying to install SE on Win98. When i run dbaccess i get following > error > when i am trying to connect > Error 25567 Internal communications buffer management err…
SE 7.X installation on WIN98
I am trying to install SE on Win98. When i run dbaccess i get following error when i am trying to connect Error 25567 Internal communications buffer management error detected. This error is usually caused by memory corruption or wrong use of buffer management routines. Make sur…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
first 'n' rows
sveiga@my-deja.com wrote: > > In article <0cefcfc2.92a34d23@usw-ex0106-048.remarq.com>, > Esther <estherNOesSPAM@ts.es.invalid> wrote: > > I would like to know how can I use the "FIRST_ROWS" optimizer > directive > > and the "SELECT FIRST 'n' ROWS" directive. I don't know the s…
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…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Left join ignores optimizer directive
Hey, I'm wondering if anyone out there has had difficulties with left joins? Our query goes incredibly slow with optimize set high and fairly quickly with it set low. In order to improve performance, we brought in a performance expert who specified some optimizer directives. W…
RE: Page Size on Solaris (Informix 7.31)
Solaris onlys has an 8K page size on certain architectures, the rest are 4K. Basically the sun4u's are 8 and the sun4m are 4K. The page size wrt to the OS is determined via the hardware abstraction layer which is typically one of the few machine code areas of the kernel and uniq…
PDQ PRIORITY
Binod Maveli wrote: > > 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 pl…
PDQ on ANSI Databases
Hi All, I've been trying to execute a parallel database query (PDQ) on an ANSI database. But everytime I run onstat -g mgm it doesn't register it as a PDQ and no resources were allocated. I tried doing this on a non-ANSI database and they were no problems. BTW, I am using IDS …
OPT_GOAL
matur_suksema@my-deja.com wrote: > Has anyone experimented with changing the default for OPT_GOAL from all > row to first rows? Would anyone recommend using first rows for a 200+GB > database? Does anyone have any good/bad experiences that they can > share? You use FIRST_ROWS…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
DBSPACETMP
Savio Mario Bartholomeo Pereira wrote: > > Hi > > Please let me know how the temporary dbspace can be freed. I am working on > IDS 2000 on NT & the command given was > > select first 100 * from billed_calls order by callbilldt > > The row count for the table mentioned abo…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
Memory problems? Please help.
I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. They used to be executed during a shell script containing abotu 30 programs. However, this was poor for maintenance and distribution so one exe was compiled and the routines seem to get slower and slower as…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
PDQ question
We have a fragmented table (round robin) in two dbspaces with two detached indexes in a third dbspace. All dbspaces are on different disks. PDQ priority is set to 100, the machine has two processors Selecting all rows (sequential scan) results in 3 Informix threads and evenly d…
RE: PDQ Advice Please
For a OLTP instance and doing large queries and update's, setting PSORT_NPROC and PSORT_DBTEMP are a better way to use the parallel processing features in Informix IDS or even 5.x instances. Check that out, before doing down the PDQ path. Wayne E. Martin Informix Database Admini…
Re: PDQ Advice Please
From: "Tony Flaherty" <aef@mfs.misys.co.uk> > >Hp-Ux 10.20 >IDS 7.30.UC7 > >We have a OLTP set-up with occasional large queries/updates running during >the day. I've not paid that much attention to the PDQ settings previously >:o/ I thought it was disabled. However I've started…
Re: PDQ Advice Please
Tony Flaherty wrote: > > HI, > > Hp-Ux 10.20 > IDS 7.30.UC7 > > We have a OLTP set-up with occasional large queries/updates running during > the day. I've not paid that much attention to the PDQ settings previously > :o/ I thought it was disabled. However I've started reading u…
PDQ Advice Please
HI, Hp-Ux 10.20 IDS 7.30.UC7 We have a OLTP set-up with occasional large queries/updates running during the day. I've not paid that much attention to the PDQ settings previously :o/ I thought it was disabled. However I've started reading up on it in the hopes that I can use i…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Query Optimizer Weirdness in Stored Procedure
(Environment: Sun Enterprise/450, SunOS 5.6, Informix 7.30UC5) Greetings All! Has anyone out there encountered this same problem, and figured out a solution? I have a single table with over 10 million records in it. I am trying to retrieve a small number of records from it ba…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
OPTIMIZER DIRECTIVES IN 4GL
Hello. I can use optimizer directives from dbaccess / Query Language, but they don�t work in a 4gl-program. The engine is IDS 7.30.UC2-1 and RDS-4GL is 7.20.UD7 on a SCO OpenServer 5.0.5. Example: select {+INDEX (tablename indexname)} * …
Re: PDQPRIORITY
From: "laurent" <laurent.salvi@libertysurf.fr> > >on informix 7.30 UC9 >i have a problem of pdqpriority. >have you heard about that Could you be a bit less specific, please? ______________________________________________________ Get Your Private, Free Email at http://www.hotmai…
PDQPRIORITY
on informix 7.30 UC9 i have a problem of pdqpriority. have you heard about that -- Laurent Salvi : laurent.salvi@libertysurf.fr…
ODBC and PDQ
I'm hoping one of you can help me. I want to set up ODBC data sources on NT and 95 client machines such that PDQ is set or not set on a per data source basis. For example, I've got data source X and data source Y. Data source X has PDQPRIORITY unset. Data source Y has PDQPRIO…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
moving a database
bsagonda@my-deja.com wrote: > hie guys i have the following setup on may database. > The database is about 13gigs big, the problem is that i have 7 dbspaces > and out of those 7 , three of them are made up of chunks using the > actual physical name including the root dbspace. > …
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
query optimizer (set explain) question
i've run set explain on three different systems (all hpux 10.20 with informix ds 7.3 uc2) the databases in question are the same schema (tables and indexes, same onconfigs, etc.) on each machine (however number of rows in each table varies. I ran set explain on each machine with…
Re: URGENT! How many rows will be returned?
I smell a troll here... Different databases use different technologies for query optimization and some are far better than others. Some 'so-called' optimizers need subtle hints to steer queries while others produce cost estimates based on statistics. Each database on your cros…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
Re: IDS PDQ
From: sfcawley <sfcawley@interaccess.com> > >Is PDQ an option that has to be turned on? Is it an option that would be >recommended for an OLTP application (or is it DSS specific functionality)? > >I would like to ensure optimum performance from my production server and >am not s…
IDS PDQ
Is PDQ an option that has to be turned on? Is it an option that would be recommended for an OLTP application (or is it DSS specific functionality)? I would like to ensure optimum performance from my production server and am not sure if PDQ is appropriate in an OLTP environment.…
PDQ
Is PDQ an option that has to be turned on? Is it an option that would be recommended for an OLTP application (or is it DSS specific functionality)? I would like to ensure optimum performance from my production server and am not sure if PDQ is appropriate in an OLTP environment.…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: Parallel index building
From: Thomas Mieslinger <thomas.mieslinger@germanparcel.de> > >I have a large table fragmented in three dbspaces on three disks. When I >do an create unique index then the iostat tells me the DBMS is reading >just from one disk not from three. > >I'm using Solaris 2.6, IDS 7.31UC…
Re: Parallel index building
Thomas Mieslinger wrote: > > Hi *, > > I have a large table fragmented in three dbspaces on three disks. When I > do an create unique index then the iostat tells me the DBMS is reading > just from one disk not from three. > > I'm using Solaris 2.6, IDS 7.31UC2 and the following D…
Parallel index building
Thomas Mieslinger <thomas.mieslinger@germanparcel.de> writes: > Hi *, > > I have a large table fragmented in three dbspaces on three disks. When I > do an create unique index then the iostat tells me the DBMS is reading > just from one disk not from three. > > I'm using Solaris …
RE: Prepared statement vs Exec sql insert/update/select
> Is there any benefit to preparing and executing sql statements > rather than just having them in an exec sql insert/update/select.... [Bill Raper] In the Informix world, there is a very significant benefit. This is in the fact that the optimizer processes are run only once …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
One HUGE Query - any optimizers?
This is a multi-part message in MIME format. ------=_NextPart_000_0082_01BEF4B3.58C19EC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've developed a program which constructs the following query and then = executes it. INSERT INT…
PDQ
Can anyone offer any rough guidelines for using PDQ? Mainly, what percentage of SHM_VIRT_SIZE should be allocated to DS_TOTAL_MEMORY for DSS? Thanks, Andrew Ford Simplified Telesys 5000 Plaza on the Lake Suite 170 Austin, TX 78746 United States (512) 425-9767…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
RE: Loading into Shared Memory...
Try SET TABLE table-name MEMORY_RESIDENT Needs to be done by user informix, so best to put it into some startup script for the Informix server, unless you only want it on occassion. HTH Vasudev > -----Original Message----- > From: Marshall Turner [SMTP:t-tech@home.com] > Sent:…
Loading into Shared Memory...
No, you don't have explicit control over what is in the shared memory buffers. Informix manages the buffers based on a 'least recently used' (LRU) scheme that keeps in memory data it expects to be used again and flushes what is not. Marshall <anandpa@my-deja.com> wrote in mess…
How to set pdq in a 4gl? (no manual and online manual doesn't come up!)
how to set pdq in a 4gl? (no manual and online manual doesn't come up!)…
Re: How to set pdq in a 4gl? (no manual and online manual
Austin Castro wrote: > > --=====================_31256267==_.ALT > Content-Type: text/plain; charset="us-ascii" > > At 04:52 PM 12/08/1999 -0500, you wrote: > >how to set pdq in a 4gl? (no manual and online manual doesn't come up!) > > > This worked for me , basically I assigne…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
RE: Attempting to set PDQPRIORITY via CLI Client
Doesn't setnet32 allow you to set environment variables? You could then set PDQPRIORITY within it. The problem then is that you would be setting it for that machine as a whole, instead of a single query. You would have to run setnet32 after the query completed to unset PDQPRIO…
RE: Attempting to set PDQPRIORITY via CLI Client
Rick, Thanks for the reply, is $INFORMIXDIR/etc/informix.rc on the PC client? What should this file look like, I don't seem to have it. My INFORMIXDIR on the client is D:\\Program Files\\Informix Thanks, John -----Original Message----- From: Bernstein, Rick [mailto:rbernste@a…
Attempting to set PDQPRIORITY via CLI Client
Hi All, I am attempting run parallel DSS queries utilizing a ODBC/CLI-32 connection to a 7.30 engine (UNIX). I cannot figure out where to specify this other than within the SQL statement. Hence, while utilizing reporting software (Impromptu) on the client, I cannot add the SQL…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
Re: PDQPRIORITY
I agree that update statistics would help you. And definitely you should perform it. Some additions about the error message: If you are using more than one connection to database server, you have to use tlitcp connections (you can't use shared memory connections). So, you have t…
Re: PDQPRIORITY
I want to agree strongly with Krishna - PDQPRIORITY 100 can and does help, but it can NEVER solve serious performance problems, since it may give you another 30% or so, but only at the expense of other concurrent processes. I can almost guarantee you that either some needed inde…
PDQPRIORITY
Hi, We are facing a lot of performance problem in informix 7.3 Application was running fine till we moved from 7.2 to 7.3. Someone suggested set pdqpriority to 100. The application is written in esqlc. The maxpdqpriority is set to 100 in the server. I've set the pdqpriority t…
Re: Help optimizing query (newbie)
Just a quick thought. If you are using transation logging it will be worth will creating the temp table with the no log option so it does not to any transaction logging. Nayan Jain wrote in message <7lapvi$3im$1@news.xmission.com>... > >Hi ! > >Just thought of correcting one thi…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Optimizer question
Hi all, Informix Dynamic Server Version 7.30.UC6 Can someone please tell me if the optimizer takes into account the number of extents for tables when deciding on a query plan? Thanks Steve _______________________________________________________________ Get Free Email and Do …
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Online index usage in one table query
In article <37861A36.3B9B6FAB@bloomberg.net>, kagel@bloomberg.net wrote: ..snipped > To the first > question, if your query is prepared with replaceable parameters the > optimizer does not know at prepare time when it is deciding on a query > plan what the actual values will be…
Informix Server & the Blue Screen of Death
David Henry <henryd@net-gong.com> wrote in message news:7ld2ud$hvn$1@news2.inter.net.il... > I am running (or trying to) version 7.3 on a 2 CPU Intel box with NT4 > service pack 4. > The machine crashes at random times and in random places, even if there is > no database activity…
Re: Help optimizing query (newbie)
Hi ! Just thought of correcting one things here On Mon, 28 Jun 1999, Peter Sloboda wrote: > Frank T. Ramb=F8l wrote: >=20 > > Hi. > > > > I am trying to run the following statements on a rather huge database. > > > > =3D=3D > > begin work; > > set lock mode to wait; > > > > up…
Help optimizing query (newbie)
Hi. I am trying to run the following statements on a rather huge database. == begin work; set lock mode to wait; update tracked_ids set chk_count=-1 where image_id in (select image_id[16,26] from image_ids); delete from image_ids where image_id[16,26] in (select image_id fr…
Re: Indexing
John: The optimizer is a cost based optimizer and the order of items in the query will not matter unless you use optimizer directives. Now if the filter created by "a=? and b=? and c=? is not very selective, and the optimizer estimates that a large number of rows will be returne…
PDQ & WorkGroup Server 7.3 UC5
Does anyone know if PDQ works in Workgroup server? I cant seem to get more than one thread for a query which uses an index that is fragmented over 3 dbspaces. I have read that PDQ will only generate 1 thread on early versions of WG, but thought that this had changed in 7.3. on…
SQL performance
Shaun Campbell wrote: > > I have a query regarding something we have noticed using New Era and > wondered whether it a bug in New Era or is related to the database. > > In New Era we have been preparing SQL Select statements with ? > placeholders so that we could use the same pre…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
7.30UC2 - Subquery uses Autodindex instead of Index
Richard Peterson wrote: > > Hello, > > I have this problem after upgrading a server from 7.20 to 7.30UC2. The > optimizer appears to process subquerys diffrently when the in clause is > used. Rather than using the index on the table used in the subquery it uses > an autoindex ins…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: Informix and multiple instances
> >The OS is HP-UX 11, 64 bit > >The DB is Informix 7.30 FC 6-1 I'd recommend an upgrade to at least 7.30.FC7 or 7.31...there's a nasty shared memory bug that could cause you immense headaches, especially if the system is managing shared memory segments for multiple instances...…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Datablade memory management ?'s
We're using the dmi library and I was needing some info on memory management. For exampe, when using mi_next_row do I need to nuke the MI_ROW * that is returned? If so do I use mi_row_free (MI_ROW * row)? Any help would be appreciated. Thanks, Tim…
Re: Create index very slow
Concerning 7+ hour index build: > > > # Parallel Database Queries (pdq) > > > PDQPRIORITY 0 > > > #MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority > > > MAX_PDQPRIORITY 0 # Maximum allowed pdqpriority [SNIP] The big problem is he seems to be perfor…
Re: INFORMIX and utilization of system resources on HP-UX 10.20
Andrzej, It seems to me that you are using Baan. If that's so, you should check the following: 1. Use multiplexing. It will help a lot. Really. (you need porting set 6.1b.04 or later, check inf_maint6.1 -v) 2. Set LRU_MAX_DIRTY and LRU_MIN_DIRTY to 2 and 1 (Baan sugest those val…
Re: Create index very slow
Mike Segel wrote: > > Aww don't take advice from a clown. Especially this one. > (only if he's drunk can you trust him ;-) > > Seriously, does MAX_PDQPRIORITY follow standard UNIX conventions? > The lower the number, the higher the priority? Or should I give up sniffing > glue? …
Re: Create index very slow
>Aww don't take advice from a clown. Especially this one. >(only if he's drunk can you trust him ;-) I did warn him! :-) >Seriously, does MAX_PDQPRIORITY follow standard UNIX conventions? >The lower the number, the higher the priority? Or should I give up sniffing >glue? Give …
Re: Create index very slow
Aww don't take advice from a clown. Especially this one. (only if he's drunk can you trust him ;-) Seriously, does MAX_PDQPRIORITY follow standard UNIX conventions? The lower the number, the higher the priority? Or should I give up sniffing glue? -Mikey Obnoxio The Clown wrote…
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…
RESIDENT and PDQ
Can anyone explain what resident = 1 means and what the advantage of setting it is ? More performance ??? What effect does the PDQ-Parameters have ? GREETINGS OLAF…
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: Re[2]: PDQ
> 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. Actually, PDQ has everything to d…
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…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Re: Severe Performance Problem - Infomix 7.3 WGS & HPUX 10.20
eric wrote: > > We're in the process of upgrading from Informix 5 to Informix 7.3 Workgroup > Server but are experiencing severe performance problems. Some programs > which used to take 5 hours to complete are now taking 19 hours, on identical > hardware with identical indexing …
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Recommended value for SHMMAX
Can anyone recommend a good value for SHMMAX based on the following: We're on HPUX 10.2 with Informix 7.30 with 784MB memory. The current value of SHMMAX on our platform is 67MB. After I bring Informix up, an ipcs -m shows that there's 3 segments for resident memory for a total…
Informix ODBC on Caldera Open Linux
I am attempting to implement a development system on Linux with with the free SE download from Intraware. Using the Intersolv 3 ODBC drivers. I'm getting the errno# -25567 with says: "Internal communications buffer management error detected. Memory corruption or incorrect use o…
Informix and Microstrategy's DSS Agent
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_01BE5AC0.2D7755EE Content-Type: text/plain; charset="iso-8859-1" Hello all, We are experiencing a problem that maybe s…
Re: anyway to optimize this query?
>query only. Well, then, why not create all possible index combinations? :-) >Obnoxio The Clown wrote: > >> Sometimes it helps to treat a 2 CPU box as a single CPU box. Have you >> tried this? >> >> >PHYSBUFF 32 # Physical log buffer size (Kbytes) >> >LOGBUF…
Re: anyway to optimize this query?
query only. Obnoxio The Clown wrote: > >let's see... > > > >there are 61772773 rows in the table. > > > >The table is indexed on three fields, let's call it f1,f2,f3, it is a > >composite index, the reason I do that is because > >there is also a where clause in the query which…
Re: anyway to optimize this query?
>let's see... > >there are 61772773 rows in the table. > >The table is indexed on three fields, let's call it f1,f2,f3, it is a >composite index, the reason I do that is because >there is also a where clause in the query which uses all three fields as >criterias. > >update satis…
Setting PDQPRIORITY for a Windows client
All, I need to know how to reliably set the PDQPRIORITY environment variable on a client wide basis for a PC client running Informix CLI 2.50.TC2 or Client SDK 2.1. These clients run a Microstrategy DSS Server or DSS Agent client on top of the Informix connectivity to do (hopef…
Re: anyway to optimize this query?
let's see... there are 61772773 rows in the table. The table is indexed on three fields, let's call it f1,f2,f3, it is a composite index, the reason I do that is because there is also a where clause in the query which uses all three fields as criterias. update satistics was p…
Re: anyway to optimize this query?
>hi all: > I have a 16 gig database, each record is contains 50 fields. > I am running a query like this: > > select f1,f2....f15, sum(f40),sum(f41),sum(f42), sumf(43) > group by f1,f2...f15 > > as you see, i have to group about 15 fields and sum 4 other fields >ba…
anyway to optimize this query?
hi all: I have a 16 gig database, each record is contains 50 fields. I am running a query like this: select f1,f2....f15, sum(f40),sum(f41),sum(f42), sumf(43) group by f1,f2...f15 as you see, i have to group about 15 fields and sum 4 other fields based on th…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
Setting PDQ via CLI/ODBC
Can one set the PDQPRIORITY in the Informix CLI drivers (or Setnet 32) such that the priority can be set for a machine that access the database server ??? Thanks Craig Caprpenter CrCarpenter@harland.net…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
composite index question
Yan Zhu wrote: > > hi all: > If I put a composite index on three fields, a,b,c, what kind of > query would this benefit? > > I made a few queries with differenct criterias, and set explain on, > this is what I discovered. > 1. if the criteria is only on a or b or c, i…
Re: Memory Leak
In article <78a8dj$1h7$1@nnrp1.dejanews.com>, joel_anderson@prosolution.com writes >We just installed our first customer with Informix 7.30 TC5 on an NT server. >With only a few users on the system for a few hours, the memory usage on the >Informix server goes from a few meg to o…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Re: Performance degraded after detaching indexes / fragme
Thomas J. Girsch wrote: > Be careful here, Art. On a 4 CPU system, PDQPRIORITY=25 is NOT exactly the > same as PDQPRIORITY=2. All kinds of resources are controlled by > PDQPRIORITY, not just CPUs. More important parameters controlled by PDQ are > memory and total threads. > …
Re: Performance degraded after detaching indexes / fragme
Be careful here, Art. On a 4 CPU system, PDQPRIORITY=25 is NOT exactly the same as PDQPRIORITY=2. All kinds of resources are controlled by PDQPRIORITY, not just CPUs. More important parameters controlled by PDQ are memory and total threads. We have an instance the has only 3 …
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: Flushing Cache
Bryan Hughes wrote: > > Does anyone know a way to flush cache in Online 7.2x short of a) writing a > huge query, and b) cycling the engine? I am trying doing to query > optimization and need to do raw timing of the same query written in > different ways. Shut the engine down an…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Q: PDQPRIORITY - Software Downloads???
Can anyone point me in the direction of software that will allow me to alter the PDQPRIORITY from the client side? Thanks, Shaun. -- _________________…
Re: PDQPRIORITY and POWERPLAY (Impromptu)
In article <01be19ba$619dde20$0b9c8318@irwin.ce.mediaone.net>, "Irwin Goldstein" <irwinNOSPAM@NOSPAMobjectsoft.comNOSPAM> wrote: > Peter Marley <peter.marley@acco-uk-co.uk> wrote in article > <912002145.4116.0.nnrp-04.9e98ba55@news.demon.co.uk>... > > Hello, > > > > has anybody…
Re: PDQPRIORITY and POWERPLAY (Impromptu)
Peter Marley wrote: > has anybody managed to get PowerPlay/Impromptu to take advantage of PDQ > using either the public/private environment variable PDQPRIORITY? > > I can get DBACCESS to work with PDQ without having to use an SQL SET > PDQPRIORITY statement, but when I try using…
Re: PDQPRIORITY and POWERPLAY (Impromptu)
Peter Marley <peter.marley@acco-uk-co.uk> wrote in article <912002145.4116.0.nnrp-04.9e98ba55@news.demon.co.uk>... > Hello, > > has anybody managed to get PowerPlay/Impromptu to take advantage of PDQ > using either the public/private environment variable PDQPRIORITY? > > I can ge…
Re: Problem with Informix 7.3 I need a good Idea very soon
Bundesarchiv wrote: > > E posibile > to mark a table (a priori) as "AVOID_FULL"(scan) ?? > > or (i.e. with UPDATE STATS) "near fullscan disabled" ?? > > (in Informix 7.3) > > I need a good Idea very soon See other posts. Also have you tried OPT_GOAL=0 which can be set in the ap…
Re: Problem with Informix 7.3 I need a good Idea very soon
Hi Klaus, in this case you will have to deal with the different levels of update-statistics, until you get what you want. Try to do "typical" queries after 'set explain on;' in dbaccess and try to figure out, why the optimizer takes a full-table-scan. hth martin Bundesarchiv sch…
Re: PDQPRIORITY and POWERPLAY (Impromptu)
Peter Marley wrote: > > Hello, > > has anybody managed to get PowerPlay/Impromptu to take advantage of PDQ > using either the public/private environment variable PDQPRIORITY? > > I can get DBACCESS to work with PDQ without having to use an SQL SET > PDQPRIORITY statement, but whe…
PDQPRIORITY and POWERPLAY (Impromptu)
Hello, has anybody managed to get PowerPlay/Impromptu to take advantage of PDQ using either the public/private environment variable PDQPRIORITY? I can get DBACCESS to work with PDQ without having to use an SQL SET PDQPRIORITY statement, but when I try using IMPROMPTU the proces…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: POWER MANAGEMENT FAILS AFTER IFMX INSTALL
David Williams wrote: > > In article <364F133C.67A6B386@deistersoft.com>, V.Salvador <nospam_vsalv > ador@deistersoft.com> writes > >On Solaris 2.6, power management daemon (powerd) fails with shmget > >error, after modifying the /etc/system file as the informix release > >notes …
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Re: Indexing speed
In article <3641d25200000001@news.harland.net-MINC>, Barry Leb <bleb@harland.net> writes >What are you temp spaces like? I have found that more smaller temp >spaces vs fewer larger ones improve index build performance. However, >there is a tradeoff There are some Informix oper…
Re: Indexing speed
OK, here is my definitive answer to the fastest possible index builds: PSORT_NPROCS=40 #Yeah I know the manual says >10 is noop, try it PSORT_MAXALLOC=10240 #Undocumented but it makes a big difference PSORT_DBTEMP=/a:/b:/c #Set to AT LEAST 3 FILESYSTEMS w/about same fr…
Re: Indexing speed
A couple of things to try: o Fragment the table to increase the number of scan threads o Turn off KAIO (onconfig setting KAIOFF=1) and increase AIOvps Steve Romankiw Bottoms, Douglas A (Doug) wrote: > We are running Solaris 2.6, Informix online 7.24.UC5. > We have set t…
Re: Indexing speed
What are you temp spaces like? I have found that more smaller temp spaces vs fewer larger ones improve index build performance. However, there is a tradeoff There are some Informix operations that can only use a single temp dbspace.(Unfortunately, I can't recall what they are …
Re: Indexing speed
A couple of suggestions. For one, try playing with different values for PSORT_NPROCS. A value of 2 or 3 usually works pretty well for us. Another, create the indexes in dbspaces other than the one containing the table, preferably on a separate physical disk. That should help…
PDQ questions
Hi all. Some questions about de PQD. I have the above producs: Informix ODS Ver 7.24.UC2-1 Informix I4GL Ver 6.05.UD2 This products are running on some Sun platforms with Solaris 2.4 The questions are: a) The ODS Administration manual (Ver 7.2) say in chapter 18: "On…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Distributions
Stefan Weideneder wrote: > > Jay Aymond wrote: [SNIP other stuff] > Do you think it's a good idea to give the optimizer detailled > informations for columns, if the information will not cause > a better query plan ? Don't you believe that it will slow down > those queries that d…
Re: How to find out way our oninit is slow?
David Williams wrote: > > In article <36125DF0.54B3@netcomuk.co.uk>, Neil Truby > <ntruby@netcomuk.co.uk> writes > >kroy@Celestica.com wrote: [SNIP] What is the apps PDQPRIORITY? What is MAXPDQPRIORITY? It may be that that one app is hogging all available resources. The onsta…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: SET EXPLAIN / SQL
Stefan Weideneder wrote: > > Hi David, > > as Sujit mentioned already, the results of SET EXPLAIN are > available as soon as you prepared your query. > This is not always true, but in most cases. > > If the query contains no question-mark "?", your query will > be optimized at th…
Re: 7.23 UC4 vs. 7.30 UC3
snip... > >> Also, Oyvind, we have experienced the wrong query path being selected by the > >> optimizer is 7.x for some time. We understand that 7.30 allows the user (us) > >> to control the query optimizer more directly. > > > >Yes, we have used this feature to verify that the …
Total memory & used memory in onstat -g ses
The onstat -g ses commands displays total memory and used memory by session. Does anyone know how I can reproduce this display using sysmaster tables? I am trying to determine which host(s) are initiating sessions using larger amounts of memory. This onstat command shows only …
Re: SET EXPLAIN / SQL
I am not sure but you can use Optimizer directives to select adhoc query plan. For more information about optimizer directives, you review the presentation slides about informix performance optimization by Kevin Fennimore on the following URL location (thank you Kevin). Good luck…
Re: Infromix & Data Warehousing Solutions
Doug Johnson wrote: > > Tim, > > Thanks for the info but we're not on the same page. I'm not talking about > the Informix query optimizer (access plan shown by 'explain plan'). There's > tons of info on www.informix.com on that optimizer. I'm talking about the > new MetaCube Ware…
Re: Infromix & Data Warehousing Solutions
Tim, Thanks for the info but we're not on the same page. I'm not talking about the Informix query optimizer (access plan shown by 'explain plan'). There's tons of info on www.informix.com on that optimizer. I'm talking about the new MetaCube Warehouse Optimizer. My understanding…
Re: Controlling PDQ for MS clients over ODBC
This is one of the kind of things you can so easily do with proper ODBC drivers like the one form OpenLink. You might download a free 2 user version from http://www.openlinksw.com to try it out. Then you might tell Informix that such functionality is a basic requirement. On Tue,…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
Controlling PDQ for MS clients over ODBC
Hi, Does anyone know how to configure PDQPRIORITY for ODBC clients (specifically Crystal Reports) running against 7.23 ODS on Solaris? The clients are running either Win 95/NT. I don't want to have a system-wide PDQPRIORITY > 0. Setnet32 doesn't appear to let you do it. I've…
Re: Need help with informix memory management
Matthias Kuespert wrote: > > Hi, > > we encountered a strange problem using Informix on Sun Solaris 2.5.1: > > If we connect to the DB (via E-SQL-C CONNECT statement) we cannot > allocate more than appr. 7 MB with our application. After that > size malloc() returns a NULL pointer…
Need help with informix memory management
Hi, we encountered a strange problem using Informix on Sun Solaris 2.5.1: If we connect to the DB (via E-SQL-C CONNECT statement) we cannot allocate more than appr. 7 MB with our application. After that size malloc() returns a NULL pointer and errno says: not enough space. If …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
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_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: query optimizator
>Something strange happened to me (is not the first time) with >Informix OnLine 7.2 on UnixWare 2.1.1 with dual Pentium 133. >A query that we use frequently, suddendly stopped working. >The query optimizer decided to change something, and the query now >do not use anymore the rig…
People Soft and Informix 7.2
Informix DSA 7.2 Platform: Sun SPARC SunOS 5.5.1 4 CPUs Has anyone found it advantages to turn PDQ on with PeopleSoft version 7.01? TIA Cheryl L. Kendricks Sr. Database Analyst H.E. Butts Grocery San Antonio, Texas…
Re: query optimizator
Marco Traini wrote: > > Something strange happened to me (is not the first time) with > Informix OnLine 7.2 on UnixWare 2.1.1 with dual Pentium 133. > A query that we use frequently, suddendly stopped working. > The query optimizer decided to change something, and the query now >…
query optimizator
Something strange happened to me (is not the first time) with Informix OnLine 7.2 on UnixWare 2.1.1 with dual Pentium 133. A query that we use frequently, suddendly stopped working. The query optimizer decided to change something, and the query now do not use anymore the right in…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Running Informix and Oracle on the same Unix box
Last time we tried to that we ran into tough waters and had to abort. The two engines need different kernel parameters, and they also have memory conflicts. Most importantly, find out if you'll be able to tech support from either one of them in this kind of a situation :-) (more…
Running Informix and Oracle on the same Unix box
Folks -- For various and sundry reasons, we're going to try to run both an Informix instance and an Oracle instance on the same AIX 4.3 box. We'll be running Informix 7.3, and Oracle 7.2.2.3. Are there any gotchas that we should know about? My guess is that the biggest pro…
Connect to Informix 7.2
Hello! I'm attempting to connect to an Informix 7.2 backend. I loaded the INET stuff but my profile generates a -25567 error which translates to: -Internal communications buffer management error detected. -Memory corruption or incorrect use of buffer-management routines usually…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: I can't think of the subject name (have not words).
David Kosenko wrote: > "Art S. Kagel" <kagel@bloomberg.net> offerred: > +> > An annoyed Informix user wrote: > +> Do You see index3 on table1(field1, field2)? There isn't sorting > needed. > +WRONG WRONG WRONG! > +> There isn't table reading needed too. index3 contains all > …
Re: I can't think of the subject name (have not words).
"Art S. Kagel" <kagel@bloomberg.net> offerred: +> > An annoyed Informix user wrote: +> Do You see index3 on table1(field1, field2)? There isn't sorting needed. + +WRONG WRONG WRONG! + +> There isn't table reading needed too. index3 contains all information +> queried and in righ…
Informix PDQ & PeopSoft
We are running peopleSoft Finanacials and Informix Dynamic Server 7.2x. In IDS 7.2x, you can no longer turn on PDQ at the instance level, so we are trying to turn on PDQ at the environment level for our batched reporting jobs. Since all of our PeopleSoft users are untimate…
Re: Data binding
"Art S. Kagel" <kagel@bloomberg.com> offerred: +Yes. Versions before 7.3 resolved the query path at PREPARE time so, +except for an EXECUTE IMMEDIATE (which prepares and executes at the +same time), these two queries MUST be treated differently. Since the +actual value of the…
Informix PDQ & PeoplSoft Financials
I�m an Informix DBA, and we are running PeopSoft Financials 6.x and Informix Dynamic Server 7.2. I would like to turn on Informix�s PDQ feature to speed up some of our nightly batch jobs, but to do so, I need to set the PDQPRIORITY environment variable. Since all of our users…
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: Optimizing a select query
Sujata, Try creating the following index on tab2 (col2, col1). This way it will only need to do an index read. Also run update statistics high (if SQL/Server has the concept). Regards David Ashby ______________________________ Reply Separator _…
Optimizing a select query
Hi everyone, Here is a question for you guys. I am facing a problem with a simple select query running toooo slow. Before I proceed, let me explain that I am facing this problem in SQL Server not in Informix. I know the die-hard Informix fans will say "Well... there is your a…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: Goodbye to compiling and linking. Every Database guy must know this!
What color do you want your database to be? ;) Ping Liu wrote: > Are there any degugging tools available for perl? > > gold_bag@yahoo.com wrote in article <352BCE60.53BF@yahoo.com>... > > I hope this helps the software professionals/managers like you.... > > > > Computer speed…
Re: Goodbye to compiling and linking. Every Database guy must know this!
Are there any degugging tools available for perl? gold_bag@yahoo.com wrote in article <352BCE60.53BF@yahoo.com>... > I hope this helps the software professionals/managers like you.... > > Computer speeds are doubling every 4 months, hence it makes sense to > program in scripting…
Re: "Changing Data structure...."
On 9 Apr 98 at 16:58, Steve Romankiw wrote: > When doing an onstat, we often see "Changing data structure forced...". > What causes this message to display? Is shared memory changing? It's probably something like a new chunk of Virtual Memory being added. HTH. -- Ciao, Bil…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: Optimizing..
In article <6gc0fc$qe1$1@news.xmission.com>, "ABEL ROJAS GARCIA" <abelrg@bital.com.mx> writes: > > Hi, > > What can I do for Optimizing queries? > > > Thanks How about giving an example of query you'd like optimized.…
Re: Optimizing..
Go to the Informix Advanced Development and OnLine Administration classes. They're a definite investment. Either that or do some SERIOUS reading. Vij. ABEL ROJAS GARCIA wrote in message <6gc0fc$qe1$1@news.xmission.com>... > >Hi, > >What can I do for Optimizing queries? > > >Th…
Optimizing..
Hi, What can I do for Optimizing queries? Thanks…
Re[2]: SET PDQPRIORITY error
We were told by Informix that HPUX 11.0-32 bit was only certified on 7.23UC10 or higher. If you are running 64-bit architecture on HPUX 11.0 then only 7.24HC1 is certified for HP systems. At least that is our understanding. We are currently waiting for 7.24…
Re: SET PDQPRIORITY error
In article <6fo8mf$cfc@sjx-ixn1.ix.netcom.com>, Ray Garrison <apsnet@ix.netcom.com> writes >I recently installed 7.23.UC1 on an HP9000 V-class box running >HP/UX 11.0. > >When I issue the SET PDQPRIORITY command, with either a numeric >or symbolic option (SET PDQPRIORITY HIGH or …
SET PDQPRIORITY error
I recently installed 7.23.UC1 on an HP9000 V-class box running HP/UX 11.0. When I issue the SET PDQPRIORITY command, with either a numeric or symbolic option (SET PDQPRIORITY HIGH or SET PDQPRIORITY 100) using low, medium, high, or numberic values from 1 to 100 I get unknown er…
Metacube & PDQ
When a user logs into Metacube several queries are run to verify a valid user and download table and filter definitions. Because of our configuration file PDQPRIORITY setting (90) these queries are considered under the domain of the Memory Grant Manager (MGM). This is ok except…
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: Update statistics of the informix.xxx tables.
>Is the update statistics scenario of the informix.systables alike tables >of a database the same as for the users tables. ? For the most part the access to these tables use a "fixed plan". Since this information is mainly needed by the optimizer to generate the query plan, we …
Re: ??? Opinions on ONCOFIG settings
Barry Leb wrote: > > We are not currently having any performance problems, but I am > interested in hearing some opinions from the experts out here. > > One of our systems is as follows: > > Sun SPARCcenter 2000E, Solaris 2.6, Veritas VM2.4 > 6 SPARCstorage Arrays 100's populated…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: ODBC and PDQPRIORITY
If you are using the OpenLink ODBC drivers you can have the server part of the drivers do anything that can be done via standard or Informix spesific SQL whenever a user connects to the database. Additionally you can define any environement variables that should be set upon such …
ODBC and PDQPRIORITY
Any takers? Essentially is there some method of setting PDQPRIORITY from within something like Business Objects? cheers j.…
Re: PDQPRIORITY HIGH
jparker@epsilon.com wrote: > > The wording in TFM ("use all AVAILABLE resources" pp 38-49 DSA Admin) > suggests that it will give whatever is available. In other words if you > wanted to run at 60 and someone else was already running at 60, your query > would be submitted at 40 …
Re: PDQPRIORITY HIGH
The wording in TFM ("use all AVAILABLE resources" pp 38-49 DSA Admin) suggests that it will give whatever is available. In other words if you wanted to run at 60 and someone else was already running at 60, your query would be submitted at 40 as opposed to being gated. But then …
Re: PDQPRIORITY HIGH
At 08:35 AM 2/24/98 , jparker@epsilon.com wrote: >Just noticed reading TFM that you can set PDQPRIORITY HIGH. According to >TFM this means that the engine will allocate as much as it can to each >query. I've never tried it like this - has anyone else and can they >comment? Isn…
PDQPRIORITY HIGH
Just noticed reading TFM that you can set PDQPRIORITY HIGH. According to TFM this means that the engine will allocate as much as it can to each query. I've never tried it like this - has anyone else and can they comment? cheers j.…
Re: Prepare a Statement that uses a temporary table?
Georg Winkens wrote: > > Is there a way in ESQL/C to prepare a Statement that uses a temporary > table (e.g. "Select * from Temp_Table ...") if this temporary table is > not already created at prepare time? No there is not. The purpose of preparing a statement is to save the co…
Re: Optimizer Info
>Are there any ways to know how the optimizer is evaluating all the >possible query plans and how it decides which one it chooses. > >I know about 'set explain' and data distributions and such, but is there >a way to see the process >the optimizer went through. Basically, no. T…
Optimizer Info
I am running 7.1 on Solaris 2.5 (soon to be upgrading to 7.24). Are there any ways to know how the optimizer is evaluating all the possible query plans and how it decides which one it chooses. I know about 'set explain' and data distributions and such, but is there a way to see…
Re: Query Optimizer
>Help me please! >I need information about algorithm of Query Optimizer. >Informix Engine - OnLine Dynamic Server 7.10 One can write a book on this topic. Basically, the optimizer looks at all possible ways of scanning every table in a query. The cost for each path is calculated…
Query Optimizer
Help me please! I need information about algorithm of Query Optimizer. Informix Engine - OnLine Dynamic Server 7.10 .…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Re: Performance question
In article <01bcf053$bbb14500$57011814@willie>, "Willie L. Meeks" <wmeeks@harrahs.com> writes >I apologize for not sending the onconfig parameters. > >SHMTOTAL 768000 >SHMVIRTSIZE 348000 >DS_TOTAL_MEMORY 614000 >DS_MAX_SCANS 1000 >MAX_PDQPRIORITY 60 >DS_M…
Re: Performance question
I apologize for not sending the onconfig parameters. SHMTOTAL 768000 SHMVIRTSIZE 348000 DS_TOTAL_MEMORY 614000 DS_MAX_SCANS 1000 MAX_PDQPRIORITY 60 DS_MAX_QUERIES 8 OPTCOMPIND 2 Willie L. Meeks <wmeeks@harrahs.com> wrote in article <01bcefc3$7f535480$57011814@willie>... > I ha…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: DELETE does not use index
>Sorry for my stupid question, but what does UPDATE STATISTICS do in detail? No such thing as a stupid question. UPDATE STATSTICS updates information in the database catalogue, such as systables, sysindexes, sysdistributions. Information from these catalogue tables is read by …
Re: Stored Procedures and querries.
From "Incorporating Stored Procedures and Triggers into Your Informix Databases Training Manual" Version 01-95 Page 6-128: When a stored procedure is created all optimization will be attempted at that time. If the tables cannot be examined at compile time (they may not exist o…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <yuten3wab3j.fsf@mew.corp.sgi.com>, Pablo Sanchez <pablo@sgi.com> writes >>>>>> "David" == David Williams <djw@smooth1.demon.co.uk> writes: >David> >David> The latency would be different? > >Sure, the respective lock managers need to deal with >different issues due t…
Re: Running UPDATE STATISTICS on a table being used
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > Since the update statistics was going on parallelly with the query, will the > query use the new plan once the update statistics is over or does it still go > with the old plan ?? The query is just taking for eve…
Informix CLI & NT
Hi, I'm running NT4, IIS3, service pack 3 & Informix CLI 2.5. Service pack 3 upgrades the ODBC manager to v3 but when you Install Informix CLI 2.5 it then downgrades it to a lesser version which in turn breaks all the ASP & ODBC capabilities on the web server. If I re-install …
Re: Performance question
Try increasing the DS_TOTAL_MEMORY to a bigger number , depending on your queries , assign 50 or 100 MB and see the difference. Willie L. Meeks wrote in message <01bcefc3$7f535480$57011814@willie>... >I have a question related to PDQ. Can any one explain to me why when you >run…
Re: Performance question
Willie L. Meeks wrote: > > I have a question related to PDQ. Can any one explain to me why when you > run a query with PDQ enabled it appears that your cpu vp's don't work as > hard. PDQ will only buy you much of anything if you have your data fragmented. Have you taken a look…
Performance question
I have a question related to PDQ. Can any one explain to me why when you run a query with PDQ enabled it appears that your cpu vp's don't work as hard. It appears to me from the results I have observed from my DSS system that if I excute 50 without PDQ enabled the box works har…
Re: Set explain use
>Not considering indexes, does it make any difference to the informix >optimizer > if we switch the order of conditions in a where clause. For example, which >one > is better: > >select * from A where p = q and r = s or >select * from A where r = s and p = q . > >None of p,q,r,…
RE: NewEra 3 Memory leak?
We had the same problem. Fortunately, we have a connection manager class that we can call to connect and disconnect from the database. By doing this, we release the connection and the memory. We tried disconnecting after 3 transactions and found that the average amount of memo…
Re: Online 7.x performance on a single CPU machine
Hmmmm....I would think that PDQPRIORITY wouldn't have much use on unie, assuming it functions according to its definition (as a percentage of maxpdqpriority which is also a percentage of "resources"....). No matter how low PDQPRIORITY is, you'll get about 1 CPU's worth of cycle…
optimizing - sqexplain
Hi, We are developing an application with New Era 2.20 using Online 7.10 (about to upgrade to 7.23). My goal is to optimize the response times and I'm new in that function. The first idea is to search through the access plan for high cost queries, the problem is that I don't kn…
Re: Query Optimizer
Dies ist eine mehrteilige Nachricht im MIME-Format. --------------7BAFAD1E691FD235D6CAD43F Content-Type: text/plain; charset=iso-8859-1 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Transfer-Encoding: 8bit Hello Mauro, but there still exis…
Re: Query Optimizer
Mauro G. Pisano wrote: > > HI all: I recently heard about the possibility of upgrade de query optimizer. > I 've got ON-LINE 5.0 and at Informix Seminary, It was listened taht by > upgradin only the query optimizer, somes exposed queries at the seminary, > had down its times fro…
Query Optimizer
HI all: I recently heard about the possibility of upgrade de query optimizer. I 've got ON-LINE 5.0 and at Informix Seminary, It was listened taht by upgradin only the query optimizer, somes exposed queries at the seminary, had down its times from 30 minutes to seconds. I want …
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
RE: Error with ODBC drivers
Alberto, Believe it or not, simply go to SETNET and redefine everything, it should fix your problem assuming you have configured your communication properly ( the type of connections, server name user and password correctly ) . Regards, Mario Estrada =============Reply Separa…
Error with ODBC drivers
Hi, trying to connect with ODBC drivers to a SE on Windows 95 I get the following error message: -25567 Internal communications buffer management error detected. This error is usually caused by memory corruption or wrong use of buffer management routines. Make sure there is no…
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: First N records in SELECT
Slavik Anosov wrote: > > Does anybody know something in Informix ODS 7.1 that perform functions of > Oracle's ROWNUM pseudo-column? I need to retrieve only first N records in > select. > No, there is no such feature. Assuming that you are using ESQL-C or 4GL you can simply close…
Re: Query Optimization question
Ignatius In version 7.x (not in 5.x) you can do: UPDATE STATISTICS MEDIUM FOR table(column) DISTRIBUTIONS ONLY The MEDIUM will do data sampling whether or not you create an index on the column. The DISTRIBUTIONS ONLY update the sysdistrib table in your database. In case you …
Re: Query Optimization question
On Thu, 10 Jul 1997, Ignatius Cristina Michelle wrote: > Hi. > > What statistical information can Informix draw upon to determine how > many rows will be satisified by a query coondition of the form "column = > value", for example, "department = 'D'" where "department" may or ma…
Query Optimization question
Hi. What statistical information can Informix draw upon to determine how many rows will be satisified by a query coondition of the form "column = value", for example, "department = 'D'" where "department" may or may not be an "indexed" column. Where is this statistical informati…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Set explain utility
>The sqexplain.out file exists immediately after the prepare. >Please, try it again. How can this be? At the PREPARE stage (for any real-life query) crucial information - values to use - are still missing. It is only at OPEN CURSOR when we tell the engine the values, and only t…
Advantages of Dynamic Server 7 over Workgroup Server 7
I understand the main difference between Workgroup Server V7 and On-line Dynamic Server V7 is PDQ. I thought I heard somewhere WGS does not scale above 2 CPU's. Does anyone know of any other reasons for buying ODS over WGS ? Thanks in advance. Steve Gould…
Re: Checkpoint duration increase with 7.22.UC1
In article <5lak28$ssn@cssun.mathcs.emory.edu>, Kernoal Stephens <kernoals@earthlink.net> writes >I recently upgraded from 7.13.UC2 to 7.22.UC1. > >With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds. >I used the same onconfig settings with 7.22.UC1 and my average >che…
Re: Checkpoint duration increase with 7.22.UC1
In article <5kq94e$o4q@cssun.mathcs.emory.edu>, Kernoal Stephens <kernoals@earthlink.net> writes >I recently upgraded from 7.13.UC2 to 7.22.UC1. > >With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds. >I used the same onconfig settings with 7.22.UC1 and my average >che…
Re: HELP !!!!!
In reply to Igor Andjelkovic's email about HELP !!!!!, on 1 May 97 Hi Igor, > I have a two error messages before my 4GL starts up > Actually , it is only one. > tbmode: forced-resident shared memory error > tbmode: shmctl: errno = 1. > > Please if anybody can help me out, k…
Re: DSA follies
> Correct - hold cursor declared with hold are not parallelized... > Several other types 'queries' are not parallelized - can't remember > which... Wow, what a coincidence! I just read a page on this in the Performance Tuning Training manual. Queries NOT parallelized: * Th…
Re: Informix and PDQ
settler@hobbes.dbintellect.com (Jeff Craig) wrote: :}>BTW, just for the record, PDQPRIORITY needs to be set at the SQL level, :}>not at the engine level. I've seen things get quite scary when :}>PDQPRIORITY is set in the ONCONFIG file. :}> :}>Anyone else out there have tidbits?…
Re: Informix and PDQ
}>From ilist@rmy.emory.edu Tue Apr 1 13:47:31 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO) }> for <settler@dbintellect.com> id NAA01683; Tue, 1 Apr 1997 13:47:19 -0700 }>Received: (from ilist@localhost) by rmy.rm…
Re: Informix and PDQ
In article <19970401060701.BAA04436@ladder01.news.aol.com>, satriguy@aol.com (SaTriGuy) wrote: > > Just a comment. > > I'd suggest that anyone that is thinking of starting to turn on PDQ > initially simply set PDQ to 1. This will turn on parallel scanning for > CLIPPED . . . .…
Re: Informix and PDQ
Just a comment. I'd suggest that anyone that is thinking of starting to turn on PDQ initially simply set PDQ to 1. This will turn on parallel scanning for fragmented tables but will not cause programs to gate in the memory manager. In many cases, simply allowing parallel scann…
Informix and PDQ
( still trying to post to Usenet after all these weeks . . .) Hopefully, this message will get through . . . I am the DBA of a small Informix shop in Atlanta, GA. We have been operational under Informix 7.13.UC1 for well over a year. The system appears to be tuned well. I wou…
Re: Setting PDQPRIORITY & OPTIMIZATION from ODBC
stiglich@promarkone.com wrote: : : :Hello, : : Does anyone know if it is possible to set PDQPRIORITY & OPTIMIZATION :from an ODBC connected client? We would like to be able to set these to :different levels for different applications : :Thanks : :Pete Anything that can be done…
Re: Setting PDQPRIORITY & OPTIMIZATION from ODBC
stiglich@promarkone.com wrote in article <858960956.32100@dejanews.com>... > Does anyone know if it is possible to set PDQPRIORITY & OPTIMIZATION > from an ODBC connected client? We would like to be able to set these to > different levels for different applications You should …
Setting PDQPRIORITY & OPTIMIZATION from ODBC
Hello, Does anyone know if it is possible to set PDQPRIORITY & OPTIMIZATION from an ODBC connected client? We would like to be able to set these to different levels for different applications Thanks Pete -------------------==== Posted via Deja News ====---------------------…
Re: On-Line 7 Performance
In article <3319777C.564D@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Rudy Fernandes wrote: >> >> In article <331606A3.1EAB@iap.net.au>, >> Andrew Mercer <amercer@iap.net.au> wrote: >> >We too are having performance problems similar to other postings in this >>…
Re: On-Line 7 Performance
Rudy Fernandes wrote: > > In article <331606A3.1EAB@iap.net.au>, > Andrew Mercer <amercer@iap.net.au> wrote: > >We too are having performance problems similar to other postings in this > >newsgroup. I suppose it is the nature of newsgroups that only problems > >are posted, but…
Access to Optimizer results
We are using version 7.2 on HP-UX 10.10, and would like to know if there is any way to access to "cost" (from the optimizer) of a query while the query is executing without having the explain plan written out to a dataset. We are trying to develop a quey govenor that can be used…
Re: understanding On-Line's Optimizer
Steve Romankiw wrote: > > I am new the Informix On-Line engine. I am looking for information on > On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from > SQLBase and the optimizers work differently. In informix, we often get > sequential scans on queries that w…
Re: understanding On-Line's Optimizer
At 10:05 AM 19-12-96 -0500, you wrote: >I am new the Informix On-Line engine. I am looking for information on >On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from >SQLBase and the optimizers work differently. In informix, we often get >sequential scans on que…
Re: understanding On-Line's Optimizer
sromankiw@execrisk.com (Steve Romankiw) wrote: :I am new the Informix On-Line engine. I am looking for information on :On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from :SQLBase and the optimizers work differently. In informix, we often get :sequential sca…
Re: understanding On-Line's Optimizer
On 19 Dec 96 at 10:05, Steve Romankiw wrote: > I am new the Informix On-Line engine. I am looking for information on > On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from > SQLBase and the optimizers work differently. In informix, we often get > sequential s…
understanding On-Line's Optimizer
I am new the Informix On-Line engine. I am looking for information on On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from SQLBase and the optimizers work differently. In informix, we often get sequential scans on queries that we feel should be using an index.…
Re: I-CONNECT & Business Objects
I don't know of a way to do this with I-CONNECT. You can, however, use Business Objects with Informix through an ODBC driver. With OpenLink, the performance is better than I-NET used to be (I don't know about I-CONNECT) and you can specifiy a PDQPRIORITY using the sessions rule…
I-CONNECT & Business Objects
Does anyone know how to set PDQPRIORITY when running Business Objects through I-Connect to a database on a UNIX server? Business Objects is running on a Windows 95 platform, connecting through I-Connect 7.20.TD1 Runtime, hitting an Informix 7.20.UC2 database on a Silicon Graph…
Re: Online V7 and Parallel Queries
> > Is it true that PDQ, parallel queries in OnLine V7.x will use both > primary chunks and mirror chunks to retrieve data concurrently when > performing a query expected to return large volumes of data??? > It is true Michael Strother…
Re: PDQPRIORITY
At 11:55 PM 11/18/96 GMT, Kurt Mehlhoff wrote: }Can someone enlighten me about the use and meaning of this variable? } }Thanks, } }Kurt Mehlhoff }Information Advantage, Inc. }Kurt.Mehlhoff@infoadvan.com I hate to say it kurt, but RTFM!…
Re: PDQPRIORITY
Kurt Mehlhoff wrote: > > Can someone enlighten me about the use and meaning of this variable? > To give the short answer, it is used in versions 7 and up to control parallel searches from the database PDQPRIORITY = 0 - serial searches only PDQPRIORITY = 1 - parallel threads only…
PDQPRIORITY
Can someone enlighten me about the use and meaning of this variable? Thanks, Kurt Mehlhoff Information Advantage, Inc. Kurt.Mehlhoff@infoadvan.com…
Re: Informix 7.13 "eating" memory
In article <32844747.22509345@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes > >What I know is, that Informix has two different memory management >routines in the OnLine Server. The one which manages the virtual >portion ( 8KB blocks ) and another one for…
Re[2]: Multiple Residency / Multiple Processors
Thanks Kate, that gives me a starting point. Some others have expressed interest in what I find, so I'll post my results in a couple of months. ______________________________ Reply Separator _________________________________ Subject: Re: Multiple Residency / Mult…
Re: Multiple Residency / Multiple Processors
Each server sees the CPUs separate from the other configs, SO you can make all three environments (3) CPU machines. PDQ is a separate issue. You may want to turn off PDQ on the large machine, and turn it on for the other two, since PDQ jobs always have a lower priority than non…
Re: update stats resolution
Manoj Shroff wrote: > > Hi All, > > Does anyone have any guide lines for the use of the > resolution clause in "update statistics" ? Hi All, data distribution is an additional overhead for the optimizer. Therefore you should try to avoid data distributions whereever pos…
Re: Informix 7.13 "eating" memory
Paul Leskinen wrote: > > I was hoping that someone out there has encountered this problem: > > We have an online transaction-processing application that stays resident > and processes financial transactions using Informix. The problem is that > Informix Online keeps allocating m…
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: Optimize A Simple Query -- Help
Chao Y. Din wrote: > > I have a simple select count statement that takes three minutes to > execute, yet I only have about 300,0000 rows. Here is the SQL. > > SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND col1 = 2010 > > Is it possible to force the query to …
Re: Optimize A Simple Query -- Help
Chao Y. Din wrote: > > I have a simple select count statement that takes three minutes to > execute, yet I only have about 300,0000 rows. Here is the SQL. > > SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND col1 = 2010 > AND col2 = 10; > [SNIP] > Is it possible…
Re: Optimize A Simple Query -- Help
At 08:29 AM 9/16/96 -0400, you wrote: }I have a simple select count statement that takes three minutes to }execute, yet I only have about 300,0000 rows. Here is the SQL. } } SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND col1 = 2010 }AND col2 = 10; } }The "key" field …
Re: Optimize A Simple Query -- Help
tvarnas@compulink.gr (Apostolos Varnas) wrote: :Chao Y. Din wrote: :} :} I have a simple select count statement that takes three minutes to :} execute, yet I only have about 300,0000 rows. Here is the SQL. :} :} SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND …
RE: Optimize A Simple Query -- Help
Chao Try creating an index on table (col1, col2, key). This should make the = optimizer utilize the index path. Also since col1 and col2 are highly = duplicate values, this will give the index some degree of uniquenss so = the optimizer finds it worth giving the new index a try.…
Re: Optimize A Simple Query -- Help
Chao Y. Din wrote: } } I have a simple select count statement that takes three minutes to } execute, yet I only have about 300,0000 rows. Here is the SQL. } } SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND col1 = 2010 } AND col2 = 10; } } The "key" field is th…
Re: Optimize A Simple Query -- Help
Chao - have you tried "update statistics medium..." or high...? That might induce the optimizer to choose the more discriminating index. If you're running "low", the optimizer is flying pretty blind when it comes to data distributions. Greg Chao Y. Din wrote: > > I have a s…
Optimize A Simple Query -- Help
I have a simple select count statement that takes three minutes to execute, yet I only have about 300,0000 rows. Here is the SQL. SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND col1 = 2010 AND col2 = 10; The "key" field is the primary key with data type char(11). …
Re: Update Statistics Low, Medium & High
billy@west.co.za (Billy Wheeler) wrote: :> >In our system, we discover sometimes some tables in index searching is much :> >faster while we update their statistics low or medium instead of high. :> I heard a discussion the other day which indicated that when you update :> stati…
Re: Update Statistics Low, Medium & High
Clem Akins wrote: > > >In our system, we discover sometimes some tables in index searching is much > >faster while we update their statistics low or medium instead of high. > > > >We have an idea that update all tables high statistics with reference to the > >server admin. guide.…
Re: PDQ on 7.12
: }From: barryleb@atl.mindspring.com[SMTP:barryleb@atl.mindspring.com] : }Sent: Wednesday, August 07, 1996 3:20 PM : }To: informix-list@rmy.emory.edu : }Subject: Re: PDQ on 7.12 : } : }TASHKOP@kiwi.co.nz (Peter Tashkoff) wrote: : } : }>Morning all : }>We are considering enabl…
Re: PDQ on 7.12
>} >We are running 712UC2, on a dual proc. HP model K w/512MB RAM. What a >nightmare. PDQ is useless, and OPTCOMPIND is turned off. If we edit a >table structure while someone is in the table, we crash the database, How can you do this when someone is in the table, it should …
RE: PDQ on 7.12
}---------- }From: barryleb@atl.mindspring.com[SMTP:barryleb@atl.mindspring.com] }Sent: Wednesday, August 07, 1996 3:20 PM }To: informix-list@rmy.emory.edu }Subject: Re: PDQ on 7.12 } }TASHKOP@kiwi.co.nz (Peter Tashkoff) wrote: } }>Morning all }>We are considering enabling PD…
Re: PDQ on 7.12
TASHKOP@kiwi.co.nz (Peter Tashkoff) wrote: >Morning all >We are considering enabling PDQ on DSA >7.12/Solaris 2.4. >We had previously disabled this facility due to the >bug in 7.10 where it didn't handle the lower level >threads. >So... we are seeking comfort from people that mi…
PDQ on 7.12
Morning all We are considering enabling PDQ on DSA 7.12/Solaris 2.4. We had previously disabled this facility due to the bug in 7.10 where it didn't handle the lower level threads. So... we are seeking comfort from people that might already be running PDQ enabled over 7.12 or lat…
Re: Priorities in Online?
Dan Jatnieks wrote: > > I thought you must have a multiprocessor machine in order > to use PDQPRIORITY. Is that nor true?? > > No, it isn't. Informix like most if not all software cannot discern how many processors are physically in the machine. YOU have to TELL it in the ONCON…
Re: Priorities in Online?
I thought you must have a multiprocessor machine in order to use PDQPRIORITY. Is that nor true?? In article <jAzqDMAanwvxEwhr@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: >In article <148.100696@deckard.hb.north.de>, Patrick Preuss ><ppr@deckard.hb.nor…
Re: Priorities in Online?
In article <148.100696@deckard.hb.north.de>, Patrick Preuss <ppr@deckard.hb.north.de> writes > >Hi, > >is there any way to prioritize a SQL-request? We have a C/S-environment >with Windows-clients and an Online 7.12 server, running OLTP and >reporting-queries in parallel. It woul…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: 2 or 4 cpu's running Informix OnLine 7.xx
greg, > > Run 2 cpuvp's, multiprocessor yes , singlecpuvp=no, pdqpriority=100, maxpdqpriority=100 > you'll like it. cranks big time. I don't know what Informix was thinking. *although* pdqpriority=100 will lock out any other pdq users until the current query finishes. so i…
Re: Blobs n ESQL/C for Windows
In article <4l6oi7$c20@news2.delphi.com> TYNEELY@news.delphi.com (TYNEELY@DELPHI.COM) writes: >cse@wetware.com (Scott Ellard) writes: > >>In article <4l2l2j$s5m@news2.delphi.com> TYNEELY@news.delphi.com (TYNEELY@DELPHI.COM) writes: >>>I have a WFW 3.11 app that read/writes BLOBS …
Drastic Reduction in transaction logging
Greetings, We have Online 7.12 UC1 currently, we started up on 7.10 about 6 months ago. We are logging our transactions using ontape -c. When we first started the database in production we were writing as many as 100 logs a day. We had to regularly change the 4mm tape we were …
PDQ on 7.10 single processor engine - FYI
In my zeal to set up PDQ on my single proccess cpu machine to prepare for my multiple processor machine (yeah I got more then one machine to support) in a UNIX AIX 4.1.3 environment. I set the configuration values for PDQ even though I identified to the engine via the MULTIPROCE…
PDQ parameters in OnLine 7.11
Has anybody any experience with using PDQ in OnLine 7.11? I heard that sometimes they can give error -208 when running SQL queries. Moreover, on my platform (ICL Sparc server) the PDQ parameters put through "onmonitor" are incorrectly written in the $ONCONFIG file eg. the value …
Re: realloc equivalent in C++
se4pm@dmu.ac.uk (Piers Myers) wrote: >In article <311BDA8A.1462@ctp.com>, Ian Flint (iflin@ctp.com) writes: >> Honbo Zhou wrote: >> > >> > Is there anything in C++ equvalent to realloc in C which can be used >> > to increase allocated memory? Can't find this even in C++ books wh…
Re: realloc equivalent in C++
In article <4fgir1$pri@theory.tc.cornell.edu>, Honbo Zhou <hzhou@r26n05.tc.cornell.edu> wrote: >Is there anything in C++ equvalent to realloc in C which can be used >to increase allocated memory? Can't find this even in C++ books which >talk about memory management specifically. …
Re: realloc equivalent in C++
In article <311BDA8A.1462@ctp.com>, Ian Flint (iflin@ctp.com) writes: > Honbo Zhou wrote: > > > > Is there anything in C++ equvalent to realloc in C which can be used > > to increase allocated memory? Can't find this even in C++ books which > > talk about memory management specif…
Re: realloc equivalent in C++
In article <4fgir1$pri@theory.tc.cornell.edu> hzhou@r26n05.tc.cornell.edu (Honbo Zhou) writes: Is there anything in C++ equvalent to realloc in C which can be used to increase allocated memory? Can't find this even in C++ books which talk about memory management specifi…
Re: realloc equivalent in C++
hzhou@r26n05.tc.cornell.edu (Honbo Zhou) wrote: >Is there anything in C++ equvalent to realloc in C which can be used >to increase allocated memory? Can't find this even in C++ books which >talk about memory management specifically. Thanks. Honbo If you "malloc" in C++, you can …
Re: realloc equivalent in C++
Honbo Zhou wrote: > > Is there anything in C++ equvalent to realloc in C which can be used > to increase allocated memory? Can't find this even in C++ books which > talk about memory management specifically. Thanks. Honbo Yes. realloc. - Ian Flint…
realloc equivalent in C++
Is there anything in C++ equvalent to realloc in C which can be used to increase allocated memory? Can't find this even in C++ books which talk about memory management specifically. Thanks. Honbo…
Problem using PDQ with Online 7.1
Has anyone had any problems using PDQ and Online 7.1, especially with regard to the PDQ PRIORITY variable being ignored. i.e. all queries passing through the memory grant manager. Thanks in advance Brian Davies Lintel Software Consultancy Ltd, Chester, England.…
Set Explain with SP's
In attempting to determine how the optimizer is processing queries in stored procedures, we've tried turning 'set explain on' within a procedure. However, when executing the procedure, I get an empty file. Is there anything special which needs to be done, to get set explain outp…
Re: EXPLAIN result diff. in TEST and REALITY
: In our TEST DB the result of a joined query and SET EXPLAIN is INDEX PATH : for the two tables. On our REAL enviroment this result is for one table : is SEQUENTIAL SCAN, and for the other one is INDEX PATH. Is this normal ?? : The query is awful slow, maybe thatsway ?? Hi, am…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Distributed Join
>I remain very sceptical. To optimize a join across multiple vendor databases >requires that your 'joining' product must fully familiar with all >the individual optimizers in each database to understand how they will process >their portion of the query. Next it must be familiar…
filemakerpro & images??? If not what???
How well does filemaker pro handle records that include a image? I know that each file is limited to 32 megs. Since scans tend to hog memory it seems to me that this memory constraint would be a problem. I work for a company that has a library of about 5000 images that we would l…
about INDEX
Good day people, somebody could tell me which is the use of INDEX and one example. I think that with INDEX, I can to optimize my querys in 4gl, thanks in advanced. Atte. German Velazquez…
7.1 - Unable to free unused shared memory
If anyone has struck and/or resolved the following problem then any advice that could be offered would be appreciated. Environment: Sparc1000 running 7.1 DSA. 512 Meg Ram. Not a dedicated Informix Server. Problem1: When physical ram (as opposed to swap) gets down to near zer…
Online/Optical
Hello, I'm running into some problems while configuring Online/Optical Version 5.0. It is running in conjunction with Plexus Storage Manager and a SONY jukebox. When I attempt to load a TEXT column into the optical storage I always get the following: 600: Cannot create blob.…
Re: Query Optimising Problem !!
Optimizing a query can be very quick once you type set explain on and then run your query. The output will tell you how the optimizer has decided to process your request: it will show you what indexes it uses, what filters and when it is doing a sequential read. It can be su…
Re: Query Optimizing Problem !!
In article <3i16po$c1s@raffles.technet.sg>, Alan Chen <sgs@technet.sg> wrote: >I have never done any query optimization practise in Informix Online >before, can anyone provide me some pointers ?? Any good reference book ?? >Any idea will be appreciated. > >Thanks in Advance. > >A…
Re: Optimizing Many-Table Joins
mmueller@calvin.bellahs.com (Michael Mueller RD) writes: >Can anyone tell me the tactics that the query optimizer uses for >optimizing joins, especially queries joining a large number (e.g. >4) >of tables? What is the max number of tables allowed in a query? >How does this comp…
Optimizing Many-Table Joins
Can anyone tell me the tactics that the query optimizer uses for optimizing joins, especially queries joining a large number (e.g. >4) of tables? What is the max number of tables allowed in a query? How does this compare to Sybase's handling? Thanks! --Michael mmueller@bella…
RE: Optimize Query for slow responce
> 26-Oct-1994 > >I can not understand the Informix Query Optimizer ! >--------------------------------------------------- > > >I have a fine large table and I create a query, where I select all fields from >the table. To lookup the records I have an unique index on a field…
Re: Optimize Query for slow responce
In article <38lia4$97d@emory.mathcs.emory.edu>, pp@q8.dk (Poul Pedersen) says: > > 26-Oct-1994 > >I can not understand the Informix Query Optimizer ! >--------------------------------------------------- > > >I have a …
Re: Optimize Query for slow responce
In article <38lia4$97d@emory.mathcs.emory.edu>, pp@q8.dk (Poul Pedersen) writes: |> Now look at the Optimizer Query Plan: |> |> |> QUERY: (LOW) |> ------ |> select * from ks_gdkonto |> where gd_kontonr = "0003573508" |> and gd_prod_kode < 90000 |> |> |> Estimated Cost: 2 |> Es…
RE: Optimize Query for slow responce
} 26-Oct-1994 } }I can not understand the Informix Query Optimizer ! }--------------------------------------------------- } } }I have a fine large table and I create a query, where I select all fields from }the table. To lookup the records I have an unique index on a field…
Optimize Query for slow responce
26-Oct-1994 I can not understand the Informix Query Optimizer ! --------------------------------------------------- I have a fine large table and I create a query, where I select all fields from the table. To lookup the records I have an unique index on a field called '…
I-NET problem
I have some connecting questions for use of INFORMIX-NET and Powerviewer using TCP/IP. Will FTP's OnNet 1.1 PC/TCP work with INET-PC? If not, are there any '100% dll' or VxD TCP/IP packages supported for connection to INFORMIX on UNIX? -my concern here is memory management ...u…
Re: Optimem Error
paulw@dev.jcdc.eta.gov wrote: : According to the people we talked to at Informix, the invalid memory : pointer error is a known bug. We get it after we execute a PIF file to : run some DOS commands we need. Do you have details of the bug?? Such as bug number, patch/fix, and a …
Optimem Error
One of my friend recently ran into the following error while using 4GL/Win. The message he got was: Invalid memory pool passed to Optimem Library After pressing the OK button a few times, Windows hung, and the application have to be exit(ed) abnormally. He has also encountere…
Re: Query Optimizer
In article <dennisp.762623729@puma>, Dennis Pimple <dennisp@informix.com> wrote: >root@perk.jpr.com (Joseph A. Miele) writes: > > >>The following two queries QUERY 1 and QUERY 2 are the output of SET EXPLAIN >>ON. I do not understand why the query optimizer does a sequential sca…
Re: Query Optimizer
root@perk.jpr.com (Joseph A. Miele) writes: >The following two queries QUERY 1 and QUERY 2 are the output of SET EXPLAIN >ON. I do not understand why the query optimizer does a sequential scan on >root.alujobsh in QUERY 2. The only difference in the two queries are these >lines…
Query Optimizer
The following two queries QUERY 1 and QUERY 2 are the output of SET EXPLAIN ON. I do not understand why the query optimizer does a sequential scan on root.alujobsh in QUERY 2. The only difference in the two queries are these lines: QUERY 1: atkliquh.inv_num = '12316' and QUER…
Re: Optimizing queries info
Greg Sheppard (imop%uspfo.wa-ngnet.army.mil@wa-ngnet.army.mil) wrote: : We've recently written a couple of reports which take FOREVER (hours) : to run...and are getting very interested in streamlineing our queries : for speed and efficiency. Is there a book or useful info on ho…
Re: Optimizing queries info
}From: bt@irl3b2c.att.com }Date: Thu Dec 16 9:15:34 GMT 1993 }Subject: Optimizing queries info }X-Informix-List-Id: <list.3228> } }Greg Shepard wrote } }> We've recently written a couple of reports which take }>FOREVER (hours) to run...and are getting very interested in streamlin…
Re: Optimizing queries info
Greg, The best way to speed up queries is temp tables. If you use set explain on you might find informix is creating its own temp tables but not making good choices. You know you data better that the engine so you should be able to build better (smaller) temp tables. -- Greg …
Query Optimizer or Lack Thereof
Yet another example of a slooooooow query. This does get frustrating because there are too many times that a perfectly good query has to be split into parts (ie. temp tables) in order to get some decent access time. In the query described below, Does anybody have a clue as to …
Re: Optimizing queries info
> > > } > }I suggest that Jonathan Leffler's book - "Using Informix-Sql" [ISBN > }0-201-51240-8] is *required* reading if you want to do anything with isql. > > Thank you very much. > Well deserved I might add (the compliment - not the thanks). j. _____________________________…
Re: Optimizing queries info
}From: bt@irl3b2c.att.com }Date: Thu Dec 16 9:15:34 GMT 1993 }Subject: Optimizing queries info }X-Informix-List-Id: <list.3228> } }Greg Shepard wrote } }> We've recently written a couple of reports which take }>FOREVER (hours) to run...and are getting very interested in streamlin…
Re: Optimizing queries info
Greg Sheppard (imop%uspfo.wa-ngnet.army.mil@wa-ngnet.army.mil) wrote: : We've recently written a couple of reports which take FOREVER (hours) : to run...and are getting very interested in streamlineing our queries : for speed and efficiency. Is there a book or useful info on ho…
Optimizing queries info
Greg Shepard wrote > We've recently written a couple of reports which take >FOREVER (hours) to run...and are getting very interested in streamlineing >our queries for speed and efficiency. Is there a book or useful info on >how best to get the quickest results with queries using…
Optimizing queries info
We've recently written a couple of reports which take FOREVER (hours) to run...and are getting very interested in streamlineing our queries for speed and efficiency. Is there a book or useful info on how best to get the quickest results with queries using iSQL? Or is it just a…
On-line engine startup failure
Is the machine a sparc running sunos 4.1.2? If so, then you need to force shared memory to be resident. Took me ages to work that one out :-) ----------------------------------------------------------------------------- Steve Lacey, IS Engineering Manager, The Bishop's Manor,…
Re: Query Optimiser
John B writes: |Has anyone noticed the 5.X optimizer making bad choices when |choosing a query plan? choosing a query plan? In my case the |optimizer insists in performing a sequential read of a detail table |ignoring the unique index used to join to the master. Performance, …
Query optimizer in 5.01 Informix
Has anyone noticed the 5.X optimizer making bad choices when choosing a query plan? In my case the optimizer insists in performing a sequential read of a detail table ignoring the unique index used to join to the master. Performance, as you can imagine is very, very poor. Infor…
Informix query optimizer info please
I am looking for detailed information on how the Informix query optimizer operates (i.e. makes its decisions, what it looks for, good tips on how to formulate tricky queries, etc.) I have a reasonable amount of experience in the land of Sybase, but I'm new to Informix. After I …
Re: SQL query
Bob Baskett writes: |netters, |can someone explain why the optimizer doesnt short circuit on the |following query: | QUERY: | ------ | select * | from book_bill_back | where 1=2 | Estimated Cost: 370832 | Estimated # of Rows…
False queries and optimizer
Is there any way to slip fake queries past the online5 optimizer? E.g., select * from foo where field1=42 works fine, uses the index on field1, while select * from foo where 1=0 or field1=42 has the optimzer doing a sequential scan on all of foo... (As for "why do I care", I…
Informix Online 5.0 Query Optimizer
We have a problem concerning Informix Online 5.0 query optimization. Informix seems to be choosing extremely inefficient paths for no apparent reason. The part_ref table originally had only one index, a composite of partnumber and option. When a query was performed that joined …
Re: Indexing strategy
1rk2ciINNrhr@emory.mathcs.emory.edu writes: >: Stuff deleted.. >: If you define the unique 3-part index before the >: non-unique 2-part index, the query optimizer may already be using the 3-part >: index (so I have heard), since the optimizer finds the 3-part index first, >: an…
Re: re:choosing idx to use
Ann Barnes@letterkenn-emh1.army.mil writes: |> |> When you create a composite index, the first field is also, effectively an |> index of its own. This was mentioned in the query optimization article here |> yesterday, but perhaps not specifically stated. Actually we have found i…
Re: Query Optimism
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Re: Query Optimism %VERIFY y %DATE 29/03/93 16:30 %REFERENCE 17053 Organization: Informix Software, Inc. Re: >In article <billd.733006990@cheetah…
Re: Help: SQL query optimizer
In article <billd.733006990@cheetah>, billd@informix.com (William Daul) writes: |> |> From: Spring 1987 TechNotes |> |> Query Optimization |> ================== |> Uh, Bill? This article is on the Rule-Based optimizer, which we have not used since 1989 (the 4.0 release of p…
Re: Help: SQL query optimizer
Anique Van der Vlugt (anique@sun-4.cs.uct.ac.za) wrote: : : Hi : : I am presently involved in a project for a SQL query optimizer for INFORMIX. : Has anyone done any research in this field or knows of anyone who does? I : am also interested in any articles related to the field o…
Re: Help: SQL query optimizer
In <anique.732967452@sun-4> anique@sun-4.cs.uct.ac.za (Anique Van der Vlugt) writes: >I am presently involved in a project for a SQL query optimizer for INFORMIX. >Has anyone done any research in this field or knows of anyone who does? I >am also interested in any articles rela…
Help: SQL query optimizer
Hi I am presently involved in a project for a SQL query optimizer for INFORMIX. Has anyone done any research in this field or knows of anyone who does? I am also interested in any articles related to the field of query optimization. If you can help me in any way please email m…
Re: Two index query optimization problem
Devin Wala writes: > > >I'm having some problems with Informix over optimizing my query. >I have a table with > 500000 rows and I can't get Informix to >use what I deem to be the "correct" index. > >There are two indexes on the table: > > index1: unique index on A, B; > index…
Re: Two index query optimization problem
> I'm having some problems with Informix over optimizing my query. > I have a table with > 500000 rows and I can't get Informix to > use what I deem to be the "correct" index. > > There are two indexes on the table: > > index1: unique index on A, B; > index2: unique index o…
Two index query optimization problem (fwd)
} I'm having some problems with Informix over optimizing my query. } I have a table with > 500000 rows and I can't get Informix to } use what I deem to be the "correct" index. } } There are two indexes on the table: } } index1: unique index on A, B; } index2: unique index o…
Re: Two index query optimization problem
In article <1992Dec12.000653.7004@anasaz> devin@anasaz (Devin Wala) writes: > > >There are two indexes on the table: > > index1: unique index on A, B; > index2: unique index on C, D, A, B; > >The problem I'm having is that I can't run a query with A and B mentioned >in the WH…
Two index query optimization problem
I'm having some problems with Informix over optimizing my query. I have a table with > 500000 rows and I can't get Informix to use what I deem to be the "correct" index. There are two indexes on the table: index1: unique index on A, B; index2: unique index on C, D, A, B; …
Re: How to setup Datalink under Windows
In <MTan.43@uci.edu> MTan@uci.edu (Mary Tan) writes: > Anyone out there using Datalink 1.1, I-NET driver version 1.01 and >Windows? > Have you got thrown out to the c:\\> after selecting LOG ON in the It took me quite a while to get the DOS Wingz working after finding t…
Macintosh memory management
The external functions that I'm loading require more memory than is available from the stack ( usaully limited to about 2-4 K, with an absolute max of 16k). I'm using MPW C on a Mac IIci with 16M, Wingz ver 1.1, Finder 6.0.5, Multi Finder 6.1b9 There is no relevant documemtaion…
Re: QUERY Optimizer
> Hi netters > > I have observed that the optimizer (SQL 4.0 and an On-Line 4.0 DB) is > very often guessing wrong, even if we run update statistics. > > The estimated number of rows returned does very much depend on the > sequence in which you enter the SELECT statement. In one …
QUERY Optimizer
Christian Hansen write: >I have observed that the optimizer (SQL 4.0 and an On-Line 4.0 DB) is >very often guessing wrong, even if we run update statistics. > >The estimated number of rows returned does very much depend on the >sequence in which you enter the SELECT statement. …
QUERY Optimizer
Hi netters I have observed that the optimizer (SQL 4.0 and an On-Line 4.0 DB) is very often guessing wrong, even if we run update statistics. The estimated number of rows returned does very much depend on the sequence in which you enter the SELECT statement. In one case we had …
query optimization
jmn@pdx.csd.mot.com (Jim Nielsen) write : >Can anyone tell me where I might find some definitive information on >how to optimize wildcard searches. > >I have a table which contains 300,000 records and I need to look up >records based on 6 possible fields. Some of the fields can…
Query Optimizer
What follows are some excerts from my previous posting and an update: > > In running the query described below on my OLD version 2.10.03K performance > was completely acceptable. On version 4.0, ouch!!!! Queries that took seconds > were now taking lots........ of minutes like 15…
Re: Update Statistics
> > Does anyone have a recommendation on how often the update statistics > command should be run? 'update statistics' only updates the system catalogs with the correct number of rows and the 'next-to-highest' and 'next-to-lowest' values so that the optimizer can make an educated…
(no subject)
rhlab!kuhn@uunet.uu.net writes: > In running the query described below on my OLD version performance was > completely acceptable. On version 4.0, ouch!!!! Queries that took seconds > were now taking lots........ of minutes like 15,20,25 minutes. > > After sending tech support a s…