Oninit® Archive
Results for “onstat -u”
sysrstcb
Thanks Art. So the only way to look the session and the table is use onstat -g opn to get TID then, search for SID at sysrstcb?…
CHK REQ times suddenly getting very long
Clive: You should do an IIUG TechTalk about managing that many TS devices in Informix! That aside, here are the mechanics of what's happening, maybe it will help you figure out what changed and how to manage that: When a checkpoint is triggered the engine locks a mutex latch that…
Sessions and transactions
Hi Y'all (with a capital Y ) A few weeks ago I posted a question about transactions and, with the help of Markus, I was able to create the query and wrapping script that I was planning. My manager liked the idea but now asked for a similar scripts to summarize session, so we can…
Long transaction message discusses a strange number
Hi Jake, for matching " Aborting Long Transaction: tx: 0x1d298fba8 ..." with onstat -x, simply go by this tx address. The tx_id's use, for the user, mainly is to identify the transaction in onlog output, in combination with LSN info (log unique ID + log position within that log).…
Error -25587 using a shared memory connection.
Weird, and 25587 apparently being a rare error. Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)? ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------…
Dates and times for Sessions at TechXchange?
I have confirmed with TechXchange that no dates or times are available (yet) for sessions at TechXchange... Tom ------------------------------ Tom Ross ------------------------------…
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 ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
Hi Dennis. OFF_RECVRY_THREADS is most significant, as also mentioned by David: https://www.ibm.com/docs/en/informix-servers/14.10?topic=cptarr-off-recvry-threads-recvry-threads-their-effect-fast-recovery https://www.ibm.com/docs/en/informix-servers/14.10?topic=parameters-off-recv…
ESQL/C conversion error with CLVCHARPTRTYPE
FYI, the new thread: https://community.ibm.com/community/user/datamanagement/discussion/segfault-since-csdk-450fc10-with-lvarchar-and-client-locale-different-from-db-locale Seb ------------------------------ Sebastien FLAESCH ------------------------------…
onstat -g ses returns "Changing data structure forced command termination"
Hello Art, Thank you for your prompt reply. Is there any other way to monitor the session information? ------------------------------ Stavros Tseriotis ------------------------------…
flags (onstat -g ses)
Hmm. So, it thinks that it is "running", ie doing something. Does the onstat -u line(s) for that session show any changes in the IO columns? Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com --------…
monitoring session memory
IDS 11.70FC4 I seem to be having some serious session memory leaks. Sadly it is intermittent. All the clients are using DBD::Informix (perl) to access the database. I have to run onmode -F quite frequently and restart some of the clients so it looks like something is not being cl…
Validate backup : archecker –tdsv and CommVault
Signal 15 is SIGTERM - some other process or session killed the onbar session or the underlying archecker session. The bar_debug file might have more detail. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt…
NETTYPE connections per thread
Hmm, I think I'm getting threads and listeners tangled up. The config is about connections per listener, performance is not affected below 500-700 connections per listener. Per your reply on my other post, the engine will increase the number of connections as required (except for…
onstat statement
Dears, Kindly let me know if I run onstat - g stm command to check current sql statement which give the Session ID but sometimes if I try to kill the session by onmode -z <id> , it doesn't kill the session. So do I need to connect the session id with onstat -k session id ? kindly…
Table Recycle Bin?
The more users on this forum the better. It adds visibility inside IBM for Informix! Art ------Original Message------ Thanks Art. I think I'll simply post the URL of this thread to the Slack group where my user posted his question. It is unlikely that my users have a time-delay …
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…
Aborting long transaction doesn´t rollback tx
A little supplement: You can watch the progress of the rollback with onstat -x. See the column "est. rb_time" of transaction list. The third column userthread points via onstat -u | grep userthread to the session_id.…
How to kill a session using SQL
Thank you. This is great. Question. Want to query the client port no. for a database session. Are you aware of what sysmaster table/view this would be in?…
Who shut down my Instance?
No, Benji, there is not record kept of what session executed the onmode to shutdown the instance.…
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…
Waits on the physical log buffer in v12.10
Can you post a thread stack from onstat -g stk? Regards, David. > On 19 February 2018 at 13:54 BENJAMIN THOMPSON <benjamin.thompson@skybettingandgaming.com> wrote: > > > Hi, > > Since an upgrade to 12.10.FC10X1 (from 11.70) we are seeing a lot more waits > on the physical log b…
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.…
Clear out temp space?
Thank you, John. So, they were likely files, not tables, and I could have observed them with an 'ls' command? Then, I might have been able to identify the session by inspecting the contents of the file. Then, kill the session (assuming I could identify it)? DG…
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…
Backup Help
When I ran onstat -, it says Blocked: LAST_LOG_RESERVED4BACKUP When I ran onstat -l grep C-, it gives me U---C-L…
sid vs pid
What is the difference between the sid and the pid (in the syssessions table of the sysmaster database)? I assume that sid stands for session ID and pid for process ID. If that is correct, then a session could have more than one process running at a time. Is that right?…
Move tables to another dbspace
Thank's We had performance issues in the same hour two times a day almost everyday, when is the most users sessions. The cpu goes to top, and we identify with onstat -u | egrep B--P a lot of sessions waiting for a resource, all in the same address, like this 402f086d8 B--PX-- 2…
IDS not writing to online.log
for tid in $(onstat -g ath | egrep "main=5Floop|onmode=5Fmon" | awk '{print= =20 $1}'); do onstat -g stk $tid done Just in case 'crit' should be in any of these outputs, e.g. wait4critex,=20 check onstat -u for any X flags and proceed from there. 'Weeks' you're saying?? No chec…
java.sql.SQLException: cannot create user thread
Hello, I am running a jdbc 3.70.JC8 application on a windows 7 64 bits version. Informix 12.10.FC7DE server is running on a Linux x86 64 bit os. I'm facing the following error: Caused by: java.sql.SQLException: Imposible crear thread de usu. Comprobar nomb. de usu. en NT y grupo…
sysmaster tables for onstat -u and onstat -g ath
Greetings. In my quest to produce Perl scripts that consolidate the output of onstat commands, it has been mostly straightforward to break up a line into into its component pieces of data. For example, onstat -u, every line has exactly one string in every column. Not so for som…
Concurrent users
I am looking for a good explanation for concurrent users. I know you can get a value from the sysmaster or with onstat -u, but I am trying to explain the meaning. No one logs directly into the database. All data manipulation id done via user applications. Any help with the expla…
RE: question...
Yes, ids@iiug.org. Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technologist, I&TG - Database Management Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email…
Transaction Locking and Indexes
David: OK, here's what's happening: Without the index every delete has to scan the entire table looking for matching rows to delete. Each row as it is examined has to be locked, dirty read or no dirty read, for a fraction of a second. As multiple scans zip through the table it …
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)…
Could not do a physical ..in a query group by
Hi, I have a query group by on a large table Over 600 Millions rows), the query run over 2 hours and then it generates an error Could not do a physical order to .... My database is an Nolog informix 11.70. on the onstat -u, I have 8 processes run by informix for this query plz h…
lock ovflow
Thanks for the inputs everyone. Slightly embarrassed - as George pointed out ... onstat -u has the info. Can trace back to session, etc. I have been using OAT for watching a number of issues like this lately. Refining SQLTRACE as well for catching offenders. Thanks - Mark…
Open tables and threads
Hi, I have a problem with some blocked transactions, I have looked over onstat -k and onstat -u but doesn't found any waiting case. I have looked over onstat -g opn and I would like to know the smi query or some way to find all the relations to tables and sessions from here. Th…
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/query using temp db space
Hi, Can you guide me to identify session/query which is consuming temp db space Thanks.…
IO Wait and PDQ
Agreed, but I can guarantee this is the only session using PDQ during the test cases.…
Stuck Transaction with BTS!
The most important thing would be to get onstat -g stk of the thread fo= r the txn. From: "MICHAEL HOFFMAN" <mrh@panix.com> To: ids@iiug.org Date: 10/29/2014 05:23 PM Subject: Re: Stuck Transaction with BTS! [34059] Sent by: ids-bounces@iiug.org I did push the logical logs pass…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Re: spin locks
Added to FAQ. Regards, David. > On 23 September 2013 at 22:52 John Miller iii <miller3@us.ibm.com> wrote: > > > The two mutex which are directly effected are sh_stamp and po_lock, but > the VP_MEMORY_CACHE_KB speeds up malloc()/free() functionality > which can have an indirect …
Re: spin locks
Added to FAQ. Regards, David. > On 23 September 2013 at 18:47 John Miller iii <miller3@us.ibm.com> wrote: > > > The output of onstat -g spi is so low, it is really not even worth > worrying about. The po_pool lock > is the hottest mutex which has 118 latch waits in over 9 hours…
Re: spin locks
Added to FAQ. Regards, David. > On 22 September 2013 at 02:20 Art Kagel <art.kagel@gmail.com> wrote: > > > IB that is the memory pool latch. You can probably reduce the activity on > it by enabling VP_MEMORY_CACHE_KB so that each CPU VP holds on to some of > the memory from the…
Using SQLTRACE
So it will trace the current sessions not new ones ?…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
does this mean a dropped network connection
I started to receive these errors the last couple of days, due they mean that a user was running some sql when the network connection got dropped or other network problems? 09:09:29 ASF Echo-Thread Server: asfcode = -25580: oserr = 32: errstr = : System error occurred in network…
Option for audit logging new sessions
We have a need to log all created sessions (successful logins only) to an external file (session id, date/time, hostname, username, etc). Is there an audit log configuration somewhere that we can use to do this? Thanks -Justin…
btscanner running v/s ready
The onstat -C report and its options report on the btscanner threads and the table/index hot lists that it processes. As to when it runs, it runs when there is sufficient work in the hot lists for it to process. When the thread finds no more work it sleeps and wakes periodically …
spin locks
IB that is the memory pool latch. You can probably reduce the activity on it by enabling VP_MEMORY_CACHE_KB so that each CPU VP holds on to some of the memory from the central pool and so has to interact with the pool latch less frequently. Art Art S. Kagel, Principal Consultan…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
IDS 7.31 resize drop and recreate new logical logs
Hi Art, Thank you for your reply. Here's what i've got when trying to add/drop logfile. => onstat - Informix Dynamic Server Version 7.31.FD1XC -- On-Line -- => onparams -a -d logdbs01 -s 10000 Informix Dynamic Server must be in quiescent mode. [informix]:/appl/informix => ons…
Concurrent Sessions
Hi All, We would soon be involved in a Complance audit. Any clues on how the official count of concurrent sessions is arrived at? Thanks in advance, Jay…
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
Hello, We are running informix 11.50.FC6X5. Is there anyway to map temp tables back to the original session that created those tables? We have reporting users that don't use explicit temp tables (create temp table), though they do have many subqueries and multisets. Most of t…
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,…
Temporary Tables Structure, how to get it ?
I know that temp tables are locale to the user sessions, what I need is to get the structure of the temp table, while inside the session, Do you know if it is possible to access this information inside the session ? Thanks Marcos Cassinerio…
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…
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 …
Informix Status Explanations
All of your guesses are correct. A bufwait occurs under two ceircumstances. One is when a page in the cache is locked by a session that needs to modify its contents either to modify the existing page, to read a new page into a cache page from disk, or to create a new page to be a…
Need a Help, Access login and sql traces
thanks i also found a way to do it, with server studio, but i still need to log sessions, the successfuls and the unsuccessful ones. your script and also server studio logs only the successfuls sessions. i understrand that there is a way to logs unsuccessful sessions with infor…
RE: Session Timeout on IDS10
Are your connections passing through a firewall? That could be the cause. We've seen that happen on idle connections. _____ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, November 30, 2011 12:51 PM To:…
Session Timeout on IDS10
We are having an issue with idle sessions timing out after 60 minutes on our IDS 10.0 server (HP-UX 11i). I have looked through all the documentation and can't find any default time out setting. Does anyone know of anything that may be contributing to this problem? Thanks …
Informix process reads a lot of pages
>So, running "onstat -g ses" shows no output except the report header line? "onstat -g ses <session id>" shows the report header. "onstat -g ses" shows some sessions, but not this session which reads a lot of pages…
physical order read to fetch next row error
you mention 5 users updating at same time I wonder if it is a locking issue ? An onstat -u will show you if any locks happening at time of error…
Re: 11.70xC3 conversion
The sysmaster database was not rebuilt after the upgrade. There should be a script, buildsmi.bat, probably in %INFORMIXDIR%\\etc. Run that script and it will drop and recreate the sysmaster database to include the new tables that 11.70.xC3 expects to see. Art Art S. Kagel Adv…
11.70xC3 conversion
This is on Windows Server 2008 32 bit. After uninstall if 11.70xC1 and install of 11.70xC3, and changing root space location in onconfig and then a restart, the conversions ran fine except for this: 11:05:48 Conv/rev: Started conversion for component SECURE 11:05:48 *** SECURE …
User is not trusted (user@machine.domain)
Hi guys. If I delete all the lines and I just add '+=00D' the log file returns the same: 09:11:36 listener-thread: err = -956: oserr = 0: errstr = informix@goncesoto.opensite.com: Client host or user informix@goncesoto.opensite.com is not trusted by the server. But if I add '+=…
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…
Cannot create a user thread error
I have a large number of normally well behaved (with Sql Server and Oracle) unit tests failing when connected to my IDS test databases. The error message is "[HY000] [Informix .NET provider] [Informix] Cannot create a user thread". (This is with Visual Studio 2008 Team System, us…
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.…
Environment for session
Hi All Quick question regarding the session environment. Sample here: Environment for session 176: Variable Value [values-list] CLIENT_LOCALE en_US.8859-1 CLNT_PAM_CAPABLE 1 DBDELIMITER | DBPATH . [.] [//ipdb] DBPRINT lpr DBTEMP /tmp GL_DATETIME %iY/%m/%d %H:%M:%S I did no…
SINGLE_CPU_VP config query
If you are only planning to NEVER have more than one CPU VP (so you will configure VPCLASS cpu,num=1 AND you will never run "onmode -p +1 cpu") then setting SINGLE_CPU_VP to 1 (OK non-zero) will allow the engine to eliminate some latching and locking of memory structures that wou…
IDS 7.31UD7 on MP-RAS not able to initialize
Art, re. the buffers and locks low numbers - yes, I agree, however they were left that way (low) on purpose. Reasoning is I am only trying to get the server 'up' and do not want to introduce other potential issues. At one time we did try with actual production values (larger) bu…
get top 5 i/o busy session
How to get top 10 i/o busy session by running 'onstat -u' and order by " nreads+nwrites" column that addition values of "nreads and nwrites" onstat -u | sort -rnk9 | head -n5 will get top 5 nreads sessions onstat -u | sort -rnk10| head -n5 will get top 5 nwrites sessions…
waiting on write of the logical log buffer
Yes We have HDR + 2 RSS using buffered loging. Round trip time is: ---- PING Statistics---- 9 packets transmitted, 9 packets received, 0% packet loss round-trip (ms) min/avg/max/stddev = 0.397/0.510/0.923/0.16 output of onstat -l: Physical Logging Buffer bufused bufsize numpage…
database name of current session ?
Hello, How can i find database name of current session using select statement? Thanks…
Single threaded vs. Multi threaded
Wow, it's been a while since I worked on Informix 5 :-) In Informix, Version 5, UNIX controlled everything. For each user that connected, a process was created and UNIX controlled process switching. This is a single-threaded architecture model. Due to the size of servers back wh…
sysmaster query
Hi, Is there any sysmaster query which is substitute of onstat -g ses <session id> command ?…
wait on lock more than 30 seconds
kindly give me the query which can find all the sessions waiting for a session and also session which applied locks.…
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…
informix dropping idle connections
Cesar this script appears to kill idle unix login sessions not database connections…
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…
Queries waiting for mutex
Hello all, Yesterday afternoon we ran into a problem. All sessions selecting or modifying data stopped responding to users. Onstat -u showed all of these sessions in a status of waiting for mutex 'S--P---'. After gathering onstat -a and onstat -g all information, I restarted Inf…
monitoring CPU
how can we map the out put with session id?…
Re: How to identify a run away process in Database
Hi John, What I mean by runaway process is. 1. the session id exists on the db (but how do i know if it is runaway process?) but can't find the pid on the OS level. Given the "onstat -g ses sessionid", can i say that the session id is runaway process? What is the hint that it …
wait for mutex ... IDS hang....
Frank wrote: (4) mutex holder ??? it shows session 88852, but onstat -g ses 88852 shows nothing ( see below) informix@dora $ onstat -g lmx IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 4 days 03:03:29 -- 2120544 Kbytes Locked mutexes: mid addr name holder lkcn…
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…
Multiprocessor setting
I think that a quad core processor qualifies as a 3 CPU system. At the time that John said that, #cores == #processors. Since that's no longer true, I would go with the number of cores rather than the number of processors. That said, I was always told that if you have more than …
frozen sessions
Can somebody tell me what a session in a "cond wait PC_I hash" condition mean? I have multiple sessions that are all stuck at the same place. The statements are all called from stored procedures. The last one executing (spil_send_mail) only inserts into a table, but that's whe…
frozen sessions
Can somebody tell me what a session in a "cond wait PC_I hash" condition mean? I've never seen a session in this state before. I have multiple sessions that are all stuck at the same place. The statements are all called from stored procedures. The last one executing (spil_send_…
951: Incorrect password or user informix is not kn
Hi Maybe an excerpt from online.log file : ..... Tue Apr 20 09:35:09 2010 09:35:09 informix password expired 09:35:09 listener-thread: err = -951: oserr = 0: errstr = informix: Incorrect password or user informix is not known on the database server. ...... 14:14:53 informix p…
Buffer Waiting ( onstat -l )
Hello, In the below mentioned output of onstat -l , there is a portion "Buffer Waiting". What does this "Buffer Waiting" mean? How could this output be useful for a database administrator? onstat -l ################################################### Physical Logging Buffer buf…
how to get session-id ?!
If I have thousands of sessions in if66 , I don't know which session connect if88 through session 40 , All I know is that session 40 of if88 is the session which application connect to if66 and then run sql like "select * from stores@if88:customer" , I want to find out which sess…
IDS 10.00 maximum concurrent sessions
Hi Art, Thanks for your quick respose. We are using shared memory connections . Also noted that there is no limit for the concurrent sessions. My issue is i want to control the number of sessions, i.e. maximum number of concurrent sessions. Say for ex i dont want the maximum num…
Change Lock Mode For Session
Hi All, Is there any way to force a particular lock mode on a informix session? I have a client app connecting to my database with lock mode set to not wait. This lack of a short wait can cause issues with a locking due to a manual process I'm running over the data currently…
IDS 11.5 License
We just received a quote for IDS 11.5 Enterprise Edition 2-user license The environment that we will use will have at lease 30 user processes running (output of onstat -u), is the 2-user license sufficient?…
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 …
Get Session Env variables
How can I get/monitor session environment variable information from the Database? We are using IDS 11.50.FC4. Specifically, I would like to see which DBSPACETEMP a session is using based on what that particular application sets it to. --Dave…
IDS random slow down
Jumping in here... I am guessing the diagnostics you posted were ran when the engine was in its slow state right? I'd like to see a few things: 1) What is the sqlexec thread that is running actually doing? You can get this information by looking at, in your diagnostics, the on…
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 …
how to check defunct processes/session
One way is to look at the reads and writes column in the onstat -u over a period of time for each session (the session id can be grepped out of the onstat -u output). If you find a session whose reads and writes are not incrementing it could be hung. MM…
User thread
I'm using Informix 11.5 developer edition and some Windows services are acusing an ODBC error (Cannot create user thread). Informix is installed on Windows. What can I do to fix up this problem?…
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…
mutex dbs_partn and pt_170003
Did you check the mutex locks with "onstat -g lmx" and get the session id what is locking it??…
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…
Lock table overflow
Can anybody let me know why we got this error below and their resolutions. We are using IDS 7.13 running on HP-UNIX 10.01. 16:04:08 Lock table overflow - user id 6012, session id 5214 16:04:08 Lock table overflow - user id 6012, session id 5214 16:04:08 Lock table overflow - use…
Re: Get Active Sessions
Omar, Thank you. Yes that seems to work. I just need to grep for the sqlexec and map that to onstat -u. Works well. Thank you very much. --David On Wed, Aug 12, 2009 at 3:14 PM, Omar Muñoz <omarmun@yahoo.com> wrote: > Hi. > > You obtain active threads by using onstat -g…
Get Active Sessions
Hello, Using either onstats or SQL to query sysmaster, how can I get a list of all active sessions. By active I mean sessions that are running something and don't just have an idle connection to the DB. I found scripts for killing idle sessions though none for getting active s…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: how to force disconnect user threads?
don't do onstat -z, that will zero out your metrics for the instance. it's onmode -z ----- Original Message ----- From: "gansvv" <gansvv@gmail.com> Sent: Mon, August 3, 2009 11:36 Subject:Re: how to force disconnect user threads? On Aug 3, 11:31 am, gansvv <gan...@gmail.com> wr…
how to force disconnect user threads?
How can I force disconnect user threads from Informix IDS? Thanks.…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
Error sql -998 (???)
Hi , Can you able to find what is the sql last parsed in that session during onstat -g ses? rgds schillache…
Informix Connection Strings
Answer was surprisingly simple. I just left the user name and password out of the connection string and all is fine. I have observed some very strange issues, which I think relate to a bug in the connection pooling code. I'll post that as a new thread.…
Question about ISAM reads vs output of onstat -u
Environment: Informix 7.31 S.O. HP-UX 11i The ISAM reads (output of onstat -g ppf) and disk reads are the same ? I followed the next steps: 1. session a: onstat -z 2. Session b: I run a query in dbaccess 3. Session a: onstat -g ppf | grep 0xb00091 (a particular table reads in…
Re: I am in a transaction ?? (I4GL)
To know if your current session has transaction opened use dbinfo to get your session id and : select address into waddress from sysrstcb where sid=? select bitval(flags,2) 0-No trans opened/1-The transaction is opened from systxptab where owner= waddress Best regards…
Long Spins
Hello, I see that there are many threads waiting for the same resources, thus, it increases long spins. I also would like to know that how should i reduce it, and also to know, how can i trace the users who are yielding long spins. Thanks…
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…
Lock mode
Is there a way to set "lock mode to wait" once for a program or does it need to be reset for every single session to the database? Is there a configuration parameter (on the database side) to set the lock mode to wait for all sessions coming to the database? Thanks ___________…
Re: Compression overview...
Peter, There was a good session on this at the conference, by Scott Lashley. Look for it when they post the conference slides. Nick…
Informix Dynamic Server Scheduler question
Thank you for your answer! The thing is that the table contains records about particular sessions and all other sessions must be able to use them. Application's behavior depends on records in this table inserted by other applications' sessions. After a session is no longer active…
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…
How to find which sessions are referencing a synonym
How to find which sessions are referencing a synonym Is it possible to know which sessions are "using" a synonym ? I use the 7.31 version The documentation indicates that "onstat -g opn" displays a list of the partitions (tables/indexes), (but no synonyms) May be another comm…
LTAPEDEV /dev/null from ON-Monitor
...or you could run 'ontape -c' for continuous log log backups; do it in a spare terminal session or use 'at now' or similar.…
DB Monitoring
Version and platform? If you're on IDS 11.10 or later, then you might consider SQL Tracing. Or you might consider the audit facility to audit only those events you care about (begin and end transaction events). I suspect SQL Tracing will alter the test too much, but auditing a s…
Re: Best Use of Free Memory
On 24 Oct, 21:01, "Kevin Cherkauer" <invalid_addr...@nowhere.com> wrote: > BUFFERS is generally a good place place to use extra memory, subject to a > couple caveats: > > 1. If the working set already fits in the current buffer pool, adding still > more buffers will not produce a…
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…
View thread info?
Hi All, Thanks for your replies. I managed to identify the process that caused the problem. 1. Use onstat -g act to look at active threads 2. Perform onstat -u | grep <rstcb value of active thread in step 1> -> get session id. 3. Perform onstat -g ses <session number from step…
Blocked:CKPT
PLEASE always include the post to which you are replying. I happen to remember what you are talking about and that this is a response to me, but anyone following this using the email gateway or perusing the archives may not know what's happening. Hmm. OK, so not blocked on logs.…
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.…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
IDS v10 JDBC 'Cannot create an user thread'
Hello, I'm looking for help deciphering this error. I installed IDS v10 onto Windows XP with the IIUG installer. I have a server instance, a database and a schema. I see my tables OK with dbaccess, and also with the SQuirreL GUI via JDBC. But when I run my server, on what is pr…
onstat -u ( Active threads increasing )
Dear all, IDS 11.10.FC1X1 on Linux . onstat -u normally has < 1000 active userthreads. but today we are facing a issue where the no of threads are increasing & may be because of which the shared mem requirement is increasing hence virtual segments are added by the database afte…
"tty" column in onstat -u
(HP-UX 11i, IDS9.30HC5) Just a comment, really, and wondering if this is the same on other systems? Doing a remote dbaccess query from one box to another, I've found that when I do an 'onstat -u' on the target machine, under the 'tty' column it shows the tty of the session on th…
what is holding the log in this session
I have a session that is running stuff from ec code in an ids10 non logged database. I know that at the beginning of the program, some indexes are created, and lots of inserts happen to a table. This is a batch process that takes over 24 hours to run. It has continued to abort wi…
RE: Monitor sessions
I think it's great that you're putting together a script to do this sort of thing. I think Paul is absolutely right, you need some commentary so that it doesn't take more than 10 seconds to understand. I would also highly recommend NOT using onstat for this sort of thing. The …
Re: Monitor sessions
On Jan 16, 11:22 am, mohitanch...@gmail.com wrote: > On Jan 16, 10:10 am, mohitanch...@gmail.com wrote: > > > > > On Jan 16, 5:29 am, scottishpoet <drybur...@yahoo.com> wrote: > > > > On Jan 16, 12:43 am, mohitanch...@gmail.com wrote: > > > > > Version: IDS 10 > > > > > I am tryi…
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…
Monitor sessions
Version: IDS 10 I am trying to write a script that will find out those threads or sessions that are stuck at particular step for more than x mts. It could be stuck to acquire a lock on a resouce, or waiting for buffer or checkpoint or using lot of logical logs or may be just run…
Long Transaction
Version: IDS 10 How can I track "tx" in following message: "Aborting Long Transaction: tx 0xc0000001f4b64938". Is "0xc0000001f4b64938" the user address that comes in onstat -u ? I am trying to track which process caused the long transaction. I have a script that runs every 15 mt…
Re: Counting Sessions
On Dec 4, 2:04 pm, Nog <n...@gfm.co.uk> wrote: > On Dec 4, 12:23 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Dec 4, 7:14 am, Nog <n...@gfm.co.uk> wrote: > > > > Hi, > > > > I'm Using IDS V10.00.UC5 on SUSE linux. > > > > I want to keep a count the number of sessi…
Logical Logs
Hi All Gurus, I'm new to this forum and IDS. Please advise me how to remove/delete the logical logs No.1 till No.3 from onstat -l, i assume flag D indicates DELETE ( pls corret me if wrong) And would it possible to readjust LOGSIZE to smaller value say "16384" from any availabl…
Counting Sessions
Hi, I'm Using IDS V10.00.UC5 on SUSE linux. I want to keep a count the number of sessions occurring hourly/daily on my instance. I was using a cron script to execute the following sql and store the result hourly; select DBINFO('sessionid') from systables where tabid = 99; Th…
Maximum concurrent users threads
Can someone tell me the formula that produces the maximum concurrent number portion of the onstat -u command? Is this based on what is defined in NETTYPE? ----------------------------------------- This message and any attachments may contain confidential information or trade sec…
Update from Digital 7.31.FD1to ....
>Baan IV run not on the same machine and connect to the informix server with an >1GB crossoverethernetcable. >so we use not Shared Memory to access the database! NETTYPE soctcp refers to tcpip connections which your Bann connections use Generally speaking, put the connection me…
Listener-Thread Error 25571
Today we saw hundreds of lines in our message log with the following error. The database pretty much came to a halt and nobody could connect or do any work. Only bouncing the engine cleared up this issue. 17:15:47 listener-thread: err = -25571: oserr = 0: errstr = : Cannot cr…
Re: Informix Session Information
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 read" they would set it >> to dirty read. Then they woul…
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
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 code. As a final step…
rstcb
Version IDS 10: In different onstat output I see "tcb" and "rstcb". I am not sure what it means. I generally grep for address from rstcb in onstat -u output to find out about the session. But I am not sure what these mean.…
Re: Display servicename/port no. of listner or user thread
On Sep 13, 5:39 pm, mohitanch...@gmail.com wrote: > Version: Informix 10 > > How do I display which listner or user thread is listening to which > port. I am looking for something that tells me which thread is using > ports/service names listed in sqlhosts. > > I tried onstat -g …
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
long checkpoints on informix
On 13 jul, 15:44, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Jul 13, 12:07 pm, Sakura.g...@gmail.com wrote:> hi everyone > > i recently start to have some long and constant checkpoint > > i did lot of change but cant reduce it > > i have Informix Dynamic Server Version 9.40…
RE: Informix beats Oracle
Dirk Moolman wrote: > When you start working with Oracle, you really start missing the simple > tools - like onstat, and dbaccess, with its "unload to ... select * from > ...." You are comparing Informix 2007 with Oracle 1997. The delta is 0. -- Daniel A. Morgan University of Wa…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
ONSTAT -U Question
Hi guys, I got a old question, at least "old" for me. The last line of onstat-u output show something like that 13 active, 128 total, 25 maximum concurrent I got NETTYPE setting to NETTYPE ipcshm,1,5,CPU # Configure poll thread(s) for nettypeNETTYPE soctcp,1,5,NET # Configure …
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: KILL SESSIONS
Couldn't one just do an onstat -k and find which sessions are having a shared lock on the database and kill those ? For me, yea, bounce the engine is the quickest, but just for sake of argument.... ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Adm…
Re: KILL SESSIONS
On 13/04/07, Drazen Kruhek <drazen.kruhek@trgocentar.com> wrote: > something without restarting engine? > why informix didn't have options onmode -z all or something? > ----- Original Message ----- > From: "Keith Simmons" <smiley73@googlemail.com> > Newsgroups: comp.databases.inf…
KILL SESSIONS
How to kill all sessions in one time on IDS 9.4! I doing dbexport database ,but some sesionss is active(user is not end a aplication) so i can't do dbexport.…
onstat -p
How long has this database been up? 7 days? (Assuming 5 min Checkpoint interval and all triggered by time) I'd say you have some issues. Read cache and write cache are not great and should be looked into bufwaits is relatively high as are lock waits Very large number of lock re…
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…
Rogue user session
Hi, Informix Dynamic Server Version 7.31.UD7, solaris 8 I've got a rogue user session connected to my instance that I need to remove, if possible without bouncing the engine. snippet frm onstat -u 4ef13618 T--P--- 32885750 userxyz console 539f5f5c 0 0 0 0 4ef1d618 T--…
IDS is busy all the time
Hi Bodgan, Yes, I am sure. The session was started at 09:27, last access was 09:33, which mets the crash timepoint. No locks. According to onstat -g sql, the session does nothing. In onstat -g ses, I can see that the session is not connected to any DB, but has two memory pools. …
Re: NETTYPE's poll thread number
Version of IDS from 9, number of max connection is number of poll threads multipy by user per thread e.g NETTYPE soctcp, 2,100, NET : Max connection is 2x100 = 200 So first you have to monitor number of user connections before fill the number in by command : onstat -u , onst…
NETTYPE's poll thread number
Hi, My box has singel processor , NUMCPUVPS =1 . A lot of user will access this server, maximum will be 1500 user threads. How shoud I set up the NETTYPE in onconfig file. On informix's manual , says poll thread should not be greater than NUMCPUVPS . and user thread can no…
CPU idles
Hi, First: it is possible to set the NUMCPUVPS parameter to a higher value than actual processors in the system. This sometimes leads to better response times. (when you encounter idle time on your CPU (using sar) and the number of active threads is not decreasing). We once had …
Command to tell the age of a lock
This morning was asked "How can I tell how long a lock has been held?" I rifled through onstat -k, onstat -g ses (sesid) and onstat -u, but didn't find anything that told me the "age" of the lock. Is there a command that will do that? DT…
onstat -u and IDS maximum concurrent sessions
I keep out IDS test environments instances in sync by bringing over the latest level-0 OnBar archive and doing a cold restore. When I issue an onstat -u the output reports the maximum concurrent at the bottom. My question are as follows. Is the maximum concurrent reset during r…
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…
Number of Active user sessions
Hello, How can I query the sysmaster SMI tables to get the number of "Active" user sessions. I know that I can get the total number of user sessions from syssessions. However, I would like the "Active" sessions. Thank you in advance, Have a great day... TGIF... Dave In4Mix…
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= …
record locked
a combination of onstat -k and onstat -u…
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: SHMBASE VALUE FOR > 4 GB - V10
Fernando: una pregunta, tienes 64 bytes en x86?? que hardware es?? que s.o. CentOS 4.3?? corre bajo procesadores AMD 64 (Athlon 64, Opteron) and Intel Pentium (Xeon EM64T) processors?? Yo tengo IBM x236 con Xeon EM64T, si monto red hat para 64 bytes , valdra IDS V10FC?? Gracias …
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?…
who locks a record?
onstat -k followed by an onstat -u…
Problem connecting asp .net to informix
I'm trying to connect to Ifx using the .net provider. Here is my connection string: database=....;server=....;user id=.....;pwd=..... With VB .NET it works perfect, but not with ASP .NET, I get an unspecified error (23101) Any tips? -- agustincb ------------------------------…
Re: Two child process having different process id but the same session id - Possible?
i have already tried using DISCONNECT ALL before to no avail, but i did you're suggestion of checking the parent's session after sql_detach is called and amazingly it happens that the parent's session is still active after sql_detach and when the child connects it sometimes (rare…
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/…
Re: Thoughts on Logical Log use requested
Ok, here's some information as requested by TBP & OTC, The onstat -l was taken today (unable to run cmd on Sun), the list of log times for Sunday (yesterday) follow that. Choosing one of the logs at random (No. 160439) it filled in 10 mins 3 secs and consists of (among others) …
number of pages read during sequential scans
I think the following could work: * Establish two sessions in a special test program to the IDS: One is the test session which executes a query, fetches data etc., the other session watches the data for the test session in sysmaster:syssesprof. * The te…
monitoring IDS latches and locks
Hi, I have the tools to monitor the number of IDS latch and lock waits, but what I am looking for is a reference on determining what is an excessive or unusually high number of these waits in a given period of time. Any references would be appreciated. IDS Workgroup 7.31 and 1…
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: Track a session to a Buffer
Hi Zev. You mean the following ? Userthreads address flags sessid user tty wait c000000007c17338 B--PR-- 175155 testdb - c000000000e104b8 If this is correct, probably btscanner is holding buffer. onstat -b -> onstat -g ath -- Tsutomu Ogiwara fro…
Re: Track a session to a Buffer
onstat -b/-B/-X would be your friends.…
Track a session to a Buffer
Hi All, I just had a case where onstat -u returned a 'B' as the first flag in the second column for over 100 sessions. The wait column for all the sessions had the same hex number. Is it possible to track down the session that is causing all the others to wait? I tried onstat…
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!…
DBDATE format issues
Make sure the session that creates the stored procedure or does update statistics on the stored procedure has the correct DBDATE setting.…
How to get ip address of client ?
If the ip doesn't resolve to a name then the number given in onstat -g ses (?) is the Hex Ip address smitin@gmail.com wrote: > Ok, I forgot to mention "ip address of a client" in the body of my > message. If I know session id, and I want to get ip address for that > session -…
Informix database filling up rapidly
Run onstat -u and onstat -g ses for each session. There must be an application creating temp tables or doing queries that take a long time and are not using indexes.…
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.…
temp table existence
Is there a way to tell which session owns it?…
Re: freeing locks
find and download grep.exe onstat -uk search for the line you are after and then take owner do a onstat -u |grep <whatever you find for owner> the third col in the onstat -u output is the sessionid. onmode -z <sid> or gointo sysmaster and have a look at the table called syslo…
Long checkpoint duration
During the checkpoint, do you see activity from the flushers? Does onstat -F show them active. Do you see write activity for those guys with onstat -u? Do you see chunk writes with onstat -D? What's your checkpoint interval? lru max dirty? lru min dirty? How big is your phs…
SESSION ID ?
Hi, I have many applications that connects to the Informix Engine quite often. I would like to track the session id of a specific application that updates a specific table ( say employee. ). This sid will be used to capture information from syssessions table. ( hostname and proe…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
set session authorization
hello everyone! just wanted to find out one thing ... :-) when you do set session authorization... where do all the rights stay??? in what tables or views??? it should be somewhere ...…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: IDS 2000 9.21.UC4/Solaris/Sparc Problem accessing table - urgent
"We had a hardware controller glitch yesterday " "A simple 'select count(*) from tabname;' sits around and gets no IO (onstat -u). " maybe you still have a hardware glitch?…
Re: Advanced Internals - Madison
Well --- That's going to be hard to do. The spin lock is not the same as a mutex. The purpose of the spin lock is to protect against inter-process access to the same memory. The mutex is to protect against inter-thread access to the same memory. Every mutex has a spin latch a…
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: Strange counts in onstat -u output
This is a multipart message in MIME format. --=_alternative 00705C3885256FC0_= Content-Type: text/plain; charset="US-ASCII" How many rows in each table? is b.appl_no indexes? do the set explain and post. It could be performing an auto index.... "Bill Dare" <dareb@jevic.com> …
RE: Strange counts in onstat -u output
This is a multipart message in MIME format. --=_alternative 00705C3885256FC0_= Content-Type: text/plain; charset="US-ASCII" How many rows in each table? is b.appl_no indexes? do the set explain and post. It could be performing an auto index.... "Bill Dare" <dareb@jevic.com> …
RE: Strange counts in onstat -u output
Any temp tables created for this query? set explain on; and then run the query to see what the optimizer is doing. Does appl_no have an index in table licence? If not, that's why you are creating a temp table and writing to it. Regards, Bill > -----Original Message----- > Fr…
RE: Strange counts in onstat -u output
Any temp tables created for this query? set explain on; and then run the query to see what the optimizer is doing. Does appl_no have an index in table licence? If not, that's why you are creating a temp table and writing to it. Regards, Bill > -----Original Message----- > Fr…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: More CPUVPs than processors
Solaris has something called turnstiles in the thead management code that was written to help alleivate mutex locking and priority problems. In particular it removes the priority inversion problem associated with sleep queue implementation of thread and resource control. This …
RE: Session's memory
> -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On > Behalf Of rotor > Subject: RE: Session's memory > > > Hi, rotor (Leonid ?) > Yes, I am. :-) [AS] Nice to see You.. > > > onstat -g afr SESSION_ID > Don't understand what I…
RE: Session's memory
> Hi, rotor (Leonid ?) Yes, I am. :-) > onstat -g afr SESSION_ID Don't understand what I can see here. > There is a chance that that the memory leak is caused by > the server bug... Not sure. This is IDS 7.31.TD6 - from my expirience stable enough. > the application doesn't de…
Re: Session's memory
> your "Current statement name" > is indicating this as the number in your [cursor] "name" keeps an > increasing order. Yes, I see. Does the "Current statement name" is cursor name really? -- ���������� �������� ���� ������������ http://webmail.delfi.lv sending to informix-list…
RE: Session's memory
Hi, rotor (Leonid ?) The first thing to do is to investigate the session's memory structure using onstat -g afr SESSION_ID There is a chance that that the memory leak is caused by the server bug... but I'm quite sure that memory leak is caused by the VERY poor application desi…
Re: Session's memory
rotor wrote: > Hi community! > Who knows in which circumstances server allocates memory for a > session? I have 'onstat -g ses 183 -r 1' output during 10 minutes. I > don't see any criminal there. Except one - memory. It grows up to 400 > Mb per 10 min! 20 sessions like this one…
DRINTERVAL
It would be interested to know which threads are running that are consuming so much cpu (onstat -g act) and what are they doing (onstat -g stk <tid>). You could try some profiling of the oninit as well to gather more info. On the other hand maybe this cpu usage is not a bad sig…
SQL Session Problem
We have recently upgrade our servers and Informix versions from Solaris 6, IDS 7.3 to Solaris 8, IDS 9.4, ESQL 9.52 from SDK 2.80. We run an archive program every week which runs various selects on the database and then archives data. This process used to process five records ev…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
RE: Terminating a parent session...
check your "expect" script, you should be able to do this by the "send" command in the "expect" script. make sure you send an "exit" with "\\r" in the expect script. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of V…
Re: Terminating a parent session...
You may wrap the invocation to the 4gl module in a shell script, and as last instruction issue the following: kill -9 0 That will kill your processes and sign you off. -- Juan de Villeros On Thu, 23 Sep 2004 12:25:28 +0530, Vijay Kumar <rudrappa@india.hp.com> wrote: > Hi All,…
Re: Terminating a parent session...
You may wrap the invocation to the 4gl module in a shell script, and as last instruction issue the following: kill -9 0 That will kill your processes and sign you off. -- Juan de Villeros On Thu, 23 Sep 2004 12:25:28 +0530, Vijay Kumar <rudrappa@india.hp.com> wrote: > Hi All,…
Re: Terminating a parent session...
--0__=88BBE58BDFD4ED0B8f9e8a93df938690918c88BBE58BDFD4ED0B Content-type: multipart/alternative; Boundary="1__=88BBE58BDFD4ED0B8f9e8a93df938690918c88BBE58BDFD4ED0B" --1__=88BBE58BDFD4ED0B8f9e8a93df938690918c88BBE58BDFD4ED0B Content-type: text/plain; charset=US-ASCII Content-tran…
Terminating a parent session...
Hi All, We have an Informix 4gl interactive module, which when completes its execution must kill the Unix session itself. Is there any way of doing so. We are using this because we want to execute an application in a remote machine. For this expect tool executes an interactive …
How many physical processors we need to support 32K THREADS in IDS.
The recommendations for the network sizing is performance oriented for TCP connections. For SHM connections, it is physical because the SHM connection requires physical memory (IPCSHM). With one TCP network interface, you could go well beyond the 256 limit. Also, if you have f…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
virtual memory segments added
greetings all, we are on 9.40 FC3 on hp-UX 11i - sometimes segments are being added and cannot flush with onmode -F . is there a way to view what is holding on to them? i thought the address from onstat -u might match to the address in onstat - g seg but this is not the case..t…
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…
Session memory usage
Hi, does someone know how much memory a user session takes on a Informix database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik…
how release threads?
dear all we have an java application running on websphere 5 and using jdbc connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1 there is 20 connections-user session used by appserver and reused within connection pooling by many users however, the number …
Re: Multiple user threads
On Thu, 15 Jul 2004 11:58:49 -0400, Bjorn De Waele wrote: PDQ threads assigned to a session usually are not released. The session keeps them assigned in case they are needed again. I suppose this cuts overhead in heavily PDQ dependent sessions. It should be harmless. However…
Multiple user threads
Hello everybody, we're using version 9.40.T7 Our max_pdqpriority is 100. Right now, I see much this behaviour with onstat -u. Informix creates plenty of user threads. If I set with the max_pdqpriority with onmode -D to 0. Then I get a single user session which shows me sometim…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
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…
Which session is using the most cpu resouce?
Can I tell which session is using the most cpu resouce? I can use ps check which process or thread using the most cpu resouce. But Can I make a relationship between threads or sessions of informix and processes or threads of operate system?…
Re: Logical logs from rootdbs to own logspace
"Andrew Hamm" <ahamm@mail.com> wrote in message news:2kh0tsF2cbhcU1@uni-berlin.de... > Really? I hope you are talking about a long-forgotten feature of a Version > Five then, 'cos this works beaudifully: > onstat - IBM Informix Dynamic Server Version 9.40.TC2E1 -- On-Line -- …
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: MAXIMUM SESSIONS
Hi Hamid. onstat -u ? -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Hamid HABZI" <HHABZI@bmcebank.co.ma> >To: <informix-list@iiug.org> >Subject: MAXIMUM SESSIONS >Date: Tue, 15 Jun 2004 17:46:10 -0000 > >Hi, >How can i know what is the maximum number of sessions …
MAXIMUM SESSIONS
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 Tank you for helping. sending to informix-list…
Performance question
Informix 7.3 on Solaris 8. prstat shows 3 oninit processes totalling roughly 33% in the cpu column. Generally it is much less than this, and we're experience slowdowns. The vendor software runs on this same server, and I see a number of their processes near the top of prstat as …
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Re: Re: cannot drop index
Some better filters...with $tid and $rstcb... tabname=f4uhlp echo "select hex(partnum) from systabnames where tabname = '$tabname'" | dbaccess sysmaster | grep "^0x" | while read partnum do onstat -g ath | grep "^ [1-9]" | awk '{print "-g opn",$1}' | onstat -i | grep $par…
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…
Temp Tables
How can i know what temp tables are in my session with script...…
Backed up logs less than 100%
Hi everybody! Our client is using online Dynamic Server 9.21.UC5 on UNIX (AIX 4.3). They reported a problem with database performance (long response time). I asked them for the output from ‘onstat –l’: Physical Logging Buffer bufused bufsize numpages numwrits…
Onstat -D / onstat -u mismatch
IDS 9.21.UC6, Solaris 2.8 building an ETX index, into logged smartdbs, onstat -u shows the nreads column ticking up. The nwrites is remaining at zero. Onstat -D shows heavy reads on one smartdbs where the data is, and heavy writes on smartdbs where the index is heading. onstat…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Intermittent Performance Problem - What does oninit do?
The key component of a database server (any one) is, arguably, the bunch of processes that provide an interface between the application and the data. In informix, this job is handled by a series of "oninit" processes. The amount of cpu used by oninit is directly proportional to …
Washington Area Informix Users Group Forum 2004 - April 21, 2004
Lester Knutsen wrote: > * Mystery Sessions from DB2 development lab in Toronto Serge ?…
Sessions and Memory
IDS: 9.21.UC6 Solaris: 8 I've about 10(ish) databases all web based, all accessed via the WebBlade, one query in one of the databases is causing the engine to allocate another segment. How can the query be traced? Cheers -- Paul Watson # Oninit Ltd # G…
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…
Re: Temporary table
On Fri, 16 Jan 2004 15:44:21 -0500, Curtis Crowson wrote: > roeferr@ig.com.br (Ferronato) wrote in message > news:<df1bdeb4.0312240634.7b2ae02e@posting.google.com>... <SNIP> >> > How can I define if defined temp table exists in the current session? > > OK while we are on the sub…
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…
What sysmaster tables are used to produce nreads and nwrites columns
Hello gurus, Could some one tell me the sysmaster table that is used to produce the 'nreads' and 'nwrites' columns from the onstat -u output. (The last 2 columns of the onstat -u). Thanks a lot. --------------------------------- Do you Yahoo!? New Yahoo! Photos - easier upload…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Temporary table
Hi! How can I define if defined temp table exists in the current session? -- Sauron…
wait statistics - meaning of mt yield
Andreas, I'm guessing "mt yield" is a mutex thread yield... This wouldn't matter if your app and DB are on the same box or not. IF this is a mutex thread yield... i think a mutex lock/latch is like an atomic/internal lock.... not the typical lock seen by "onstat -k". I reserve …
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?…
Sick server session
IDS 9.21 on Red Hat My client's database session is really not too well. The database server will not accept memory-type operations, such as onmode -k or onstat -F. There are also no oninit proceses running. An onstat -g seg shows single segments, but an ipcs -m shows multiple…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: HELP - User threads "Waiting on a buffer"
Bug: 163653 REFER 162377 SAME BUG IN 9.40 ENGINE HUNG ON BLOCKED CKPT DUE TO DEADLOCK BETWEEN BTSCANNER AND SQLEXEC May be you are hitting this bug, or something similar (when you delete records, the btscanner is active). Check with tech support. Leave some time between you del…
HELP - User threads "Waiting on a buffer"
All, We are running into an issue with IDS 7.31.UD4 engine. We are running some load testing against our applications, and we notice that eventually the application hangs. There are no X locks on the DB at athe time, but a ton of my threads are in "Waiting on a Buffer" status.…
Re: Server session stats
me here wrote: > > Didnt even notice. I am a bit dyslexic at the best of times. As an > aside, why is dyslexic so hard to spell?? I am sure some sadist > created that word. If a dyslexic was also cross-eyed, would they be able to read properly?…
How to create dbspace
hello I am working on informix 9.3 on win2k with ArcSDE when i am loading data the dbspace exhuasted after restarting the servis i am able to run the service but unable to connect Plz find the below the details of onstat -d d:\\PROGRA~1\\Informix\\bin\\onstat -d: Informix Dy…
Server session stats
Does anyone have any good admin queries (SQL) that can be run to report on current server stats. Simiar results to "onstat -u" I can query the syssessions view on sysmaster and have trolled the newsgroups and web for useful queries. A lot of the reporting scripts where Unix shel…
Informx Session Id limit
Hi All We are running informix 9.21 on solaris, and have small database with 1.2GB. I observed the sessions id 260009 and keeps increasing, we had shutdown database last few days ago, but session id has been reverted back . As i am new to informix, any of u clarify my queries …
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…
transaction/session id in SE7.2
Hi I am using InformixSE7.2 (on linux) and have been trying to write a stored procedure which, amongst other things, gets hold of the session id. Ideally I would like the current transaction id but I haven't found out how to get hold of that! This is the first time I've used I…
Remote session
Hi there. This one is about connections between servers. Imagine the following situation: In a remote node (calvin), a query is being executed, e,g,: select * from database@hobbes:table_name In local node (hobbes), its possible to find out the details of the remote (say clien…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
is hdr on?
Hi ! I have 2 Informix servers (7.31UC7) with HDR - server1 and server2. Is HDR on? --------------------------------------------------------------------------- server1: [informix@server1]$onstat -g dri Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 23 day…
informix 9.4 question: PDQPRIORITY and user threads
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C31F07.D165AEC0 Content-Type: text/plain; charset="iso-8859-1" We are testing IDS 9.4 against linux Red Hat 7.2. Con…
Re: onconfig.ows - MULTIPROCESSOR
Setting it to 0 can improve overall system performance as then when a VP encounters a latched resource it will suspend the current thread and wait for it to be cleared. With MULTIPROCESSOR on the VP will spin for a while before suspending on the assumption that the latch may belo…
onstat -u ( flag S in position 1 )
Hi all I am facing a performance problem in our IDS 7.31 ( HP-UX ) Recently we change all our servers and storage ( process before ran in 1 hour , now run in 8 minutes ) We don't have any I/O problem not even CPU problem . ( rp 8400 , 10GB memory , 12 processors at 860MHZ and XP…
Numbers of Locks
Tham Huei Hwan wrote in message <96a5b7$h0c$1@news.xmission.com>... > >How to find out how many locks is hold by particular users / process ? > onstat -u has a column for number of locks, but it's a summary of the different types. onstat -k gives you more detail. You have to "j…
Database sessions!
Is there a way to close idle database sessions after a certain time?We have too many open database sessions concurrently which most of them are not used by any users anymore.And this causes additional Virtual segments because of a large session pool..I know it has to do with the …
onstat -u shows reads
The tables on our data warehouse have only read access by public. An onstat -u shows some users that have reads AND some writes, while most users only have reads. Does anyone know what tables these queries would be writing to, and why not all queries have a write?? Sent via …
onstat
Hi all. I was told by our DBA that onstat has different exit codes depending on the engine's mode (or mood). So, if I test $result (in C shell) or $? (Bourne / Korn shell), I should get a numeric value. My tests show 1=Quiescent, 5=On-Line. Does anyone know what these values …
killing a process
I have a hung informix instance. Does anyone have any info on how to kill the active sessions? tia…
Nettype
I have been experiencing some network errors in my online.log. Is there anything that I can tune? There is about 1300 users connecting and this is my network configuration. NETTYPE soctcp,20,100,CPU # Configure poll thread(s) for nettype 11:24:54 listener-thread: err =…
RE: What do the results of doing onstat -u mean?
Might I suggest www.markscranton.com. cheers j. > -----Original Message----- > From: Tariro.Mukanyi@icl.com [mailto:Tariro.Mukanyi@icl.com] > Sent: Friday, January 12, 2001 1:52 AM > To: informix-list@iiug.org > Subject: RE: What do the results of doing onstat -u mean? > > > Hi…
Re: How to end a user session...
Use: onmode -z "sessid" where sessid is given to you by onstat -u command. Doina ----- Original Message ----- From: Denmark B. Weatherburn <dweatherb@btl.net> To: Informix Users Group <informix-list@iiug.org> Sent: Friday, January 12, 2001 1:28 AM Subject: How to end a user se…
RE: What do the results of doing onstat -u mean?
Hi guys I would like to know what the maximum, concurrent and total number of users mean. How do you check the maximum number of informix users allowed on your system? Are informix remote connections considered as users on both the remote machine and local machine? I really nee…
How to end a user session...
Denmark B. Weatherburn wrote in message <93lgi4$ivq$1@news.xmission.com>... > >Hi Listers, > >My question is how to end a user session once I've identified it using >onstat -u? > >Thanks, > >Denmark W. > Thank you for asking this question instead of going out shooting. onmode -…
Re: SET LOG question
Bogdan Neagu wrote: > Hi all. > > Let's say I have a database with Buffered Logging. > > I open a session and do a SET LOG; that redefines the logging mode to > unbuffered for this session only ( yes ? no ?) Only for that particular session. > > > How can I retrieve the loggin…
SET LOG question
Hi all. Let's say I have a database with Buffered Logging. I open a session and do a SET LOG; that redefines the logging mode to unbuffered for this session only ( yes ? no ?) How can I retrieve the logging mode of the session ? Does the server write imediatelly the transacti…
Re: KAIO ands "onstat -g iov" output
In article <932h3l$os4$1@nnrp1.deja.com>, William Rice <ricew@operamail.com> writes >I can't imagine a couple of extra AIOVP's having anything like a >significant impact on performance. > >Will >1 AIO VP's a) Use more memory - seperate process b) Use more thread schedu…
Lock
Hi DBAs, How will I get a list of locks pertaining to one database in a database server? Onstat -u will give me a list of all the session with a coloumn "lock" . But this will give me only the system wide locks used. I want it perticularly for one database in a database server. …
how to find how many user connected to database a day
Thanh Ngo wrote: > > Hi all, > 'onstat -g ses' show me who is currently connecting to > server. Is there a way I can count how many users were > connecting to server in a day or so? > > Any help would be appreciated. Record, daily, the max session id from onstat -g ses and subtr…
SID of a temporary table
> Is there any way to retrieve the ID of the session in which a temporary > table was created from another session? Thanks…
SID of a temporary table
Is there any way to retrieve the ID of the session in which a temporary table was created?…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Multiple users logging on with same ID
From: Sears Associate <pstuehl@sears.com> > >I have a question regarding multiple users logging into informix via >inet with the same user id. What type of problems can this cause. My >concern is what happens when page level locking is implemented and one >user is updating dat…
Multiple users logging on with same ID
I have a question regarding multiple users logging into informix via inet with the same user id. What type of problems can this cause. My concern is what happens when page level locking is implemented and one user is updating data at the same time another user with the same id…
IDS hungs
We installed a new porting Set to Baan server last weekend. At the same time we installed Iconnet version 2.4 to our IDS 7.31 FC2. Iconnect installation was required by new Porting set. After that we have had major problems with Baan client logging when there is over 300 Baan us…
onstat command from an app server how?
We are splitting our server into an app and DB server (2 different servers). How can I do an onstat - to see if the engine is up from the app server? I have my Informix variables set, but it's not working. Dbaccess works fine from the app box. INFORMIXSQLHOSTS=/u/ifmx/etc/sql…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: logical logs
Assuming it's a long transaction use: onstat -x The session with a "R" in it's flag list is the session rolling back, and therefore the session that generated your long transaction. -FPL >>> Aboobacker V V <aboo@syd-co.au.dhl.com> 08/31/00 08:16PM >>> Hi all, How to find out…
what to check when informix freezes??????
Hi, - check the duration of current Checkpoint. - free space in your chunks. - check locks of a specific user with 'onstat -u' ... Regards, Andi…
logical logs
onstat -u and look for the session(s) with lots of writes. Art S. Kagel Aboobacker V V wrote: > > Hi all, > > How to find out which session causing the logical logs to fill up. > > Regards > > Aboo…
onstat -u - Why so many redunant user id's????
Can anyone tell me why I'm getting so many redundant/duplicate user process id's when I run onstat -u? Below is an output from the following command: onstat -u | grep pamc why is sessid 54753 repeated? 40050c60 Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0…
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…
CDR_DSLOCKWAIT
With Enterprise Replication, the DataSync is the replay thread on the target system. It really runs as an internal transaction. Since it is a transaction, it is in competition with normal user sqlexec threads for the same resources. When the DataSync thread is running, it does …
Session begin time
Hi All, How to identify the start time of a session. Plese help. Regards Aboo…
RE: onstat -u error received
Sue Either the SMI interface is changing when you request this information, but more likely you have a version of IDS that has a bug .. think it relates to system names greater than 8 characters. The latter bug was fixed quite some time ago - upgrade if you are concerned. MW …
Tables accessed using synonyms
Suppose certain user threads are accessing a table using synonyms from different db's, does that thread shows in 'onstat -g opn' command. When i tried with onstat commands, it was showing no threads, still i didn't get exclusive access to the table., but i know there are differe…
Checkpoint/LRU question
"Manel Falcó i Aige" wrote: > > Hi, > Does a checkpoint block the users sessions ? As well when buffers are > flushed via MAX LRU ? At checkpoint time any users performing updates will be blocked. In addition, at least through 7.30 Informix says they have rewritten this in 7.3…
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…
Mystery Session
Hi, Under the IECC console in IDS 7.3 for NT, when there is only one user accessing the database, under sessions the user name of the client is displayed and another client, which looks like this: < (� Has anybody else experienced this? or know what it is??? /Kirk…
Re: Slowness
Thanks for all the posts. I did make some changes and it seems to have sped up quite a bit - my developer was out for a few days, so he'll be the final "judge" - he's the one with the query problems... Also one of our tables got error 136 (extents), so I had to "fix" that p…
Re: Performance Tweaking
From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: "AJ" <aj@acck.edu> >> >>I have an HP9000-800 series D270 two way running HPUX 11.0 and Informix >>7.3 >>Dynamic Server. >>I also have 1 Gig of memory installed, 3x 600 meg swapspaces, 100000 >>BUFFERS, 63 LRUs, NUMCPUVP=2, …
Re: Long Transaction
Well, if i reduce the LTXHWM, isn't it the Longtrx will occur more frequent?? Or i should said i need to increase the number of LTXHWM and LTXEHWM?? below is the output of onstat -l and onstat -p Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 6 days 16:26:22 -- 16…
Informix spawning threads every 5 seconds
In article <8id17o$8o$1@oak.fernuni-hagen.de>, Johnson <johnson@kudzu.fernuni-hagen.de> writes >We have Informix 7.23 UC3 running under AIX 4.2.1. Aio has been activated. >Using vmstat, I have observed that the number of runnable kernel threads jumps >from 0-1 to 19-21 every 5 se…
Row locked on reads even under dirty read
Hi again, family. This is not so much a call for help as it is a request for discussion. Here's the way the problem was presented to me: The programmer, Charlie, complains to me that his app is getting a slew of error 244/154 (or, if not waiting on locks, 244/144). (Exactly how…
RE: onstat -u
I was thinking about this after sending the msg...is it possible to be logged on, yet not have any active threads processing; so having the onstat -u not return anything is just showing that the user has no threads? Joe Robinson, SFC System Administrator USPFO for Oregon, Oregon…
RE: onstat -u
Are you sure he is actually connected to the database? onstat -u tends to show all the connected users.... Will >===== Original Message From RobinsonJ@or-arng.ngb.army.mil ===== >I have a telnet user who consistently is walking out the door without >logging off. Here's how I a…
onstat -u
I have a telnet user who consistently is walking out the door without logging off. Here's how I assume I should go about killing the user, with the problem listed below. 1. Do a who -u | grep username (identify tty port) 2. Do a onstat -u | grep username (to identify session i…
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…
RE: What is bufwaits (onstat -p)
>===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> ===== >"Art S. Kagel" wrote: >> >> The bufwaits indicates when a thread has to wait to read a page into a >> buffer from disk usually this is caused by the LRU Queue to which the thread >> has hashed to …
Re: What is bufwaits (onstat -p)
"Art S. Kagel" wrote: > > The bufwaits indicates when a thread has to wait to read a page into a > buffer from disk usually this is caused by the LRU Queue to which the thread > has hashed to acquire a buffer being locked by another thread trying to do > the same thing or needing…
Re: What is bufwaits (onstat -p)
Daniel Wood wrote: > > Bufwaits have little or nothing to do with LRU contention nor with > reading in a page from disk. As Vinod said it does occur when one > has to wait on a buffer because another is accessing it. I have to differ Daniel. There ARE situations, all too commo…
What is bufwaits (onstat -p)
The bufwaits indicates when a thread has to wait to read a page into a buffer from disk usually this is caused by the LRU Queue to which the thread has hashed to acquire a buffer being locked by another thread trying to do the same thing or needing to move a buffer from the 'clea…
Need Help Determining Locks
Joel, You have not mentioned the verion of Informix you are using .If the version is > 7.x , then you have use onstat ( informix utility ) command with foll. options : 1. -u , to check users and transactions 2. -k , lock status 3. -s , latch status 4. -g sql , to check the query…
Onstat
Hi all, I recently installed Informix dynamic server 7.31.UC6 on HP UX 11.0 I am getting an error while running onstat. "Changing data structure forced command termination. " can someone interpret this message for me and tell me the action to be taken. Thanks, Srini…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: Better locks info
Thanks for everyone's input.... actually, I was using something called onlocks, but if you're (Rudy's) who-lock.sh and who-access.sh use syslocks, then it will suffer from the same problem...... What I want is a fast script which tells me everything (I know, I always want too m…
Re: "Dead" user threads
Yuri Dovgart wrote in message <8cka0t$kge$1@hyppo.gu.net>... >SNIP >> >> How to configure DB server so that to automatically >> remove such user threads. > >You can use keepalive feature in 'options' field in 'sqlhosts' file. See >Chapter 4 of Administrators Guide for details. > …
Re: Better locks info
Appreciate your comments, Jake. In fact, the "Locking" script actually supports another script (that I use far more frequently) that helps determine the first signs of trouble within an instance. All it does is reduce the rows returned by "onstat -u" to those sessions that are "a…
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…
"Dead" user threads
Hello, all. ARCHITECTURE: server-side: Informix DS 7.31 under SCO Unix 5 client-side: programs written in PowerBuilder 6 under Win95/NT PROBLEM: Sometimes, e.g. when client-side program crashes, the corresponding user thread on server is not removed (it is present in the …
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Trace utility similar to Oracle's
there are many ways to look at a session; look at onstat -g ses <session id> for starters. if you do onstat -g sql you will see a list of session id's and the databases they use. another interesting way is to use xtree, if you can open it in an xterm client. this gives you a pic…
Serials and Stored procedures
Rob Wilson <rwilson@ntsource.com> wrote in message news:m7Vq4.886$Mn3.7118@newsfeed.slurp.net... > When you use DBINFO, you will get the last serial value from _your_ > session. Even if other people have made inserts after this session's, > you will have the correct number. Exc…
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…
Can the BTree cleaner thread block a user transaction? -Help
Now that I've posted it, I think the more appropriate title should be: Can the BTree Cleaner Thread block a user thread from getting an exclusive lock on the table? thanks, Lyzander * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and e…
Can the BTree cleaner thread block a user transaction? -Help
Informix7.24 UC7 on Solaris 2.6, ESQL/C 7.24UC7 Hi everyone! We have a process that used to run fine on our server for over a year. What the process does: unload about 200 rows to a file delete the same number of rows from the table begin work lock table in exclusive mo…
onstat -u shows "blocked: LONGTXN"
Yesterday some program seemed to go a bit silly and caused the engine to hang with a long transaction. onstat -u showed in the top line a message similar to "Blocked: LONGTXN". The engine was stuck for 1/2 hr so I called support believing that the roll back was not working. Infor…
onstat -u ....waiting on condition
Hi I was just looking at the output from onstat -u 3b706d2c Y--P--- 97984 3b70d958 Y--P--- 121881 3b710860 Y--P--- 100957 3b71167c ---P--- 121893 3b711fe4 Y--P--- 113791 3b71b1b0 ---PR-- 121842 3b7230ac Y--P--- 100952 3d96c014 S--PR-- 121894 3d96fd38 Y--P--- 104413 3d9714bc Y--P…
RE: Help: onstat -u
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_01BF62CB.E7D271F8 Content-Type: text/plain; charset="iso-8859-1" We see the same thing in 7.3 when we do a "onstat -g s…
Re: Help: onstat -u
Depending on the version of IDS you are using it is either just a VERY busy server (unlikely if it almost always happens) or a bug in onstat that was fixed in later versions. It usually helps to post platform and version information. Art S. Kagel lily wrote: > > hi, all > > …
what does info from onstat -g ses xxx indicate here
From what i know so far, this thread looks like its waiting on user input. But just seems to be a simple query that is taking ages. Apparently the developer done "set isolation dirty read". Any ideas ? session #RSAM total …
Re: onstat -u
---- you wrote: > I am running Informix 8.2 on HP-UX 11.0. When I issue onstat -u command > it shows the following: > address flags sessid user tty wait tout locks nreads nwrites > > Under flags option: > There are seven flags, the Seventh place flag is I know B,C,D,F; bu…
onstat -u
I am running Informix 8.2 on HP-UX 11.0. When I issue onstat -u command it shows the following: address flags sessid user tty wait tout locks nreads nwrites Under flags option: There are seven flags, the Seventh place flag is I know B,C,D,F; but it also shows M sometime. …
Help: onstat -u
hi, all I meet a strange things. When I use the command 'onstat -u', at the end of the output, it doesn't give the maximum concurrent users number, it give such a line: ...... Changing data structure forced command termination. I'd like to know what cause it ha…
Re: Session id
Jaroslaw select dbinfo('sessionid') from systables where tabid = 1; HTH Sujit Jaroslaw Pulkiewicz <pulkiewi@quantum.de> on 01/09/2000 12:49:34 PM Please respond to Jaroslaw Pulkiewicz <pulkiewi@quantum.de> To: informix-list@iiug.org cc: Subject: Session id Hi, How to re…
Session id
Hi, How to retrieve the ID of the current session from within SPL ? Regards. Jaroslaw Pulkiewicz…
datase connectivity problem
>What are your NETTYPE settings? These control the number of concurrent >connections your server will be able to handle. NETTYPE settings are as follows NETTYPE tlitcp,1,250,CPU The manual I have says that 1 thread is sufficient for 5-100 users and I was going to up it to 2 …
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: Strange advises
It sounds like what your basic questions are is "Do these suggestions make sense?" and "What can I do to improve performance?" > The first is "You have KAIO running. We are aware that this feature is > causing > performance problem with Informix implementation. Recommend to n…
IECC - no sessions
Hi I have IDS 7.30 on solaris 2.6. When I start the IECC 3.00 TC1 I see databases, dataspaces, table,.. - but I don`t see open sessions. What`s wrong ??…
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…
RE: system configuration
The first obvious issue is the number of sequential scans!! Have you run UPDATE STATISTICS as described in your release notes? It is most important to run regularly. You do not appear to have sufficient locks allocated (you ran out) and have contention of resources (latch waits…
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…
stored procedures and threads
David Henry wrote: > > I'm using Dynamic Server V7.3. > I have heard it claimed that all calls to stored procedures go via a single > thread. Can anyone verify or deny that claim? Stored procedures are executed by your current SQLEXEC thread. Someone may be thinking of UDFs in …
Long spins or onstst -g spi. Need any information.
First let me state that you do NOT have a spin problem. The reports you post show an engine that is healthy in this respect at least. I will try to explain as many of the various locks and latches as I know about below: Eugene Nechayev wrote: > > Hi Informixers > > Can somebod…
disconnect session
Hi, I have informix dbs 7.30 on solaris 2.6. How can I disconnect a user session ?…
disconnect user
Hi, I have informix dbs 7.30 on solaris 2.6. How can I disconnect a user session ?…
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…
onstat & SMI
Hi, does anybody knows what query (queries) I must run to produce same output as onstat -u command? I'm not sure for flags, which fields in SMI represents those flags. Thnx in advance.…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
strange session
When i start IDS7.30.FC7 on HP 11: oninit -s into quiescent mode, my logfile shows: 07:18:39 Quiescent Mode 07:18:39 Checkpoint Completed: duration was 1 seconds. 07:19:01 (20) connection rejected - no calls allowed for sqlexec 07:19:01 listener-thread: err = -27002: oserr…
IECC - no users shown
I have a IDS 7.30 on OS solaris 2.6. When I open the IECC I don`t see the sessions. With onstat -g ses the sessions are shown. I brought the IDS down, and started new. Who can help ?…
INFORMIX BUG !!!
Hi Gurus, Today I have faced a strange problem. Some users was not being able to log in database. Online.log was showing following error: 10:06:45 listener-thread: err = -951: oserr = 0: errstr = dispatch: Incorrect i password or user dispatch is not known on the database serv…
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…
How many memory is a session used ?
Dear ALL : Is there a way to monitor the memory usage of every session ? I mean, how can I determine which session used the maximum amount memory ? Thank for any answer and suggestion. I use Informix Online Dynamic Server 7.22UC3 on HP-UX 10.20. Jung-Hui Cheng cheng@dbtel.com.t…
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.…
Help !!!!!!
Hello all, Here is the issue. I have a huge insert/update/delete operation and i'm trying to do some benchmark. When i have five client programs running the same stufffs processes are taking 6-8 seconds for handling 100 records which consists of approx 1200 deletes.h 1200 updat…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
oninit trace to user
Hi, During peak usage, if I do a top, I see that oninit threads taking 80% of the cpu. Is there a way I can trace the oninit thread back to a user and an sql statement if applicable? The oninit thread might not be running an sql statement, but more times than not I would guess…
How do I increase user threads?
How can I increase the no. of user threads in Informix RDS 7.3? Do I have to make a change in onconfig or stune or mtune? Please help. Thanks. -- Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm).…
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…
onstat
Hello after executing an onstat following message appears in the first lines: "Changing data structure forced command termination" What does this mean? Why does the Profile (as in a normal onstat) not appear and the onstat view only shows me the sessid? Regards André…
Re: [Q] Record Locks - Continuing Saga... (RE: Art S. Kagel)
Your engine is blocked waiting for a checkpoint to complete (see the (CKPT REQ) in the header and the "Blocked:CKPT" on the second line!) and session 20 is waiting for the checkpoint to complete (see the 'C' in the flags column 1). You cannot kill that session until it tries to …
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…
Write cache low
Hi everybody there Following is onmonitor performance statistics and onconfig file listing. Can somebody help me improve write cache please ? STATUS: Profile Userthreads Spaces Databases Logs Archive ... Display system profile information. -----------------------------On…
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.…
RE: Question about IDS scalabiltiy
Carlos Bolden wrote: [LOTS OF GOOD STUFF SNIPPED including ONCONFIG] See Obnoxio's comments they are all right on the money. I would add the following based only on guess work (I'd need the onstats I mentioned in my last post to really diagnose): TAPEDEV=/dev/null ????????? …
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: Maximum Concurrent Users
From: ericl@panix.com (Eric Lorenzo Lim) > >On Online 7.11.UC1, what determines the maximum concurrent >users shown on the last line of onstat -u? Is it physical memory, >some some tuneable parameter settings? > >My onstat -u at one point showed 22 maximum concurrent users >but …
Maximum Concurrent Users
On Online 7.11.UC1, what determines the maximum concurrent users shown on the last line of onstat -u? Is it physical memory, some some tuneable parameter settings? My onstat -u at one point showed 22 maximum concurrent users but now it's showing only 17. Thanks! seejah! ...er…
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…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
DataWarehouseForum serves as an on-line user group for current and prospective data warehouse users
www.DataWarehouseForum.com DataWarehouseForum serves as an on-line user group for current and prospective data warehouse users. The intent of DataWarehouseForum is to provide a continuing presence for business and IT user to exchange current …
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…
onstat -u problems
Whenever i run onstat -u i receive following message INFORMIX-OnLine Version 7.13.UC1 -- On-Line -- Up 5 days 01:49:50 -- 30456 Kbs Userthreads address flags sessid user tty wait tout locks nreads nwrites b028010 ---P--D 0 root - 0 …
The ready queue Full but Unix not busy
Can anyone explain the lngspins column ? > MT global info: > sessions threads vps lngspins > 6 37 14 446935 > Spin is situation, when vp wants to acquire latch on the resource, but has to wait, because resource is locked. Long spin - when VP spins more …
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: 7.31 is it the answer?
Nicole Guffey wrote: > > Anyone know when 7.31 for NT will be out, if it's not already? Also, > does anyone have the quick and dirty on what has been fixed/improved in > 7.31, or at least point me in a direction (other than informix sales) > where I can get GOOD technical info o…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
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 …
Re: onstat -u / onstat -g ses Problem
Informix Netherlands advised to start the database with the environment variable SINGLESEG_OFF=1. Try it! Regards Hans Bosma Database Administrator NCCW(Netherlands Ing Thoralf Bihlo wrote: > > I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server > 7.30 UC6. >…
REQ: Problem with onstat -u / onstat -g ses
I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server 7.30 UC6. My SHMVIRTSIZE is 32k and onstat -g seg shows that I have just one Segment. When I try an onstat -u or onstat -g ses I get the Error: >Changing data structure forced program termination< during the …
error -951
Over the weekend we updraded from HP-UX 10.10 and Informix 7.24UC6 to HP-UX 10.20 and Informix 7.30UC7. After this upgrade the user root is generating a 951 message. 10:12:59 listener-thread: err = -951: oserr = 0: errstr = root: Incorrect password or user root is not known on …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
DBA probems
Hi this is mukund I face a problem with onstat -u utility. It returns an error 'Changing data structure forced command termination' Can anybody help me on that ? I have informix online (IDS) engine ver 7.13. Sql serial no AAB#J516701 Thanks Mukund ____________________________…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
onstat -t
Hello, Is there anyway to tell what the actual tablenames are when you execute a onstat -t ? I know that tblnum is the tablespace number, but what can this be related too to tell me something useful? Thank you david.tamburin@protegrity.com david Tamburin…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Re: checkpoint time > 15 sec.
Art S. Kagel wrote: > The incidence and impact of bufwaits due to individual buffers is minor > compared to the incidence and impact of bufwaits due to not being able > to latch an LRU queue. Why would that be a bufwait? Surely that would be a latchwait or a mutexwait. (Don't …
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: oninit & user threads
In article <367e5ca1.0@145.227.194.253>, "Sean Kelsey" <Sean.Kelsey@lsa0103.wins.icl.co.uk> wrote: > Yuletide greetings to one and all ! > > Chit-chat over, lets get on with my question... > > OnLine 7.24.UC5 on HP-UX 11 > > Does anyone have a good way of establishing what thre…
Re: oninit & user threads
onstat -g sch will tell which vp is in which oninit process. This doesn't change. onstat -g act will give you the running threads. Steve Berg On Mon, 21 Dec 1998, Sean Kelsey wrote: > Yuletide greetings to one and all ! > > Chit-chat over, lets get on with my question... > > …
oninit & user threads
Yuletide greetings to one and all ! Chit-chat over, lets get on with my question... OnLine 7.24.UC5 on HP-UX 11 Does anyone have a good way of establishing what threads are actually running on an/all oninit process ( or VP for that matter ), at any point in time ?? Yeah, yeah…
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: Informix Performance
>Speaking of this, when the 'User thread Status' shows 'Y--P---' it >indicates that the process is waiting on a 'condition'. It often seems >this indicates the process is waiting on some input from a user process via >the network. However, this may not always be true. Is there…
Re: User thread status help
gquian wrote: > > I'm running an application process that works abnormaly slow on Informix > >Online DS. > >I've take a look in on-monitor about user-threads. > > > >The 'User thread Status' column shows 'Y--P---' during a lot of time. Like the 'B' in your first posting the 'Y'…
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: Informix Performance
Read the Manual. It tells you what those status flags mean, in the section entitled "Monitoring OnLine." The "B" tells you that the thread is waiting for a Buffer, which could tell you that you're I/O bound. The "P" tells you that this is the Primary thread for that session. …
Re: User thread status help
What, specifically, is the process trying to do? The "Y" means that it's "Waiting on a condition" such as a user response. I'd also check to see how OPTCOMPIND is set. gquian wrote in message <911819846.930921@proxy.inode.es>... >I'm running an application process that works a…
User thread status help
I'm running an application process that works abnormaly slow on Informix >Online DS. >I've take a look in on-monitor about user-threads. > >The 'User thread Status' column shows 'Y--P---' during a lot of time. > >Do you know what's happening? > >Should I change any parameter? > …
Informix Performance
I'm running an application process that works abnormaly slow on Informix Online DS. I've take a look in on-monitor about user-threads. The 'User thread Status' column shows 'B--PR--' . Do you know what's happening? Should I change any parameter? A lot of thanks for your help.…
Re: matching sessions with databases
Hi Nicole, If you run a onstat -g ses # of the session id at the bottom it will tell you the current database for that session id. Nicole Guffey wrote: > Is there a utility, or a piece of code, that identifies which > database (or even dbspace) a session is accessing? > > …
matching sessions with databases
Is there a utility, or a piece of code, that identifies which database (or even dbspace) a session is accessing? Thank You, Nicole Guffey Nguffey@jdriscoll.com…
Re: concurrency problem in 5.07
In article <364A546F.54AB198@hotmail.com>, June Tong <june_t@hotmail.com> writes >robert schmidt wrote: > >> when more than two queries run concurrently, the response time is >> highly degraded. All of the data that the queries are reading >> is in informix buffer cache, so there…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Re: concurrency problem in 5.07
robert schmidt wrote: > when more than two queries run concurrently, the response time is > highly degraded. All of the data that the queries are reading > is in informix buffer cache, so there is no i/o time. > The inquiries are read only (cursor stability), > so not too much l…
Re: Script to find 'active' IDS 7.2x threads
Thomas J. Girsch wrote in message <363f83a4.0@news.one.net>... >What's wrong with onstat -g act? > >Or the sysmaster database, for that matter? > >The Wilcoxons wrote in message <71nr8s$lo6$1@nw003t.infi.net>... >>Here is a script we have used to track 'active' threads in IDS 7.2…
Re: Script to find 'active' IDS 7.2x threads
What's wrong with onstat -g act? Or the sysmaster database, for that matter? The Wilcoxons wrote in message <71nr8s$lo6$1@nw003t.infi.net>... >Here is a script we have used to track 'active' threads in IDS 7.2x . We >have it linked to onstat-u and onstat-ur so we can have it re…
Script to find 'active' IDS 7.2x threads
Here is a script we have used to track 'active' threads in IDS 7.2x . We have it linked to onstat-u and onstat-ur so we can have it repeat or not. S.W. wilcoxon@pioneerplanet.infi.net -------------------------------Cut Here------------------------------------ #!/bin/sh # # Do a…
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 equivalent to the Unix 'top' command?
Does anyone know of a database equivalent to the unix 'top' command (public domain) which would list the most resource hungry instance. I realise ontat -u might go someway to achieving this (assuming performance problems are user related) but is not ideal on a multi-instance mach…
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.…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
dengelsen@my-dejanews.com wrote: > > Hello, > > Informix (7.23) produced the following error in the message Log File: > > CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on > NET VP's. > > What does this message mean? You have requested that your poll th…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: onstat -u
In article <3612E041.665A3885@hotmail.com>, june_t@hotmail.com (June Tong) wrote: > David Meyer wrote: > > > I was running an 'onstat -u' command and have been receiving the > > following message: > > > > "changing data structures forced command termination" > > > > I was wonder…
Re: onstat -u
David Meyer wrote: > I was running an 'onstat -u' command and have been receiving the > following message: > > "changing data structures forced command termination" > > I was wondering if any of you have seen this message and might know > what it means and how to correct it? Yu…
Re: onstat -u
We experienced a similar problem. Here, it was related to the fact that our instance's Resident shared memory requirements exceeded the Unix Kernel parameter 'shmmax' [the recommended value is in the release notes]. Once Resident SM was less than shmmax,…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
onstat -u
I was running an 'onstat -u' command and have been receiving the following message: "changing data structures forced command termination" I was wondering if any of you have seen this message and might know what it means and how to correct it? David Meyer Guerilla Software…
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: Tuning kernel for Pyramid Nile
Normally you will find a starting point in the $INFORMIXDIR/release/* directory. Assuming you have already set up these parameter, and the onstat -g seg , shows no more than one virtual segment, just give us some answers: 1) What is the output of onstat -p ? 2) Do you experiment…
Re: Tuning kernel for Pyramid Nile
Normally you will find a starting point in the $INFORMIXDIR/release/* directory. Assuming you have already set up these parameter, and the onstat -g seg , shows no more than one virtual segment, just give us some answers: 1) What is the output of onstat -p ? 2) Do you experiment…
Cost of Sessions
Hello. Does anyone have or know where I can information on the cost of creating a database session? We're using ODS 7.22.UC1 on Solaris 2.5.1 using ESQL/C. I'm interested in for time-to-create, memory usage, cpu usage, etc... Thanks! -- Joseph Kormann jkormann@mcs.mds.lmco.com …
Lock Timeouts - Help needed
We have migrated from an Online 5.0 engine on a SPARC machine to Online 7.02 on an Intel machine. We ran the normal dbexport and dbimport and got the database up and running. We then ran update statistics to optimise the system. We are now getting masses of Lock Timeouts on tab…
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…
Session Timeout
Dear All, Greetings. If the user terminal is not active (idle) for a certain period and is = not running any process (like batch updating) and so forth, how do I use = the OS to kill the inactive user session. Basically, I would need a UNIX script to accomplish that but my cur…
onstat -u output
Hi , Does any one know what "# of maximum concurrent users" mean at the (last line) end of onstat -u output ? There is no USERTHREADS parameter in our onconfig file (like the book says). We have 7.13 UC2 on solaris 2.4. Thanks. Keith…
SMI query for onstat - g opn (open tables)
I'm trying to write an SMI query similar to "onstat - g opn" which shows open tables for each user thread. But, I want to see the username, database name, and tablename instead of thread ID and table partnumber in hex!!! I can't seem to track down the columns that I need in the…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: latch/lock , buffer - questions.
Sadagopan, Sathish wrote: > > Hi All, > 1) When a thread needs a buffer to read in data , does it acquire any > latches/locks.How is the allocation done ? This is all explained in the Administrator's Guide. Basically the thread hashes into the LRU queues selecting a queue at …
latch/lock , buffer - questions.
Hi All, 1) When a thread needs a buffer to read in data , does it acquire any latches/locks.How is the allocation done ? 2) What is the difference between locks and latches. 3) If i want to track , the number of times a PARTICULAR user's operations caused his threads to wai…
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 …
Q:How to find list user sessions with database
Hi, Please excuse me if this is obvious. Does anyone have a simple way (sysmaster query or onstat option) of listing the sessions on a server and the database they are currently connected to. I have a script that does it by going through the onstat -u output and calling onstat…
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: Problem with "Changing data structure forced command termination"
On Thu, 9 Jul 1998, Art S. Kagel wrote: > PabloF@my-dejanews.com wrote: > > > > Hi All, > > Anyone out there knows why i can read sometimes the message > > "Changing data structure forced command termination." > > when i execute "onstat -g ses" ? > > I think there's a problem w…
Re: Problem with "Changing data structure forced command termination"
PabloF@my-dejanews.com wrote: > > Hi All, > Anyone out there knows why i can read sometimes the message > "Changing data structure forced command termination." > when i execute "onstat -g ses" ? > I think there's a problem with a ODBC connection. OK definitive answer. Remember…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
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…
Re: Thread process and Informix license
>From: "Art S. Kagel" <kagel@bloomberg.com> >Date: Mon, 30 Mar 1998 11:30:42 -0500 >Subject: Re: Thread process and Informix license >Message-ID: <351FC8B2.BC2@bloomberg.com> >Reply-To: kagel@bloomberg.com >Organization: Bloomberg LP > >PCGRP Yakov Berkovitch 5055 wrote: >> >> Is…
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: +…
sid <--> tid
Hi everyone. How I can determine, to what user session (sid) belongs thread ( tid ) Thanks. Serg…
How to get the current sid !
How can I get the current Informix-session-id within an current session ? We use Informix Online 7.2 Thanks Rene Kursawe…
Oninit sessions
I am in the process of doing some system related research. I was wondering what is the typical number of VPs that would be defined on a production node? Do the number of servers also relate to the number of VPs being defined? Many thanks. -Ken.…
oninit sessions
Does anybody know what the aproximate number of oninit sessions should be under normal operating conditions for Informix 7.2. I am asking because I have 28 oninit processes running on our Sun-Ultra and I am worried that something got corrupted on our machine after a hard crash th…
Meaning of drcb_bqe
I have another challenging question which may shed some light on my long checkpoint problem: What does the abreviation "drcb_bqe" stand for? Here's the context of the question. NOTE: Only the pertinent lines of the onstats are shown. onstat -l has the following entry in it: …
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: onstat -u
Harold asks: >Here's a good question. > >Sample: > >4004d214 Y--P--- 4999 dbolte 91 40c936d8 >4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 >4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 >4004e314 Y--P--- 5023 hwhite …
Re: onstat -u
Hi, "128 total" means the initial size of your user table. When you will need 129 concurrent sessions, Informix will add an additional table with again 128 entries. The USERTHREADS table changed from a static size ( pre 7.10UD1 ) to a dynamic size. Bye Stefan Weideneder Harol…
Re: onstat -u
In article <6h5n5u$2hc$1@news.xmission.com>, Harold Luse <hluse@vth.colostate.edu> writes > > >Here's a good question. > >Sample: > >4004d214 Y--P--- 4999 dbolte 91 40c936d8 >4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 >4004ded4 Y--P--- 4484 …
onstat -u
Here's a good question. Sample: 4004d214 Y--P--- 4999 dbolte 91 40c936d8 4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 4004e314 Y--P--- 5023 hwhite 77 40006f8c 0 …
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…
System Crash
We are running a 7.23 system and today morning we got the following message : mmt.c line 2447 , thread 1255 , proc id 1044 , yield_processor : Stack overflow in thread 1255. message. The system is up but no one can connect we can't shut the system down or…
Re: Thread process and Informix license
PCGRP Yakov Berkovitch 5055 wrote: > > Is anybody know if i need a license per process or per thread ? > > I have a multi-thread process that performs parallel connections to a > database. Do I need a license for each of the thread or only for the > process ? No, Informix licens…
Posting from the Informix-list
Hi: We are running a 7.23 system and today morning the we got mmt.c line 2447 , thread 1255 , proc id 1044 ,yield_processor : Stack overflow in thread 1255. message. The system is up but no one can connect we can't even shut the system down or kill…
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: KAIO vps, and bufwaits
David Williams wrote: > In article <6bq06q$8tp$1@news.xmission.com>, Art S. Kagel > <kagel@ns1.bloomberg.com> writes > >On Mon, 9 Feb 1998, Tony Tyrwhitt-Drake wrote: > >When a thread needs a buffer to update and the page is not already in > >the buffer pool the thread uses a …
Re: (CKPT REQ) ?????
W. H. SMITH wrote: > > Barry Lemrow wrote: > > > > I have been experiencing problems where the database locks up. The onstat > > command banner contains this: > > > > INFORMIX-OnLine Version 7.21.UD3 -- On-Line (CKPT REQ) -- Up 6 days > > 05:13:28 -- 175552 Kbytes > > Blocked:…
onlog -n hung, online (CKPT REQD)
Hi, I wanted to examine the current logical log file, (I was not logged in as informix). onstat -l showed the following: a22e648 1 U---C-L 24596 100a03 250 247 98.80 a22e664 2 U-B---- 24590 100afd 250 250 100.00 a22e680 3…
Detecting cursors in OnLine 7.x
Is there a way to see how many cursors a particular session id has open in ODS 7.23? -- Scott Kolaya kolaya@acmenet.net…
Re: how to remove stale locks ?
Christian Haul wrote: > > Hi. > > Over here student develop programs in java using the jdbc:odbc bridge > to connect to informix oline 7.23. When their programs crash, the locks > are not released properly. Hence I need a way to remove them. So far I > couldn't find a proper way …
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: Who is blocking ?
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 address. the owner-adress from this r…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Re: Extended checkpoint times
Michael Segel wrote: > > anonymous wrote: > > > Hi, > > [SNIP] > > From the informix manual it states checkpoints wait for critical code > > sections to complete before it can complete > > so in theory if an application hung for whatever reason inside a > > critical code section …
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…
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: Multi Thread App
On Tue, 6 Jan 1998, Alexander Jaremenko wrote: } Hello Mr Kagel, } Thank You for response. } } > ODS/ESQL-C versions 7.21 and later support threaded applications. } > Versions prior to 7.13 supported only one connection per process and } > 7.13->7.20 supported multiple sessions …
Re: Multi Thread App
Alexander Jaremenko wrote: > > Hi All, > I'm about to write multi thread application with ESQLC. I would like to > know how ODS would treat multiple threads doing sql requests - as > separate DB - user sessions ? > Happy New Year! ODS/ESQL-C versions 7.21 and later support thr…
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…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
SPL glob var. set from outside session
Hi, is it possible to set a global SPL variable from outside the session in which it applies ? tnx -Peter Groarke…
Isolation Level
Hi. How can I know the current isolation level for a session? Thanks.…
Checkpoint blocked ?
On AIX 4.2 with OWS 7.20.UC2, I had a deadlock situation twice in a short time : nobody could work, and an onstat gave the message : checkpoint required, blocked. I had to stop Informix (onmode -k) and restart (oninit). I guess that some user threads where blocking the checkpoin…
Re: Onstat Utility
>Hi, > I'm using onstat -g ath and see threads that are slleping forever. >What could this be? Are users not exiting properly from Informix? How >do I kill these processes. > > The "sleep forever" threads are threads that will be remain dormat until they are activated by some o…
Onstat Utility
Hi, I'm using onstat -g ath and see threads that are slleping forever. What could this be? Are users not exiting properly from Informix? How do I kill these processes. Thanks Bob…
Transaction Id/ Connection Id
Hello, With Informix Ver7.xx It is possible to have multiple connections/sessions to the Informix online server in the same process. Within each such connection to the database we can have a transaction, Thus we can have more than one transaction within a DB server. For each s…
Re: informix logical logfiles
I suspect either you just restarted your database engine or may have run onstat -z which might? zero out these statistics. Are either of these true? -Bill } } > We use informix online 7.11 and I think our applicaton behave a bit strange. } > } > After } > onstat -l } > } > Buffe…
informix logical logfiles
> We use informix online 7.11 and I think our applicaton behave a bit strange. > > After > onstat -l > > Buffer bufused bufsize numpages numwrits pages/io > P-1 0 16 0 0 0.00 > phybegin physize phypos phyused %used > 108b75 10000 …
Re: Information about tables in use?!
Hi! I'd just add that there is an undocumented onstat option, -T, which does the same thing as -t, but list ALL that are cached, not only the active ones. I've found a use or two for this puppy. It's been around since 7.10.UD1 at least I think.... Rgds Karlsson Art S. Kagel…
Re: Information about tables in use?!
Mr Cheuk Kong Lo wrote: > > I'd like to know if there is a way to find out what tables are in use > by a user (thread). Any possible of knowing what row is current in use > by a user (thread) as well? > Onstat -g opn shows open tables by thread id. Onstat -k will show locked ro…
Information about tables in use?!
I'd like to know if there is a way to find out what tables are in use by a user (thread). Any possible of knowing what row is current in use by a user (thread) as well? Thanks. -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.s…
Re: onstat -u, B-flag
Alexander Selg wrote: > > June Tong wrote: > > > > Alexander Selg (alexander.selg@siemens.at) wrote: > > The Problem was, that our UPDATE STATISTICS HIGH, which runs every day > for 29 tables, didn't come to all tables because it needs to much time > (after 24h the process contro…
Re: onstat -u, B-flag
Alexander Selg wrote: > > Hello All ! > > The command "onstat -u" gives some information about the userthreads. In > the 2.column you can see the flags to each thread. The 1.position > indicates the resource a thread is waiting for. > My question is: if there is a "B" on the 1.po…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: onstat -u, B-flag
June Tong wrote: > > Alexander Selg (alexander.selg@siemens.at) wrote: > : The command "onstat -u" gives some information about the userthreads. In > : the 2.column you can see the flags to each thread. The 1.position > : indicates the resource a thread is waiting for. > : My que…
Re: onstat -u, B-flag
Alexander Selg (alexander.selg@siemens.at) wrote: : The command "onstat -u" gives some information about the userthreads. In : the 2.column you can see the flags to each thread. The 1.position : indicates the resource a thread is waiting for. : My question is: if there is a "B" o…
RE: onstat -u, B-flag
Alexander, Your session id 386 is waiting on a buffer, has issued a begin work, is the primary thread for the session and was executing an rsam call. You can find what kind of buffer it is waiting by running the following sql statement. SELECT is_wbuff , is_wlogbuff FROM sysse…
onstat -u, B-flag
Hello All ! The command "onstat -u" gives some information about the userthreads. In the 2.column you can see the flags to each thread. The 1.position indicates the resource a thread is waiting for. My question is: if there is a "B" on the 1.position, which means the thread is w…
When does bufwaits get incremented ?
Hey, I've been trying to track down some information about when bufwaits is incremented. I found the following in the ODS Admin guide... "When a user thread needs to acquire a buffer, Online randomly selects one of the FLRU queues and uses the oldest or least-recently used entr…
Username for this session
Hello, I am involved in a LiveWirePro application with OWS 7.12TC5. In a particular Insert statement, one of the fields is the name of the user who is currently performing the Insert operation. Is there a variable in Informix like Oracle has "userid" which holds this value and …
How do you terminate user threads?
Please send information on how to terminate userthreads from command line. Also, are there any good GUI for informix that run on Solaris 2.5.x. Thanks, David Webb dtwebb@encoredev.com…
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…
orphan sessions in ODS 7.2
Greetings... Does anybody out there know a way to identify orphan sessions in a 7.2 engine? Andy…
Re: UserId/Passwd error.
Rajesh Koilpillai wrote: > > Hi > > I am getting this error message when i try to start the > Informix server > > 12:32:27 listener-thread: err = -951: Incorrect password or user informix is no > t known on the database server. > > 12:34:47 listener-thread: err = -9…
Re: UserId/Passwd error.
Rajesh Koilpillai wrote: > > Hi > > I am getting this error message when i try to start the > Informix server > > 12:32:27 listener-thread: err = -951: Incorrect password or user informix is no > t known on the database server. > > 12:34:47 listener-thread: err = -9…
UserId/Passwd error.
Hi I am getting this error message when i try to start the Informix server 12:32:27 listener-thread: err = -951: Incorrect password or user informix is no t known on the database server. 12:34:47 listener-thread: err = -951: Incorrect password or user informix is no t k…
Re: Informix and Oracle in the same shop
news_reader@mew.corp.sgi.com (Pablo Sanchez) wrote: >No vendor, that I know of, is truly multi-threaded... at least in the >sense of user threads and the like. Your view of multi-threading is very much from the OS point of view and from that view, all databases are not multi-th…
Re: Informix and Oracle in the same shop
In article <33935782.7D9610FC@devnull.org>, Tim Schaefer <devnull@devnull.org> writes: > Pablo Sanchez wrote: > > > > No vendor, that I know of, is truly multi-threaded... at least in the > > sense of user threads and the like. > > -- > > whoa! > > Finally somebody mentioned the …
How do I know....
Greeting... Can anyone tell me how do I know how long a user session has been connected to an Informix 7.2 engine? I can not find this information from onstat -u. Please let me know! Thanks Andy Chang…
Re: Blocking of user threads
>We are using Informix Online 7.13. The problem is that usually >the user threads get blocked and if the applications which was >accessing the thread exit the database which that thread was accessing >gets blocked. Hence to access that particular database once again we >need to b…
Blocking of user threads
Hello, We are using Informix Online 7.13. The problem is that usually the user threads get blocked and if the applications which was accessing the thread exit the database which that thread was accessing gets blocked. Hence to access that particular database once again we need t…
Re: INFORMIX-OWS on UNIX
Lutz Wiggershaus wrote: > Is it correct, that there is a max of 32 or 64 parallel user threads in > a normal installation OWS? Is there a possibility of increasing this > number? How can i manage to get it to 96? > Thankx, > Lutz > > Lutz Wiggershaus wiggershau…
Re: 7.22 onstat -u flags
On Wed, 12 Mar 1997, Allen W. Jantzen wrote: } Well, I finally moved my production db to 7.22 from 5.03. After } (finally) remembering to do an UPDATE STATISTICS and tuning } the parameters, things seem OK, but a bit slower than ver 5.. } } My question: the onstat -u output ha…
Re: 7.22 onstat -u flags
With DSA (6.x 7.x), the onstat -g ath is probably going to give you more information about what's going on in the engine than the onstat -u. You will often see the sqlexec thread (these are the user functions) on a condition wait (sm_read) or condition wait (netnorm). This is t…
Re: 7.22 onstat -u flags
On Thu, 13 Mar 97 05:43:05 GMT, rferdy@kuwait.net (Rudy Fernandes) wrote: >>> My question: the onstat -u output has a "Y" in the first slot of the >>> flags column for _all_ my client processes almost all the time. >>> >>> The doc just says that a "Y" means that the process is …
Re: 7.22 onstat -u flags
On Thu, 13 Mar 1997 01:43:49 +0000, David Williams <djw@smooth1.demon.co.uk> wrote: > A condition is a mutex (latch). Look in $INFORMIXDIR/etc/sysmaster.sql > as search for "create table sysconlst". This is "{ Conditions }" and > contains one field "con_nwaits integer, …
Re: 7.22 onstat -u flags
In article <3326ED29.32C7@worldaccess.nl>, Gert van Eck <gvaneck@worldaccess.nl> wrote: >Allen W. Jantzen wrote: >> My question: the onstat -u output has a "Y" in the first slot of the >> flags column for _all_ my client processes almost all the time. >> >> The doc just says…
Re: 7.22 onstat -u flags
In article <3326ED29.32C7@worldaccess.nl>, Gert van Eck <gvaneck@worldaccess.nl> writes >Allen W. Jantzen wrote: >> >> Well, I finally moved my production db to 7.22 from 5.03. After >> (finally) remembering to do an UPDATE STATISTICS and tuning >> the parameters, things seem OK…
Re: 7.22 onstat -u flags
Allen W. Jantzen wrote: > > Well, I finally moved my production db to 7.22 from 5.03. After > (finally) remembering to do an UPDATE STATISTICS and tuning > the parameters, things seem OK, but a bit slower than ver 5.. > > My question: the onstat -u output has a "Y" in the first…
7.22 onstat -u flags
Well, I finally moved my production db to 7.22 from 5.03. After (finally) remembering to do an UPDATE STATISTICS and tuning the parameters, things seem OK, but a bit slower than ver 5.. My question: the onstat -u output has a "Y" in the first slot of the flags column for _all_…
Multi-threaded applications for On-Line
I am currently developing multi-threaded ( Solaris thread ) application for Informix On-line. I was told to wait till ESQL/C Version 7.2 to use threading in my application. Page 11-4 on the Informix ESQL/C Programmer's Manual Version 7.2 tells me that only DCE thread package is …
Multi-threaded applications for On-Line
I am currently developing multi-threaded ( Solaris thread ) application for Informix On-line. I was told to wait till ESQL/C Version 7.2 to use threading in my application. Page 11-4 on the Informix ESQL/C Programmer's Manual Version 7.2 tells me that only DCE thread package is …
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: -951 error
In article <331B4EFA.90@acer.de>, Kai Shen <shen@acer.de> writes >Hi all, > >after installing Online 6 on SCO OS 5.0.1 as user informix.informix we >get the message >listener-thread: err = -951 User informix is not known on the database >server >This occurs both with and without …
Re: -951 error
Kai Shen <shen@acer.de> wrote: >Hi all, > >after installing Online 6 on SCO OS 5.0.1 as user informix.informix we >get the message >listener-thread: err = -951 User informix is not known on the database >server >This occurs both with and without NIS installed. > Is the user 'in…
Re: -951 error
Kai Shen <shen@acer.de> wrote: >Hi all, > >after installing Online 6 on SCO OS 5.0.1 as user informix.informix we >get the message >listener-thread: err = -951 User informix is not known on the database >server >This occurs both with and without NIS installed. > Is the user 'in…
Re: HELP: MEANING OF onstat -g sch output
In article <5ds4qr$hg4@cssun.mathcs.emory.edu>, Rick Ward <wardr@gusco.com> writes >Edward Bidinotto wrote: >> >> Can anyone explain what the output on onstat -g sch means especially the >> column >> "busy waits"? Does a high number in that column mean that the vp is >> staying b…
Re: onstat
Steve Romankiw wrote: > > In onstat, what does "total" refer to. > > . > . > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 > 0 > 13 active, 128 total, 44 maximum concurrent > > Thanks. > > Steve Romankiw > Executive Risk Inc. From the Informix Administrat…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
Re: OnLine Internals and Performance Questions
jim, > - The IFMX docs say that MAXCPUVP should not exceed the real number > of processors in the system. However, my CPU's are typically running at > 50-65% utilization. Is there really anything that could go wrong if the > number of CPU VP's were greater than physical p…
From Port to Process
Hi, is it possible to trace an Online-connection back from the portnumber in netstat to the user-thread? Thanks, Patrick --- Patrick Preuss http://home.t-online.de/home/patrick.preuss ppr@deckard.hb.…
Re: Userthread increase in Informix 7.11
cw.Lin wrote: > > WE would like to know how to increase userthreads in Informix 7. The User Threads can be add by add NETTYPE in $HOEM…
How to increase userthread in Informix 7.11
We would like to know how to increase the number of userthreads in Informix 7.11UC2 ? From the last line of "onstat -u " command show as followings: " active user xx , 128 total , max concurrent user xxx" Does this "128 total" is the number of user licence ? can we increase th…
Total users
(Informix OnLine DS 7.12.UC5, 150 user license on Sparc1000 Solaris 2.4) This question is prompted by a certain nervousness caused by the following: Last line of onstst -u (on a slow day) 85 active, 128 total, 99 maximum concurrent (and, yes, most of these are 'REAL' user thr…
Restricting Concurrent Sessions, OnLine 7.12 for UNIX/Solaris
We would like to restrict each user to running no more than 3 concurrent OnLine database sessions (number of threads is not of concern). The users might be connecting via DBACCESS, ISQL, 4GL programs, ODBC, NewEra... Any ideas on how to neatly enforce this restriction? Thanks.…
7.11.UC1 Database Hangs & Error 908
I'm joining a new group who is experiencing database hangs and error 908s. If someone is logged into Informix and/or is running a process, they hang with no error messages. Users trying to connect receive 908 errors, Attempt to connect to database server failed. The Informix l…
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: unexpected virtual processor termination
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-140477562-830393090=:47444 Content-Type: TEXT/PLAI…
Re: System tuning
In article <4ivh5r$guu@cssun.mathcs.emory.edu>, Informix Sysadmin <informix@asl3.asl-labs.bc.ca> wrote: > >This is on a system that has between 20-35 informix users, 128Mb RAM, >2x88100 CPU's running DG/UX5.4R3.10 The database is on 5x1Gb RAID5 >disks. Does it seem immediately o…
Re: sessid and pid
Hi Lin, Lin-Chuan Lee wrote: > can someone explain the relation between sessid and pid ?? > tbstat -u generates (among other things) unix pid > while onstat -u gives sessid. New to V7 ... The 'pid' that tbstat -u gives is the Unix pid of the sqlturbo *process* that is the engi…
sessid and pid
can someone explain the relation between sessid and pid ?? tbstat -u generates (among other things) unix pid while onstat -u gives sessid. New to V7 ... Thanks in advance, -Lin…
-107 error is still there
A few days ago I posted an article about a problem with locking in Online 7.11.UC1 on a HP-UX machine.Jim Gordon posted me an answer stating that there was a syntax error on the create index command and that he couldn't reproduce the error on his HP-box.The syntax error was a typ…
Re: ONSTAT question
Bashar Chalabi wrote: > onstat -u (version 7.1) sometimes shows a user thread with position > 1 of the flag field set to Y. The Informix manual says it means > "Waiting for condition". I cannot find anything else. > > What is a condition, and why is my thread waiting for it? A c…
ONSTAT question
Hi there. onstat -u (version 7.1) sometimes shows a user thread with position 1 of the flag field set to Y. The Informix manual says it means "Waiting for condition". I cannot find anything else. What is a condition, and why is my thread waiting for it? Thanks for any help Ba…
NewEra run on OS/2 win-os2 ?
Can run NewEra on OS/2 win-os2 Session ?…
Re: Hanging processes after database startup
Lou, I missed your original post so please bear with me. Have you used "onstat -u" to see what everyone is waiting on? The flags column should tell you the type of wait. If it's a latch or lock wait, the wait column might help trace down the specific problem. (That's a…
Re: Wierd problem
> We have a home-grown, UNIX-based configuration management (CM) system > builtusing shell scripts, SCCS and make. We use this system not only to > configureand build software loads, but also to build test databases. > This allows eachengineer to easily build a test database for…
Re: Wierd problem
Roger: Are you running OnLine? Version 5.x, 6.x or 7.1? Are you doing this with dbaccess or over the network? These issues could have something to do with the problem. Roger Tomas <tomasr@agcs.com> wrote: >We have a home-grown, UNIX-based configuration management (CM) system…
Wierd problem
We have a home-grown, UNIX-based configuration management (CM) system built using shell scripts, SCCS and make. We use this system not only to configure and build software loads, but also to build test databases. This allows each engineer to easily build a test database for the…
Re: Waiting for nonexistant latches
>Every so often (read ``once or twice a day'') our whole database system >locks up, and an investigation of ``tbstat -us'' (users and latches) >invariably shows one or another user waiting for a latch when no latches >are displayed in the latches section of the tbstat output. The…
Waiting for nonexistant latches
We're experiencing a rather frustrating problem on site here, We're running Informix OnLine 4.10, under Interactive 3.0.1 (Unix System V/386 Release 3.2) in a 486 box. Every so often (read ``once or twice a day'') our whole database system locks up, and an investigation of ``tbs…
Re: 7.x, determining a unix process from a session/thread
gainer@gainer.engr.sgi.com (Patrick Gainer) writes: >In article <40aspa$f1l@oscar.cc.gatech.edu>, >Carlos Ugarte <cau@cc.gatech.edu> wrote: >>With onstat and onmonitor you can determine some information >>about each thread, but I haven't figured out yet how to determine >>what u…
Re: 7.x, determining a unix process from a session/thread
In article <40aspa$f1l@oscar.cc.gatech.edu>, Carlos Ugarte <cau@cc.gatech.edu> wrote: >With onstat and onmonitor you can determine some information >about each thread, but I haven't figured out yet how to determine >what user process is tied to that thread. Can anyone give a Bu…
7.x, determining a unix process from a session/thread
Could anyone tell me how to determine what process (the unix process) is associated with a particular thread and/or session (probably the same thing)? With earlier versions of Online, you could detect what executable was tied to an sqlturbo (or sqlexec, I guess) because both the…
Re: User Threads
antaya@io.org (J. Cameron Antaya) wrote: >Does anybody know much about the number of concurrent user threads variable in >the /usr/informix/etc/onconfig.std file? >We're running an application, and receiving the message "You have >exceeded the maximum number of user threads" >Can…
User Threads
Does anybody know much about the number of concurrent user threads variable in the /usr/informix/etc/onconfig.std file? We're running an application, and receiving the message "You have exceeded the maximum number of user threads" Can I just up the number of threads in the config…
Re: How to list all database names in a dbspace?
>My sysadmin tells me that the tbcheck -pe command should not be used >on our system -- it corrupts the databases if blobs are in them (this >is a UNIX (Sun OS) system). I therefore cannot parse the output of >the tbcheck command to get a list of all datbases on the host server.…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Does Informix do Versioning Read-Only Transactions?
Tony Rothwell (Tony@santen.demon.co.uk) wrote: : In article: <3lb8n5$ecm@sword.eng.pyramid.com> graeme@pyramid.com (Graeme : Sargent) writes: : > : > Tony Rothwell (Tony@santen.demon.co.uk) wrote: [ stuff deleted ] : > : Discrete transactions have (virtually) no place in real-…
NewEra
Does anyone know if NewEra will run under Win/OS2 session in OS/2? Thanks…
Re: Need help: zombie user threads
>On Fri, 27 Jan 1995, Rolf Saalfrank wrote: > We have a problem with our client server application as described > below: > Windows Application > -> Q+E ODBC driver V. 1.2 > -> Informix NET for Windows 5.01E1 > -> LWP Winsock interface > -> Network > -> Informix Online 6.00 UE1 u…
Re: Need help: zombie user threads
In article <3gffop$1k5@cssun.mathcs.emory.edu> calvinng@technet.sg (Calvin Ng) writes: >From: calvinng@technet.sg (Calvin Ng) >Subject: Re: Need help: zombie user threads >Date: 29 Jan 1995 02:23:05 -0500 >On Fri, 27 Jan 1995, Rolf Saalfrank wrote: >> We have a problem with our…
Re: Need help: zombie user threads
In article: <D32E2w.9Cn@Yuri.CC.Uni-Augsburg.DE> sfk@teflon.RZ.Uni-Augsburg.DE (Rolf Saalfrank) writes: > > > We have a problem with our client server application as described > below: > Windows Application > -> Q+E ODBC driver V. 1.2 > -> Informix NET for Windows 5.01E1 > -> LWP…
Re: Need help: zombie user threads
In article <D32E2w.9Cn@Yuri.CC.Uni-Augsburg.DE>, <sfk@teflon.RZ.Uni-Augsburg.DE> writes: > Newsgroups: comp.databases.informix > Path: massive!ncar!gatech!howland.reston.ans.net!Germany.EU.net!news.dfn.de!news.uni- augsburg.de!teflon.RZ.Uni-Augsburg.DE!sfk > From: sfk@teflon.RZ.U…
Re: Need help: zombie user threads
On Fri, 27 Jan 1995, Rolf Saalfrank wrote: > We have a problem with our client server application as described > below: > Windows Application > -> Q+E ODBC driver V. 1.2 > -> Informix NET for Windows 5.01E1 > -> LWP Winsock interface > -> Network > -> Informix Online 6.00 UE1 un…
Need help: zombie user threads
We have a problem with our client server application as described below: Windows Application -> Q+E ODBC driver V. 1.2 -> Informix NET for Windows 5.01E1 -> LWP Winsock interface -> Network -> Informix Online 6.00 UE1 under UNIX Now the problem: When our Windows client crashes, a…
Gracefull Exit
> > > I would also be interested in an application that will cause > > > user's to exit an application gracefully after being > > > inactive for a certain period of time. > > > [...stuff deleted...] > > > > We use a simple shell script which monitors the "idle" time in th…
Online 5.0 gets hung
Problem: We have an Online 5.0 system. The front-end menu is by JAM. Once inside the menu, the user has the choice of calling IQ, a report writer. When the user runs a report and chooses to print it to the PC printer, they get hung and eventuially disconnected from our network(DA…
OnLine 6.0 & Critical Section
Dear Informix users Does anyone knows how OnLine 6.0 Dynamic Server handles a client application when the client is killed abnormally? Does it still handles the case called critical section, where OnLine abort itself? In OnLine 5.X, and before, if the a server process is kill …
Re: Online Engine Aborting -- Help!
In article <1994Mar1.162948.4900@lmpsbbs.comm.mot.com> ennis@ssd.comm.mot.com (Bill Ennis) writes: >We are experiencing a problem with the Online engine shuuting itself down. >We see the following in the online.log: > >4:30:17 Lock table overflow - user id 110, process id 23526 …
Online Engine Aborting -- Help!
We are experiencing a problem with the Online engine shuuting itself down. We see the following in the online.log: 4:30:17 Lock table overflow - user id 110, process id 23526 04:30:17 Lock table overflow - user id 110, process id 23526 04:30:22 Lock table overflow - user id 1…
Re: Latchwaits
jerry (warlok!kysilk.sherwood.com!jerry@uunet.UU.NET) wrote: : Can anyone explain why the latch wait count on a system would suddenly : climb? We have a production system that has gone from 6,000 to : 300,000 when comparing the same period on two different days. I have : resear…
Re: Killing of sqlturbo
> > Other people have commented as part of this thread that a "Safe kill" > should use tbmode -z process-id. I have tried this repeatedly (Online 4.1) > and it has never worked, but maybe it's just a problem with my platform. > > I've never tried kill -1, -2, or -3, all of which…
Re: DBAmon post
} Jack Parker, in your mail you wrote: } > Here is the promised DBAmon. Walt shar'ed it (thank you Walt). Please } > let me know your comments - what we can do to improve it. There are a } > couple of readme files which should explain things. If they don't - write. } } Jack, …
Carl Wuebkers 'recovery' problem.
Folks, After perusing the responses to Carl's problem I realized that no-one has come up with this answer, so here it is. We had this problem over and over again and started re-creating it on purpose to devise a solution. The solution wound up being to lower the high water mar…
Informix on Sun 690 MP
We are interested in anyone's experiences running Informix On-line 4.10.UE3 on Sun 690 multiprocessors. We are currently running SunOS 4.1.2 with Database Excelerator on Sun 690's with 4 CPU's and Informix On-line 4.10.UE3. We are experiencing database lockups which are the res…
OnLine problems: need help with latches/locks
I am trying to find what stops the application from running: OnLine4 Application stops, UNIX continues running happily, CPU-usage 25%, MEM-usage 50%, cache hit rate R:93.88% W:92.23% from tbstat when in troubles : ____________________________________________________________ Us…
Re: Why more than one sqlexec process ?
>From: uunet!ix.de!aa (Andreas Ahrens) >Message-Id: <1992May12.082020.29359@ix.de> >Subject: Why more than one sqlexec process ? >Date: 12 May 92 08:20:20 GMT >X-Informix-List-Id: <news.1237> > >I'm a new Informix user (and my boss told me to be the DBA) and there's >one thing ab…
Re: Problems with on line & locks
I recently ran into a deadlock problem where no deadlock seemed possible. I now have a number of answers to why this might be. The majority of the answers are to do with basic deadlock theory, the twin-locking problem and adjacent key locking, but the one documented here is actu…