Oninit® Archive
Results for “onstat -g his”
Network tuning advice needed
Please check the other answer, but looking at your description it reminds me of a typical situation I see once in a while... I would bet your program makes a very large amount of very quick queries. I've seen that scenario in typical ETL processes with lookup queries. For each va…
Error in COMMIT WORK when trying to add a chunk
Interesting case. To Mark's remark: in our LTX checking we're actually calculating a txn's consumed log space against the total configured log space, so under this perspective having differently sized log files should not make much of a difference. BUT in determining this "txn's …
Informix 15.0.0.2 IL1: Insert from SMALL table into temp LARGE table very slow
Hmm - interesting. Inserting into a large temp. table does not convert anything. Is simply creating a new temp. table in the LARGE page format. (in my understanding so far) This should not make such a difference. Can we please get a case? And can you please share the "repro"? I t…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Henri: Honestly, if you set SQLTRACE to LOW or MEDIUM and have a reasonable number of reasonably sized buffers configured, I have not seen any significant performance hit from turning SQLTRACE on. The single incident I did see was a client who crashed their host be configuring a …
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 ------------------------------…
Empty `onstat -g his`
Hi, That's my onconfig setting: SQLTRACE level=med,ntraces=1000,size=2,mode=user And that is what `onstat -g his` shows: IBM Informix Dynamic Server Version 11.70.FC5XE -- On-Line -- Up 22:33:44 -- 344686176 Kbytes Statement history: No statement trace data is available. A syssql…
SMI equivalent of onstat -g spf
Yes but the syssqltrace* tables are only populated if you have SQLTRACE enabled! ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Informix 14 - ALTER JOIN -
Sqltrace will give more detail than set explain, did you try it? ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any othe…
Slow Running Query
Instead of using -r2 run the onstat in a loop with a sleep and write each output to a different file. Then you can diff the files to find the long runners: iter=0; while [ $iter -lt 10 ]; do onstat -g act >act.$iter.out sleep 2 iter=$(( iter + 1 )) done You could also enable SQLT…
onsmsync issue question
Hi, few years ago i had issues with onsmsync, it took very long time to execute. I had to create indexes on some tables but don't remember which ones. execution time was modified from hours to minutes. Probably running an sqltrace will help to find which indexes could be interest…
Informix Enterprise Gateway Manager Error
Thanks for reply Gaurav, When the egm process goes down, there are no messages at all in online.log and egm.log. Even odbc trace or mssql server does not generate log messages. Does this happen because the sql server version is 2017? ------------------------------ SangGyu Jeong S…
Decrease Size of Root Dbspace
Yes there is a task to move the sysadmin to another database, but the contents if there are any (such as SQLTRACE results, etc) are lost. After the move of the sysadmin database to another dbspace, the sysadmin will be as it were new. dbaccess sysadmin -…
YIKES! 12.x documentation for onstat -g opn does not match the output
Thanks, Doug. I see this was written by Richard Harnden, to give credit to his hard work. However, my Fragments script (written in Perl) does the same and more. What I needed was a script to reverse the new onstat -g opn output. The onstat lists the tables (ugh - partitions numb…
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…
Number of logical logs growing ?
Well, something is causing activity in the instance and consuming logical logs. The timestamps and ordering of the online log seem strange. All those entries on the same second, the backup start entries before the corresponding logical log completing. Is the machine hibernating? …
for sysmaster masters:syssqlstat Vs previous query
Hi, is there a table in sysmaster that will catch the query that has been running just before the current query ? I would like to query the last query that has been running for MY session (i.e this query must run in the same session), but syssqlstat, but if I run such query, th…
More durable query
Without enabling sql trace you are just making it harder to get the information. Enabling sql trace on Informix should have minimal impact if you keep to the low/med setting. One way would be to periodically just dump to flat files the output of "onstat -g ses 0" ( or whatever o…
Performance Tuning
Today I am going through Lester Knutsen's SQL Tracing webcast :-) https://www.youtube.com/watch?v=KM2yjraC71M Thank you Lester…
High CPU Utilization
Turn on SQLTRACE in low mode. Bear in mind this allocates memory from your virtual segment. Then use 'onstat -g his' to find any long-running or frequently run queries which are consuming a lot of time. HTH, Ben.…
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…
rootdbs is full message
It usually helps to include some additional information: 1) the specific lines from the onconfig pertaining to DBTemp spaces 2) 'onstat -d' output showing the root and temp space flags. 3) the section from the message log with the error, and the surrounding few minutes of entries…
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.…
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…
SQL have most IO read
If you turn sqltrace on to low it will track this information along with other very useful information when tuning queries. You pre-configure the tracing so the impact to performance in low mode is less than 0.2% from my testing. John F. Miller III miller3@us.ibm.com 503-747-136…
Re: Database slow - drop and recreate indexes
From what I'm reading you've gone down the route of rebuilding indices and other actions without really knowing what the problem is. Of course there could be something I don't know here. I would hold off any other actions until you know what's wrong. Do you have a large ready qu…
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)…
Performance impact of SQLTRACE
Hi all, Pretty much still an informix newbie but I've searched and haven't found an answer. On Informix 11.10, is there a significant performance impact to turning on global SQLTRACE through onconfig? We've got problem queries that need to be addressed and it seems like this mi…
Re: Identify the sessions which using all tempspac
Thank you for pointing out this RFE. I have voted for it. While I wouldn't say this is a top priority for our business, as a DBA I find getting a complete picture of who is using temp space is impossible. User created temp tables can be discovered easily but are only part of the…
How to Get "SQL" statement in running session
Hello ? How are you ? How to Get "SQL" statement in running session without "SQL TRACE ON" ? Our customer want to get "SQL" history to get Top N SQL . They are developing to gather Informix DBMS log and OS log's history these day. They use Informix 11.5 version. In case of Ko…
Different output of onstat -g opn in version 11.70
Hi Art, Our team will take a look at this. Thanks! Hai-Nhu ------------------- Hai-Nhu Tran Content Design Manager IBM Analytics Platform (415) 486-4151 | T/L 2= 00-4151 hntran@us.ibm.com ----- Origi= nal message ----- From: Art Kagel <art.kagel@gmail.com> To: "id= s@i…
sql trace not capturing all activity
Hi, I hope someone can help. I'm trying to trace all activity on one specific database, using commands select sysadmin:task('set sql tracing database add','trace_this_db') from sysmaster:sysdual; and select sysadmin:task('set sql tracing on',150000,'4000b','high','global') from s…
ph_alerts table
I agree with Paul about no downtime required for moving the sysadmin database. DEFINITELY move it to another dbspace. I think it's a bit tricky but not that bad. I did that about 2 years ago at a site. I add chunks as needed. I've recently turned on sqltrace again, and one of the…
lock ovflow
Thanks for the inputs everyone. Slightly embarrassed - as George pointed out ... onstat -u has the info. Can trace back to session, etc. I have been using OAT for watching a number of issues like this lately. Refining SQLTRACE as well for catching offenders. Thanks - Mark…
session host variables in sysmaster
Hi, thank you, but i know sqltraces and it is not activated on production databases. The OLTP application generates a lot of requests (some thousands each second) and sqltrace is not usabled if not pointing on a specific session. The question was, where onstat -g sql get the hos…
onstat -g iof: gfd and chunk number
Jon, That was BEAUTIFUL! But you were correct; it is not potable or even usable in my situation. For starters, your great advice about looking for the oninti process with "1" in the C column was quite effective. However, that's where the portability ends. In my case: $ ps -ef |…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
temp table schema
From outside of the session that created it? If you have SQLTRACE enabled, you MIGHT have captured the create or select ... into temp statement that created it, otherwise there is no way that I know of. From the session that created it (ignoring the fact that the session should …
Filtering the results of an iterator function.
I create a stored procedure abc that creates a temporary table and then returns the records. I then want to use those records in an sql statement but filter them outside of the stored procedure: select * from table (abc(para1,para2) as t1 where t1.some_field = 'XYZ' As soon as …
Memory parameters and Workgroup Edition
Effectively MAX_PDQPRIORITY is already set to 0. On the DS_ parameters, wellllllllllllll, the ONLY effect that these have is that DS_TOTAL_MEMORY limits the setting for DS_NONPDQ_QUERY_MEM since the latter is limited to 25% of the former. DS_NONPDQ_QUERY_MEM is the only part of …
Update statistics issue
If you would like you large tables running update statistics = low to run very fast then you need to read the link below. I= n general this makes each index which update data statistic low is run o= n take about 1 minute (unless there is great data skew). http= ://www.ibmn…
SQLTrace retention purge seems to not work
I'm playing with SQLTRACE and have the OAT task setup to purge every 15 minutes at this point trying to get it to simply purge anything. Right now, it has filled up the dbspace and seems to not want to purge anything. I've looked at the proc it calls and I believe that something…
Using SQLTRACE
Hello to all, I need to have all the sql statements run by about 50 users (it's a matter of security not performance), so i activated sql tracing using server studio with selecting these users, but i noticed it doesnt give the user/hostname informations. My questions : 1- Is S…
Enable sql trace in global
SQLTRACE doesn't create a file. I just creates a ring buffer of queries in memory with supporting meta-data. There is a task manager sensor that copies the new entries from that buffer into a set of tables in sysadmin, however, so you can see queries that have scrolled off the en…
Abnormally Large Trace Table
First you should deactivate SQLTRACE... and/or the mon_* task that copies the SQLTRACE circular buffer into a regular sysadmin table (actually I think there are three tables) I believe (but would have to verify) that the *iter table stores execution data of prepared statements...…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
set lock mode to wait 5
Hello guys!! Again I have questions about informix. I have a application java and uses database in informix. Users login in the app across query table in database but the loggin is very slow (Maybe 3 minutes). I enabled sqltrace informix and i verified that there are queries th…
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.…
IDS 7.x SET EXPLAIN ON for all query
Hi, how can I set the configuration/directive on the fly to explain all the query that hit the database? I want to trace certain query from a program which we don't have the sql documentation for it. Thanks.…
Reschedule Webcast - Informix Performance Tuning using SQLTrace, Remote DBA Monitoring and Yellowfin BI
Folks, We are rescheduling our Informix Performance Tuning Webcast that was scheduled for June 4th to July 2nd, 2013 at 2:00 pm, Eastern Standard Time. Webcast - Informix Performance Tuning using SQLTrace, Remote DBA Monitoring and Yellowfin BI You are invited to attend our ne…
Informix Performance Tuning Webcast - June 4th, 2013
Folks, Our Informix Performance Tuning Webcast is next week on June 4th, 2013 Informix Performance Tuning using SQLTrace, Remote DBA Monitoring and Yellowfin BI You are invited to attend our next Webcast on Tuesday, June 4th, 2013 at 2:00 pm, Eastern Standard Time Lester Knut…
Next Informix Performance Tuning Webcast - June 4th, 2013
Folks, Our next Informix Performance Tuning Webcast is June 4th, 2013 Informix Performance Tuning using SQLTrace, Remote DBA Monitoring and Yellowfin BI You are invited to attend our next Webcast on Tuesday, June 4th, 2013 at 2:00 pm, Eastern Standard Time Lester Knutsen, Art…
Exploring the Sysmaster Database - a Webcast by Lester Knutsen - Replay and download available
Folks, The replay is on YouTube my new scripts are available for download from: http://www.advancedatatools.com/Informix/Webcasts.html Our next Informix Performance Tuning Webcast is June 4th, 2013 Informix Performance Tuning using SQLTrace, Remote DBA Monitoring and Yellowfin…
What are the Performance Hits using SQLTRACE?
AIX 6 IDS11.50.FC7W3 I need to find my query bad guys after a new software release and want to use SQLTRACE. I have done my homework and have played with it in test but I do not have a box that will get hit anywhere near as hard as my production box will. Can nayone give me a g…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
Monitor CPU usage by Informix session
On Thu, Nov 15, 2012 at 2:42 PM, MURALI PAZHAYANNUR < pmurali@ftportfolios.com> wrote: > We had a situation where an Informix session brought the production > Instance > down to its knees. We restarted the instance and it happened a second time. > Here are the server details: HP…
Current SQL from system tables
foredstest@gmail.com wrote: > Please advice how to get Current SQL from system tables for particular > session (like onstat shows)? if you don't want to enable sqltrace then please look at the syssqlcurses inside sysmaster.sql file. comment sdb_iscurrent/odb_iscurrent conditions…
sessions multiple Informix driver
Thank you for your recomendation. The sql trace feature is ok. It is migration. Now is better. Thank you for all.…
SQL TRACE with strange behave...
Hi, IFX 11.50 FC9X6 , AIX 6.1 I never was capable make SQL TRACE work properly , it never does what I expected. But, some way or other I always get what I need. Today they appear be totally crazy at our production environment.... never ever do what I configure it to do.... Wh…
IDS crashes in flexible grid create table commit
I had SQLTRACE set to level=low. I changed it to level=off and now I no longer have the problem. Thanks!…
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…
Fwd: SQL Capture - DB version 11.7.FC4
Tom: Try instead to turn the SQLTRACE feature on and query sysmaster:syssqltrace instead. That accesses a different area of memory in the server and may avoid the bug that is causing the crash after repeated runs. There is a lot more information about the queries and how they …
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 …
Need a Help, Access login and sql traces
For logging access you could use the auditing facility. I don't know any way to log the SQLs without external tools: - Brute force tcpdump - Something like IBM Guardium (not sure if it works with 9.x) - Some external party tool for replication... not sure about this one, but it's…
SCHAPI Error -272
I am running Informix Version 11.50.FC3 against Solaris version 10 for the last 4 years with no changes and just last week received the following error. 17:27:51 On-Line Mode 17:27:53 SCHAPI: Started dbScheduler thread. 17:27:54 Booting Language <spl> from module <> 17:27:54 Load…
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…
SQL tracing question - Compiled Statement
IDS 11.50.fc6 ISQL 7.50.fc5 CSDK 3.50 ESQL/C 3.50.fc6 OAT 2.73 on Windows 7 HP-UX 11iv3 (PA-RISC) I am using OAT to look at the SQL trace information. The vast majority of the statements are SELECTs -- no surprise there. I then click on the SELECT to get a listing of the specifi…
Re: AIO and Buffer Waits
Hi Alberto, if calculating the LRU queues as you suggested the value would be 2400 LRUS not 240. Are you sure that would be correct? The values AUTO_CKPTS 1 RTO_SERVER_RESTART 600 are set. I cannot increase the physical log because I have 2 GB chunks as biggest. And y…
IDs tries to allocate virtual memro segments
Hi, We are using IDS V11.50.FC8 on HP and we have a strange behavior. The engine tries to allocate virtual segments non stop. The engine has been running since the end of April without any problems. The engine allocated a bunch of virtual memory segments until it reached the …
Re: Identifying Unused Stored Procedures
Hi Donald, I don't think IDS stores any information regarding last execution/creation time of a routine. Hence, this is almost no way to find this out the past history through IDS. In the future, if this data is needed, you might need to create a log table to track this through …
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.…
Informix Instance inventory
2011/4/28 JAVIER HERNáNDEZ <javier_hdzt@yahoo.com.mx> > My client recently upgraded his license entitlements to Informix 11.7 an > has > asked us to make sure he is compliant. > > The main problem is my client is a national institution and has several > "IT" > departments that n…
Jobs very slow
What versions of IDS are you using. You have to tell us more on what you have to play with. You can use onmode -Y <sid> 1 after identfying the session (onstat -g ses) of your program running. This will generate an sqexplain.out.<sid> for your session. You can also use SQLTRAC…
How to capture the lock wait or dead lock info
You can use the SQLTRACE facility and enable the task called "Save SQL Trace". This will save the traced sql statements into a table. You can add to the insert statements a where clause to limit the scope to only save statements with lock waits or lock errors. John F. Miller III…
SQLTrace questions ?
Hi, I'm using the SQLTrace tool. I have some technical questions : 1/ Why the maximum size buffer trace is 100 Kb ? I don't understand the reasons of this limit. 2/ The theoric maximum trace number can be 2 147 483 647. But how to compute the real maximum trace number for his I…
OAT and mon_syssqltrace
Hi, I am trying to get permanent sql traces in mon_syssqltrace using OAT but it seems that is limited to the max numbers of traces set. How can I get a history of saved SQL traces that goes way beyond the max number of traces set for sysamster:syssqltrace? Is it possible to se…
IDS suddenly generates 4 times more logical logs
I'm going to try it ;-) Any recommendation on how to set the SQLTRACE parameter ?…
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…
sql_runtime in syssqltrace
On Sun, Nov 28, 2010 at 11:55 AM, Tristan Ball <tristanb@pronto.com.au>wrote: > Hi Everyone. > > Can someone please tell me what unit of measure sql_runtime represents? > > The manual doesn't seem to say. I suspect it's seconds, but the times given > don't seem to measure up to …
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 ?
9.40 doesn't keep any SQL history. You can use the SQLTRACE facility but it is expensive and captures lots of data. You can use AGS's Server Studio which can capture and record historical SQL by polling the sysmaster tables. The capture is not 100%, but about as good as you will…
Locking & Logging Issue
Thanks, Cesar. As I mentioned, the only "change" has been a spike in searches via the external web app. Mining, possibly. Yes, we are using smart data spaces (sbspaces) to hold the CLOB information. That is where we see the HDR+IS locks placed on the smart large object headers.…
Index page size - test result....
Hi All, I always read here about the vantages to use indexes in bigger pages, where have best performance. But I never seen/found any effective test. So I decide try one in small scale, what for me appear works and show the index with 16k page size run faster and consume less C…
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…
Analyzing Data from OAT
Hi Jonathan, OAT (SQL Tracing in particular) could be taking some data from previous run. In my OAT in SQL Explorer -> Tracing Admin I see Oldest traced statement pointing to my previous run of SQL Tracing: 1. I enabled SQL tracing on 2010-06-15 15:00 and run it for an hour 2. I …
sql trace question - message log
Every new instance I configure, I got this error too. Just drop the table mon_syssqltrace_info and wait for next time of the sqltrace task run, they will recreate all this and others tables... Cesar --- Em qui, 6/5/10, Tom Lehr <tomcaml@gmail.com> escreveu: De: Tom Lehr <tomc…
Re: SQLTRACE iwht 111.50 (real-world usage please).
Folks, So late last night I ran the same benchmark with 100 users that we used for the Fastest DBA contest on one of my tuned systems... and the results surprised me. Two runs with SQL Trace off and two runs with SQL Trace on on, and the two with SQL Trace on, high, were both >…
Re: how many transactions/sql statements server has executed
On Apr 29, 6:58 am, LonelyWolf <lonelywolf1...@gmail.com> wrote: > On 23 huhti, 20:54, "da...@smooth1.co.uk" <da...@smooth1.co.uk> wrote: > > > > > > > On 23 Apr, 09:09, LonelyWolf <lonelywolf1...@gmail.com> wrote: > > > > Hi > > > > I'd like find out how many transactions and/or…
remscan
Im noticing some performance issues with selects across servers. On the execution plans and sql traces there are remscans for the queries that access the other server. Whats a remscan ? Is it a "remote sequential scan"?…
SQLTRACE iwht 111.50 (real-world usage please).
Is anyone out there using - IDS 11.50 and - SQLTRACE with a level of high in the onconfig to track the last N sql statement for the server? I was thinking track the last 1,000 sql statments in high mode but has anyone tried this for real? What kind of overhead are you seeing …
how many transactions/sql statements server has executed
On 23 huhti, 20:54, "da...@smooth1.co.uk" <da...@smooth1.co.uk> wrote: > On 23 Apr, 09:09, LonelyWolf <lonelywolf1...@gmail.com> wrote: > > > Hi > > > I'd like find out how many transactions and/or sql-satements Informix > > instance has executed in a given period of time. Seem's…
Performace issues
There's much to much about performance tuning to be able to answer you properly here. Go to the IIUG web site members pages and download all of the presentation materials from previous IIUG Conferences that pertain to server tuning, including several of my own. Second plan on att…
save sql trace in message log
hello all we see this in the message log and are not sure exactly why and what is the process to correct it. --- 07:15:00 SCHAPI: [Save SQL Trace 21-1597] Error -310 Table (informix.mon_syssqltrace_info) already exists in database. we are assuming it is not a huge problem but o…
Detailed Audit
IDS does not provide any feature specifically designed for capturing SQL statements. You may find other tools useful, but most have limitations: - SQLTRACE (captures to memory, and you'd have to make sure you put it file before the capture buffer wraps around) - SQLIDEBUG (a fea…
OAT SQL Explorer - Live vs Saved Data
OAT is using a task in the Task Scheduler to save off of the SQL trace data. So you can configure how often IDS saves SQL trace data by modifying the schedule of the task. If you go to the OAT Task Scheduler -> Scheduler page, find the task named "Save SQL Trace". Clicking on …
Random Server Slowdown "Redone"
Hi Javier , Here my opinion and hints... 1) I agree with Art, where have to lot Lockreqs, but I don't consider this impossible since you have 8 machines running your applications... 2) Active an OS monitoring tool, like sar to collect information for each 10 or 15 minutes... (…
Scheduler error message
IDS 11.50 FC4 on Redhat Enterprise 5 I'm seeing the following in my online.log file 01/13/10 09:15:00 SCHAPI: Error -206 The specified table (mon_syssqltrace) is not in the database. 01/13/10 09:15:00 SCHAPI: Type: SENSOR, Name: Save SQL Trace, Location: NULL. 01/13/10 09:15:00…
Waits cond wait netnorm and IO Wait
Is there a possibility that I collect this data through SQL, thus making an automatic trace waits to acquire these in my environment. Where do I find more information about waits and latchs?…
Error messages in log
Hi ! I have just upgraded to 11.50.FC6 on HP-UX 11.31 Itanium. I get a lot of the following messages in the online log: 14:15:01 SCHAPI: [Save SQL Trace 20-149] Error -206 The specified table (mon_ ssqltrace) is not in the database. 14:15:01 SCHAPI: [Save SQL Trace 20-149] …
data comparison between two IDS 9.4 servers?
Hi, I have a banking application porting from non mid-ware to Tuxedo based. In this regard, we changed the communication protocol and some of the public function in order to adapt to Tuxedo based programming. We would like to test the application porting through transactions as…
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
No the parameter is SQLTRACE which appears to be off, at least the config line you posted is commented out: #SQLTRACE level=low,ntraces=1000,size=2,mode=global Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that…
SQLTRACING
Hi all, IDS 11.10.FC3 on Solaris 10 I want to trace the SQLs run by the user "vikas" using the SQL Admin API execute function task("set sql tracing on", 10,"2k","low","user"); What should be the correct execute funtion systax so that i get only sqls executed by user "vikas" a…
onstat -g his ( Log Space for Select)
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 ================ ID Left Right Est Cost Est Rows Num Rows Partnum Type …
oninit taking 98% cpu
On Aug 21, 6:45 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > Well how about giving us a clue, by posting some statistics about the > database server. > > eg onstat-c > onstat -u > onstat -p > onstat -g iov > > ? > > "BertieBigBol...@gmail.com" <bertiebigbol...@gmail.com> wr…
Log and Query Analysis Tools
sparc wrote: > Hi there, > > I hope my question isn't too naive, but I'm curious about how folks > using Informix profile their database usage and query patterns. > > For other databases like Postgres and Oracle, there are programs that > can trawl the logs, and come up with grap…
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…
trigger on SMI table syssqltrace
Hi, Could it effect the performance if we increase the "ntraces" value or set the "level" to high for SQLTRACE where default is: SQLTRACE level=low,ntraces=1000,size=2,mode=global We created a trigger (on each insert on syssqltrce) as create trigger log_sql_statements insert on …
OAT SQL Trace Broken?
I'm running OAT 2.23 on WinXP against IDS 11.50.FC4 on HP-UX 11.23. I've logged in as user 'informix' and configured parameters via the GUI for a user to access the SQL Trace capabilities. But when the user attempted to use SQL Trace with OAT on his PC, a series of errors ensued…
SQLTRACE on HDR Secondary
On Jun 11, 9:42 am, informixdba <informix...@gmail.com> wrote: > Is there a trick to get SQLTRACE to work on the HDR Secondary. > We use our secondary for some read only applications and would like to > be able to analyze the queries with SQLTRACE. This is for HDR, but > also w…
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 …
IDS 11.5.FC3 : Tracking new sql sessions
Dick, This works perfrect. Looks like there are lots of changes in xc3 release. Thanks for your help. --- On Tue, 4/21/09, Richard Snoke <dsnoke@us.ibm.com> wrote: From: Richard Snoke <dsnoke@us.ibm.com> Subject: Re: IDS 11.5.FC3 : Tracking new sql sessions [15572] To: ids@ii…
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…
IDS 7.31 Solaris8 - Long Checkpoints
Kurt, It's cool you're not taking more virtual memory segs to get the work done (only 1 "V" in your onstat -g seg output). Your engine is only sized to about 413MB, while you said you have 4GB RAM on the server. In addition to Art Kagel's suggestion he just saw posted.... Try in…
Track activity on a particular table
Onstat -g ppf or sysmaster:sysptprof shows you that kind of information by partition, you just only ask/filter for the partition you are interested in. There is a parameter config that inhibit of gathering that stat but I cant remember right now which one is... Walter -----Ori…
DB Monitoring
If you want the existing 11.50 to do that then turn on SQLTRACE in the onconfig and run onstat -g his or select from the sysmaster database the table called syssqltrace. This will have all the data you have requested. See the following link= to the documentation http://publib.bo…
v11.50.fc2 excessive kernel reads
I just installed v11.50.fc2 on an Aix 5.3 system. Only changes to the config file was that I changed the sqltrace to be global and not user ... and I added SCANNER num=2,treashold=500000,rangesize=100,alice=6 previous that was not set ... Since the upgrade the kernel reads on …
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…
load distribution to kio vps
IDS: 11.10.FC2 I am seeing slow performance and when I look at onstat -g iov I see that out of 28 kio vp only 2 are super busy. Below is the snapshot (first 2 have 107 and 136 io/s): kio 0 i 107.7 27388858 15142656 12246202 0 45203359 0.6 0 0 kio 1 s 13…
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.…
Re: Problem with ODBC
Sheshnarayan Agrawal avait ï¿œnoncï¿œ : Hello >>> Where can I trace these options? > Start->Control Panel -> Administrative Tool ->Data Source (ODBC)->Tracing > Tab then supply absolute path name for the trace file (i.e > c:\\my_dir\\trace.txt) under "Log File Path"after that c…
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…
Informix Profiling tool.
tracing of SQL Statements in IDS 11 was covered on todays technical Support Exchange If anyone would like the slides and replay details please email dryburj@uk.ibm.com…
Re: Informix Session Information
Informix DBA wrote: > Marco, > > I completely agree you are 100% correct and yes I did get the 4 million > lines of code speech. Though, I am just doing my part to try and help out. > > If you have any other solutions/ideas, please let me know. > > -- David > Informix DBA > …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: 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…
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…
onmode -ky hangs
Hi Frank, Could you post an onstat -g ath when this happens? It's definitely a result of running out of memory while acquiring locks, but that shoulld not necessarily cause an engine hang. -------------------------------------------------------------------------------- ---- Pr…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
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?…
onstat -g sql
In v10 there is the onconfig parameter ... UNSECURE_ONSTAT If you set that to something other than 0 ... ie. 1, then onstat -g sql will work the way it did prior to v9.40fc4 ... be aware that that will open back up the onstat to all users ... PDL "NADINE DIEL...." <nadine.die…
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/…
program hangs
OS: Linux SuSe 9.2 IDS. 9.40 The program can't make any connections too the INFORMIXSERVER "Guy Bowerman" <gbowerman@yahoo.com> schreef in bericht news:fGlKf.5191$HU.3533@trnddc04... > Danny, > > Can you add: > OS version, > IDS version. > What the program is doing at the time …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
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: sql tracing and logging
MC4U: One of the things I have done in the past with multiple tables is to create a VIEW with linked tables into a single reference. It makes ad hoc PERFORMs a snap. If the support group was looking as a specific form, you may want to look at the underlying code for it. Of co…
sql tracing and logging
The software I use came bundled with Informix and I would like to know how to trace which tables the data is stored in from any given screen in the application. For example, our support group informed me that they ran a trace on the screen in question and they referenced only one…
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…
find indexes not being used
The Mighty Kevin Fennimore once gave me a shell that took the output from "onstat -g ppf" and made it all pretty. I use it now to track activity on tables and indexes. Kevin and his guys at UCI Consulting do some amazing things with IDS. If you have an opportunity to sit in on o…
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:…
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…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: SQL Tracing tools?
"Abdullah Kauchali" <abdullah.kauchali@someplace.com> wrote in message news:cnicmc$spp$1@ctb-nnrp2.saix.net... > What do informix users use to profile (log) SQL statements hitting the > database server? (In MS lala-land, we have the almighty Profiler Tool. > Works well.) We us…
Re: SQL Tracing tools?
IDS v 9.4 (and maybe earlier) supports 'dynamic explain' to capture sql statements for a specific session: onmode -Y <session id> 0|1 A file is then created with the following name: sqexplain.out.<session id> For example, if you wanted to capture the sql statements for se…
RE: SQL Tracing tools?
Colin, You said sqlidebug and sqliprint are "internal tools". Would that be internal as in onstat used to be 'internal'/undocumented feature.... Or are they "internal tools" as in you have to get them from IBM? Thanks, Norma Jean -----Original Message----- From: owner-informi…
RE: SQL Tracing tools?
Abdullah Kauchali said > What do informix users use to profile (log) SQL statements > hitting the database server? (In MS lala-land, we have the > almighty Profiler Tool. > Works well.) > There is the SQLIDEBUG and sqliprint which are internal tools that can be used. They ea…
Re: SQL Tracing tools?
onstat -g sql does it to some extent. Some of the GUI tools such as Server Studio have modules that will extract the data slightly more conveniently, but last time I nlook they give you nothing not available from command-line utilities. For heavy-duty query analysis, in a dev e…
SQL Tracing tools?
What do informix users use to profile (log) SQL statements hitting the database server? (In MS lala-land, we have the almighty Profiler Tool. Works well.) Any help or suggestions greatly appreciated. Kind regards Abdullah…
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'?…
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…
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: 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…
alarm to console
This concerns IDS 9.4 on Windows 2000. What is the best way to blast a message up on the screen of the server when logical logs fill up? I've looked at alarmprogram.bat in the /etc directory, but email is not a good option for the machine I'm concerned with. The "pager" looks a…
RE: How to trace ODBC connection?
Don't you have a way of tracing the tty to a person ? Not sure, but I can trace my internal users on the tty, which gives me there computer names which I can look up. Otherwise you will have to track down the application using onstat -g sql, and then to build some code into your…
Re: How to trace ODBC connection?
miyaki <lcib@yahoo.com> wrote in message news:<bv245a$f5m$1@terabinaries.xmission.com>... > Hi all, > > Most of our applicatoins were developed in Windows/Web > platform and they are accessing my database via ODBC > type of connection. I found that it's very difficult > to trace …
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: create index stalls entire informix server
Check your PDQ settings. If its not in your environment check to see if queries are using the PDQ Manager using onstat -g mgm. If they are using PDQ, chances are someone started the server with PDQ set. Doing this effectively makes every query that is executed run via the PDQ man…
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…
RE: Informix 9.40 crash after stress test.
If a user connects to the server using shared memory or TCP/IP has nothing to do with how much shared memory is allocated for the threads running from that users session. Shared memory connection vs. TCP/IP is simply the method of communication between the server and client. If…
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…
isolation & lock mode in onstat
How reliable is the output of onstat -g sql as far as the isolation and lock mode is concerned? I have an ESQL/C process that sets committed read and wait 60, however in the output of onstat -g sql there is quite frequently DR for dirty read and Not Wait, which both would be a ma…
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…
RE: TOP Process
You could be seeing a loop of some type. I've seen this in the 4ge world every now and then. Of course, I guess that it is possible for a program to be actually doing some work . . . -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Monday, January…
TOP Process
HP-UX 11.00 IDS 9.21FC1 Hallo everyone, I have something that's been a problem to me for quite some time now. If I run a "top" on HP, showing me the processes using the most cpu power, I often find 4gi's sitting right on top, using 60 - 90 % cpu power. I also think these pro…
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 …
network driver cannot accept on hp-ux 11.00
"Art S. Kagel" wrote: > "Nicholas Pieter Heesters Jr." wrote: > > > > I need to make a correction. I was looking at the wrong > > server when I said the version was 7.31UC2. It is really > > Informix 9.21FC1 that is giving me the problems. > > > > The value of NETTYPE is "soct…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
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…
Changing from Informix to Oracle
On Tue, 25 Jul 2000 17:26:58 +0100, "Art S. Kagel" <blp@bloomberg.net> wrote: > > >Boscia wrote: > >> OK, thanks for all the good information. When the time comes I will be >> armed to discuss Informix vs. Oracle >> >> In the meantime, here are the onstat commands that one of y…
Re: How to find out why a table is locked? (2nd try)
Mode Ansi enforces repeatable read. That means that if a transaction reads a row it places a shared lock on the row. That shared lock will prevent the row from being altered or deleted by another thread. I suspect that is what has happened. "Sven C. Koehler" wrote: > "Art S.…
How to find out why a table is locked? (2nd try)
"Art S. Kagel" <kagel@bloomberg.net> wrote: > Oh come now. You have GOT to give us something more to work with. Ok. I gathered some more information. :-) I am using Informix Dynamic Server Version 7.30.UC5 on sparc-solaris 2.7. My application runs on Redhat linux 6.1 (intel) …
Re: is there a Trace Utility in informix? (newbie)
From: daniel30@my-deja.com > >I have a simple question for you guys. I'm working on a project that >involves an informix server with IECC v3.00. I want to know which >queries are being run on this server. > >I'm used to working with SQL Server and in SS there is a tool called >Pr…
is there a Trace Utility in informix? (newbie)
Hi, I have a simple question for you guys. I'm working on a project that involves an informix server with IECC v3.00. I want to know which queries are being run on this server. I'm used to working with SQL Server and in SS there is a tool called Profiler (perviously called SQL …
Trace utility in Informix (newbie)
Hi, I have a simple question for you guys. I'm working on a project that involves an informix server with IECC v3.00. I want to know which queries are being run on this server. I'm used to working with SQL Server and in SS there is a tool called Profiler (perviously called SQL …
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…
tracing informix se
Informix SE 7.23 on SCO UnixWare 2. Is there a way to trace what an .ec ESQL/C program sends to the database server? For example, an environment variable, with the name of the file to log all SQL commands to ? Thanks,…
Re: Slowness
OK - I will be the smartass...So you have a faster CPU...Your Developer group decides to store almost 4x as much data but doesn't give you adequate disk space to even have TEMP on a seperate drive. Then they complain about speed (or lack of it)... Take your nearest Scott Adam's…
RE: onstat: Shared memory: permission denied???
Ignorant people tend to be a reason for paranoia where I work. We had an employee who when asked to delete all the logs a certain application was creating tried his hardest to delete the physical and logical logs (cooked chunks) Luckily for both him and me his atttempts to get t…
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…
Query tracer
Hi, I am looking for a way to trace realy each SQL statement an application sends to the database server. Because the source code of the application cannot be changed I have to use means of the DBMS or a tracing tool. I tried: onstat -g sql sid -r seconds > file. The minimum i…
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…
RE: Top Databases Used
>I feel sorry for you actually. Ahh, somebody nicked his lollipop and he's sulking >I was told once that when people end up insulting you personally, it >generally means that you've won the argument and the other person has >nothing more left to say. Nope, it justs means peopl…
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…
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…
Trace utility similar to Oracle's
Hi there, First on all I am not comparing the two products. I am trying to learn Informix myself. With Oracle, I can trace a session to get all SQL statements executed for that session and then use a utility (tkprof) to get the execution plans for each of the traced SQL stateme…
SQLIDEBUG environment variable
Hello everybody, Does anyone know the differents values that you can set this environment variable in order to trace SQL statements. I know that sqliprint will allow to view the resulting file containing the trace, but I don't have all of the values or event some of them for th…
Re: Huge performance problems Sun/Informix
In article <88cafc$rmc$1@news.xmission.com>, Thomas Vogt <t.vogt@drgueldener.de> writes > >Thanks for your reply ! > >The size of physical dbspace is 50000 KB. > Dave comes in fast from the wasteland that is his latest weekend upgrade... First I need:- Hardware =====…
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: oninit use 95+%cpu
richard palmer wrote: > Informix 'trainers' that I've been around tend to know about odd quirks > of the engine -- they hear about stuff from internal sources that we are Often true. > > rarely informed of. That said, I think the SERVERNUM suggestion is > a crock that I would …
Re: oninit use 95+%cpu
From: vyao@dehavilland.ca > >We have a production server which is running IDS 7.31uc2 on HP-UX 10.20. >This >morning one oninit process use 95+% cpu and none of the users could do >anything. >No any error could find in informix online log and unix syslog. > >At that time, there w…
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…
Re: tracing of SQL-Statements
From: "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> > >I am looking for a way to trace really each SQL statement >an application sends to the database server. I-Spy? ______________________________________________________ Get Your Private, Free Email at http://www.hot…
SQLIDEBUG, sqliprint
Following a hint of that friendly guy at Siemens Informix Support I found SQLIDEBUG (an environment variable) and sqliprint (a tool) to trace sql statements and other traffic between client and server. It seems that these are "undocumented features". Anyhow, I am looking for a d…
tracing of SQL-Statements
I am looking for a way to trace really each SQL statement an application sends to the database server. Because the source code of the application cannot be changed I have to use means of the DBMS. onstat -g sql sid -r seconds > file records sql statements. The minimum interval …
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…
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…
SQL Retriever dumps core in Inf 7.3
We had been successfully running SQL Retriever ODBC services with our Informix database server until we upgraded Informix to 7.3 and AIX to 4.3.2 over last weekend. Now the ODBC server crashes with a seg fault and dumps core when I try to crank it up. Has anyone else had this pro…
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…
write cache / NETTYPE
I agree, crank up your buffers. Even Inserts will take advantage of the page being already in cache! Plus Index modifications will greatly improve. Gee, I need to shoot for 85% on write cache? Does that mean I need to reduce buffering since I regularly see 93%-95% on writes and …
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.…
oninit trace to user
Hi, During peak usage, if I do a top, I see that oninit threads taking 80% of the cpu. Is there a way I can trace the oninit thread back to a user and an sql statement if applicable? The oninit thread might not be running an sql statement, but more times than not I would guess…
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…
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…
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…
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…
Re: Tracing ALL sql queries - is it possible?
>Jabbar Fagan wrote: > >>Thanks for the info. How much does it cost? > >Because: >> "Randy Reiter" <rreiter@sqlpower.com> wrote: >>> Yes - with ZERO database server impact. Refer to www.sqlpower.com. > >Get Informix-Spy (from Informix). TTBOMK, it's free, so it has the >major a…
Re: Tracing ALL sql queries - is it possible?
Jabbar Fagan wrote: >Thanks for the info. How much does it cost? > > Because: > "Randy Reiter" <rreiter@sqlpower.com> wrote: >> Yes - with ZERO database server impact. Refer to www.sqlpower.com. Get Informix-Spy (from Informix). TTBOMK, it's free, so it has the major advanta…
Re: The last executed SQL statement
Within the Stored Procedure : SET DEBUG FILE TO "foo.dbg"; TRACE ON; This will allow you to trace all the sql statements. If you require to monitor the statements try running "tail -f foo.dbg" HTH Harinath Venkata Svenska Handelsbanken New York.…
Re: Tracing ALL sql queries - is it possible?
It depends on where the SQL is coming from, I imagine. If they're typing it in, it would capture it. If they're just telnetting in to kick off a program, I would doubt it. Maybe if the SQL is displayed/copied to the screen--that'd be an interesting question... > In our case w…
Re: Tracing ALL sql queries - is it possible?
In our case we have around 100 users telnetting into a sun box (UE4000) from a pc - using a 3rd party (Acadia) telnet product. Once connected to the Sun box and logged in, they establish a connection to the database using shared memory (since at this point they are local on the …
Re: Tracing ALL sql queries - is it possible?
> The following quote no.1 > > "The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server from a network telnet session will be > available in the product next week." > > is not the same as the following quote no. 2 > > "The fac…
Re: Tracing ALL sql queries - is it possible?
> The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server from a network telnet session will be > available in the product next week. This reeks of marketing-speak. Your product does NOT monitor shared memory connections nor…
Re: Tracing ALL sql queries - is it possible?
> Your statement of the capabilities of the Sql Power SniFFFer product line > is not quite correct regarding shared memory connections or IPC > connections to an Informix database server. Actually, it was one of your people who verified that it doesn't work for shared memory, st…
Re: Tracing ALL sql queries - is it possible?
Obnoxio The Clown, Your statement of the capabilities of the Sql Power SniFFFer product line is not quite correct regarding shared memory connections or IPC connections to an Informix database server. Please refer to the response that will be posted this morning to the Informix…
RE: Tracing ALL sql queries - is it possible?
I wandered over to the site to have a lokk and requested more information. That was nearly a month ago and I haven't heard a thing. Maybe they should use it to monitor their web forms:-)) Paul Watson # WF Software Ltd # Contractor: Tel: +44 1463 674729 # …
Re: Tracing ALL sql queries - is it possible?
Except for shared memory and loopback connections. I think it's important to make that clear in your advertising when answering a question like this one. How do you know Michael isn't running a shared memory installation or using stream pipes? > Yes - with ZERO database server…
Tracing ALL sql queries - is it possible?
Hi, does anybody know whether it is it possible to dump a trace of ALL sql queries, with timing info, under Informix? Thanks a lot -- Michael Ivanov. Voice: +7 (812) 219-9237. E-mail: ivans@spb.sterling.ru…
Re[2]: Long checkpoints (LRU_xxx_DIRTY/LRUS)->NETTYPE values
On Thu, 25 Mar 1999 11:25:10 -0800, MOPSOMER@raychem.com wrote: > Here is some additional information regarding these long checkpoints > we have in our productional SAP R/3 environment (Informix 7.24.UC3). [snip] > Yesterday, I had to extent a couple of dbspaces, whic…
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…
Sysmaster Question(s)
Hello all, I am working on gathering information that is found in the onstat commands but I would prefer to do it with the SMI tables so I can store it in a table and do some trending. I am currently on 7.30.UC3 on HPUX-10.20 and there are a couple of things that are really stu…
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…
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?…
Re: Tracing sql statements
Simpson, Don wrote: > > I too would like to know if there really is a way to capture every sql > statement of a user. I believe that's not an option. I'm writting a quick and dirty proggy that goes "select distinct sqx_sqlstatement from syssqexplain" every configurable interval …
RE: Tracing sql statements
You can use the Auditing feature, onaudit. This audits just about anything you want, by specific users as well. Only, it doesn't show you the actuall SQL statement executed, just the table Id and row Id effected, and whether it was an update, delete, etc.. You can also use the…
Tracing sql statements
I've used the "onstat -g sql xxx' statement to view the last sql statement issued by a user. Does anyone have a suggestion or know of a way to run a complete trace on a specific user? -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.co…
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: How to trace a SQL statement
You can trace your SQL statements by issuing SET EXPLAIN ON statement before executing the SQL statement. This makes informix to write optimization messages to $INFROMIXDIR/sqexpln directory. But you need to find another way to keep track of the time passed by during the query …
Re: How to trace a SQL statement
Hello, try SET EXPLAIN ON from dbaccess before the sql statement you want to trace. After this sql statment SET EXPLAIN OFF. You will find information about the performance of your sql in sqlexplain.out Hope this helps. Regards Alexander SoftTeam Blas Catherine <catherine.bla…
How to trace a SQL statement
This is a multi-part message in MIME format. ------=_NextPart_000_00A9_01BE1247.14B9EE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I've been working with an Informix Database with ASP for a little time = now. We are runn…
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…
Re: SQL-trace
You can try setting the environment variable SQLEXPLAIN to "ON", this (may! devpends on your server, I suppose), create a file called sqexplain,out in the current working directory. Don't forget to unset the variable and restart the program after the program starts though. If y…
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 …
monitor temp dbspace
Our environment: 7.2.UC5, Sun 5.2.1 solaris, probably about 400-600 connections - occasionally a user will create a really wild outer join on (possibly) unindexed filter, creating a REALLY LARGE usage of temp dbspace for the sort (order by) or some other (scan..) I have developed…
SQL-trace
Hello, how can I trace (record) the "Start-up" of an application (Billingsystem) with an informix Online Dyn. 7.2 Database in the background. Is it possible with an SQL script ? Best regards A.N�gele…
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…
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: Performance problem after merging db server
Greg Moye wrote: > > Stephan Stresing wrote: > > > > Hi, > > we have a heavy performance problem after 'merging' two db systems > > to one. We did this because according to the Informix Performance guide > > and the advices of Informix experts. > > The most obvious thing is that …
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 …
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…
Re: latch/lock , buffer - questions.
Sadagopan, Sathish wrote: > > Hi All, > 1) When a thread needs a buffer to read in data , does it acquire any > latches/locks.How is the allocation done ? This is all explained in the Administrator's Guide. Basically the thread hashes into the LRU queues selecting a queue at …
latch/lock , buffer - questions.
Hi All, 1) When a thread needs a buffer to read in data , does it acquire any latches/locks.How is the allocation done ? 2) What is the difference between locks and latches. 3) If i want to track , the number of times a PARTICULAR user's operations caused his threads to wai…
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: queue statistics
In article <6ngrh3$j6f$1@news.xmission.com>, "Sadagopan, Sathish" <sadagop0458@att.com> wrote: > > > Hi, > The qst option of onstat says "queue statistics not enabled".How to enable Q > statistics ? > TIA > Sathish > another reply explains what you need in your $ONCONFIG file.…
RE: 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: PDQ PRIORITY idling threads ( Informix 7.3 TC2/1 ?)
In article <6ml99e$n4u$1@news.xmission.com>, Alexander V.Didytch <unknown.thegreat@usa.net> writes > >Hi ! > >Here is the problem: > >I have the stored proc. with SET PDQ PRIORITY HIGH; inside it; >when I'm run it everything is fine, and onstat -u gives me a lot of >thread with t…
PDQ PRIORITY idling threads ( Informix 7.3 TC2/1 ?)
Hi ! Here is the problem: I have the stored proc. with SET PDQ PRIORITY HIGH; inside it; when I'm run it everything is fine, and onstat -u gives me a lot of thread with the same SID. that relates to that procedure but when the procedure. finished its work onstat -u give's me th…
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…
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: 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…
RE: 4GL Database Feature Question
On 9 Jan 1998, Richard Thomas wrote: } Jonathan Leffler wrote: } > On 8 Jan 1998, Axel Granholm wrote: } > > We have a 4GL application that has been growing in size over the last 6 } > > years, and have a question about fragmentation aware SQL from within the } > > application. }…
Re: Cannot connect to Online
Dirk Scheer wrote: > > Hello out there, > > since 4 weeks, there's a very strange behaviour with INFORMIX Online 7.13.UC3 > on HP-UX 10.01. From time to time it happens, that no new user can establish a > connection to Online (the process hangs, until online shutdown). Users > cu…
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…
Easy Q: Dummy table?
I have a need to print CURRENT variables from within a simple SQL file being piped to dbaccess. It is so that I can surround a SQL statement with two datetime selects to trace how long the SQL statement took to run. Is there a way just to "select CURRENT" so that it gets output…
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…
Re: Help: - TRACE not working in stored procedure
In article <33B12BE2.2900@west.co.za>, marks@west.co.za wrote: > > rrazdan@gtscorp.com wrote: > > > > My stored procedure does not generate a TRACE file. I am using Informix > > OWS 7.12 TC5 on a WinNT 4.0. I also tried using a APPEND TO with a > > manually created trace file…
Re: Help: - TRACE not working in stored procedure
rrazdan@gtscorp.com wrote: > > My stored procedure does not generate a TRACE file. I am using Informix > OWS 7.12 TC5 on a WinNT 4.0. I also tried using a APPEND TO with a > manually created trace file but still no success. Am I missing > something ? I am doing this using In…
Help: - TRACE not working in stored procedure
Hi ! My stored procedure does not generate a TRACE file. I am using Informix OWS 7.12 TC5 on a WinNT 4.0. I also tried using a APPEND TO with a manually created trace file but still no success. Am I missing something ? I am doing this using Informix SQL editor. CREATE PROC…
Re: Stored Procedure Help please !!
In <01bc7c22$f14e3ce0$a10b0514@rram.den.csci.csc.com>, rramesh wrote: >Hi, >I am trying to debug a stored procedure so I did the statement Set >Debug file to "/tmp/procedure.dbg". We are able to create the file >manually but when I run this SQL statement I get Error 648 and Isam …
Re: SQL tracing utility
Please try to turn off your mime encoding an post in plain ascii. Roger Hernandez <rogerh@shadow.net> wrote: :We are running Informix ODS 7.21 on Solaris. Our clients run on Windows :NT 4.0. : :I am looking for a utility which will let me trace all SQL statements :(from client…
SQL tracing utility
This is a multi-part message in MIME format. ------------49B0B7C56100 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii We are running Informix ODS 7.21 on Solaris. Our clients run on Windows NT 4.0. I am looking for a utility which will let me trace a…
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: Shared Mem FAQ's, was malloc...
Joe books works good in many instances for 7 as well. I have both and for those of you who are waiting on a copy of my scripts, let me tell you how good his scripts are. I first combined the seeuser and watchhot scripts for my 5 engine on AIX 3.2. When my 7 engine came along 5 mo…
Re: Help On Stored Procedure Lang
praveen@qsun2.ho.att.com wrote: > > Hello Informix experts, > > I have a situation, where I am updating/Inserting a > row through stored procedure, I want to write the same > SQL statement to a file with the values. Well, perhaps through SPL it's even eas…
Re: -107 error is still there
On Dec 11, 10:32am, Tolis Varnas wrote: > Subject: -107 error is still there > > > A few days ago I posted an article about a problem with locking in > Online 7.11.UC1 on a HP-UX machine.Jim Gordon posted me an answer stating > that there was a syntax error on the create index co…
7.1 How to identify disconnected client sessid
I have seen this occur on numerous occassions, where a client connected with a nettype of soctcp aborts (ie the PC is rebooted, power lost, etc). The sessid is still active and if holding a lock presents some problems. T date, all that I have found to rectify the problem is to ha…
Re: Debug for Stored Procs
Billy Wheeler (billy.wheeler@digitec.co.za) wrote: -> Are there debugging tools for writing stored procedures? A friend has asked -> and I don't know the answer. Thanks for any help. In your procedure: SET DEBUG FILE TO "filename"; TRACE ON; There are a modest number of op…
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: onstat -p (compress)
John R Worachek (jworache@jcpenney.com) wrote: : What does compress mean within onstat -p output? The number of times a page compression has taken place - ie the number of times a slot table has been shuffled to make contiguous space out of fragmented space (within a page). -- …
Re: table usage profile in 6.x 7.x
Saeed Talebbeik (saeed@sap-ag.de) wrote: : Folks, Is there any statistics kept within the online 6.x or 7.x : system that shows how many I/O operations have been performed : on a particular table? The question that I want to answer is to : run a benchmark on my application and fi…
Re: sql question
In article <9539@emory.mathcs.emory.edu> baskett@hermes1.sps.mot.com (Bob Baskett) writes: > > help, im having trouble doing a select. we have a table (trace) which > has two trace_types, (WAF and ASM). what i want to know is the ASM > source_lots which have more than one WAF s…
sql question
help, im having trouble doing a select. we have a table (trace) which has two trace_types, (WAF and ASM). what i want to know is the ASM source_lots which have more than one WAF source_lot. the trace table: create table trace ( source_lot char(16), test_lot char(16), …