Oninit® Archive
Results for “STMT_CACHE_QUERY_PLAN”
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 ------------------------------…
SQL query cost is very high
Query plan would be useful On 11/2/2023 4:06 AM, Indika Jinadasa via IBM TechXchange Community wrote: 0100018b8f4925bb-37054389-e021-4f73-91b4-f0b956ba7f90-000000@email.amazonses.com"> Dear Friends, We are using IDS 14X and the below SQL query is taking hig…
%Cached using onstat -p vs %Cached using onstat -g buf
I am on Informix 11.70, and I am grabbing metrics to record. One of them is the buffer write% for each server. When running onstat -p , it shows the %cached as 90.60 . However when actually calculating the %cached, it yields 80.20. The 80.20 value aligns with the value from onsta…
Informix 14 - ALTER JOIN -
yes, thats the problem... statistics and execution plan are the same.... the issues is becouse just queries with OUTER JOIN are slower.... others are faster sorry , did a mistake writing the title... is OUTER JOIN not ALTER JOIN ------------------------------ Miguel Carbone ----…
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…
Join Char and Serial
Using the functional index, if you construct your query similar to the following: SELECT s.serial_col , c.char_col FROM table_serial AS s INNER JOIN table_char AS c ON fn_to_char( s.serial_col ) = c.char_col ; Do you get a better access plan ( I did a simple test on my ma…
Fri May 24 08:27:36 CEST 2019 Hora Con Data Con
In our application testing on Linux Informix v14 is about 7% faster than v12.10, which I believe to be mainly down to using modern compilers. I don't know if these optimisations apply to Solaris. Number of reads or number of writes are very broad metrics. You've already found th…
SQL Plan Management in Informix
If you are looking for something exactly like Oracle SQL Query Baselines, there is no such feature. If your aim is to lock down a query plan you need to use query directives. I realise that directives do not necessarily guarantee a specific plan, just restrict the optimiser's fr…
SQL using the index
There are a few ways this can be done. The most straightforward way I know is to switch on SQLTRACE in low mode. Then look for the part number of the index in the query plan output from "onstat -g his". Be aware that "onstat -g his" uses decimal partnums and other views may be u…
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…
sqexplain.out
It looks to me like it is the exact same query printed 3 times, with 3 different execution plans for each one. I'm now thinking it is three different plans that will all take the same time to run and the engine just chooses which one of those three it will run, but will all give…
Issue with statistics
Ok, I am going to try this tomorrow. I'll see if I can get them to tee up the report and then I'll grab this information and get back to trying to find the execution plan. They aren't getting back to me with those dates they are running in the query, so they must be busy on somet…
SEQSCANS Counter in sysptprof
To find your query turn on sqltrace in low mode. You can then search for the part number of the table in the query plans displayed by 'onstat -g his'. Bear in mind that 'onstat -g ppf' reports part numbers in hex and 'onstat -g his' uses decimal. Ben.…
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.…
error initializing 11.70.FC9
IDS 11.70.FC9 HP-UX 11.31 PA-RISC I did a standard installation (as root) of 11.70.FC9 in a separate directory on our test server. In the past, I have always set up a quick test instance anytime I install a new version, load the stores7 database, and run a few SQL statements to …
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…
SET EXPLAIN PLAN
Hello, I am using SET EXPLAIN ON before executing any query to see the cost of the query, but it is not generating any output file. Im using data studio editor. I tried SET EXPLAIN TO <'path/filename'>. how to generate set explain plan can you provide the steps please Thank …
Dynamic Explain (onmode -Y 1)
11.50.FC8 When I set up dynamic explain for a particular session id for a particular long running job , the output is not quite what I expect. Only a few of the sql statements have their query plans listed along with their respective query statistics in the output file; the res…
SQL statement equivalent TO onstat -g ssc
Patrick: I don't think that the statement cache is exposed in sysmaster. The only reference to it in sysmaster that I know of is the efficiency profile record in syssqlcacheprof: select * from syssqlcahceprof where name = 'Statement Cache'; But that's just over all hits, misses…
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)…
COMMIT WORK, LRU's and Checkpoints.
I wonder if someone could explain what happens when a commit work occurs in terms of the buffer cache? The SQL Manual for COMMIT WORK has the following sentence: "The database server takes the required steps to make sure that all modifications that the transaction makes are comp…
opentable memory leak
it's just a shot in the dark... check your query plan if an AUTOINDEX path is used. if yes, try after creating a permanent index on that column. Wolfgang…
RSS/HDT Sec - Different Query Plans???
Hello Folks, O/S AIX 7.1 IDS 11.70.FC8XB8 I have a query (and I can supply it if requested) that gets a different query plan between the RSS and HDR secondary both attached to the same primary. I was certainly not expecting this. What could be causing this behavior? Thanx, Dan…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
BTS & Outer Joins
Thanks Art. However, I should have gone with the full query, as it presents a tougher situation: a double Outer Join, with the second join related to the first. When the second outer is included, the query fails with the same indexing error. What is strange is that the explain …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Checkpoint causes Db to "freeze"
Jack Is this an issue that has just started occuring or have you always had longish checkpoints. How are your disks connected, what sort of cache do they have ? A few weeks ago my checkpoints went from 0-1 seconds to 30-50 with no change in work-load. Investigation showed the ca…
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
So here's an interesting little nugget that I just realized: The Explain Plan doesn't always print out the "Query Statistics" portion. The plan of tables and joins is printed, but not the stats breakdown. This section prints a long time after the query is started, so if I kill th…
Req help - identifying applns using given database
Request you to let me know if it would be possible to use explain (like oracle which stores explain results in plan table for querying later) or any other such utility to indirectly log the details of the query being executed on the database. Request you to direct me to available…
Execution Plan
What host language are you using that uses $<num> as a host var that is not replaced until OPEN time? - "Java" Why not just run the thing with SET EXPLAIN enabled or the EXPLAIN optimizer directive in it (with or without the AVOID_EXECUTE option) and look at the actual query pl…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Obtain query plans on the client (easily)
Hi all, I apologize for the publicity, but this is kind of a FAQ and I believe this can be useful. Since it's and article free of opinion, publicity, marketing etc. I hope you don't mind: http://informix-technology.blogspot.pt/2012/12/execution-plans-on-client-planos- de.html …
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,…
Query Performance on HDR instance
Recently we have faced a scenario, a query was running quite fast on primary instance but performing poorly on HDR instance. The execution plan on both instances were different as well. After running "update stats" on tables involved in query, the execution plan on HDR become sam…
Re: Someone have a technique to alter tables with
Fernando, In the message sent by both PMR : Date: 06/06/2011 Time: 11:43:34 Sql : -710 Table (informix.x_xxxxxx) has been dropped, altered or renamed. Isam : 0 Unknown error message 0. Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain …
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…
mon_page_usage Error in Logs
per finderr -710 this occurs when an object changes and a query plan has to be re-optimized. This error may have stopped occuring since the query plan has since been reoptimized but if it continues to occur try this : (if it still continues after this then contact tech support).…
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 …
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…
sqltrace x prepare statements (4GL)
Hi, IFX 11.50 FC8 AIX 6.1 + 4GL 7.32 (with CSDK 3.50 FC8) I have a 4GL program, executing a simple foreach over a table with 1.5mi records code 1) If this foreach running as dummy, without any code inside , take 1 minute to run: declare xyz cursor select ...from xyz foreach x…
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.…
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…
Art's Fear the Panther....
You probably noticed that Art Kagel posted a new entry in his blog: http://informix-myview.blogspot.com/2010/10/fear-panther.html At the end he mentions that IIUG is preparing the vNext survey (!). The world never stops! He wrote: "The IIUG will soon be posting its new Featur…
How to verify SQL statements execution date/time
I don't think that the information exists in the database itself. Perhaps if you have SQLTRACE set and have the contents of the trace cache being saved to a table or file you could get that information that way. Another option is Exact Solutions' iWatch product which captures SQ…
How to retrieve/check previously executed SQL ?
Ummmm... Upgrade to version 11.5 and turn on the SQL statement cache? I don't think it was available back under 9.4 Jarrod -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Wednesday, 22 September 2010 4:23 p.m. To:…
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…
frozen sessions
Thanks Jacques. This is the first time we've seen something like this, and it was only affecting sessions that used this procedure. The rest of the sessions (again procedure driven) were working without a problem. I ended up restarting the engine to correct the problem. -----Ori…
To IBM - DeveloperWorks - Articles
Hi, This message is to IBM . In the DeveloperWorks have a lot of nice Informix Articles , but most of them very very olds (2001-2006) what they treat only old IDS versions without consider news resources and updates.... Is time to review and update all this articles , isn't ??…
Statement Cache & Web Logic
Hello A developer is asking about Web Logic and their documentation and how that relates to informix and the database statement caching. here is what we have set: # Turn the sql caching on onmode -W STMT_CACHE_NOLIMIT 1 onmode -W STMT_CACHE_HITS 15 onmode -e on we have not had …
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…
Seeing one oninit working hard while others are no
Where is the capture parameter? I really only see the EXPLAIN_STAT enable. Is that it? If I turn it off, will that possibly improve anything? # SQL Statement Cache Configuration Parameters ################################################################### # STMT_CACHE - Control…
onstat -g his ( Log Space for Select)
On 28 Aug, 15:22, "zaiets.ko...@gmail.com" <zaiets.ko...@gmail.com> wrote: > Hi! > IDS 11.50FC5 > In onstat -g his output for SELECT Stmt Type Log Space not 0. > Statement text: > SELECT COUNT(*) FROM work_alloc > > SELECT using table [ work_alloc ] > > Iterator/Explain >…
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…
await_MC3 ??? How release a thread?
I think seeing a query plan would help maybe... (set explain). MM…
Re: a little help with query.
It didn't work the way you said. It's using the index but still doing (Parallel, fragments: All). Not key only. Thanks, floyd ----- Original Message ----- From: "Vagner" <pontes.vagner@gmail.com> Sent: Wed, July 15, 2009 18:56 Subject:Re: a little help with query. Hi, When yo…
Re: a little help with query.
Hi, When you put the filter on varchar_column column the engine works on data pages to process your count, because IS NOT NULL or != filter is not applied to index, for test purposes try to put varchar_column=some value, the access plan will be "Key Only" Without the filter pr…
Alter statistics to trick the optimizer?
IDS 10.00.fc8 OS AIX 5.x Situation: Statistics updated low every night. Table is empty at time statistics are run every night. I have no control over SQL or schedule of the application tasks. Mass load occurs on table at time of end users choice. Automated task begins on interv…
Cache some specific tables of any database
Sorry about no specs. Our version is 11.50.FC4 running on a Linux_64 machine. Thanks in advance for your helps, mr. Kagel !!! Alexandre Marini Analista de Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW Art Ka…
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 …
Monitoring SQL Statement Cache
I need to define a set of monitors to monitor key DB metrics. I can see that using the SMI tables, I can get a lot of what I want. However, I can't seem to find any way of monitoring the efficiency of the SQL Statement Cache. Something like a cache hit ratio (in %) would be use…
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…
Re: SQL STATEMENT CACHE Informix
On 13 Mar, 16:22, chav...@gmail.com wrote: > Hello, > Recently we enabled SQL STATEMENT CACHE in Informix 10.FC8, I > have been monitoring the chache since then, one thing I observed is > the statements are being removed from the cache well before (50-70MB) > the configur…
SQL STATEMENT CACHE Informix
Hello, Recently we enabled SQL STATEMENT CACHE in Informix 10.FC8, I have been monitoring the chache since then, one thing I observed is the statements are being removed from the cache well before (50-70MB) the configured max 100MB cache size limit, because the server can…
Activate query execution plan through JDBC driver
Hello, I want to activate the query execution plan to all the queries going through a JDBC driver. Just like doing "SET EXPLAIN ON" in all queries. Does anyone know if is it possible to activate this through a JDBC driver? Like some variable that one can pass to the JDBC connec…
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…
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…
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…
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…
Virtual segment usage - now I'm confused.....
On Nov 1, 11:11 am, Fernando Nunes <s...@domus.online.pt> wrote: > i...@perrior.net wrote: > > On 1 Nov, 13:32, "Art S. Kagel" <art.ka...@gmail.com> wrote: > >> On Nov 1, 8:50 am, i...@perrior.net wrote: > > >>> OK we managed to catch the process that blew up our Virtual portion.…
query plan from session cache
Hi, is it possible to retrieve the query plan(s) for an already running SQL (or for SQLs from the session cache)? The problem: When I run the 'slow' SQL (with set explain) it runs fast and well optimized - but the application runs the same SQL much slower. Regards, Andreas Kut…
STMT_CACHE
mohitanchlia@gmail.com wrote: > Version: 10 FC 4 > > I was reading about STMT_CACHE to see if this could be used to > increase the performance of repeated queries. But I see lot of people > have filed bugs about it. It appears engine crashes if you try to use > it. So my question…
4gl/esql syntax
On Aug 8, 1:35 pm, "sergio kapul" <ska...@comcast.net> 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 ins…
Informix engin
SET EXPLAIN ON; SELECT .... ; SET EXPLAIN OFF; The query plan will be written to the file sqexplain.out in your home directory on the server host. Art S. Kagel ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 8/02 7:19:26 Hi, How to get the details of…
Re: Strange behaviour of the buffer pool
Looking at a larger instance on the same versions I can see the "resident" pool being 354MB while the "res-buff" being the same the BUFFERS setting: onstat -g mem|grep " R " res-buff R c00000001669d040 1280004096 2848 2 2 resident R c000000000491040 …
Using STMT_CACHE
Hi These are the advantages of using SQL Statement Cache feature. 1)Reduced memory consumption because query data structures are shared among different users. 2)Faster query processing time because for statements present in the cache, the database server can skip parsing and opti…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Strange query
On Jun 28, 7:15 am, tich...@excite.com wrote: > When we run the query below we get an unexpectedly large number of > rows returned. when we put {+ORDERED} in the query the estimated rows > reduces from 9322036 to 12 even though the query plan is exactly the > same. Any ideas? Do…
Re: IDS Optimizer Query Plan, declaring and naming indexes
Yea, because depending on the data distribution, the optimizer may decide it is easier to scan the table than to use the index. You have update stats high, so you'd think the optimizer would make the correct decision, but if the query is slower, I guess it didn't. You can force t…
Re: IDS Optimizer Query Plan, declaring and naming indexes
Do you have the same data in both tables ? Do both tables have good statistics in sysdistrib ? -----Original Message----- From: NCC1701BOB@gmail.com [mailto:NCC1701BOB@gmail.com] Sent: Friday, June 15, 2007 09:44 AM To: informix-list@iiug.org Subject: IDS Optimizer Query Plan, d…
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
Hi I have captured explain plan for an SQL query in 2 servers having IDS 7.31. Problem is Im getting different plans for the same query in different servers havin same table structure and indexes. Only difference is number of records. I hope this shouldnt be the cause for the d…
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…
SELECT statement in FROM Clause
OK, I didn't want to get into my whole philosophy of how one properly switches from one programming language to another. I'll try a brief one here, but I continue hold that SQL is not a 'programmer's language' it is a 'user's language'. Perhaps that's better, as you are correct i…
Re: Dynamic Explain plan option in version 10
Paul Watson wrote: > It would be nice if we had the V8 capabilities for SQLEXPLAIN, i.e. the > ability to specifiy where the file is written. I believe this is in as a > feature request > I believe this is a registered feature request, and I believe we may see it in the future.…
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…
attached index
On Fri, 18 Aug 2006 09:21:36 -0700 (PDT), Floyd Wellershaus <fwellers@yahoo.com> wrote: >We have a query that runs kind of slow, which is exacerbated by the fact that it has to run millions of times. >It's searching on partial firstname and lastname. >It is using a composite ind…
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…
Statement Cache
IDS 9.40.FC8 Solaris 9 When I do onstat -g ssc I get lines as follows lru hash ref_cnt hits flag heap_ptr database user -------------------------------------------------------------------------------- 37 152 11 6549 DF 3c3d7e438......... 38 254 571 730…
Informix 9 and correlated subqueries
We recently upgraded to Informix v 9 from 7.31 with one of our customers, and we are having trouble with some correlated subqueries. In dbaccess they appear to run fine, but under some processes they run slowly. We suspect a poor query plan in these cases, as they seem quite co…
Incorrect Query Plan
Hi We have a table with 3 composite indexes like so: CREATE INDEX ix_rpl_ix2 ON rpl_scs_st_orderfill( style, fin_week, fin_year); CREATE INDEX ix_rpl_ix3 ON rpl_scs_st_orderfill( style, colour, fin_week, fin_year); CREATE INDEX ix_rpl_ix4 ON rpl_scs_st_orderfill( styl…
Easy INFORMIX questions
Stored procs can have a precompiled "plan", it gets precompiled when the "UPDATE STATISTICS FOR PROCEDURE" statement is executed. The update stats command needs to be executed when the stored proc changes, if the indexing on the tables that the procedure uses change or the data t…
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?…
IDS - Running temp dbspaces on RAMDISK
and you will need to recreate the temp dbspaces on startup... you might not be able to drop them if they are "corrupt" since the underlying file has gone.. Check the application usage of temp tables no rows /columns you do not need. It may be faster to - get the first n tables…
Re: IDS 9.4 Slower then IDS 7.31
The stange thing is the query plans look identical to when they are ran on 7.31. Thats what makes this so frustrating. If the engine was getting a different query plan you should be able to play with update stats and optomizer directives to correct it. But in this case its get…
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/…
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: Different Query plan when run on different server
Colin Dawson said: > > I'll post sqexplain output if someone really wants it but can anyone > suggest > an explanation as to why I am seeing this behaviour. > the onconfig parameters to > reduce the size of SHM and locks etc. Errrr.... -- Bye now, Obnoxio "C'est pas parce qu'…
AW: Different Query plan when run on different server
>Colin Dawson wrote > This server has a > restored copy of > the live DB albeit one week old. If it is a copy of PRD and configuration (look at OPTCOMPIND!) and environment (PDQPRIORITY !) is the same it should produce the same query plan. > > BTW Running dostats on the table …
Different Query plan when run on different server
I was investigating a slow running query and couldn't understand the path it was taking so I ran it on a testing server as update stats hadn't been run on one of the main tables in the query. This server has a restored copy of the live DB albeit one week old. The live server is a…
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!…
Re: IDS Feature Request List (including potential new requests).
Talk to Art Kagel. He already does this kind of stuff with dynamic names for prepared SQL statements a feature Oracle does not have! http://www.thetechtwo.com/detail-11064865.html "Sure, Pro*C does not support dynamic creation of prepared statement names and cursor names in hos…
Re: Upgrading from 9.21 to 10 planning
SQL Statement Cache. "bozon" <curtis@crowson1.com> wrote in message news:1134659196.580944.90680@g47g2000cwa.googlegroups.com... > SSC? Is that Shared Statement Cache? >…
Re: Really Frustrating -9628 Errors
Sounds like a bug i've seen before but 'should' have been fixed??? ... update stats will work but it only for xx hours and someother may fail. phone TS and have them look in their bugdb. wa afaicr is cranking up spl cache params PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX…
time consistant view
Hi, informix 7.31fc6 Using Informix Enterprise Command Center SQL Editor 3.01.TC1 I want to query 2 tables, a history table and a planned table. select * from history where date >= ("17/11/2005"); select * from planned where date >= ("17/11/2005"); Both selects take 5 minutes. …
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 …
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: OT: IDS 10 QPlan sanity failure problems
surprised that didn't work! there was a change to the query plans after 9.40.UC4 which means the plans all need updated and the update statistics for procedure requirement should be documented. Are you using ER?…
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
TBP said: > > Maybe the Query plan could be local to the session! Yep, that would work for me. That would effectively be what I would want -- I wouldn't want "my" query plan to overwrite anyone else's. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut ferm…
help with query plan
Below is the sqexplain output for a query, and below that is the schema for the table in question. I don't understand why this is doing a sequential scan on the scprofil table. It is not doing this on the development box, that has the exact same schema. I ran the required update …
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…
Some questions about views
Background: Michelle made this change to the webtodev database yesterday: Alter table to_recipient add ( fr_fee_reduction MONEY(16,2) default 0 not null before source_flag, fr_explanation VARCHAR(255) before source_flag, fr_operator_id VARCHAR(30) before source_flag); After she …
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…
Detecting when a query plan becomes ineffective
We update statistics daily at 2am. Some of our tables our quite volatile and I suspect that the changes are rendering the query plan obsolete as soon as 12 hours later. Is there a way to detect when the changes to tables/indexes have been so great as to require a fresh "update st…
Re: Running Informix on 2 different Servers in parrallel
wcottishpoet wrote: > Neil, > > other than the holiday, how about all the following which are available > in 9.40 .... > > > Improved Performance 8-15%better in internal benchmarks;Fuzzy > Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree > Scanner;Improved R…
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: is it possible to use wait hint with cursor select?
On Thu, 16 Sep 2004 15:24:48 +1000, "Andrew Hamm" <ahamm@mail.com> wrote: >sumGirl wrote: >> Is it possible to use a wait hint in a select done via cursor? Please >> no "dont use cursors" posts, I didnt write the code and I am just >> trying to help a developer. I am not a progr…
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: 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: 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…
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: database market share 2003
> From: Data Goob [mailto:datagoob@hotmail.com] > > In the real world Informix is already dead. > In the real world, DB2 is still in it's childhood. Some facts about DB2: 1. DB2 doesn't support table fragmentation within a single node (unlike XPS, which is able to fragment tab…
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.…
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,…
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…
Shared memory and SELECT-Performance
On Mon, 01 Mar 2004 05:07:19 -0500, Markus Bschorer wrote: Increase the size of the buffer cache (BUFFERS onconfig file parameter) so that more data is kept resident. The fact that after a few minutes the data need to be reloaded is a clear indicator that the cache is too small…
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…
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…
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.…
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…
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?…
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: Explain Plan for queries
If you are on 9.40 you can set the dynamic explain for the session and get the plans for the queries. U need to activate it using onmode -Y command. But, if you are not on 9.40 .. u will need to run the queries seperately from dbaccess to get the plans. HTH Thanx much, Rajib S…
Re: Explain Plan for queries
Obnoxio The Clown wrote: > > 2. As I mentioned I need to obtain query plans for multiple > > queries. Is there a way to run a whole file having all these > > queries using DBACCESS? > > Yes. Edit a file to contain: > > SET EXPLAIN ON; > SELECT ...; > SELECT ...; > SELECT .…
Re: Explain Plan for queries
Rajib Sarkar wrote: > Actually in 9.30 there's an optimizer directive AVOID_EXECUTE which will > provide the explain plan without executing the query. You can also set it > using SET EXPLAIN ON AVOID_EXECUTE (pls check the syntax though). Ah, bollocks. The documentation doesn't…
Re: Explain Plan for queries
Actually in 9.30 there's an optimizer directive AVOID_EXECUTE which will provide the explain plan without executing the query. You can also set it using SET EXPLAIN ON AVOID_EXECUTE (pls check the syntax though). In 9.40 in addition to the above, you can dynamically turn on expl…
Re: Explain Plan for queries
Answers Embedded. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "ovkrishna" <member44474@dbforums.com> To: <informix-list@iiug.org> Sent: Thursday, October 16, 2003 12:31 PM Subject: Ex…
Re: Explain Plan for queries
On Thu, 16 Oct 2003 12:31:11 -0400, ovkrishna <member44474@dbforums.com> wrote: > >Hi, > > > >I have a bunch of issues, though mostly related to obtaining the query >plan in informix. I am working with version 9.30. > >I am a newbie to Informix online dynamic server. So my quest…
Explain Plan for queries
Hi, I have a bunch of issues, though mostly related to obtaining the query plan in informix. I am working with version 9.30. I am a newbie to Informix online dynamic server. So my questions might be too basic. Please be patient with me. I need to obtain the query plan for a se…
SQL Query hang
Hi John, I dont have any query/query plan/schema. I need to create a new simple database myself and think of SELECT statement that would hang. But most important as I mentioned is, it should be a SELECT statement that is hanging and should be only statement in the session. I w…
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…
Different query execution plan
If I run the same query on QA box and our PRODUCTION box, I see different query execution plan. Following settings are used in both QA and PRODUCTION box. OPTCOMPIND 0 # To hint the optimizer OPT_GOAL -1 The table structure, including fragmentation is same. There is only 1 di…
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…
Statement Cache in IDS 9.4
Hi, Apparently SQL statements are not cached by SSC(Shared Statement Cached) if the �like' keyword is used. I can change the query to use the equal sign instead of �like' and the statement would be cached (but of course defeats the purpose). The actual query we use is more e…
onmode -Y
You can read some more explanations on the Performance Guide, pages 10-12 to 10-20 (Query Plan Report). I haven't used it yet, but I guess it should as what the documentation says. -edmund…
Time delay on ipcshm connection versus tlitcp
Tracy, Were these two tests run one after the other? Did we shutdown and bring up the instance? Were the tests run more than once giving the same results? I have seen many a test run where the second test through shows great improvment. The reson is obivous once you think about…
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…
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…
DNS Question
I am an Informix DBA running Informix 7.3 UC7 on an IBM AIX 4.1.3 rs/6000 box. Recently, we had a network problem where one of the two DNS servers in our Unix server's table became unavailable. The Informix application began to slow down and eventually new users were unable to ge…
pooled connections and prepared statements
stormchaser wrote: > Thanks for your informative reply. I am disappointed that user > statement re-use is required, since the database should be smart enough > to do that for me. Do you know if preparing *each time* might result in > better cache performance? In other words, doe…
Some IDS 9.2/4GL 7.3 strangeness
Recently updated to engine 9.20 and 4gl 7.30 and had a few suprises: ---------------------------------------------------------------------------------------------------------------------- Had this one today for the bug catalogue if it is not already in there. The insert action…
RE: Query Optimization: Wrong execution plan?
>===== Original Message From Xavi Tarafa Mercader <xavier.tarafa@corp.terra.com> ===== >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.…
Re: Query Optimization: Wrong execution plan?
From: Leonids.Voroncovs@dati.lv > >Xavi Tarafa Mercader wrote: > > > Any suggestion about how to improve the query performance? > >Set OPTCOMPIND parameter ( in onconfig file ) to 0. I'm not sure that will help. The query is going to probably scan both tables anyway, so a nested…
WG: Query Optimization: Wrong execution plan?
Dynamic hash join is a relatively new idee. You can refuse on it, if you set the variable OPTCOMPIND to 0 in you onconfig - file. If it doesn't work, try to use optimizer direktives (only 7.30 and higher). Best regards - Denis > ---------- > Von: Xavi Tarafa Mercader[SMTP:xav…
Re: Query Optimization: Wrong execution plan?
From: Xavi Tarafa Mercader <xavier.tarafa@corp.terra.com> > >I have a problem with a query: Are you sure it's the wrong execution plan? You're going to probably pull back most of the rows in both tables, aren't you? What happens if you run select * from tab1, tab2 where tab1.pk…
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 Instances, 1 machine VS 1 Instance 2 databases
Keith L Morris wrote: > > Greetings, > > The current job I find myself in was setup with 2 INFORMIX instances > each with one database. (On the same machine.) > > We have applicattions that link to both concurrently and do work. > > I would THINK that ONE instance with TWO datab…
Re: 2 Instances, 1 machine VS 1 Instance 2 databases
From: Keith L Morris <keith.l.morris@wcom.com> > >The current job I find myself in was setup with 2 INFORMIX instances >each with one database. (On the same machine.) > >We have applicattions that link to both concurrently and do work. > >I would THINK that ONE instance with TWO…
2 Instances, 1 machine VS 1 Instance 2 databases
Greetings, The current job I find myself in was setup with 2 INFORMIX instances each with one database. (On the same machine.) We have applicattions that link to both concurrently and do work. I would THINK that ONE instance with TWO databases (giving the one instance all the…
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?…
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…
Number of LRUs, Cleaners & Buffers
i'd say the pct numbers look good. i dont think there is any reason to use affinity unless you are auditing and can only charge by the cpu. remember to change only one thing at a time, and to have a goal for your tuning. if 2 sec checkpoint time is acceptable to users, then forgo…
Xtree and Informix 7.30 UC8
I have heard many Informix users using a tool called Xtree that analyzes the query plan of a DSS query. I am using Informix DS 7.30 UC8 on HP-UX 10.20 and want to know how can I install this on my system. Any help or suggestions would be greatly appreciated, Benny Lago Alliance…
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…
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…
prepares in 9.2
cstefanick@koz.com wrote: > I recently went from 7.22 to 9.2 (big change, I know). In 9.2 > statement cache is used so that similar query plans are shared. Does > this mean that preparing statements is no longer needed in 9.2? > > Sent via Deja.com http://www.deja.com/ > Befor…
Re: Need for Speed...
The query, query plan and schema for the tables would be good too (including fragmentation strategy) Will Sent via Deja.com http://www.deja.com/ Before you buy.…
Declaring cursors
Greetings When I DECLARE a fairly trivial cursor to SELECT rows from a large table (where the SELECT uses indexes) how "expensive" is it in terms of processing time ? eg are query plans updated/created etc when I execute the declare ? Regards, John…
stored procedure vs. prepared statement
Kevin Macclay wrote:We're running INFORMIX-OnLine Version 7.12.UC1. 1) Please do not post HTML/MIME to this list/newsgroup, many readers use the mail gateway and do not use HTML or MIME enabled mail readers. 2) I STRONGLY suggest upgrading your server to AT LEAST 7.31 or even as…
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…
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…
Query in Indexes...
Hi Gurus, I have a query, is there a safe and tested approach where can i disable the indexes and enable it again. Im planning to put the approach in the 4GL's. Regards, Jojo…
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…
Re: Beginner...update stmt.
UPDATE compare_forecast SET compare_forecast.New_A12 = (SELECT Step1.sumofregunits * upc_rslts_fcst.New_R_PCT FROM upc_rslts_fcst, Step1 WHERE Step1.upc = compare_forecast.upc AND Step1.upc = upc_rslts_fcst.upc AND Step1.week = compare_forecast.week …
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…
Re: Show query plan?
Sunil SET EXPLAIN ON; before the query will dump the query into a file sqexplain.out in the current directory. HTH Sujit Sunil Bhaskarla <sunil@intelus.com> on 01/06/2000 05:49:46 AM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Show query plan? How can I se…
RV: Show query plan?
Use SET EXPLAIN ON: the information you are looking for is logged in a file UserName.out in NT or sqexplain.out in Unix. --Diego Mezzera ----- Mensaje original ----- De: Sunil Bhaskarla <sunil@intelus.com> Enviado: Jueves, 06 de Enero de 2000 10:49 a.m. Asunto: Show query plan…
Show query plan?
How can I see what the query engine is doing behind the scenes when I type a query? In other words, how can I see its query execution plan (creating temp work tables and such)? I remember in SQL Server its something like SHOW QUERY PLAN ON... Thanks, Sunil…
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…
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…
Logical log usage and long transactions
Firstly, thanks to all who answered the mail "write cache hits slipping". Read caches are sitting nicely in th 99.4% mark. Write caches are still slipping, but I realise that I wasn't aggressive enough with my LRU settings, so that's something to look forward to at next reboot. …
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…
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…
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…
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…
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: 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.…
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…
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…
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.…
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: NOT IN TRANSACTION
> If you are the DBA (ie you can su informix), then from the command prompt, > type: > > ontape -s -<LogLevelSwitch> <yourdatabasename> > > where LogLevelSwitch can be U (for unbuffered logging), B > (for buffered logging) or A (for ANSI style logging). With > U all transactions …
Set Explain On in SP with Cursor
Hello all Informix lovers, Can anybody help me with this 'set explain' question? I have a cursor SELECT in an Informix stored procedure, and also an UPDATE inside the foreach loop. I would like to execute 'set explain on' so that it outputs the query plan for both the SELECT an…
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…
Index statistics
Hi, how can I find out if an index is used? Is there a count in sysindexes or some where else that is incremented when a certain index of a table is used in a query plan? Thanks in advance Monika Rabold Bull GmbH Langen Robert Boschstr. 52 63225 Langen Tel: 06103/761-4225 Fax:…
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…
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…
Re: explain plan without actually executing the SQL
I believe the explain plan will be generated upon preparing the statement (e.g.in ESLQ). Regards, bc Jay Walters wrote in message <36D99F9D.2516C1F1@computer.org>... >Is there a way to get the query plan for a query without executing the >query? I can only find set explain on…
Re: explain plan without actually executing the SQL
I've done this with using prepare let lv_str="select * from systables" prepare p1 from lv_str ... Theres a field on sqlca which gives the cost.. Jay Walters wrote in message <36D99F9D.2516C1F1@computer.org>... >Is there a way to get the query plan for a query without executing …
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…
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…
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?…
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.…
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…
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: 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: Getting HTTP_REFERER from Web Datablase?
Hi Tony, I'm using Web Datablade 3.32.UC2, and calling as a CGI. I turned on webdriver tracing, and from the SQL statement that contains WebExplode function call, HTTP_REFERER appears once a blue moon, most other times not. Kinda weird. Ah wait, I think I know what's going 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: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
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: Bug ? No rows returned from a view
Martin Brassard wrote: > > In the folowing problem, it seems that Informix doesn't return the same > data depending of the query plan it uses. > > We issue this query et don't get any data. [SNIP] > Then, if we issue that other query that is the same, but with a bigger > interval…
Re: Bug ? No rows returned from a view
Martin Brassard wrote: > In the folowing problem, it seems that Informix doesn't return the same > data depending of the query plan it uses. > > The query plan perform an index search on the master table for the first > case, but a sequential scan in the second (this is ok becau…
Re: Bug ? No rows returned from a view
Martin Brassard wrote: > > In the folowing problem, it seems that Informix doesn't return the same > data depending of the query plan it uses. > <skipped> I've had such problems on IDS 7.11 It was solved by setenv OPTCOMPIND=0 before connection Hope this helps Leonid…
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 …
After Alter/Create Table => Get Error -937
I am using 9.12 UC2 on Solaris with the Web DataBlade 3.30.UC6 using nsapi with Netscape Enterprise Server. Anytime I alter or create any table (with SQL editor or dbaccess), I get error -937 "Table (tableName) has been dropped, altered or renamed" when I run my web pages. The …
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: 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…
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: +…
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…
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: 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 …
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: 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…
Query to extract Initial & Next Extents
I am currently writing queries for capacity planning and I need to be able to extract the initial and next extent values given to tables on creation. My problem is I cannot find the relevant fields in the sysmaster database, but I know it is there somewhere as oncheck -pt displa…
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…
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: Stored Procedures and querries.
sane man wrote: > > Hi, > I was under the impression that when we put a > sql statement in a SP. the sql's query plan is > decided when we create the procedure. This seems > not to be the case. Can some explain to me when > in SP does the query plan for the Query is > decided…
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 …
Stored Procedures and querries.
Hi, I was under the impression that when we put a sql statement in a SP. the sql's query plan is decided when we create the procedure. This seems not to be the case. Can some explain to me when in SP does the query plan for the Query is decided in SP. Hopefully not when he qu…
Re: Running UPDATE STATISTICS on a table being used
In article <652nqa$3ho@cssun.mathcs.emory.edu>, sujata_soman_at_omm-la2-infotech-001@internet.omm.com says... > > >Hi. > It is me again with another question related to UPDATE STATISTICS. >Yesterday, I ran UPDATE STATISTICS high on 6 of my largest tables WHILE they >were being…
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…
Re: What's the problem with stored procedures
Jacob Salomon wrote: > > Kirk Waterhouse wrote: > |I had an Informix employee (a fairly high level consultant type) tell > |me that I should not use stored procedures with Informix. He said > that > |Informix did a very poor job of implementing stored procedures. He > said > |tha…
Information About Views
How does Informix handle views. Does it execute the SQL statement everytime someone accesses the view or is the view cached? When you create a SQL statement against a view with a WHERE clause does the view select all the information first then apply your WHERE clause or does it…
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…
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…
Reply to SELECT too slow
Hi: 1:you should provide your sql statement in details,which maybe a simple select , a join,or subquery ,etc. In different case they will result in different performance. Also you should provide your table schema,index,and sqexplain. 2.I think three fector will affct your perf…
Re: Set explain utility
In article <5ofjd7$5fv$3@gulfa.kuwait.net>, rferdy@kuwait.net (Rudy Fernandes) wrote: > >>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 us…
Re: dbaccess faster than ESQL/C ?
Are you using the same network facility in ESQL as with dbaccess? WHich di you run first? The reason I ask is because whichever is running second has the benefit of the data being cached (unless you bounce the engine in between runs). The only things I see that can make a differ…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5j39eg$2sj@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes > > >In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams ><djw@smooth1.demon.co.uk> writes: >> >I can do a *moderate* comparison between Informix and Sybase (32 bit >> >port): >>…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: > >I can do a *moderate* comparison between Informix and Sybase (32 bit > >port): > > > >Sybase 11.0.X Informix 7.22 > >------------- ------…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5ith88$14g@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes >[ 1 - I've snipped, what I believe, were a whole bunch of unrelated > newsgroups from this note. I've left only the comp.database.* > > 2 - If you disagree with what I've written, let'…
Get query plan on dbs a for dbs b
Dear all, Two questions for you all: 1) Has any one ever tried to get a query plan (by setting explain on) on = database A for the query that actually runs on database B (could be on a = different computer) by copying the database statistics from B to A (such = as systables, sy…
Re: Performance problem
Raymond Chow wrote: > > Help please!! I have two different machine. Risc6000 R40 and Risc6000 59H. > R40. IGB RAM, SSA DISKS, faster CPU > 59H, 324MB RAM, slower CPU. > > My day end run, seems that the 59H is faster than R40. Sounds ridiculous. > But it is true. > Any help in her…
Re: Performance problem
Raymond Chow <raychow@pc.jaring.my> escreveu no artigo <01bc3a2c$94c45c80$d3db8ea1@Mimos.Jaring>... <snip> > My day end run, seems that the 59H is faster than R40. Sounds ridiculous. > But it is true. > Any help in here? > Any reference on good Informix performance tuning book? …
Performance problem
Help please!! I have two different machine. Risc6000 R40 and Risc6000 59H. R40. IGB RAM, SSA DISKS, faster CPU 59H, 324MB RAM, slower CPU. My day end run, seems that the 59H is faster than R40. Sounds ridiculous. But it is true. Any help in here? Any reference on good Informix p…
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: Informix: Please buy Borland
Let me preface this posting by saying that I am *not* interested in converting anyone from Informix to Sybase. As a matter of fact, I'm planning on taking two Informix classes next week to learn about Informix. My posts regarding Sybase are more for educational purposes rather …
Re: Informix: Please buy Borland
pablo@mew.corp.sgi.com (Pablo Sanchez) wrote: : :In article <33146861.31595912@gate.idg.no>, Nils.Myklebust@idg.no writes: :> :> Sybase may have spread their resources to thin, but their basic error :> was in their server design. : :Would you please elaborate on this basic error…
Re: A performance question
Gregory Trubetskoy wrote: > > I am evaluating Informix on NT (to possibly replace MS SQL Server), and > I notice a significant difference in performance. > > I did a little tweaking, not too much - I set BUFFERS to 6000 (x4096K > page)(the machine has 128 Meg) SHMVIRTSIZE to 16Me…
Re: A performance question
In article <330B7E2B.6916@thetsn.com>, Gregory Trubetskoy <grisha@thetsn.com> writes >I am evaluating Informix on NT (to possibly replace MS SQL Server), and >I notice a significant difference in performance. > >I did a little tweaking, not too much - I set BUFFERS to 6000 (x4096…
Re: How do I find out the query plan in Informix?
Hi, Yes, it is real similiar. You'll need to SET EXPLAIN ON from whatever application that you are using. You should then see a sqlexplain.out file in your home directory on the dbserver machine. This is where the query plans get dumped. -Bill } } Sorry if this is a dumb questi…
How do I find out the query plan in Informix?
Sorry if this is a dumb question - I'm evaluating Informix workgroup server. (i386 NT) How does one find out what the query plan was for a statement/procedure? On SQL Server you can do SET SHOWPLAN ON (or something similar) and it will show the access method, wether it created …
Re: Prepared V Inline sql
Peter Jennings wrote: > > The environment is Online V5 under AIX. > > We have been running some simlple tests to compare the > performance of prepared sql to inline coded sql in an > esql-C program. Our intuition and experience of other databases > tells us that prepared (dynamic…
Re: Prepared V Inline sql
Peter Jennings (peter_jennings@uk.ibm.com) wrote: : The environment is Online V5 under AIX. : We have been running some simlple tests to compare the : performance of prepared sql to inline coded sql in an : esql-C program. Our intuition and experience of other databases : tells …
Re: sqlca and delphi
Frank Tschirpke wrote: > > Hallo, > > we need the sqlca-struct in delphi (1.02) and informix OnLine (7). How > can we access this struct? > > frank Frank, From the BDE API Help: Native handles allow you to bypass BDE functions to use native SQL database APIs to create and mani…
Re: Spurious SQL Results
Carol Davies wrote: > We are getting spurious (unexpected, wrong) results from SQL statements > which disappear when the SQL is prepared. Doesn't exactly match the circumstances, but I've had similar problems with a damaged index. Do an oncheck, and check that your index pages…
Re: SPL & Triggers - do's and don'ts
In article <3291472D.5831@sprynet.com>, Jake Salomon <jsalomon@sprynet.com> writes >As far as I recall, the SP cache is still limited to 50 procs. This is >not [yet] a tunable to keep those feature requests coming, folks! > Where did you hear about this limit - I cannot find …
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: Stored Procedures in Client/Server Env.
govardha@plains.nodak.edu (Jogendra Govardhanagiri) wrote: > I have couple of questions on using SPs in the client/server environment. > I like to get some info. on this. >1) Is there any limit on the number of clients calling a single > procedure at the same time? There is …
RE: How to reduce extents 5.x OnLine
>Saeid Yazdanmehr writes... >I am wondering if anybody has done the follwoing: >1) Trying to reduce Extents for performance improvement on an Informix >database version 5.0. Simply use tbunload/tbload. This compresses the extents and OnLine handles the compressed ext…
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: query plan
Diane Lombardi in Beach Lab (lombardi@cshl.org) wrote: : I am trying to improve the performance of a particular : query. I am using Sybase sql server v4.9.2. : I noticed that the first time I execute the query : the performance is a little slow. The second time : I execut…
Re: Optimizer's strategy
In article ehu@maicgn.SoftwareEngineering, ar@mai.de (Achim Reiners) writes: > >Hy everybody, > >I've some questions to the optimizer's strategy and to Informix' >plans regarding new versions. My current version is Online 5.01: > >1.) It is NOT possible to only look at the execut…
Re: query plan
Qing Yin (umyin@mctrf.mb.ca) wrote: : In <2thui0INN84u@phage.cshl.org> lombardi@cshl.org (Diane Lombardi in Beach Lab) writes: : | I am trying to improve the performance of a particular : | query. I am using Sybase sql server v4.9.2. Did Informix buy Sybase? :-) -- gburnore@…
Re: query plan
In <2thui0INN84u@phage.cshl.org> lombardi@cshl.org (Diane Lombardi in Beach Lab) writes: | I am trying to improve the performance of a particular | query. I am using Sybase sql server v4.9.2. | I noticed that the first time I execute the query | the performance is a little s…
query plan
I am trying to improve the performance of a particular query. I am using Sybase sql server v4.9.2. I noticed that the first time I execute the query the performance is a little slow. The second time I execute the same query, with different search values, the performance i…
Re: query plan
> I noticed that the first time I execute the query > the performance is a little slow. The second time > I execute the same query, with different search values, > the performance is terrific. More likely, your data is read physically the first time and the second time you …
Database monitoring tools
I am interested in tools to monitor Oracle and Informix databases over time in a distributed UNIX environment. Desired features include: o Predict future resource consumption based on past usage over time, and report problems on an exception basis. For example: Based …
Re: Stored queries under INFORMIX 4.00 or INFORMIX 4.10
In article <1992Nov4.162232.28445@walter.cray.com> n2976@cray.com writes: >Does anybody know if INFORMIX 4.00 or INFORMIX 4.10 supports stored queries? > >If not what about 5.00? What about any INFORMIX product? > We do not support stored queries (I think what you really want he…
Re: SQL Precompilers (preoptimize!)
Path: emory!swrinde!elroy.jpl.nasa.gov!orchard.la.locus.com!prodnet.la.locus.com!jfr From: jfr@locus.com (Jon Rosen) Newsgroups: comp.databases.informix Message-ID: <1992Mar04.203112.01004902@locus.com> Date: 4 Mar 92 20:31:12 GMT References: <1992Mar4.160455.12513@rock.concert.n…
Flushing changes
Path: emory!wupost!darwin.sura.net!gatech!udel!rochester!cantaloupe.srv.cs.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!<UNAUTHENTICATED>+ From: Sean.Levy@cs.cmu.edu Newsgroups: comp.databases.informix Message-ID: <EdYNfaS00hMgQ7TYBn@cs.cmu.edu> Date: 6 Feb 92 20:30:30 GMT Org…