Oninit® Archive
Results for “onstat -g sql”
RE: Informix: external optimizer directives not working
Hi, just for your info, we fixed this issue: -. I had used the sql syntax text extracted from onstat -g ses output. It seems this command formats the text and the directive gets created with extra spaces, carriage returns, etc. and when the same SQL gests executed it does not m…
Gathering EXTREME amounts of time in %sys CPU
<snip - delete a lot of old text> David Williams wrote in message <0mcD2LAtTeo2EwkJ@smooth1.demon.co.uk>... > Several... >>> Have you seen anything like this ? > > Not exactly, the only time I saw a system freeze that hard was an old > 7.1x running against Pyramid which hung …
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
What triggers a blocking checkpoint?
Hi Jacob, if I understand you right, you do not want to know afterwards, when long checkpoints occurred, but what is (was) happening when such a long checkpoint is triggered. A long checkpoint typically is a result of very active writing. (or too slow I/O). As far as I can see fr…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Hello community, does anybody tried to get the same or similar output as an SQL query from sysmaster? Thanks a lot Milan Rafaj Unless stated otherwise above: Kyndryl Česká republika, spol. s r. o. Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4, IČ: 096 28 886 Zapsaná v obchodním r…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
SESSION_LIMIT_MEMORY
Hi, To capture the SQL query that a session was running just before it reaches the SESSION_LIMIT_MEMORY and terminates, you can consider using database monitoring tools or querying the database logs directly. These tools can provide insights into the recent queries executed by th…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
SQL command identification/source
I am involved in the operation of a large multi-user system with hundreds of users. The application code is written in Java and Infomix 4gl. I am able to monitor the current traffic and identify possibly suboptimal SQL statements (e.g. using onstat -g ...). However, I often have…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
SMI equivalent of onstat -g spf
Hello, does anybody know if there is a sql table/view from sysmaster to get the info which command onstat -g spf provides? Thank you ------------------------------ Milan ------------------------------…
list sql statements
Hello Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration, prefectly , these informations (sessid, sql statement, cost, duration , cpu consum…
session(s) taking the most cpu ressources
Current server: onstat -g top ( see 'https://www.ibm.com/docs/en/informix-servers/14.10?topic=ogmo-onstat-g-top-command-print-top-consumers-resources' ) Previous - in real time you can use "onstat -g cpu", or observe / filter (continuous) "ath" output (UNIX/Linux): onstat -g ath …
Long Running Query thru shell Script
Hi Amit, I strongly guess you're not going to be happy with this approach. An easier one would be capturing a series of 'onstat -g ses 0' outputs while your problem is going on, then searching and comparig them for sessions that at more active than others, or for SQL that frequen…
HQ - Current SQL statement or Last parsed SQL statement
Informix HQ does not display "Current SQL statement" or "Last parsed SQL statement" for session unless sql trace is turned on. Is this bug or feature? Some customers have 100.000s statements per second and turning sql trace on will keep just last 0,05 seconds of sql commands (unl…
zombie SQLERR 349
Trapping the error should provide you with (an af file containing) an 'onstat -g ses <sid>' output which then would show things like user client host client application current + last parsed SQL statement Here's what to do: onstat -g cfg DUMPSHMEM (shmem dumping on?) onmode -wm …
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
onstat statement
Hi AMit Killing the session may take some(and sometimes a lot) of time because what it does is rollback the transaction. If the transaction is "intensive", i.e lots of SQL statements, it can really take long. You can check what this session does with onstat -g tpf and look at the…
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How to get open cursors by session
Hi, I was investigating about how to get current opened (active) cursors in server. Preferably, getting a SQL query to sysmaster will be the best but also onstat command would work. Reason for this question is to make a quality assurance of a program and we're not sure this progr…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
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…
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…
Could not do a physical-order read to fetch next r
Dear Techies, As we are facing a serious issue in our production server this evening, which makes the transaction stop. Issue logged in application server: Java.sql.SQLException: Could not do a physical-order read to fetch next row. Impact: records are not inserting in the resp…
Issue with statistics
What does this onstat -g ses show me? I am seeing session id's, total memory, used memory and the 20 or so lines that shows all have dynamic explain = off. Also the onstat -g sql says unable to open input file sql. Not sure what these were for...…
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…
onstat -g sql --- interpretation?
Hello,Under column Iso/Lvl, there are values such as CR, DR -- what do they mean?And also, there are many "wait 300" -- is it just something referring to set isolation level to wait 300 seconds from the application that we should not be worried about? Thank you! onstat -g sql IB…
SQL statement equivalent TO onstat -g ssc
Informix version 11:70 / 12.10 Platform : Linux / Unix Hi all I am looking for SQL statement which equivalent TO command : onstat -g ssc Anyone have any idea which tables that I should "reference to" in sysmaster DB ? Thanks…
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)…
How to know the current isolation level in ESQL/C?
Lu: When a session first connects to a database the isolation level is determined by the logging mode of the database: Unlogged: Dirty Read ANSI Mode: Repeatable Read non-ANSI Logged: Committed Read You can detect the logging mode of the database immediately after the DATABASE…
onstat -g ses - getting the pid
I am running 11.50.FC7 on Solaris 10 Sparc. I have a couple of tables that are locked. I am trying to see what is locking them. I ran onstat -g sql to determine some ids that were associated with the tables. I then ran onstat -g ses to get the pid of the session. For these par…
Turning on logging for DDL and DML
try this - just comment out the stuff you don't need select sysadmin:task('set sql tracing off') as sql from sysmaster:sysdual union all select sysadmin:task("set sql user tracing off") from sysmaster:sysdual -- USER mode union all select sysadmin:task("set sql user tracing cle…
Long transactions monitor and Statistics
My guess is that you want to look at systxptab table and the column called longtx. I have not tested the below SQL, but it should get you most of the way there. select a.sid, a.username, longtx from sysrstcb b, systxptab c, sysscblst a where c.owner =3D b.address and a.address …
Finding users locking the database
Hi, I would like to ask how can I find the locking user using the data below Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 347d61a8 0 (700000019709508) 70000001ca75ba8 HDR+X a00157 88305 K- 1 I Normally, I would just onstat -u | grep owner then find the sessio…
session host variables in sysmaster
Hi, i would like to know where onstat -g sql goes to get host variables for the current request. I have to query sysmaster from a client so i don't have onstat commands. I know current sql can be retrieved from sysconblock, but i didn't find where host variables are. I am working…
Identify SQL version from client
Hi Sergio, You can identify SQL version from the clients, like reported on onstat -g sql, querying the sysmaster:syssqlstat. sqs_sessionid integer, { session id } sqs_dbname char(128), { database name } sqs_iso smallint, { Isolation level } sqs_lockmode smallint, { lock mode…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Sessions Connection Info
I think it's possible, but not practicable... It would involve dumping some memory structures for the session and comparing it with some other dumps from the listener threads. The point is... Why do you need it? What are you looking for.... ? In any case this would not be support…
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.…
Finding the Bad Queries
There are a couple of things you can do. The syssesprof table in sysmaster records the number of sequential scans for the session. You can search on that to find longer running sessions that repeatedly scan tables and then follow what queries that session is running. Another is …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Map temp tables to session
Understood, but rather odd. Internally created temp tables should be following TEMPTAB_NOLOG and be created in a temp dbspace. I note that others have posted queries to get you the links you need to track down the culprits. Art Art S. Kagel Advanced DataTools (www.advancedatato…
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,…
Monitoring IDS Load
Normal performance monitoring would include all of that and more including: onstat -P - to monitor which partitions have a dominance in the the cache and how much that presence is changing over time to determine whether more cache will improve performance Monitoring dbspace fre…
SQL TRACE with strange behave...
Hi John, Hmmm... this is very very useful and probally will solve all my problems with the trace. Looking at manuals I do not found anything... Can you tell us how disable the tracing over db scheduler?? Obs.: I get this SQL trace with : onstat -g his Regards Cesar On 18/7/2…
History of deadlock
Hi, can you help me one more time with deadlock? Can you tell me howto find specific sql command that made deadlock? I know command onstat -g ppf but i cant find the way howto change hex addr to more readable text.…
index in use when any SQL access it...
Hi, ifx 11.50 FC9X6 , AIX 6.1 I'm looking about use of indexes on some tables. The mainly objective is check if this indexes still needed and who use it. Then I using the commands bellow (in my own scripts) to try reach my objective: onstat -g opn onstat -t onstat -g ppf T…
index in use when any SQL access it...
Hi, ifx 11.50 FC9X6 , AIX 6.1 I'm looking about use of indexes on some tables. The mainly objective is check if this indexes still needed and who use it. Then I using the commands bellow (in my own scripts) to try reach my objective: onstat -g opn onstat -t onst…
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…
Problem with identifying root cause of continual m
original post: Hi to all, I have a problem with identifying root cause of continual memory consuming by db-sessions. Our OS: AIX Our IDS: 11.70.FC3 Application layer is Weblogic Application server and the interface is JDBC driver. During investigating this issue I was able to i…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Need a Help, Access login and sql traces
I am using Informix 11.50, but the system table should also be available in your version. I created a shell script and scheduled it every 10 minutes through the cron, it writes the output to a log which I monitor. . setdb.sh # Set environment to intended database echo `date` >>…
onstat -g ath
if ! kaio && ! auto aiovp then check to see if you have enough aiovps configured. onstat -g iov , the last few should not be relatively busy (< 1.0 i/o per sec.) usual suspects : check for hot spots on disk (onstat -g iof; onstat -D). check for seq scans (onstat -g tpf | awk '…
SQLI Version = CSDK version ?
Hi, Exists any documentation what show the relation between SQLI version showed at 'onstat -g sql' (F.E. Version) and CSDK version? We have versions like : 9.20 9.22 9.24 9.28 9.35 connected at our database. I know the 9.35 is relative to CSDK 3.50 . And the others ? How I ca…
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…
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.…
RE: Monitoring Queryplan onmode -Y
And it is in user u1's home directory, Art J. Found the error minutes ago: User name of u1 is 01020304. Write permission to /home/01020304 was set to 1020204 (see the missing "0"). Setting the write permission to 01020304 (only possible via uid 123 of that user) and it goes swimm…
Re: Monitoring Queryplan onmode -Y
It should be in user u1's home directory on the server host A Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, A…
Monitoring Queryplan onmode -Y
Hi all I am trying to monitor the optimizer query plan of a session with onmode -Y sid 1. With onstat -g sql I can see that the session changes the queries frequently. So I assume that each new query of the session will generate a query plan. This is what I want to see. Manual…
Viewing Running and Last Parsed SQL Statements
Hi Ernest, A more useful approach might be to use the SQL tracing facility (SQLTRACE and related parameters, tables, etc.) You can configure that to capture SQL for many subsets of users, including just a single session. That way you'd have a more complete and permanent record o…
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 insert increases the value of nreads in onstat -u
Hi, I have a esql/c program that run this sql (output of onstat -g ses): Insert into cs_nyd_disg_ofi(cod_periodo,grupo_datos,numero_cliente,monto_a_compensar,di ......pond_t_pro_e,di_pond_d_pro_e,nhs) values(?,?,?,?,?,?,?,?,?,?....,?,?,?,?,?,?,?,?,?,?,?,?,?) When I r…
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…
Re: onstat -g sql output - host variables section
On Mar 4, 12:41 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > What makes you sure that the application is not passing the variables in the > wrong order? > Regards. > > > > > > On Thu, Mar 4, 2010 at 5:20 PM, Tom <tlow...@munis.com> wrote: > > Greetings, > > > I thought tha…
onstat -g sql output - host variables section
Greetings, I thought that the variables listed in the "Host variables" section aligned with the fields given in the "Current SQL statement" section located just before the "Host variables" output. But, as shown in this example, this does not appear to be the case. I looked at th…
How to check informix DB bottlenecks
Hi All, How to check the informix tables for bottlenecks? i am having problem our database and the user are explaining that it is a DB problem. I verified the logs and there's no valid error on the log file... I've used onstat -g sql, onstat -g ses, onstat -g lmx, onstat -k for…
Re: Drop table from temp dbspace
On Feb 18, 6:11 pm, Superboer <superbo...@t-online.de> wrote: > Ooops i was too trigger happy ignore the prev. posting please > > Superboer > > On 18 feb, 14:04, Superboer <superbo...@t-online.de> wrote: > > > > > Hello Jose, > > > are you sure that it is a temp table?? > > > if …
Drop table from temp dbspace
Hello Jose, are you sure that it is a temp table?? if you gointo dbaccess and choose the database xxx(if possible...) is there a table present that is called _temptable??? if that is the case you can use sql to fix the issue. also if that is the case then temp1dbs is not a rea…
how to analyze bottleneck in informix db
Hi All, I'm curious about on how to analyze a database which has bottlenecks... On my perpective, i'll do the ff: 1. onstat -u -- to check what user. 2. onstat -g ses -- to check the current session. 3. onstat -g mem -- to check the memory. 4. onstat -k; to check the processes …
Help with debugging Queries
Yes, in the output from onstat -k you see a column called owner. You can grep this value from an onstat -u output. The output from onstat -u will include session ids (I think in column 1 but I can't run the cmd right now) that can be used with onstat -g sql to determine what sql …
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…
Table accessed
I am pretty sure that version of Informix has the onstat utility. When a session connects to the database look at the output from onstat -g sql, locate the session id of the connected user and then run onstat -g sql <session id>. If the user is accessing a table it will show up t…
onstat shows memory held by finished sessions
Hi, I am using IDS 11.50 on HP-UX 11. The onstat -g ses shows the sessions which are complete. For example the program is finished but still the onstat -g ses shows insert session. The session details show it as "current SQL statement". Is the session still holding the memory? I…
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…
Informix virtual shared memory
> You need to find out where the repeating SQL is coming from by > tracking back the session number to a process using onstat -g ses and > beat the developer up! Hope its not something I wrote many years ago…
Error sql -998 (???)
Hello, everybody!!! I´ve recently monitored one instance of IDS 11.50.FC4, running on linux 64 bits, and sometimes appears a session like this: Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 76986 - - - Wait *-998* 0 9.35 Off But wh…
Connection Pooling with the .NET Provider on IIS
MC, Your complaint is that a connection pool does what a connection pool is supposed to do. Essentially you're telling the waitress that you want a stack of pancakes and a coffee, and when she brings your order, you complain that its a stack of pancakes and a coffee. ;-) In str…
Open SQL Statements
There is nothing inherently wrong with a session having open statements, even many such. I wrote a middleware server while at Bloomberg that prepared about 10,000 statements at startup so that they were available to client programs already optimized and ready to run. This is a co…
Identify long-running SQL statements in IDS 10.00
I don't presently have any monitoring tools like Sentinel or DBSonar, but I do need to be able to identify sessions / SQL statements that are long-running using the onstat commands. I'm currently on Informix IDS 10.00.FC5 for HP-UX, so I can't use OAT :o( If you have a process o…
connections to specific database
>Hi, > >I'm trying to find out, how I can monitor the connections to a specific database. onstat -u only gives information fo entire IDS. It sounds like something trivial but I just can't find it. > >thanks for any help >Dagmar There isn't a built in way to do that. All the onst…
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 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…
Track activity on a particular table
This should get you going, the trick is that DBINFO('sessionid') returns the current users session id. select sid, username, uid, pid, hostname, dbinfo('UTC_TO_DATETIME', connected) from sysmaster:syssessions where sid = DBINFO('sessionid'); John ids-bounces@iiug.org wrote o…
DB Monitoring
Hi, The first thing you have to know the session id of the connectio tester... After that you can use the commands to see db activities and sql statements running: Use 'grep' if the OS is Unix or Linux , use 'findstr' if the OS is windows onstat -u | grep <session id> (regard …
btree invalidation
On 22 Dec, 21:05, roger_vi...@yahoo.es wrote: > I have the following line in the output of onstat -g mem > > btree inval V c000000054330028 1745338368 149991704 1704431 > 213054 > > I'm care about that because the last week the number of memory > segments (onstat -g seg) has…
temporary table display problem in 'onstat -g sql'
could anyone help to answer the question ? 1) the customer execute the sql "select * from pobms into temp objtmptbl with no log" in instance 73mcbs without exit dbaccess , this instance justly has on temporary dbspace. a) onstat -c |grep TEMP return the following informationA…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Kill inactive persistent sessions
I think I spotted this SQL on www.informixfaq.com. Worked fine with IDS 10. Goes against the sysmaster db. set isolation to dirty read; SELECT -- s.sid as sid, s.username[1,10] as user, q.odb_dbname[1,10] database, s.tty[1,12] as tty, -- dbinfo('UTC_TO_DATETIME',s.connected) …
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…
help ! How can capture the SQL?
SHAN SALEON wrote: > Thank you for upstairs ! > My IDS version : 10 > OS: HP-UNIX > > Andrew Grantham can you send me your scrips . my e-mail: shanshl@msn.com > Thanks > The only way is to capture ALL of the SQL for the offending session and rerun the queries using SET EXPLAIN O…
"Dynamically added new Virtual segment "question
> What do I do? (and don't start me on onmode -F on HP-UX!!!!!!!!!!) > First off is onstat -g seg to find the address of the new segment, no > problem. > But once I've done that, what's the next move? > I'm guessing onstat -g mem and find out what processes have a pool > starting…
Re: Informix Session Information
Marco Greco wrote: > Fernando Nunes wrote: >> Marco Greco wrote: >>> Dave wrote: >>>> Hello, We have the following situation. Our 4GL developers have a need >>>> to identify and save in a variable the current session isolation >>>> level. If the isolation level is not "dirty rea…
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 > …
Re: Informix Session Information
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 in4mixdba@gmail.com On 10/16/07, M…
Informix Session Information
Dave wrote: > Hello, We have the following situation. Our 4GL developers have a need > to identify and save in a variable the current session isolation > level. If the isolation level is not "dirty read" they would set it > to dirty read. Then they would execute some lines of c…
Vendor JAVA Apps eating up Shared Memory.
Hi, Not sure if I can help you, cause you gave too little information about the JAVA apps and their session pool. Just one thing I have been running in in the past: In Java, you have to close all statements, preparedstatments, resultsets etc. to free up shared memory. In case yo…
How to audit the operation from dbaccess or isql
They can certainly write a monitor that looks for new sessions in syssessions and tracks down the pid/host/user combination to determine who is running dbaccess/isql and from there to see what SQL they are running. However, such queries are intrusive, hurting performance, if run …
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…
Re: onmode -Y
On 14 Apr, 02:04, Floyd Wellershaus <fwell...@yahoo.com> wrote: > First stack, while it was doing an insert to one table: > Stack for thread: 660906 sqlexec > base: 0x07000003989dc000 > len: 36864 > pc: 0x0000000100056518 > tos: 0x07000003989e2c70 > state: running > …
Re: onmode -Y
First stack, while it was doing an insert to one table: Stack for thread: 660906 sqlexec base: 0x07000003989dc000 len: 36864 pc: 0x0000000100056518 tos: 0x07000003989e2c70 state: running vp: 4 0x0000000000000000 Next stack, when the process is hung, while it is doin…
onmode -Y
I've been monitoring a problem process, and issued an onmode -Y sessionid 1, for the session that process is using. When the process hit the next query, it output to the sqexplain.out.sessionid file. But now the process appears hung, and the onstat -g sql sessionid shows a new …
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…
querying sysmaster to get last sql executed
Hi all, Does anyone know how to get current or last sql sentence execute by a session? I know that onstat -g ses <session id> shows it, but I want to get it trough sysmaster. is it possible? Regards…
IDS is busy all the time
Hi, I need a hint. Maybe somebody has had the same or a similar problem: We have an IDS 10 Server which has been running with a load of about 15 % until some days ago. Suddenly (without a config change), the load is > 50 % all the time. We shut down the engine and the load went…
Autogenerated keys
Tracked it down, some library code was not doing what I thought it was. Very annoying. Thanks. On Wed, 2006-12-13 at 10:01 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > So with that definition, if you insert a row with: > > INSERT INTO li_stu_geggrps_rec (group_id) values (0)…
AW: find session_id, ip, machinename
onstat -g sql shows session id (SID) and database. onstat -g ses shows SID, user, process id (PID) and hostname. Type onstat -g sql SID or onstat -g ses SID to get more info about a single session. -----Ursprüngliche Nachricht----- Von: informix-list-bounces@iiug.org [mailto:in…
identify sql process/syntax that consumes biggest
Hi, Execute onstat -g ses and you will see the memory consumption per session. To see the last sql of a session, call onstat -g sql <sessionid>. To identify which sql in particular leads to the memory usage, is not that easy. It depends on Multiple factors, e.g. if large sorts a…
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…
A question of load . . .
We had similiar problems too. What happen was one 'power user' was running Cognos Impromptu query, using non-standard catalog to create her own report, therefore, generating excess number of 'outer join' and suck out all CPU. Next time happen, you can run 'onstat -g act' to see w…
To Print last executed SQL Query
Hi, You could use first onstat -u and find the session Id of= the running process on Informix. Then onstat -g sql [session id]= You will see the error numbers for SQL and ISAM= , and the last sql statements Luis Panozzo Saavedra= Gerente T=E9cnico Soluciones Integrales S= …
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…
Re: ISAM Error SQL error -243
I am sure that the program is not multi-threaded. And yes the program is failing on the same table with the locking error. No other program is running simultaneously. The program itself is a sequencial sql statements embedded in a c-program. ARE there any chances that a SQL state…
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?…
UNSECURE_ONSTAT
Greetings, HPUX 11.11 9.40 FC7 Is there a onconfig parm available in 9.40 that will allow non dba users to run onstat -g sql commands without them being apart of the group informix? Last thing I want to do is add a user to group informix! Thanks…
onstat -g sql
problem : We have a user who has dba rights on his database.(Informix version 10) He can execute the "onstat -u" command to see which users are active. Now he's asking to have have the possibility to do "onstat -g sql" to see more detailed what the users are doing. This we can n…
Re: Informix session VS 'oninit' CPU usage
One more thing: you can use onperf to monitor session activity, it could help you a little. "Rupan3rd" <rupan.nospam.3rd@hotmail.com> wrote in message news:n2tYf.49175$nz4.46626@tornado.fastwebnet.it... > Hi Gurus, a question for you. And sorry in advance if it has been already…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: 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!…
Tool to Record Database changes (inserts, deletes, etc.)
What plateform / Informix version ? Use can try onstat -g ses <sessionid> if you know session id or you can run a script with a loop with following statement: onstat -g stm Probably tools you can use Server Studio, SQL Power Tools, may be some more. There are some other optons…
Re: IDS and Server Studio
I've demoed it on my laptop to 2 customers now before now and they seems to both be planning to use it. Something that unskilled people can use to monitor space, sessions and locks. Gotta have a GUI Enterprise Manager like Oracle/SQl Server! I like it as it is simple to setup …
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: Subject: Re: OT: Don't create tables owned by informix -
Write a C program that runs onstat -g ses argv<1> that takes one parameter, makes sure it is up to 8 character long and it is all digits.....easy! Also a seperate replacement for onstat -g sql that does the same validation. Love Dave. PS Was thinking about this today. How…
Upgrade to 9.40, next question......
Colin Dawson wrote: > I seem to recall that onstat -g options are restricted, where is it > documented and can it be changed? > > ~] onstat -g ses > > IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up 1 days > 22:04:12 -- 3212288 Kbytes > > Must be a DBSA to run t…
onstat -g sql equivalent for tbstat
Hi, I am using IDS 5.x on Linux (red hat 7.1) I would like to monitor the sql statements being run by some process I know in IDS 9.x you can do a onstat -g sql, then a onstat -g ses <sesid> However this option is not available with IDS 5, or that informix toolset. Neither does t…
Re: informix - tool like SQL server profiler
Check the manuals, but basically onstat -- (double minus) will list all possible commands. onstat -r 'n' is repeat command every 'n' seconds so onstat -r 5 -g sql will list the sql for all processes every 5 seconds Regards Colin There are 10 types of people in the world, those…
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:…
See placeholders in IDS 9.30?
ahum... $ onstat -g dmp 0x13407a18 rstcb_t |grep scb scb = 0x0x139d6e88 $ onstat -g dmp 0x139d6e88 scb_t |grep sqscb sqscb = 0x0x139e3018 sqscb_poolp = 0x0x139e4410 $ onstat -g dmp 0x139e3018 sqscb_t |grep host nhost = 1 hostnum …
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…
onstat -g sql :showing two versoins for F.E Vers
Hi, When I give onstat -g sql it displays two different F.E Vers 7.32 and 9.28. I am not sure what's going on or what does that mean - can some one explain or give me some pointers. Other Details : bash-2.03$ uname -a SunOS fgru70802 5.8 Generic_117350-22 sun4u sparc SUNW,Ultr…
When is sql statement cleared from sysmaster
When is the sql statement cleared from sysmaster? I am doing onstat -g ses and onstat -g sql for a session and there is no sql statement shown. Does that mean that this session has never run an sql statement? I am particularly interested as I have a web application front-ending…
Re: Cannot DROP database
kadu wrote: > I've found that we are using an Enterprise Replicatio (ER). So It's > reason why I can't drop it. All of you right said that anything is > using it... But Why I can't see it with onstat -g sql? onstat -g sql only shows connections that run sql.…
Re: Cannot DROP database
kadu wrote: > I've found that we are using an Enterprise Replicatio (ER). So It's > reason why I can't drop it. All of you right said that anything is > using it... But Why I can't see it with onstat -g sql? onstat -g sql only shows connections that run sql.…
Re: Cannot DROP database
I've found that we are using an Enterprise Replicatio (ER). So It's reason why I can't drop it. All of you right said that anything is using it... But Why I can't see it with onstat -g sql?…
Re: Cannot DROP database
obnoxio the output on onstat -g sql is apparently posted in the original post... informix@czhs0300: onstat -g sql Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:10:35 -- 372392 Kbytes informix@czhs0300: onstat -g ses Informix Dynamic Server Version 7.31.UD7…
Re: Cannot DROP database
obnoxio the output on onstat -g sql is apparently posted in the original post... informix@czhs0300: onstat -g sql Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:10:35 -- 372392 Kbytes informix@czhs0300: onstat -g ses Informix Dynamic Server Version 7.31.UD7…
Cannot DROP database
I've found that we are using an Enterprise Replicatio (ER). So It's reason why I can't drop it. All of you right said that anything is using it... But Why I can't see it with onstat -g sql?…
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…
Re: Which thread consumes the most CPU time?
Wait statistics tells you the time in microseconds that threads spent in several different run states: running, ready to run, waiting for buffers, etc. To get the time for state running, you can use the sql that roeferr@ig.com.br just sent (I modified it a little): database sys…
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…
IDS 9.40.uc4 'onstat -g sql'
Hi all... I just installed the above release...once my development team started banging on it they quickly noticed they could no longer do an 'onstat -g sql xxx' ... command comes back and tells them they bust be a dba...I contacted IBM support and they verified that this is how…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
onstat -z via sql command?
Hi, is there a SQL command to reset the statistics like "onstat -z"? I got some scripts with selects from the system tables and it would be fine if these tables are reset just before the selects. I know, I could start a cron job for "onstat -z", but then I have two things to …
Catching runnig SQLs
Consider using I-Spy. See http://www-306.ibm.com/software/data/informix/tools/ispy/ From the manual: I-Spy provides the following query monitoring and control features: - Logging SQL statement text and various statistics related to the statement, such as total time of execu…
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…
Ostat -g sql
Hi, Running onstat -g sql returns the command that the session runs. Do you know from which sysmaster table it gets this information? Thanks, Vasilis…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: MAXIMUM SESSIONS
"Hamid HABZI" <HHABZI@bmcebank.co.ma> wrote in message news:<cane4a$jtv$1@news.xmission.com>... > Hi, > How can i know what is the maximum number of sessions in a period of time. > IDS 7.31.UD6 on AIX 5.1 I use the following SQL against sysmaster: SELECT COUNT(*) FROM sysses…
Re: Informix tool related question
Repost from partners@iiug.org: Hi Rob. Which version of Informix are you using? On what platform? If it is recent, you can use "onstat -u" to get the session ID, and then "onmode -Y sessionid 1" to turn on "dynamic explain", so that the query optimiser appends its plans to the …
Informix tool related question
Rob, if your database is IDS 9.40, you can dynamically turn on sqlexplain with onmode -Y, followed by a onstat -g stm <sessid>. I have not done it, i'm not on 9.4 yet, but i hear that's a feature. by doing that, you wouldn't need the source code recompiled to run with "set explai…
RE: onstat -g sql in 9.4
SYSSQEXPLAIN still exists in 9.40 sqx_sessionid 40 sqx_sdbno 0 sqx_iscurrent N sqx_executions 0 sqx_cumtime 0.00 sqx_bufreads 0 sqx_pagereads 0 sqx_bufwrites 0 sqx_pagewrites 0 sqx_totsorts 0 sqx_dsksorts 0 sqx_sortsp…
Re: onstat -g sql in 9.4
I spoke with support this morning. They confirmed that UC5 will have the fix, but that UC5 availability is a few months out. The good news is that there is a fix available for UC4. Thanks for all of the feedback. Bob scottishpoet <dryburghj@yahoo.com> wrote: : Yes, please log …
RE: onstat -g sql in 9.4
I will be testing 9.4 in the next few days and I will need this feature. Does anybody know if the sql_stmt fields have been removed from sysmaster. Regards Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of …
RE: onstat -g sql in 9.4
I was looking at this very topic today in 9.30.FC5 (I think) and certainly the current and last sql statements are present in 9.30 Which was very useful as it helped me to find a problem - no solution, just the problem Regards malcolm -----Original Message----- From: owner-inf…
Re: onstat -g sql in 9.4
I reported this as a bug about six months ago. Bug: 165499 DBACCESS - LAST PARSED SQL STATEMENT DOES NOT SHOW UP IN ONSTAT -G SQL OR ONSTAT -G SES They said it should be fixed in 9.40.UC5 Do call an open a case to make sure they get it coded in this release. Thanks bothwelln…
Re: onstat -g sql in 9.4
bothwellno@spam.duke.edu wrote: > We use the output from onstat -g sql <sessid> to assist with > problem resolution. > The value of 'Last parsed SQL statement' is very helpful to find > problematic SQLs. > > We are upgrading from 7.31 (AIX 4.3.2) to 9.40 (AIX 5.2) and have > not…
onstat -g sql in 9.4
We use the output from onstat -g sql <sessid> to assist with problem resolution. The value of 'Last parsed SQL statement' is very helpful to find problematic SQLs. We are upgrading from 7.31 (AIX 4.3.2) to 9.40 (AIX 5.2) and have noticed that in version 9.40, the 'Last parsed SQ…
Re: Server Studio - newbie question
The latest version of Server Studio JE 4.0 (with Sentinel performance monitoring server) is available at: www.serverstudio.com/downloads.html Server Studio JE is a client-based product. It can connect remotely to multiple IDS instances. Unlike ISA, it does not require any Infor…
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…
Washington (DC) Area Informix Users Group - Forum 2004 - Wednesday,
Solutions for IBM Informix and DB2 Users A One-Day User Group Technical Conference Wednesday, April 21, 2004 8:30 AM to 5:00 PM Northern Virginia Community College 8333 Little River Turnpike, Annandale, VA You are invited to join us for the largest convocation for IBM database …
Re: onstat -g sql : garbaged characters
Mehrab Bucktowar (DHL UK) wrote: > I'm running IDS9.21 HC5 on HPUX11.0. From time to time I to notice > garbaged characters in the "Current Database" column when using a > onstat -g sql. > There's no error in the log file. Is it sign of something going > wrong? Most likely. > A…
onstat -g sql : garbaged characters
I'm running IDS9.21 HC5 on HPUX11.0. From time to time I to notice garbaged characters in the "Current Database" column when using a onstat -g sql. There's no error in the log file. Is it sign of something going wrong? Any idea? thx/rgds mebs sending to informix-list…
onstat -g sql : garbaged characters
I'm running IDS9.21 HC5 on HPUX11.0. From time to time I to notice garbaged characters in the "Current Database" column when using a onstat -g sql. There's no error in the log file. Is it sign of something going wrong? Any idea? thx/rgds mebs sending to informix-list sending to…
onstat -g sql : garbaged characters
I'm running IDS9.21 HC5 on HPUX11.0. From time to time I to notice garbaged characters in the "Current Database" column when using a onstat -g sql. There's no error in the log file. Is it sign of something going wrong? Any idea? thx/rgds mebs sending to informix-list sending to…
Re: ER and onstat -g sql
This problem got fixed in 9.21.UC7. Bug number is #115253. Regards, Nagaraju "Mr Tricky" <mr_tricky@hotmail.com> wrote in message news:<pan.2003.02.18.10.26.09.635708@hotmail.com>... > I've just switched some of our servers from HDR to ER to put a 3rd server > into the mix. Eve…
ER and onstat -g sql
After recently switching from HDR to ER (needed a third server online) I've noticed that I'm getting the "Changing data structure forced command termination." message far more often than I used to, every time I run it in fact. I was just wondering if anyone else has noticed this…
ER and onstat -g sql
I've just switched some of our servers from HDR to ER to put a 3rd server into the mix. Everything seems to be running dandy, only when I run onstat -g sql I almost invariably get the "Changing data structure forced command termination." message. Has anyone out there seen this b…
User Group Technical Conference - WAIUG Forum 2004
Washington (DC) Area Informix Users Group - Forum 2004 Solutions for IBM Informix and DB2 Users A One-Day User Group Technical Conference Wednesday, April 21, 2004 8:30 AM to 5:00 PM Northern Virginia Community College 8333 Little River Turnpike, Annandale, VA The Washington D…
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,…
Washington Area Informix Users Group Forum 2004 - April 21, 2004
Solutions For IBM Informix and DB2 Users A One-Day User Group Technical Conference Wednesday, April 21, 2004 8:30 AM to 5:00 PM Northern Virginia Community College 8333 Little River Turnpike, Annandale, VA Pre-Registration: $20 - must be postmarked by April 12, 2004 On-Site Reg…
Washington Area Informix Users Group Forum 2004 - Technical Conference
Wednesday, April 21, 2004 8:30 AM to 5:00 PM Northern Virginia Community College 8333 Little River Turnpike, Annandale, VA Pre-Registration: $20 - must be postmarked by April 12, 2004 On-Site Registration: $25 - all registrations after April 12, 2004 Solutions For IBM Informix …
Washington Area Informix Users Group Forum 2004 - Technical Conference
Wednesday, April 21, 2004 8:30 AM to 5:00 PM Northern Virginia Community College 8333 Little River Turnpike, Annandale, VA Pre-Registration: $20 - must be postmarked by April 12, 2004 On-Site Registration: $25 - all registrations after April 12, 2004 Solutions For IBM Informix …
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…
Washington (DC) Area Informix Users Group Forum 2004
Solutions For IBM Informix and DB2 Users A One-Day User Group Technical Conference Wednesday, April 21, 2004 8:30 AM to 5:00 PM Northern Virginia Community College 8333 Little River Turnpike, Annandale, VA Registration: $20 - must be postmarked by April 12, 2004 The Washington…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
RE: java app shuts down Informix Server
Mel, if what you're seeing looks like this: 07:00:42 Assert Failed: No Exception Handler 07:00:42 IBM Informix Dynamic Server Version 9.40.HC2 07:00:42 Who: Session(10, informix@myserver, 0, ce9ed5a0) Thread(15, btscanner 0, ce9bd26c, 1) File: …
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?…
Re: IDS Performance problem
Nothing you mention here specifically indicates a problem. If you know how to use dbaccess, run it and select a database. Use another session to take a look at what your backend process is doing. You will find that it is in exactly the state you describe below. This status will …
IDS Performance problem
Hi, I have performance problems with on IDS 9.30 on hpux. When i look current sessions with onstat -g sql somme are always with status cond wait(netnorm) and wait more than 1000 times. What is meaning for this status ? When i look all waiting sessions on threads with onstat -g …
[HELP] What my Informix is doing?
On 11 Sep 2003 02:54:04 -0700, steven@steven4u.net (steven) wrote: >My system is SCO OSR5 + Informix Online 7.x with 128M ram. The >database is created w/o loging. > >Is any method here let me know what the Informix is doing? > Try with some "onstats": onstat -p onstat -u ons…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Informix profiling / debugging - speed of sql statements ?
Hi out there ! After my bad experiences with informix on linux (no KAIO, SMP not runnning with 9.30) i tried to improve speed on a complex database . onstat -u shows all sessions and onstat -g sql SESSIONID shows all SQL statements one user lets run - so says the manual. In pra…
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…
Re: IDS license count per user or per session?
The answer, as with so many other things, is: "It depends." Generally, unless you push, claw, scratch, and battle, the answer winds up being "whichever is greater." For MOST applications, the number of concurrent sessions is greater than the number of actual simultaneous users…
Re: SQL in onstat -g ses output
Josi Kyllerd wrote: > Dumb question time: What is the difference between "Current SQL statement" > and "Last Parsed SQL statement"? Usually the SQL is identical in both but > I've always wondered why sometimes this is not the case. And why might > only Last parsed SQL statement b…
SQL in onstat -g ses output
Dumb question time: What is the difference between "Current SQL statement" and "Last Parsed SQL statement"? Usually the SQL is identical in both but I've always wondered why sometimes this is not the case. And why might only Last parsed SQL statement be displayed as in the output…
Re: Merant ODBC Drivers?
When looking at an Informix Online instance, onstat -u or onstat -g sql - what am I likely to see if there are 100 users with the Merant odbc driver on their desktops? I think it's 'Datadirect'? (This includes you Obnoxio...) Does this product use 'connect/disconnect' in such a w…
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…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix 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…
real-time monitoring of SQL commands?
Try onstat -g sql {session id} -r 1 That actually lists the SQL statement itself. To get better than 1 second granularity, you need to run set explain on from within your program or a stored procedure. This puts every SQl command out to a sqexplain.out file. Regards, Ray "M…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
pooled connections and prepared statements
stormchaser wrote: > Thanks for your informative reply. I am disappointed that user > statement re-use is required, since the database should be smart enough > to do that for me. Do you know if preparing *each time* might result in > better cache performance? In other words, doe…
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…
UPDATE STATISTICS and Error -647
I have a script that performs the following statement: UPDATE STATISTICS MEDIUM FOR TABLE p3e DISTRIBUTIONS ONLY; From onstat -g sql I get a -647 in the SQL ERR column. Could someone explain, please? The platform is: Online 7.24.UC5 Sun 5000, Solarius 2.6 Thanks, Paige Miller…
is there a Trace Utility in informix? (newbie)
Daniel, 3 possible tools : 1) from UNIX shell onstat -u onstat -g sql session_id onstat -g ses session_id 2) I-Spy 3) (if you have X Windows installed) oncockpit/onperf Best regards, Sergey <daniel30@my-deja.com> wrote in message news:8kk8q9$6os$1@nnrp1.deja.co…
Re: SHMTOTAL
I had also talked to someone at Informix years ago about SHMTOTAL. They said that it was not a good idea to specify it because when Informix got close (don't know details) to having used SHMTOTAL amount of memory that everything got very SLOW and there was no message anywhere i…
Re: Monitoring lock tables
Leonid Vorontsov wrote: > There is syslocktab table in sysmaster database, but unfortunately this > table is undocumented. > Explain columns in this table, please. And write an SQL statement for > monitoring all locks > with session, table, lock type if You can. Well, all right…
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…
Re: result of onstat -g sql xxx
Daniel Willems wrote: > > Created by BaaN is the following sql statement: > > UPDATE {+ INDEX( tiitm0011001abaan) } "baan".tiitm001100 SET t_llci > = ?,t_mrpi = ? WHERE t_item= ? Oh PLEASE don't tell me Baan are using Optimiser Directives, please! :-( > Is Infomix u…
result of onstat -g sql xxx
Created by BaaN is the following sql statement: UPDATE {+ INDEX( tiitm0011001abaan) } "baan".tiitm001100 SET t_llci = ?,t_mrpi = ? WHERE t_item= ? Is Infomix using index tiitm0011001abaan when updating table "baan".tiitm001100 ? -- *** remove spam twice when replyi…
onstat -g sql <id>. Can I get more than just the last statement
I'm tracking a problem with GL_DATE and DBDATE screwing up, and am focusing on what the SQL being passed via ODBC looks like after it's been parsed by the server. Unfortuntaley, onstat -g sql <id> only shows the last statement for a given id, and I'm interested in a bunch of sta…
Re: Sql statement on onstat -g ses command
Are you executing onstat -g ses <id> -r 1? Try onstat -g ses <id> -r Vinod Bhansali >From: dyrson.alves@telemigcelular.com.br >Reply-To: dyrson.alves@telemigcelular.com.br >To: informix-list@iiug.org >Subject: Sql statement on onstat -g ses command >Date: Wed, 14 Jun 2000 18:36…
Re: Sql statement on onstat -g ses command
Are you executing onstat -g ses <id> -r 1? Vinod Bhansali >From: dyrson.alves@telemigcelular.com.br >Reply-To: dyrson.alves@telemigcelular.com.br >To: informix-list@iiug.org >Subject: Sql statement on onstat -g ses command >Date: Wed, 14 Jun 2000 18:36:39 GMT > >The output belo…
Sql statement on onstat -g ses command
The output below is from a onstat -g ses <id> command. Note that in the last line the there aren't the Current SQL statement and the Last parsed SQL statement. The output just shows "Changing data structure forced command termination." Does someone knows what this means? The sele…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Server Studio - IDE for DBAs and back-end developers
Server Studio for Informix is an integrated development environment (IDE) for DBAs and back-end developers. It is utilized in database schema management, stored procedure development and debugging, maintenance and optimization of Informix server-side applications deployed on any …
Estimating table access?
Geoff Wilson wrote: > Oracle stores the SQL text strings of queries that are run on the database. It > also stores information attached to them about how many times they were run. > The idea is so that you can monitor how much work the parser is doing, but > it is also useful as…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
DBEXPORT PROBLEM
Thanks!! But where can I get "myschema.ec" Vic. "Stefan Weideneder" <stefan@weideneder.de> wrote in message news:38E3B34A.B6831AE@weideneder.de... > Victor Hugo Paredes Paz wrote: > > > > I need some help here. > > > > * I am trying to dbexport my database. > > * I am workin…
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…
Server Studio for Informix
Server Studio for Informix is an integrated development environment (IDE) for DBAs and back-end developers. It is utilized in analysis, development, troubleshooting, maintenance and optimization of Informix server-side applications deployed on any platform. Server Studio features…
RE: Finding CPU hogs
Look at onstat -u and note the user processes that are running. Particularly note the users with large numbers of read and write activity. If you want more, then onstat -g ses {sess-id} to find the sql they are running. If a repeat says the same sql , then you likely have an ap…
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…
Error -256
In article <388C898D.35337451@bloomberg.net>, kagel@bloomberg.net wrote: > r_pastore@my-deja.com wrote: > > > > Hi, > > I'm seeing error -256 when monitoring (onstat -g sql) an > But onstat -g sql will give you the session id. The run onstat -g ses <sid> > and the pid…
Zero Impact Sql Monitor detects HACKER Database Login Failures
Zero Impact Sql Monitor detects HACKER Database Login Failures ============================================================== The Zero Impact Sql Monitor from Sql Power Tools automatically alerts organizations to HACKER login failures to database servers. The Zero Impact Servic…
RE: onstat -g sql
One of the reasons I ask this question is due to the fact when I do an onstat -g sql I have sessions with current queries, but onstat -g con shows them to be waiting on sm_read or netnorm. I thought that meant they were waiting for requests. Why would they wait for requests as w…
onstat -g sql
My question is about Current SQL: I have always wondered what defined whether or not an SQL statement was CURRENT. It seems for a select, it is their until I close my cursor. But how about for an update or an insert? At what point (from the clients perspective) does the SQL sta…
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…
DB-SuperVisor
Hello Informix Users, I just saw a message go by from somebody wanting a tool to track informix sessions and asking about the use of ISPY. This is a message to all of you Informix users. You have been looking for an easy to use graphical product to supervise your Informix Dynam…
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…
Last parsed SQL statement
When onstat -g sql <sessionid> is executed is gives the Last parsed SQL statement. Is there anyway of querying the sysmaster database to get this statement?…
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…
Memory Fault
We're running Informix Online 7.24. The database is really busy, but whenever we use commands such as oncheck -pe or for that matter any of the oncheck commands we get a Memory fault. When we do other commands like onstat -g ses or onstat -g sql we get a message that essentially …
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…
Help! Locks
Informix Gurus: I am trying to drop a database and I am getting an error because someone has a lock on a table or a session is just open within this database. I've tried using onstat -g sql and onstat -u to track down the lock, but no luck! I also tried selecting from syslocks i…
Re: Sql Loopback Monitor $799 introductory offer
Sql Loopback Monitor and Service Level Loopback Monitor for Solaris and AIX =========================================================================== Sql Power Tools is pleased to announce the release of the Sql Loopback Monitor and Service Level Loopback Monitor products. Th…
Utility to track all SQL
Does anyone know of a utility that can simply log every command the engine processes to a file or STDOUT? Basically I'm looking for something like the output of onstat -g sql xxx in a real time mode. I've checked the IIUG site and didn't see anything (but I didn't search that t…
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
Since oninit will run many Informix threads, it would be difficult to determine which thread is running on which oninit. My guess would be that some combination of onstat -u, onstat -g ath, or onstat -g ses would give you what you need. John Carlson Informix DBA WHSmith USA js…
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…
Performance Problem
In article <7ju9ts$7uo$1@news6.svr.pol.co.uk>, Callum <callum@online- home.freeserve.co.uk> writes >I am running IDS version 7.24 UC6-1 on a dual processor RS/6000 (AIX 4.2) >with 512M of memory, the only thing running on the system is Informix. The >problem I have is that the p…
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…
SPL Workstation! Develop, debug, analyze and optimize server-side applications.
SPL Workstation is a visual productivity environment for Informix DBAs and developers. It is utilized in analysis, development, debugging and optimization of Informix server-side applications deployed on any platform. SPL Workstation runs under Windows 95/98 or NT and features th…
Re: Capturing SQL
Javier Puente wrote: > > You can access this information by making : > 1.- onstat -u To get the session conection id > 2.- With the sessionid you can trace SQL tasks by doing > onstat -g sql sessioid > EX: > onstat -u |grep myuser > > ---Supposing that sessionid is…
Re: Capturing SQL
You can access this information by making : 1.- onstat -u To get the session conection id 2.- With the sessionid you can trace SQL tasks by doing onstat -g sql sessioid EX: onstat -u |grep myuser ---Supposing that sessionid is 123 onstat -g sql 123 -r 1 Regards J…
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: The last executed SQL statement
From: "Art S. Kagel" <kagel@bloomberg.net> > >Obnoxio The Clown wrote: >> >> >How to obtain the last executed SQL statement? >> >> If you're using IDS, onstat -g sql <sessionid> or onstat -g ses >> <sessionid> > >Be careful using onstat -g sql on a multiprocessor machine with sev…
The last executed SQL statement
Thanks a lot for your information! Can I obtain the last executed SQL statement in a stored procedure? In article <7f79md$6d1$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > >How to obtain the last executed SQL statement? > > If you're using IDS, on…
Re: The last executed SQL statement
Obnoxio The Clown wrote: > > >How to obtain the last executed SQL statement? > > If you're using IDS, onstat -g sql <sessionid> or onstat -g ses > <sessionid> Be careful using onstat -g sql on a multiprocessor machine with several CPUS and many users. The query this creates aga…
Re: The last executed SQL statement
Once again to add to the Clowns' reply. run onstat -u and look for the userid in question, this will show y ou which sessionid to use in the onstat -g..... Terry Obnoxio The Clown wrote: > >How to obtain the last executed SQL statement? > > If you're using IDS, onstat -g …
Re: The last executed SQL statement
>How to obtain the last executed SQL statement? If you're using IDS, onstat -g sql <sessionid> or onstat -g ses <sessionid> HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
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: ZERO Impact Performance Monitor for Informix BETA program
> C.1 The functionality for the monitoring of a SHARED MEMORY CONNECTION > when the SQL was issued across the network (e.g. telnet session) will be > available next week. Okay, but wouldn't this also work for a network connection for a telnet session also? What relevance does …
Tracing ALL sql queries - is it possible?
Per the emails I received, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Pow…
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…
Re: ZERO Impact Performance Monitor for Informix BETA program
Chuck, Per your question, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Pow…
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…
Washington(DC) Area Informix User Group - Training Day is only 10 days away
The WAIUG Training Day is only 10 days away and its filling up fast. Advanced Registration is Required so we have a count of how many people are comming for the sessions and lunch. Please register at: http://www.iiug.org/~waiug/trainingday99.html --------------------------------…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: SeqScans Statistics 7.3_uc6
Hi again Matt, I am using 7.30.UC6 on HP-UX 10.20. I had very bad performance before installing HP patches (and mainly PHKL_16751). Could you tell me on wich system does your Informix DS run ? David... ----- Message d'origine ----- De : <mattb5@ozemail.com.au> � : <informi…
Re: Update - Washington Area Informix User Group - Training Day
Hi, Our user group is based in the Washington DC, Area but we have members and participants in our events from all over the country. You would be most welcome to attend. You need to check with the International Informix User Group web site for user groups in the Dallas Area and…
RE: Update - Washington Area Informix User Group - Training Day
Any such training in the Dallas, TX area? Uday -----Original Message----- From: Lester Knutsen [mailto:lester@advancedatatools.com] Sent: Sunday, February 28, 1999 2:12 PM To: Washington Area Informix Users Group Mailing List; Informix-List Subject: Update - Washington Area Inf…
Update - Washington Area Informix User Group - Training Day
Washington Area Informix User Group - Training Day Wednesday, March 24, 1999, 8:00 am - 4:00 pm University of MD, College Park, AV Williams Engineering Bldg. Training Day is a one day technical training event for WAIUG members at the University of Maryland during the …
SeqScans Statistics 7.3_uc6
In article <36D5C1A6.256D@bloomberg.net>, kagel@bloomberg.net wrote: > mattb5@ozemail.com.au wrote: Hi again Folks, I have tried all of the suggestions from this newsgroup and those suggested by Informix but still have tens of thousands of scans after upgrading to Informix 7.…
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…
RE: Washington Area Informix User Group - Training Day, March 24,
Is there a similar Informix user's group in Dallas, Tx? Uday -----Original Message----- From: Lester Knutsen [mailto:lester@advancedatatools.com] Sent: Wednesday, February 03, 1999 1:00 AM To: Informix-List; Washington Area Informix Users Group Mailing List Subject: Washington …
Washington Area Informix User Group - Training Day, March 24, 1999
Washington Area Informix User Group Meeting Plans Washington Area Informix User Group - Training Day Wednesday, March 24, 1999, 9:00 am - 4:00 pm University of MD, College Park, AV Williams Engineering Bldg. Training Day is a one day t…
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?…
Tracing sql statements
fprose@my-dejanews.com wrote: > > 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? dbaccess sysmaster - > select * from syssqexplain where …
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: matching sessions with databases
If you do an onstat -g sql, there is a column that tells you which database each session is connected to. So you could do an "onstat -g sql | grep <db>" to see which sessions are accessing a particular database. Sean Gilmour wrote in message <3655FF8E.AC274878@css.mot.com>... >…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
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: How to determine number of users/sessions?
Bob Gorman wrote: > > How can I query the Informix Dynamic Server inorder to determine the > number of users/sessions connected to a particular database environment? Use 'onstat -g ses' or 'onstat -u' to just look at connected sessions. To see who is connected to what database u…
Re: Monitoring lock tables
Leonid Vorontsov wrote: > There is syslocktab table in sysmaster database, but unfortunately this > table is undocumented. > Explain columns in this table, please. And write an SQL statement for > monitoring all locks > with session, table, lock type if You can. Well, all right…
Information on locking-conflicts
Hi group, I'm writing a small tool for monitoring our informix-application (printing cpu-utilisation per session, long-running sql, ...), using lots of information out of the SMI-tables. Yesterday I added code to print SQL-Errors; this works fine. Informix puts most Error-Info o…
Re: 4GL program crashes engine!
WF Software wrote: > What's in the online log?.... Nowt but the usual assert failure. I re-ran with AFDEBUG (which hangs the engine instead of crashing it, which allowed me to identify the "rogue" SQL from onstat -g sql. Neil…
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: Q:How to find list user sessions with database
]Steve Berg wrote: > > You could also use onstat -g sql instead of onstat -g ses <sessid>. Don't run onstat -g sql on a very busy server it will NEVER return and you will not be able to kill the session it starts! Because of the VERY dnamic nature of this particular table and t…
Re: Q:How to find list user sessions with database
You could also use onstat -g sql instead of onstat -g ses <sessid>. Steve Berg spb@nb.com On Wed, 15 Jul 1998, CONWAY Graham wrote: > Hi, > > Please excuse me if this is obvious. > > Does anyone have a simple way (sysmaster query or onstat option) of listing > the sessions on …
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Capturing SQL
Hi... We have a program which calls many subroutines from a library, all of which make SQL calls. We do not have the source for the library. I'm aware of onstat -g sql, but that give only a snapshot of the current SQL being executed. Is there a better way (or a tool) which exis…
Re: Monitor tools
In article <6ja8nl$irc$1@news.xmission.com>, Peter Tashkoff <TashkoP@kiwi.co.nz> writes > >You could go to the trouble of getting onperf going on your system, if you = >like GUI tools, personally I find them inefficient. >If you have a suspicion that you have a specific process …
Re: Monitor tools
You could go to the trouble of getting onperf going on your system, if you = like GUI tools, personally I find them inefficient. If you have a suspicion that you have a specific process that is hogging = resource the steps I take are to identify the active threads, then from = t…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: Update Statistics
Robertson Lee NTSE wrote in message <6fft5q$cus$1@news.xmission.com>... > >All, > >I have been left a large script by the Informix DBA to run. It does an >update statistics (low, medium and high) on all of the tables in the db. > >Is there any way I can monitor how this is doing …
Re: Update Statistics
Robertson Lee NTSE wrote: > > All, > > I have been left a large script by the Informix DBA to run. It does an > update statistics (low, medium and high) on all of the tables in the db. > > Is there any way I can monitor how this is doing as at the moment it is just > sat in dbacc…
Re: onstat -g sql
Tom Freestone wrote: > > When I do onstat -g sql, I get: > INFORMIX-OnLine Version 7.13.UC5 -- On-Line -- Up 22:52:58 -- 660024 > Kbytes > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR …
Re: onstat -g sql
Tom Freestone wrote: > > When I do onstat -g sql, I get: > INFORMIX-OnLine Version 7.13.UC5 -- On-Line -- Up 22:52:58 -- 660024 > Kbytes > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR …
Re: onstat -g sql
Tom Freestone wrote: > > When I do onstat -g sql, I get: > INFORMIX-OnLine Version 7.13.UC5 -- On-Line -- Up 22:52:58 -- 660024 > Kbytes > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR …
onstat -g sql
This is a multi-part message in MIME format. --------------0D1BC7E22DDAC0600B6A3858 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit When I do onstat -g sql, I get: INFORMIX-OnLine Version 7.13.UC5 -- On-Line -- Up 22:52:58 -- 660024 Kbytes Sess SQL…
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: Who is blocking ?
Rainer Schaub wrote: > > I can tell you the solution for OnLine. > Make a onstat -u and onstat -k. > The one who has a L , at onstat -u at the first position on > flags, is blocked. > You have to take the "wait"-adress of this process and have too look > at onstat -k at ad…
Re: Identifying problem sql's via onstat
I used the following sql in sysmaster db to identify sql using wrong or useless indexes: select sqx_sessionid, sqx_executions, round(sqx_bufreads/sqx_executions) bufreads, round(sqx_pagereads/sqx_executions) pagereads, sqx_estcost, sqx_estrows, sqx_index, sqx_sqlstatement from …
Re: Identifying problem sql's via onstat
Steve Gould <sg@leaderflush.co.uk> wrote in article <884685991.19482.0.nnrp-03.9e987eaf@news.demon.co.uk>... > Has anyone written a unix or awk script > to identify the link between a running unix > processes and sql statements which are > effecting performance. I can manually ru…
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: Identifying problem sql's via onstat
We are currently evaulating tools from Platinum's DBvision and BMC's Patrol. Hoping they give us some more info on it. But both product seems to have very little on Informix SQL drilldown in their tools. Anybody can share experience? Thanks. Chris Steve Gould (sg@leaderflus…
Identifying problem sql's via onstat
Has anyone written a unix or awk script to identify the link between a running unix processes and sql statements which are effecting performance. I can manually run onstat -u to give me the session id and then onstat -g ses sessid to give me that specific sql. But I can't identif…
Re: Monitoring all SQL statements
Assuming you're running OnLine 7.X, there are several ways. As one person suggested, if you can control the SQL, put a "SET EXPLAIN ON" at the beginning of the SQL and it will give you the statements run, as well as optimizer info, in a file called sqexplain.out. But if you had…
Re: Monitoring all SQL statements
Bill Ennis wrote: > > Yes, you can issue the SQL set explain on within the session you > wish to capture and the sql will be logged in a file named sqexplain.out > on the server machine. If you are running the queriues local to > the server the file will be in the current directo…
Re: Monitoring all SQL statements
Yes, you can issue the SQL set explain on within the session you wish to capture and the sql will be logged in a file named sqexplain.out on the server machine. If you are running the queriues local to the server the file will be in the current directory. If you are running from …
Monitoring all SQL statements
Is there a way on Informix to monitor all SQL statements done by a specific session. I'd like to catch them all to optimize those statements. Ricardo Palmeira <palmeira@tce.pe.gov.br>…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Easy Q: Dummy table?
"Richard Thomas" a �crit dans le message <62koso$tg@cssun.mathcs.emory.edu>... >Chad Chervitz wrote: > >> 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 …
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: Spooling all SQL Statements
In article <5kps14$jn0$2@gulfa.kuwait.net>, Rudy Fernandes <rferdy@kuwait.net> writes >In article <5ko05e$p9k@cssun.mathcs.emory.edu>, > lperson@mcny.com (Lou Person) wrote: >>We are sending sql statements to OWS from an >>application. Is there anyway to "spool" all sql >>stat…
RE: Spooling all SQL Statements
In article <5ko05e$p9k@cssun.mathcs.emory.edu>, lperson@mcny.com (Lou Person) wrote: >We are sending sql statements to OWS from an >application. Is there anyway to "spool" all sql >statements which are sent to the server? Meaning, >can we store all SQL statements, which OWS …
RE: IIUG - Track Session Announcement
Will these papers be available after the meet on the iiug server. Maybe they are normally but if somebody could update me as to where they are, I would appreciate it ... ---------- From: ilist To: informix-list Subject: IIUG - Track Session Announcement Date: Tuesday, April 15, …
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5j39eg$2sj@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes > > >In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams ><djw@smooth1.demon.co.uk> writes: >> >I can do a *moderate* comparison between Informix and Sybase (32 bit >> >port): >>…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: > >I can do a *moderate* comparison between Informix and Sybase (32 bit > >port): > > > >Sybase 11.0.X Informix 7.22 > >------------- ------…
IIUG - Track Session Announcement
As advertised earlier this year, the IIUG is sponsoring and conducting a technical track at this year's Informix Worldwide Users Conference (IWUC). The IWUC will be held July 22 - 25 in San Francisco CA. An open call for papers was issued oriented around our theme of "News You C…
Re: How to find which user is holding a database table?
Hi, You need to look at locks not SQL -since the onstat -g sql is limited to only the current and last SQL operations. If a transaction is in procress this is incomplete. You need to identify the table space for this table and check the SMI database for locks. -Bill } } Hi All…
How to find which user is holding a database table?
Hi All I have to do schema changes to a database which has lots of people = (developers). Most of the time there is no problem but sometimes I get = the message: 215: Cannot open file for table (tablename) 106: ISAM error: non-exclusive access from which I understand that some…
Re: Memory Leak
Venky9970@aol.com wrote: > > Hi, > > We are currently using Informix-Online DSA 7.11 UC1 on Unisys SVR4 1.4 > and are planning to migrate to Online DSA 7.20 UC2. Currently we are > bringing database down and up in our daily batch due to shared memory leak > in previous versions. …
Re: How do I find out which users are connected to a database
Hi, with Online 6 you can use onstat -u to determine the user thread number of the users. Then use this number as parameter for onstat -g ses to find the SQL-statement currently being executed. This should be sufficient to get the database name. I don't know if this works with O…
Re: out of virtual shared memory
In article <530p0d$o12@cssun.mathcs.emory.edu>, Ralph.Halter@pac.panmail.com writes >Hi all! > >We're running OnLine 7.10.UD1 on AIX 4.1.2 on an RS6000-J30 with 256MB memory >and 480MB paging space. There are 15 uniface developers/users filling about >50MB of logical logs per day…
Re: Executing stored procedures - performance problem
Oleg V. Besedin wrote: > > recently we found a kind of interesting behaviour of our Informix system. > Stored procedures which normally work within 2 - 3 minutes started > to take 8 - 9 hours to complete (180 times performance drop - ha-ha). We recently had a drastic performance…
active queries/users
Does anyone know of a way to query the system catalogs (SMI tables) to list the active users on online 7.2? Same as onstat -g ses (sql) but only for those users actively running a query. suggestions... -- -------------------------------------------------------------------------…
Re: OnLine v7 versus v5
I will tell you 2 nice features that I absolutely can't do without: version 7 has an auditing feature (no more writing trigger as in V5) V7 shows what SQL people are running via onstat -g sql #. I am able to catch those overanxious computer hogs and have had evidence to show ven…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Stored Procedures
P Watson Computer A (compans@cix.compulink.co.uk) wrote: : How many people out there are using stored procedures to do any : significant amount of work? We are producing a Client Server version of : an existing 4gl product and response times are an issue. We are trying to : deter…
Re: Stored Procedures
On Jul 10, 6:19pm, P Watson Computer A wrote: } Subject: Stored Procedures } } Here are some initial thoughts: } } 1. At first glance it looks like version and release management could be } more complicated than with 'traditional' 4gl because of the way they have } to be shipped…
Stored Procedures
How many people out there are using stored procedures to do any significant amount of work? We are producing a Client Server version of an existing 4gl product and response times are an issue. We are trying to determine how much stored procedures can give us here. We would like t…
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?…