Oninit® Archive
Results for “onstat -z”
sysadmin monitoring
This is handy (and may help with troubleshooting) showing the last time onstat -z was executed: echo "select dbinfo('UTC_TO_DATETIME', sh_pfclrtime) from sysshmvals;" | dbaccess sysmaster 2>/dev/null | tail -2 | line The lore is in sysshmvals we called them "profilers", not "st…
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
Need advice on compiling dostats utility
Art, It can be observed by monitoring the Informix partition profiles while 'update statistics' is running. By all means IBM development can confirm or deny but I think I have already done this. This was part of a big look at update statistics I did with Jeff in 2022/23 and it wa…
BlockLogXmit status
Amit and Stuart, This support article doesn't mention that this issue doesn't happen randomly. It happens when the number of reads (or possibly writes) on the RSS shown by 'onstat -g smx ses' reaches 4,294,967,296 (2^32). 'onstat -z' won't help here. Therefore you will only see t…
Complete time stamp of when the server started
Try this against sysmaster. It's will show when the internal stats were last cleared (onstat -z) or when Informix was last started. Full disclosure, I think that Art shared this originally! dbaccess sysmaster <<! select current year to second - ( sh_curtime - sh_boottime) units…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Hello Andreas, mispelling. Onstat -g spf i meant Milan Rafaj Kyndryl Česká Republika/Czech Republic Odesláno z/Sent from Outlook / iOS…
RSAM memory pool cleanup
Hello Andreas, thank you for a tip. I thought if onstat -g seg shows no free memory for a segment that is it not possible to shrink or eliminated such a segment using onmode -F. Milan Rafaj Kyndryl Česká Republika/Czech Republic Odesláno z/Sent from Outlook / iOS…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
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 ------------------------------…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
question about CPUs
Thanks Vladimir, so, i have a machine with 7 Cores, SMT4, 14 CPU VPCLASS (i think it s recommended to put 2 VP per Core with SMT4) and ( onstat -z ; sleep 60 ; onstat -p) difference is 5, is it using 5 trom the 7 Cores or 5 CPU VPCLASS ? thanks ------------------------------ Joh…
Avoid to see the Last 20 Sessions Terminated in onstat
Thanks for your response Kirit, I verified that onstat -z doesn't have any effect. Finally, I created a little script as a "wrapper" that use "sed" according your suggest. #!/bin/sh if [ $# -ne 1 ] ; then echo "Ingrese sesion" exit 1 fi sid=$1 onstat -g ses $sid | sed '/^Last 20 …
How to configure informix to store TPS on logfile (without query on sysmaster)
You could run an "onstat -p" and parse out the time since startup and the number of COMMITs from the output. That will not be accurate if you have reset the server's stats (onstat -z) since the server was last bounced. Also it will be skewed low if your transactions don't run at …
Performance of 14.10.FC5 is worse compared to 12.10 is that possible?
M D: This is a tough one. I would suggest several things to look at: SET EXPLAIN for the test query on both to see if the query plans are the same. Did you run update statistics on the target server after the import? If the database is small, just run: UPDATE STATISTICS HIGH; Wha…
How to stop Defragmenter cleaner thread on startup ?
Hello, how can I set Informix to NOT run Defragmenter cleaner thread on start ? I was disable all ph_task in sysadmin, bounce instance, but it was run automatically again on startup. My Issue is, that on startup, Informix engine add to much share memory segments (12GB) , and afte…
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
onstat statement
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…
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
memory monitor
Original post: HI, I use informix version 12.10, How to monitor below memory through SMI? dictionary cache; table statistics cache; ...... thanks for your time. Lu chuan Response: Well first off, when you say "table statistics cache" I'm assuming you mean the cache the s…
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…
Dev Server Won't Start
Does anyone see anything in this message log that tells me what is wrong? It fails on oninit and says check the message log. I have tried onclean -ky multiple times as I thought it was a shared memory issue [informix@DB1 ~]$ onstat - shared memory not initialized for INFORMIXSER…
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.…
Informix 12.1 Blocking Checkpoints
Hi Horacio, just curious: what was the parameter to change, and what was the change? The task at hand would be catching a situation where a thread is seen 'in critical section' for so many seconds. I've quickly sketched a script that might help at this - haven't really tested …
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…
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…
onstat -a order
Hi All, On Informix v.12.1, what is the order of the results for 'onstat -a'? Our file is 234MB large, so I'm breaking it down into the individual pieces. I've gotten to the 'onstat -g all' section, but am stuck on the section with the heading: Thread Thread id Cancelled I/Os C…
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)…
onstat -d
I am sure it must exist Does someone have a script to give a pretty layout of onstat -d ............. The dbspace, and following that the chunks belonging to that dbspace ? My company decided not to stick to naming conventions, and now I am trying to match dbspaces with chunks …
Slow Bulk Loading problem
You need to zap the onstats (onstat -z) and then run the onstat to gather diagnostic information once the performance is sluggish. What is the machine, version, etc. On Wednesday, October 14, 2015 1:07 PM, CHALLENGER212 ABDERRAFI <abderrafi212@gmail.com> wrote: Hi, I have add …
onstat -d
Hi, I see a line in onstat -d output that say metadata Size Free Bpages Metadata 17324 4005 17324 I see the free space was drastically reduced when I run cdr commands. My question is, what will happened with that space if it gets empty ? Thanks in advance. --001a11c11a8c11f…
Stuck transaction
Hi All, I found a transaction using 'onstat -x' that is definitely stuck. 119696f88 -LH-G 0 0 logid 81731 81763:0x189257c COMMIT 0:00 0 The problem is that those log numbers date back to when the engine crashed in Nov. 2013! (our current logid is 86457) The engine has been res…
IDS 11.70 FC1 Crash
Mohd: Your client has several problems that I can see: 1- The physical log is VERY small at 8196 K. The engine is recommending making it nearly double that. I would go even further and make it around 30MB. 2- This is a very early release of 11.70 and has several bugs in it. Thre…
Re: 908: Attempt to connect to database server (hd
Hi, On client host, I did a ping instead of nslookup : x087823@PBDDLX03: # ping hmba04 PING hmba04.dns24-1.socgen (192.85.62.2) 56(84) bytes of data. 64 bytes from hmba04.dns24.socgen (192.85.62.2): icmp_seq=1 ttl=250 time=9.01 ms ^C --- hmba04.dns24-1.socgen ping statistics --…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Onstat -d
Hi, Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs has from 2 to 8 free pages less. Why this happend? Enviado desde mi iPhone…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
Do not set the PSORT_NPROCS ?
Thanks Art! One more question :-) If SHMVIRTSIZE is 1GB DS_TOTAL_MEMORY is 500MB and *PDQPRIORITY is not set in the session or server side.* The available virtual shared memory size for all OLTP sessions is 1GB or 500MB? Thanks, Frank On Tue, Jul 23, 2013 at 10:45 PM, Art Ka…
DB Tuning question
Hi, first thing is: You did not name the statements which take too much time. Which tables are involved (how many rows) ? Are your statistics up to date ? Have you checked the slow queries with set explain, if the indexes are used ? The config looks like a small system (32 bit,…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
transaction count
You can look at the commit and rollbk output in onstat -p. Collect the starting values or onstat -z at the beginning of the day/hour and check it again at the end of the day/hour. Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Beh…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
onstat & SMI
Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.…
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 …
event trigger/alarm
Hi, Folks, IDS11.50 FC8, Redhat Linux. I am going to narrow down which job peoridically caused IDS to add new memory segments. Basically, the plan is, whenever IDS is adding a new memory segment( as in the attached online log messge) , the event will trigger my script to take …
How to check what/where is the culprit of slowdown
Is it fine to re-execute onstat -z? to clear the benchmark?... The update stats is Medium and it was executed 07-30-2011. 07/30/2011 M…
Help! Broken server destroys customer demo...
I'm not sure how to attach a file to a message, so I'll post the files inline: ol_matdemo.log: 11:03:45 IBM Informix Dynamic Server Started. 11:03:45 Warning: The IBM IDS Developer Edition license restriction limits 11:03:45 the total shared memory size for this server to 10485…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
onstat -g ppf - lkrqrs X isrd X bfrd
Hi, I'm trying to identify useless indexes on the database. (v10 and v11) For this I'm using the 'onstat -g ppf' where I have filtered indexes partnum what the isrd equal to 0 (isam read) . With this, I deduce, any SQL use this index for access the table since the statistics w…
Set tables activity
Thanks Gerd and Art I have a question. The information in sysptprof is from the moment of start up the instance until the current time. And Can I clear that table with onstat -z? Thanks a lot Servio Velasco…
Stop long running query
You need to identify the session and use onmode -z on the session id. Start with onstat -g sql and see if you canidentify your query. Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KHURRAM SHAHZAD Sent: Monday, January 17, 2…
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…
onstat -l
I'm seeing a couple of extra lines in the output of 'onstat -l', which I can't find documented in the 11.50 administrators guide and references. The lines in question look like this: Buffer Waiting Buffer ioproc flags L-1 0 0x1 0 L-2 0 0x1 0 The exact lines varies (L-1 through…
CDR Grouper FanOut thread is aborting
Madison, We tried, but the problem is still there, see below. Thanks, Frank 09:16:10 Maximum server connections 173 09:16:10 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 1453, Llog used 8076 09:16:20 listener-thread: err = -27001: oserr = 0: …
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…
onstat -g ses output
Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I am interested in knbowing what this output section means: Host variables : address type flags value ---------…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Re: Delay in commands returning
<david@smooth1.co.uk> wrote in message news:74c11349-0684-4776-b3c3-bf3c4de63334@33g2000vbe.googlegroups.com... >> What about "time onstat -" how long does that take?? time onstat - IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up 05:25:50 -- 25968640 Kbytes re…
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…
I/O writes
Thanks a lot. It got me out of confusion. And do you hinkthat I/O queue length are not bad? Here are recent messages found in online.log ------------------------------------------------------------------ 07:35:02 Logical Log 27846 Complete, timestamp: 0x5a4d390a. 07:35:02 Process…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Update Stats for procedure uses too much Virt memory.
After running update statistics for tables in a database, we run update statistics for procedure to update the SP's, using the following: set isolation to dirty read; set pdqpriority 0; update statistics for procedure; commit; There are about 400 SP's and some are complex calli…
onstat -g iov
No doubt the real answer is RTFM. But, can anyone give me or point me to a good description of the i/o -wakeup ratio, and why 0.5 is "good"?: onstat -g iov -r 5 IBM Informix Dynamic Server Version 10.00.FC8W2 -- On-Line (Prim) -- Up 81 days 06:27:37 -- 46892464 Kbytes AIO I/…
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…
If there were no onstat...
IDS v10.00.UC8 Solaris 8 6-1, 175 Bats: Left Throws: Right Born: 11/17/1967 in Independence, MO. Pretend there was no onstat -x (or any onstat) to get info about open transactions. You wanted to find out if there were any open transactions in a logical log file older than the cu…
Informix allocating shared segments
Onstat -g seg will showes the session-id which cause problem , the " total memory" and "used memory" will be large !! and then onmode -z session-id to kill it , if you can not see such kind of session-id , it would be possible the memory leak of engine , and might need to upgrade…
Re: net statistics from shared memory ?
On 6 Aug, 20:10, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > We are currently running our c programs through esqlc and also shell scripts. They attach to the database SERVER that is associated with shared memory. > > In the near future we are going to separate the database …
net statistics from shared memory ?
We are currently running our c programs through esqlc and also shell scripts. They attach to the database SERVER that is associated with shared memory. In the near future we are going to separate the database server from the application server, which means that all the talking b…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
SCHAPI: Error -566 Cannot initiate sort...........
Folks, Program Name: onstat Build Version: 11.10.UC2 Build Number: N158 Build Host: vach Build OS: AIX 5.3 Build Date: Thu Oct 25 22:56:40 CDT 2007 GLS Version: glslib-4.50.UC2 After run out of memory, we terminated the big session( that caused the problem), but the error messa…
Re: informix 9.3 to 9.4 issue
analog todd wrote: > Hello, > I'm having some serious issues with a production instance of Informix > and I can't figure out why. > I'd been running 9.30.UC7 for over a year solid, no complaints. > Monday night, I installed 9.40.UC8 and its been awful. What am I > I presume tha…
Re: informix 9.3 to 9.4 issue
analog todd wrote: > Hello, > I'm having some serious issues with a production instance of Informix > and I can't figure out why. > I'd been running 9.30.UC7 for over a year solid, no complaints. > Monday night, I installed 9.40.UC8 and its been awful. What am I > missing? I've…
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…
Can I know the last time when I run 'onstat -z' ?
Is ids server will record the timestamp when we run 'onstat -z' ? Can I get any information from sysmaster database or else ?…
Replication performance problem related with DRINTERVAL
On Nov 8, 8:58 am, Yasar Akman <akman.ya...@gmail.com> wrote: > Hi, > > we are moving our application from tru64 to aix. Our application is an > real time application and performance is very important. We are doing > some tests on informix on the new platforms. But replication s…
Buffer allocated to data, index and other
Hi If % used of buffer (hit rate) is low (100% is the 'desired' percentual), probably the buffer pool size should be increased. What is the Shared Memory allocated when the instance start? run: onstat -s and show us the result. How many processors in box? How much memory? When yo…
Re: Kill Update Statistics
On 17 Oct, 16:31, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 17, 8:05 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > > emmendingen.de> wrote: > > Is there any way to kill a running update statistics. > > > UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONL…
Trouble with update statistics
We had/have some trouble with update statistics here. Because it's not so simple to describe in short I send the whole story: - IDS 9.40.FC4W2 - Solaris 5.9 Generic_117171-12 sun4u sparc SUNW,Netra-T12 - Table contains about 800,000,000 rows - Fragmented by expression 20 fragme…
Kill Update Statistics
Is there any way to kill a running update statistics. UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. I tried with with onstat -z several times but it runs and runs and seems to do nothing anyway. Sorry, I forgot: IBM Informix Dynamic Server Version 9.40.FC4W2, …
Kill Update Statistics
Is there any way to kill a running update statistics. UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. I tried with with onstat -z several times but it runs and runs and seems to do nothing anyway. Regards Reinhard…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: help table lock, cannot kill transaction
hatricom wrote: > On May 30, 10:08 pm, hatricom <andiolte...@gmail.com> wrote: >> hello, >> >> i have a tranzaction which ahve lock on some tables. >> >> The session it is not on informix server. >> >> I see with onstat -x : >> >> e0363b08 --X-G 0 33 16…
help table lock, cannot kill transaction
hello, i have a tranzaction which ahve lock on some tables. The session it is not on informix server. I see with onstat -x : e0363b08 --X-G 0 33 16462 16462 0x4314d0 COMMIT 0 onmode -Z 3761650440 onmode: Cannot kill transaction 0xe0363b08. On…
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…
onstat -p
Dear forumers, Attached is the "onstat -p" command : Do you think my bufwaits is high ?? Or is there anything significant from this information that need attention for performance reasons ? -------------------------------------------------------------------------------- ------…
onstat -p
The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagr…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Bizarre sysmaster/IDS 10 problem
Just a hunch.... 1. Run "onstat -g vpcache" and see if you see a huge negative or positive number for "Number of 4096 byte memory blocks requested for each CPU VP": /home/pd/dattadg% onstat -g vpcache IBM Informix Dynamic Server Version XXXXX -- Initialization -- Up 00:0…
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--…
shared memory
Hi, Your shared memory is used because Informix needs it. It is that simple. Shared memory is being allocated for each connection. I saw systems with several Gb of Shared memory. Why do you think the 100000 is a maximum value for initial segment ? What OS is being used ? The sys…
sysptprof
Floyd Wellershaus wrote: > I am writing some benchmark scripts to keep track of chunk and table IO. > According to the manual, the following is true about sysmaster:sysptprof > > > The *sysptprof* table lists information about a tblspace. Tblspaces > correspond to tables. > > Pro…
Onstat Reference
It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11 changes will be in place when the V11 Beta goes public. I'm happy to be told where they are wrong. If you like it then use it, if you …
Exclusive access to a Database
Doug, I used your query. The database in question didn't appear in the returns but I still get the following when I run the dbexport command: -bash-3.00$ dbexport /dbdump -ss mmls_db -425 - Database is currently opened by another user. -107 - ISAM error: record is locked. I kn…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Update statistics and shared memory
We are not exactly sure what our problem is, but any help would be greatly appreciated. We are running IDS 7.31.UD3-1 on AIX 4.3.3. We have been experiencing a problem for a number of years, but it had not been one that has caused us any major problems untill recently. Here is t…
Getting ISAM error 116 during update statistics
Thanks for all your support this problem is solved by increasing the shared memory value in that server :-) On 5/26/06, ART KAGEL, .... <kagel@bloomberg.net> wrote: > > > Increase DS_TOTAL_MEMORY from the default and increase SHMVIRTSIZE to > accomodate > the extra memory. Also …
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
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?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Poor performance on replacement server
Dear Informix users The firm I work for have recently purchased a 4 processor ES45 Alpha server to run our practice management (sales ledger) system. This is replacing a 2 processor DS25 Alpha server (which struggles at period end). Outline specification is 4x1.2Ghz Alpha proce…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: 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…
freeing locks
I used to know how to find stuck locks when we were on Unix and using IDS 7.31 We are windows now and do not have onmonitor. I guess all I have is onstat -k How do I get a pid from that output I can onmode -z that puppy ? Or is there a better way? sending to informix-list…
Sysmaster - sysprofile - size of values
I have recently encountered some interesting problems with my remote monitoring software. My software is heavily reliant on the sysmaster database and I have observed that many figures show up as negative in sysmaster because they are in fact >2billion. The reason is quite obvio…
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…
ONCONFIG comments
Comments embedded. If somebody told me to change my $ONCONFIG, I'd take it with a large grain of salt and check up on every parameter they suggested I modify. I'd then make the changes one at a time and see how each one worked differently. Looks like an OLTP instance. Also look…
Re: Internal Error while trying to set up start or end key for i
This error is probably due to a remaining connection in the database that is locking any of the system tables. You can check the database conecctions (in informix -> onstat -g ses ) and check for the user that use the database you are using, if you find those users that are lea…
onstat -D output
Hello, We have a table that we know has has no less that 10k rows added to it since yesterday. Yet, when I do an onstat -D on the chunks that the table is stored in, it shows zero writes. Is there some bug I don't know about ? Or is there any way that the stats could have been ze…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
database reorg for large databases?
If your tables are fragmented, you will gain a lot of speed setting pdqpriority before copying each table, that will allow multiples threads per each table. Same for indexes on fragmented tables. Actually I would copy all the tables, set an onconfig suitable for indexes creation …
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…
onstat -p
We are running IDS 9.3 on Tru64. Most of the onstat -p statistics quit being accumulated 3 days ago and I = have no idea how to restart accumulation without restarting the = instance. What/how causes the stats to not accumulate? How do you begin accumulation again? Copy of onst…
number of transactions
__toto wrote: > hi, > how can i know the number of transactions > on a database in a given period (for example 1 day) ??? > > Onstat -p will show you, in the commit & rollback columns how many transactions were committed and/or rolled back since startup or since the last time on…
Re: Informix UC7.41 - slow
Geezer From The Freezer wrote: > > "Art S. Kagel" wrote: > >>Geezer From The Freezer wrote: >> >>>TBP wrote: >>> >>> >>>>Geezer From The Freezer wrote: >>>> >>>> >>>>>Hi, >>>>> >>>>>My Informix installation seems to be running quite slowly. It's running on a Sun >>>>>Blade >>>>>1…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
Re: any way to know the progress of a level1 (or level0) ontape save?
"sumGirl" <emebohw@netscape.net> wrote in message news:a5e13cff.0409151450.245785df@posting.google.com... > Just wondering if anyone knows of a way to check the progress of an ontape backup? If you zero out the stats with onstat -z then do an onstat -D you can see which chunk it…
FW: RE: Informix IDS query to the Informix -list
Fwd from sputnik� ________________________________________ From: None [mailto:myinformix@rediffmail.com] Sent: Tuesday, September 14, 2004 02:08 To: Jean Georges Perrin Subject: Re: RE: Informix IDS query to the Informix -list � Hi Jean, Thank you for your prompt reply. If you…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
onstat -z via sql command?
Hi, is there a SQL command to reset the statistics like "onstat -z"? I got some scripts with selects from the system tables and it would be fine if these tables are reset just before the selects. I know, I could start a cron job for "onstat -z", but then I have two things to …
Re: Informix Tuning Problem
UPDATE STATISTICS? Andy Leung said: > My server run very slow for this few weeks.. I've checked the %cache go > 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92…
Catching runnig SQLs
Consider using I-Spy. See http://www-306.ibm.com/software/data/informix/tools/ispy/ From the manual: I-Spy provides the following query monitoring and control features: - Logging SQL statement text and various statistics related to the statement, such as total time of execu…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
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…
TBLSPACE_STATS
On Fri, 21 May 2004 10:53:22 -0400, Andy Kent wrote: > The SMI tables maintained when you have TBLSPACE_STATS show statistics since > - when? > > How do you zeroise the counters? IB, those stats are since startup or the last onstat -z reset them. Art S. Kagel…
Update Statistics 597 errors and assert failures
We just installed IDS 9.40.FC3 on a 64-bit DEC Alpha server running the True64 operating system (uname -a: OSF1 odb1 V5.1 2650 alpha). The server has 2 CPUs and 4 Gig physical memory. The following relevant Informix environment variables are set: BIG_FET_BUF_SIZE=32000 DBUPSPACE…
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…
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,…
Determining "onstat -z"
Eric Herber wrote: > Fred Prose wrote: >>Is there any way to programmatically determine if a "onstat -z" has >>been issued? We run some analysis tools/scripts that log deltas for >>things like IO and resetting the counts really skews the output. > > Check the following column: >…
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: Diskreads-Cache always 0.00%
Hi Manuela. onstat -z Zero Profile Counts The onstat -z command resets all profile counts to zero. See also http://www.oninit.com/onstat/index.html Hope this helps. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Manuela Biel" <mb@worxbox.com> >Reply-To: "Manue…
Diskreads-Cache always 0.00%
Hi Paul, thanks for your answer. I don't know the -z flag. What does this result mean? IBM Informix Dynamic Server Version 9.40.UC2X3 -- On-Line -- Up 18 days 11:00:35 -- 1609260 Kbytes Thanks! Manuela "Paul Watson" <paul@oninit.com> schrieb im Newsbeitrag news:401E1C8D.6A…
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…
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…
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
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?…
dbimport Problems: 567 and 116 Errors
Yes, shown below 18:44:33 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:45:37 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:45:39 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:45:41 Dynamically allo…
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…
RE: TBLSPACE_STATS
Hi, In the machine notes for ids 9 I find the next text: "16. In this release, partition profiling can be disabled by setting a new configuration parameter, TBLSPACE_STATS, to 0 in the onconfig file. When TBLSPACE_STATS is set to 0, the output of onstat -g ppf will …
onstat flags
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_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPa…
RE: zombie users
Perhaps you should try killing the sessions instead of the tty. onmode -z 642 onmode -z 831. cheers j. > -----Original Message----- > From: Brett Geer [mailto:brett@brabys.co.za] > Sent: Wednesday, February 07, 2001 4:00 AM > To: informix-list@iiug.org > Subject: zombie users …
RE: zombie users
You're not running the onmode on the sid - try onmode -z 642, onmode -z 831 Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Brett Geer Sent: Wednesday, February 07, 2001 11:00 AM…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
assertion failure during 'alter table'
Brett - I will try this, but we update statistics on all tables every night. However I'll try it anyway. Did this happen for any ALTER statement or only when adding a VARCHAR field, which is the case here. Jane In article <3A793CEF.7791C9E0@hotmail.com>, Brett Randall <bret…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
RE: onstat
On Tue, 30 Jan 2001 dr_pablo@my-deja.com wrote: >> I have seen vendor-supplied scripts, which use the following >> exit codes from "onstat". I do not know where they are documented. > >Here's the URL to the FAQ page containing the info: > >http://www.iiug.org/resources/faq/ifaq0…
RE: onstat
I got this email awhile back: >PEOple, > >For those of you who do not know, it is very tough to determine the *real* >status of IDS. "onstat -" will return, stating that the server is "online" >but many times it is in the process of a "fast recovery", etc. In >addition, "onsta…
RE: onstat
The exit codes were posted into a FAQ at the IIUG web site at one time. Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] Sent: Monday, January 29, 2001 11:17 AM To: informix-list@iiu…
RE: onstat
Hi Bernstein. Please visit following site. >exit codes from "onstat". I do not know where they are documented. http://www.informix.com/informix/iuc/ppt/ts_ids.ppt And search "onstat". Regards. -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion …
Re: onstat
At 11:17 01/01/29 -0500, Bogdan Neagu wrote: Hi Bogdan. When the meaning of the question is different, I'm sorry. onstat returns the following. The server status is expressed as a number 0 Initialisation 1 Quiescent 2 Recovery 3 Backup 4 Shutdown 5 Online 6 Abort Regards. >…
RE: onstat
I have seen vendor-supplied scripts, which use the following exit codes from "onstat". I do not know where they are documented. integer inf_dwn1=255 # Informix mode is down integer inf_dwn2=-1 # Informix mode is down (60_USAP2) integer inf_init=0 # Informix mode is Initia…
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
Doug Fossmeyer wrote in message <94lc38$an0$1@news.xmission.com>... > >I have a hung informix instance. Does anyone have any info on how to kill >the active sessions? > Assuming you can identify the process in the onstat -u listing, you will see the session id there. Next, work…
Re: time of last onstat -z?
"B. Dana" wrote: > > How can I determine the last time the counters were zeroed? select sh_pfclrtime from sysshmvals; ... gives the time of the last counter reset in localtime(). I find :- select sh_curtime - sh_pfclrtime from sysshmvals; useful to show number of seconds rep…
Re: time of last onstat -z?
The stats are cleared, obviously, at startup, after that if you have cleared them since you can look at sysshmvals.sh_pfclrtime which is a UNIX time. However, you do not need to translate that just use: SELECT (sh_curtime - sh_pfclrtime) Secs_Since_Reset FROM sysshmvals; Art S.…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
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…
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 -…
How I can determine if my CPU VPs are starved of CPU !
If you have a version of top , run it at peak period and monitor the cpu utilization of your cpu vps (oninit processes). If ALL are close to 100% (say, about 90%), you need to add cpu vps. If you already have cpuvps = number of physical cpus, you've reached your hardware limit. …
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
bug in onstat -t ?
onstat -t gives following output (look at column npages): Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident 17 c0000000995f8908 0 1 100001 10000e -9223372036854775558 250 0 0 5 0 120 c0000000995f8d78 …
Fw: Redbrick Memory Management & Statistics
----- Original Message ----- From: exformix <exformix@hotmail.com> To: Leonardo F. Cardoso <lfcardoso-nospam@hotmail.com> Sent: Tuesday, November 07, 2000 12:02 AM Subject: Re: Redbrick Memory Management & Statistics > Hi, > > There is no concept of updating statistics in Redbri…
Redbrick Memory Management & Statistics
Hi, How can I control the amount of shared memory redbrick uses? I can�t find any parameter in the configuration file. Another question: Is statistics automatically maintained in RedBrick? Is there some SQL command like "update statistics"? Thanks in advance …
Onstat -P
Hello all, I am hoping you can clear up something for me. I am curious about the onstat -P command. The Admin Guide/Manual for 7.3x has one pithy statement about "display for all partitions the partition number and break up of pages in the buffer pool belonging to the partitio…
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 …
onstat on IDS2000
Hello all IHAC with IDS2000 ans the output of onstat -d is the following : Informix Dynamic Server 2000 Version 9.20.UC3X4 -- On-Line -- Up 6 days 16:59:45 -- 459440 Kbytes Dbspaces 500d1d08 6 8001 6 1 N S informix usersbs0101 Chunks address chk…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Identifying tables with high % of deletes/updates
Hi all, I am looking for a way to easily identify those tables on which a high % of inserts/deletes/updates occurred during the last time window (say 2 weeks). Somebody suggested using SMI table sysptprof, but according to the manual: "Profile information for a table is availabl…
Re: Informix v7.3 vs 9 on NT Server
Art wrote: > > 457 dirty, 199903 queued, 200000 total, 262144 hash buckets, > > 4096 buffer size > > start clean at 10% (of pair total) dirty, or 157 buffs dirty, > > stop at 5% > > > > onstat -R > > 253 active, 384 total, 277 maximum concurrent > > Unless you have run onstat -z…
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…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Update staistics Running Way Slow
William Rice wrote: > > >===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > ===== > >Sanjeev sagar wrote: > >> > >> This is a multi-part message in MIME format. > >> --------------FBF95EAB01AE2EFCAE40C116 > >> Content-Type: text/plain; charset=us-ascii …
RE: Update staistics Running Way Slow
>===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> ===== >Sanjeev sagar wrote: >> >> This is a multi-part message in MIME format. >> --------------FBF95EAB01AE2EFCAE40C116 >> Content-Type: text/plain; charset=us-ascii >> Content-Transfer-Encoding: 7bit >…
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…
problem with onstat -p "pagreads" value decrementing
In article <8ghgs8$59j$1@news.mathworks.com>, Ben Draper <bdraper@mathworks.com> writes >I assure you that the counter is not rolling over. > >I'm seeing the counter go from (1 example) 5602893 to 3536618 and then the >number gradually climbs as you'd expect it to... > > onstat…
Re: Onstat
Are you executing onstat with -r 1 option? It happens sometimes. Try with -r 5 option. Vinod Bhansali --- Srinivas Sreekumar <SRINIVAS_SK@inf.com> wrote: > Hi all, > > I recently installed Informix dynamic server > 7.31.UC6 on HP UX 11.0 > > I am getting an error while running …
RE: Onstat
I had a low value for the shared memory kernal parameter for my unix server. When I increased it it started working.. Thansk, Srini -----Original Message----- From: Marat [mailto:maratkotik@mail.ru] Sent: Monday, May 15, 2000 7:41 PM To: informix-list@iiug.org Subject: Re: Onst…
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…
onstat -p
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
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…
RE: [ifxmaillist] Performance IDS - IBM F50
Henrique There could be a number of reasons. It could be application, informix configuration ... Is it OLTP or batch? Are you running the update stats as described on the Release notes? List you onconfig Reset the stats (onstat -z) before a time when you expect performance i…
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…
Re: Long checkpoints with no obvious cause
> >Does anything stand out like a sore thumb? > > Not to me. Nothing changed? > >I zero the states each weekend with onstat -z > > Hmmm... I think you might want to call tech support about this, but I seem to remember that we had some problems with onstat -z, and we found ou…
Re: Exclusive Lock Problem: !!
From: hpandu <hpandu@miel.mot.com> > >Thanx for your input. I found someone opened the database. >In case, I couldn't get hold of the person to ask him to quit, or i >couldn't find which user have logged. Is it possible by db activity I can >remove the exclusive lock. Pls. sugge…
Finding CPU hogs
Jeff Larsen wrote: > Is there any way to determine which user session > might be causing oninit to hog the CPU? Can any > of the onstat -g commands help? Examine syssesprof for sessions with "excessive" activity (bufreads, lockreqs, isreads). If possible, initialize stats (ons…
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…
Who takes 99% of CPU
Pascal Fiset wrote: > Hi guys, > > When i do a ps aux , i see that the online process is running at 99% on the > CPU. > > I would like to know if there's a way to know who is taking all the CPU > in that instance. onstat "something". > > Because when i "onstat -u" nothing moves …
Borland Delphi and Informix
Hello everybody, we have huge performance problems on our 2-node Sun-Cluster with Informix: Environment: Sun E4500, 6 CPU's, 1GB Memory (primary host for database) Sun E3500, 4 CPU's, 1GB Memory (secondary host for takeover) 4 A5000-Diskarrays with 14 9,2GB disks each connec…
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. …
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Re: Chatr on HPUX and Informix
En Susan Elliott (ISG) va escriure el dia 7 Nov 99, a les 17:11: > > Howdy Folks, > > We have just recently upgraded our database from 7.24uc5 to 7.30 uc7. > We are running on HPUX 10.20, Application is Baan. > > Since we have performed this upgrade, we are expierencing the dat…
Chatr on HPUX and Informix
UPDATE STATISTICS? Is your online.log available? Neil Susan Elliott (ISG) wrote in message <80304n$e3c$1@news.xmission.com>... > > >Howdy Folks, > >We have just recently upgraded our database from 7.24uc5 to 7.30 uc7. We >are running on HPUX 10.20, Application is Baan. > >Sin…
RE: disconnect user
You need to use 2 commands: onstat -g {ses or sql} to determine the SID onmode -z SID to actually kill the session However, before you go doing that, I would HIGHLY advise looking at the Administrators Guide at http://www.informix.com/answers/english/docs/73ids/4354.pdf The …
Re: disconnect user
En Andreas Lommel va escriure el dia 3 Nov 99, a les 10:06: > Hi, I have informix dbs 7.30 on solaris 2.6. How can I disconnect a > user session ? > Use: onmode -z <sessid> (<sessid> = 3rt colum from onstat -u> --------------------------------------- Isidre PONS ROCA BASE…
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…
Re: table locked
do a onstat -k and onmode -z <session id> to kill the session. --- Ant�nio_Roque <antonio.roque@auchan.pt> wrote: > Hi , I�m having a table locked , but there are no > running program that locks that table > how I can see which table name is locked and also > how can I unlock …
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
RE: Informix On-Line 7.24 UC5 Shared Memory Error.
Is there something bogus with Informix 7.2.4? We're having horrible performance problems running 7.2.4UC8 on a Pyramid ES with 512M memory (62M allocated for shared memory.) Another instance is running Informix 7.1.4 on the same OS same memory and only 15m allocated to shared mem…
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…
Onstat command
This is a multi-part message in MIME format. --------------DE4F14609E17179D45AF0716 Content-Type: multipart/alternative; boundary="------------73DD82890539D87E4735A41C" --------------73DD82890539D87E4735A41C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: …
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
RE: onstat -z
onstat -p lists the number of checkpoints since the counters were last reset. Count back the checkpoints in the informix messages log .. and you have the a short time interval when they were reset. Murray Wood -----Original Message----- From: Marty Allred [SMTP:mallred@my-deja…
onstat -z
Is there any way to tell the last time someone ran "onstat -z"? This seems like it should actually be logged in the online.log file rather than having to rely upon my fellow DBA's to communicate the fact that they reset things. Especially when I have to monitor hundreds of syste…
2xRe: rows in sysptprof !
---- you wrote: > > >Those stats are cleared by running onstat -z. > > > >Art S. Kagel > Hi Kagel, > yeh, I know that I can initialize those stats by onstat -z,but if not, are > they initialized when the table is closed by the last user. becose I want to > use those stats in my …
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
Re: PDQPRIORITY
I agree that update statistics would help you. And definitely you should perform it. Some additions about the error message: If you are using more than one connection to database server, you have to use tlitcp connections (you can't use shared memory connections). So, you have t…
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é…
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…
Q: Counters reset for onstat
William_Riedy@fac.com wrote: > > The counters for the output of the onstat commands get reset every so > often. What controls these #'s being reset? How often do they reset? > > The arguments that I am looking at are: > > onstat -g iof > > onstat -g ioq > > onstat -g iov …
Re: running out of Unix Shared memory segments
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <body text="#000000" bgcolor="#FFFFFF" link="#0000FF" vlink="#800080" alink="#FF0080"> <tt>Here is an interesting problem we encountered. (IDS 7.24)</tt><tt></tt> <p><tt>I tried to use 'update statistics MEDIUM…
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.…
onstat options....
Hi Users, Which is the best site(s) / Book(s) to explain in detail all the columns of different options in onstat. There are a few changes in onstat results from 7.2x to 7.3.... so need something which explains all these. Thanks in advance, Pramod ___________________________…
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: onstat
In article <7hpivn$l4u$1@news.gte.com>, michael.talbot@telops.gte.com says... > Hello, > > Question from a unix/informix neophyte: > > > > When I issue the onstat command I get the following reply. Does anyone know how to resolve this? > > /tmp-> onstat > shared memory not initi…
Re: onstat
Either the environment variable INFORMIXSERVER is not set (or isn't set to the correct value) or the Informix database engine is down. What is the value of DBSERVERNAME in the ONCONFIG file? John Carlson Informix DBA WHSmith USA Hello, > > Question from a unix/informix neophyt…
Re: Capturing SQL
Javier Puente wrote: > > You can access this information by making : > 1.- onstat -u To get the session conection id > 2.- With the sessionid you can trace SQL tasks by doing > onstat -g sql sessioid > EX: > onstat -u |grep myuser > > ---Supposing that sessionid is…
Re: how to disconnect some people ?
From: "Ph. Chantry" <chantry@seditel.REMOVE.fr> > >Today, we disconnect people with "onmode -ky" or "onmode -uy" commands. > >Is it a way to disconnect only people who's connected to ONE given database >? That's what I like about the French -- they're so subtle and smooth... :-…
Re: how to disconnect some people ?
Are you familiar with "onmode -z <sid>"? You need to know the user's session id (onstat -u). "Ph. Chantry" wrote: > Hi all. > > Today, we disconnect people with "onmode -ky" or "onmode -uy" commands. > > Is it a way to disconnect only people who's connected to ONE given databa…
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…
Update stats...running slow
IDS 7.30 UC2 on SOlaris 2.5.1 Suddenly my update statistics start running slow. Nothing has changed on box. Before it used to take 2 hrs, now it's taking 8 hrs. It's a simple update statistics medium command. Following is my onconfig file. #************************************…
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…
onstat columns
Does anyone have a listing, even partial, of on onstat command column meanings? Informix's references are completely unhelpful, or nearly so, in describing, for example, what the "q-limits" column of "onstat -g ntd" means or how it's calculated, except for saying that the comman…
Re: Tracing ALL sql queries - is it possible?
Yes, In this situation the SQL is being sent across the network (in a telnet session) by developers, DBAs or end-users. The Sql Power SniFFFer would capture the SQL text, rows returned, database server response time, end-user response time, network send time, network receive ti…
Re: Tracing ALL sql queries - is it possible?
> The following quote no.1 > > "The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server from a network telnet session will be > available in the product next week." > > is not the same as the following quote no. 2 > > "The fac…
Re: 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 …
Tracing ALL sql queries - is it possible?
Per the emails I received, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Pow…
onstat -l
When my machine is blocked in a CKPT, onstat -l shows ... Buffer Waiting Buffer ioproc flags L-1 57c6ab54 0x1 0 L-3 57c69884 0x1 0 ... which is not documented anywhere. I can guess what it means, but does anyone know what exactly it means (and what flags ar…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Re: ZERO Impact Performance Monitor for Informix BETA program
Chuck, Per your question, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Pow…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: How to find and remove exclusive lock on table or row
I guess you are trying to identify the user/thread that is using the exclusive lock and want to kill/remove the process that is using the lock without shutting down the server ?? Well, using onstat -k will give you the relevant lock information, you will then need to use onmode …
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
Re: onstat -g sch , Busy Waits ?
Jay Aymond wrote: > rdavis@rmi.net wrote: > >In article <78kcue$kng$1@nnrp1.dejanews.com>, > > darren_m_rogers@my-dejanews.com wrote: > >> Hi, > >> Could anyone explain what may cause a large number of 'busy waits' ? > >> Informix Dynamic Server Version 7.30.UC5 (HPUX-11.00)…
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…
RE: onstat -t
onstat -t shows tblnum in hex. So you can link it with hex(partnum) of systabnames to get your tablename. HTH Sathish -----Original Message----- From: David Tamburin [mailto:david.tamburin@protegrity.com] Sent: Wednesday, January 27, 1999 4:16 PM To: informix-list@iiug.org Subje…
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: Online Workgroup Server on SCO 5.0.4 with onipcshm
1. Have you set the SCO kernel parameters as stated in release notes ? 2. Try to update statistics for you database(s) in Workgroup Server for better performance. Kind Regards, Octav Ralph wrote: >Hi, > >thanks for the reply > >attached you find the sqlhosts and the onconfig…
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: Online command to get status
onstat - J.-M. Gimenes H. Zalkind wrote: > Hi, > > I am running Informix 7.23 UC5 on Solaris 2.6 > > I need to know an Informix command (quick online command I can include > in a script) to get status of Informix server (Quiescent, On-Line, > Recovery...). > > I thought first a…
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…
Re: onmode -z problems; Baan is not guilty
Martin Both wrote: > Martin Both wrote: > > > rare circumstances. I use dbaccess from a remote host and is it not possible > > to kill the thread with onstat -z. Killing dbaccess is useless. > > I don't know why and it happens very seldom. > > Sorry I mean onmode not onstat. > >…
Re: onmode -z problems; Baan is not guilty
Martin Both wrote: > rare circumstances. I use dbaccess from a remote host and is it not possible > to kill the thread with onstat -z. Killing dbaccess is useless. > I don't know why and it happens very seldom. Sorry I mean onmode not onstat. I think onmode -z should print a m…
Re: onmode -z problems; Baan is not guilty
Mark D. Stock wrote:Did you try bouncing the Baan driver? It is of course the driver that > makes database connections and controls access. There might even be a > Baan command to close old connections in the driver, I can't remember. > > Cheers, > -- > Mark. Baan is not the pr…
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: Table statistics question
-=Eclypse=- wrote: > > We have the following script to get stats on our most used tables: > > dbaccess sysmaster << EOF > select tabname, isreads, iswrites from sysptprof > where isreads <> 0 or iswrites <> 0 > order by isreads desc > EOF > > When do the isreads and iswrites "res…
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: lock problems
You could kill the user thread with onmode -z <threadid>. You can get the thread-id by onstat -g ses. Ciao, Dirk. ProzessDV schrieb in Nachricht <19981104083348.22202.00003757@ng06.aol.com>... >We have OWS 7.22 on SCO UNIX and Windows 95 clients. When a program on a client >PC …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
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: Help!ONLINE: System Error: Recvd erroneous event on select
cecilio wrote: > > The specific message is: > hh:mm:ss > > Art S. Kagel escribi�: System Error: Recvd erroneous event on select > > I have tried to kill all the users sessions (with onmode -z) when the system > starts to generate this message, but it doesn't stop filling the log …
Re: Informix 7.24 versions
Just to let you know, we've been getting server crashes with 7.30.UC2. When we run update statistics on a table with an index and no data (yet). We had to re-create a tble due to this. Informix should have a patch to us soon. icc@injersey.com on 09/10/98 01:06:10 PM Please re…
onstat -h
Does anyone have any info about the meanings of the output of the onstat -h (hash chain info) in IDS 7.3? It's not in the hardcopy or in the 7.3 Admin manual, and I'm trying to document it. Thanks, joe -- -------------------------------------------------------------------------…
onstat -D vs onstat -g iof
Informx gurus: --------------------------- This is a copy of a post that I previously send, however seems that because of the problems with the informix-list not many people had the opportunity to read it. I am sorry if you already read this message. ----------------------------…
onstat -D vs. onstat -g iof
Informx gurus: Could some one explain the output of onstat -D and compare it with the output of onstat -g iof? On my online 7.23 running on AIX 4.2 I get the following for onstat -D: address chk/dbs offset page Rd page Wr pathname .... 400382c8 2 2 1 40261 303…
onstat commands
Does anyone know of a source that describes all of the onstat commands? The 7.x manuals are pretty good, but some of the explanations are a bit brief. ==================================================================== Harold Luse Phone: (970) 491-4120…
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…
Re: Need of kill query
WF Software wrote: > > In article <6pb6bg$fab$1@news.xmission.com>, sanjeevsagar@rocketmail.com > (sanjeev sagar) wrote: > > I am in need of one kill query which should do the > > following > > KILL ALL SELECT QUERY CONNECTED TO A SPECIFIC > > DATABASE OF A SPECIFIC INSTANCE. …
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Negative cached in onstat -p
Tom Grenier (tomg@biztravel.com) wrote: : While looking at the stats last weekend -- my % cached was negative. : Didn't seem to have any affect on anything, and I did a onstat -z to : reset everything, but wondered what happened to cause it. Any thoughts? Tom, You've overflowed…
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: onstat
Gabriel Weisz wrote: > > 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 ? No. Check the permis…
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…
onstat -t output
Hi, The output of onstat -t shows zero in the column 'nrows' , whereas ' nused ' and 'npdata' have non-zero values . Why is this so ? TIA Sathish…
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…
Onstat -R
Can someone explain the onstat -R headings.. Is the percentage free or used. Been digging thru the texts.. examples but little explanation? INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- 36320 Kbytes 8 buffer LRU queue pairs # f/m length % of pair…
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: +…
ODS 7.22 on IRIX
A customer of mine is running 7.22 ODS on a Silicon Graphics IRIX 6.X system. We're finding some strange stuff. Engine freezes. Onmonitor gives blank screen. onmode -z pid just hangs. onmode -k hangs. No action whatsoever from any of the onstat info commands (returns numbers, …
Re: Read Ahead Pages, etc.
Art S. Kagel schrieb: > > Dianne Pendleton wrote: [snip] > or (ixda-RA + idx-RA + da-RA) - RA-pgsused ~ 0 > > If the second result is positive then your RA parameters are set too > high. Obviously small positive values are just fine but a large > descrepancy (more than a few per…
onstat -g ...
Hi guys, Where I can find explainations about the output format (headers and key words) reported after executing onstat -g ... In the Informix Administrator's Guide there is an explaination of all other options of "onstat", but for "-g" option I did not find detailed informati…
onstat -k
Thanks to everyone who answered the onstat -k tblsnum question. I appreciate it. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-1275 Colorado S…
onstat -k
How would one link the tblsnum field of an onstat -k with a table name? Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 3008c64c 0 4004a354 0 HDR+S 100002 230 0 3008c680 0 40042814 0 S 100002 22f …
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…
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…
onstat and tbstat
Hi, We have just upgraded from 5.x to 7.x. Those tbxxxx files are now onxxxx files, but they still exist lots of tbxxxx like tbstat, tbmonitor, and so on, are these files different from the new version onstat and onmonitor or they are the just the same but with different names??…
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
In article <Z0$3mTASWg30EwR4@smooth1.demon.co.uk>, David says... > > That could be from when Online is booting and loading its cache > with data. Try doing an onstat -z 1 hour after the server has > booted then look at the stats at the end of the day, > Yes, I'd already done t…
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 …
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: Assert Failure and onstat
"Juan R. Guzman" <jguzman@remove_this_transre.com> wrote: >I know there is a problem with onstat -z on 7.11uc1, because once tech >support told me to do it and then my engine crashed. Then he apologized >because he had forgotten about a bug with the onstat -z. Again this is …
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: onstat -d,onstat -D
I believe 1001 indicates that the dbspace is a blobspace. I know that 2001 indicates that the space is a temporary dbspace. "Tony_Reynolds(Accounting & Purchasing System") wrote in message <67972r$caj@cssun.mathcs.emory.edu>... >Can anyone tell me the difference between a dbspa…
Re: onstat -d,onstat -D
I believe it in indicates that table in dbspace has been dropped. -Lin "Tony_Reynolds(Accounting & Purchasing System") <tr-2959@mail.necgroup.co.uk> wrote: > Can anyone tell me the difference between a dbspaces address with a > flag of 1 and a dbspaces address with a flag of 100…
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…
onstat -g tpf - 100's of millions of lock requests.
Howdy Anybody struck a problem with threads in selects spinning on the CPU and = generating hundreds of millions of lock requests when viewed from onstat = -g tpf? Anyone know just what is these lockrequests? IE, in what situation they = are created. Syslocks shows zero locks 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…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
Re: lchwaits, read aheads
In article <341968A8.4F9F@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Manoj wrote: >> >> All, >> >> Are there any guidelines for the below ? >> >> ixda-RA idx-RA da-RA RA-pgsused lchwaits >> 4398 29 27805 32188 55 > >This shows that the In…
Re: lchwaits, read aheads
Manoj wrote: > > All, > > Are there any guidelines for the below ? > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 4398 29 27805 32188 55 This shows that the Informix read-ahead logic has prefetched 4398 index leaves, 29 index nodes, and 27805 data pages f…
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: bufreads in onstat -p output
>Hi guys, > > I am facing a problem with an application suddenly becoming slow. The > interesting thing which I noticed when this application was running > was that the bufreads display in onstat -p output was increasing at an > alarming rate. I am setting this to…
bufreads in onstat -p output
Hi, Sorry for resending the message. I forgot to mention in my earlier message that I am running Informix ODS 7.22 UC2 on Sun Sparc 5000 on Solaris 2.5.1. and the application is an esql-c program. Ketan. >Hi guys, >I am facing a problem with an application suddenly …
bufreads in onstat -p output
Hi guys, I am facing a problem with an application suddenly becoming slow. The interesting thing which I noticed when this application was running was that the bufreads display in onstat -p output was increasing at an alarming rate. I am setting this to …
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…
Onstat question
When we use the Onstat -u , sometimes we get this display: onstat -u INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 332c020 ---P--D 0 inf…
onstat options
Hi, What are the best indicators of response time, trans/sec, and general load for monitoring an informix database... using the onstat program? Any help would be appreciated. Thanks Mark~…
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. For Online 7.1, the total fi…
Re: onstat
Carol Davies wrote: } } 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 } >…
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.…
onstat documentation
Does anybody have any good documentation for onstat? In case it varies to much from one version to the other I have online 7.11UC1. thanks…
Re: Killing off client threads
If you are using Online DSA, you should be able to find the session id (sessid) with onstat -u, then execute onmode -z sessid to kill the offending connection. Note that onmode is usually restricted to use by Informix user. -------------------------------------------------------…
Re: onstat -z crashes servers
In article <32270CF3.5809@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >I have Onine 7.11UC1 with Solaris 2.4 on sparc 20's with DR working. >Well yesterday I noticed that my bufreads and the isamtotals from a >onstat -p were negative numbers. After speaking with …
onstat -z crashes servers
I have Onine 7.11UC1 with Solaris 2.4 on sparc 20's with DR working. Well yesterday I noticed that my bufreads and the isamtotals from a onstat -p were negative numbers. After speaking with Informix they thought it was because the number had grown too large and changed the first…
Re: Version 7.12uc1, killing 4ge's
Kate Tomchik wrote: > > Now I know that in version 5.03, you always need to > kill the calling job, never the generated sqlturbo to avoid a crash, > but version 7 has no sqlturbos! How do I avoid this problem? > -- you could do an 'onstat -g ses' identify the problematic sesion…
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: Statistics causing Shared Memory Problems
james, > night we load mainframe data and update existing tables and insert new information. you say each night you load the data. are you a 24x7 shop? so you can't run the update statistics at night after the load is done? or are there users then as well. obviously it doe…
Re: Statistics causing Shared Memory Problems
Have you tried to see what updating your whole db with high does? You also did not state what version of Informix or hardware you are running on? This is very interesting! I'm have a Informix 7.12 on UNIX AIX 4.2 machine I could try this on. I would need the length of the record …
Statistics causing Shared Memory Problems
I am having an interesting problem after changing some of our update scripts. Each night we load mainframe data and update existing tables and insert new information. In the past, I have been updating statistics in individual fields to high, but changed this to update the whole …
Re: OnLine 7.X performance - R U satisfied?
ray, > Are you taking full advantage of you physical memory? How does you > caching ratios look (onstat -p)? If not in the 90's play arournd with caching ratios are good, high 90's. > BUFFERS and SHMVIRTSIZE. Also, is the engine frequently allocating > additional shared…
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…
Re: Re-create Index on a Large Table ( 7.1 )
In article <3v140a$m6v@txirvuhw302.gtetel.com>, kbrand@gtetel.com (Kevin Brand) wrote: >Diana Li (li@inetgw.fsc.ibm.com) wrote: >> Hi Everyone, > >> I have a table with 450,000 records inserted via an ESQL/C program. Since >> the transaction rate started to go down when t…
Re: Re-create Index on a Large Table ( 7.1 )
Diana Li (li@inetgw.fsc.ibm.com) wrote: > Hi Everyone, > I have a table with 450,000 records inserted via an ESQL/C program. Since > the transaction rate started to go down when the number of records approached > 300,000 and running update statistics took a long time and …
Re-create index for a large table
->Hi Everyone, -> -> I have a table with 450,000 records inserted via an ESQL/C program. Since -> the transaction rate started to go down when the number of records approached -> 300,000 and running update statistics took a long time and did not seem to help -> much,…
Re-create Index on a Large Table
Hi Everyone, I have a table with 450,000 records inserted via an ESQL/C program. Since the transaction rate started to go down when the number of records approached 300,000 and running update statistics took a long time and did not seem to help much, I tried to drop and…
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: The truth behind UPDATE STATISTICS...
[Graeme Sargent (graeme@pyramid.com) wrote] > Rus Ambler (rizzo@fourgee.demon.co.uk) wrote: > : In article <3nocjb$1nc@cssun.mathcs.emory.edu> [good stuff snipped] > : I re-iterate my problem: > : Session 1 : [isql system], QUERY, NEW, [update statistics for table iplas], > : …
Re: The truth behind UPDATE STATISTICS...
Rus Ambler (rizzo@fourgee.demon.co.uk) wrote: : In article <3nocjb$1nc@cssun.mathcs.emory.edu> : huddles@emspo01.hasting.com "Huddleston, Joe" writes: : > : > it sets the number of rows the system catalog thinks the table has, which : > will affect which indices the o…
RE: The truth behind UPDATE STATISTICS...
> I re-iterate my problem: > > Session 1 : [isql system], QUERY, NEW, [update statistics for table > iplas], > RUN, CHOOSE, "iplas_4", RUN > Session 2 : [isql system], QUERY, CHOOSE, "iplas_4", RUN > > Both these sessions running on the same box, at the same time, usi…
RE: The truth behind UPDATE STATISTICS...
In article <3nocjb$1nc@cssun.mathcs.emory.edu> huddles@emspo01.hasting.com "Huddleston, Joe" writes: > > it sets the number of rows the system catalog thinks the table has, which > will affect which indices the optimizer will use. > > -joe- > (huddles@hasting.com) A…
Re: Update Statistics
Naomi Walker writes: |> From what I know, one of the main reasons to run update statistics is |> to not only update the number of rows in the system catalogs, but to |> update the min and max index values. |> |> I really dont understand why this information cannot be kept up to d…
Re: Update Statistics
> > update the table information so that RDSQL has current information.' > > Does this mean that, if I have a table of, say, 1 000 000 rows, and > each day 30 000 rows are purged and another 30 000 rows are added, > there is no need to run update statistics as the table size is >…