Oninit® Archive
Results for “onstat -o”
EXTERNAL TABLE issue?
David, ask for the APAR/Issue number: it is normally a public informix on IBM's website…
script to check status of dbspaces & chunks
I would use the IBM provided script alarmprogram.sh in onconfig ALARMPROGRAM /opt/informix/etc/alarmprogram.sh…
Gathering EXTREME amounts of time in %sys CPU
<snip - delete a lot of old text> David Williams wrote in message <0mcD2LAtTeo2EwkJ@smooth1.demon.co.uk>... > Several... >>> Have you seen anything like this ? > > Not exactly, the only time I saw a system freeze that hard was an old > 7.1x running against Pyramid which hung …
Dostats
Hi, Art, Recently, We found somehow our dostats running could ask Informix to add quite some extra virtual memory segments , 1) Online log. 07/05/2026 22:18:31 Dynamically allocated new virtual shared memory segment (size 8000000KB) 07/05/2026 22:19:47 Dynamically allocated n…
ASF connection name error during startup
Hi, ls -lart $INFORMIXDIR/etc .infos file(s) which can be regenerated by onmode -R I think there are .oncfg(?) file(s) in there are well /INFORMIXTMP ( onstat -g dis to show?) strings <filename> these as well or just clear out for the instance and restart. Regards, David. -----…
SBSPACE Chunk error
Hi please check the flags for onstat -d output here: https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=utility-onstat-d-command-print-chunk-information "Why these alerts are coming"? Informix Server does not send out any alerts per email per default. But maybe you have a…
Which VPN is a listener thread attached to?
Hello Jacob, try following to find out which network listeners are running: $ onstat -g ntt | egrep "tcplst|address" hostname/ip + port + protcoll should be shown... Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------…
where is IBM 14.10.xC11W2 ?
HCL released Informix 14.10.xC11W2 mid may 2025, but there is still no Version on IBM Fixcentral... Can someone at IBM please fasten this process... Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------…
CDC on Workgroup Edition?
After some digging I found this: https://www.cursor-distribution.de/en/sales-informix/ibm-licensing-informix/ibm-license-informix-workgroup-edition-en/1416-ibm-informix-workgroup-edition-v14-10-xc10-en CDC is not mentioned in "Prohibited components". (And neither is CLR btw.) ---…
security features
What are the latest security features in IBM Informix, and how can organizations better secure their Informix instances?" ------------------------------ Janelle mclaughlin ------------------------------…
IBM is ending support for Informix?
I'm hoping for any clarification that the group can provide for the link shown below (does this mean what it seems to mean?): Continuing Support for IBM Informix ends on 30 April 2025 In the quote below I have highlighted certain words with a bold font: "...IBM is announcing the …
IBM Informix CSDK licensing
Hi all, IBM ILMT detects IBM Informix Client SDK 4.50 installations and identifies the licensing metric as " Authorised User Single Install", however I am pretty sure there has never been the possibility of purchasing a licence nor a requirement to keep a record of installations …
IBM Informix v.15 is released
After wrestling with some last minute IBM Release gremlins, IBM Informix v.15 is released as of today. From the announcement " We are excited to announce that Informix 15 is now available with its unparalleled scalability for the modern data-driven world. This latest release brin…
Informix 15 is out! Well sort of...
David: According to the Actian Webinar recording about the HCL-Informix v15 release, OneDB has been replaced with HCL Informix and IBM and Actian have agreed the beginning with the v15 releases, IBM Informix and HCL Informix will be identical (except for the branding). HCL Inform…
logical, physical & temp chunks location
Hi DBAs, We have legacy Informix database and I am unable to figure out dbspaces & their respective chunk names along with full pathname. Please help me with a query to find the above or any onstat command. Thanks in advance. Syed ------------------------------ Syed Hussaini ----…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
The next IIUG Tech Talk:
The next IIUG Tech Talk: IBM Informix: What's new and what's upcoming Thu, Mar 28, 2024 11:00 AM EDT March 28 @ 11:00 am EDT The IBM Informix database serves as the foundation for thousands of applications and billions of devices worldwide. IBM is fully intent on investing in the…
Check if buffers are in swap?
It's typically not oninit process memory that's getting swapped, but rather allocated shared memory, and this you can protect from swapping by setting it resident - this is the purpose of the RESIDENT onconfig parameter. HTH, Andreas ------------------------------ Andreas Legner …
Informix future...
Benjamin: See my post to David's question below about OneDB and how it stands versus IBM Informix. HCL Informix is, has been, and will continue to be identical to IBM Informix in every way except for licensing and the name on the package. ------------------------------ Art S. Kag…
Cannot drop two chunks that got added from a storage pool
Can you show affected dbspaces and chunks from onstat -d? Suspecting incorrect offset (-o <#kB>) specified, hence "No such chunk". ------------------------------ Andreas Legner ------------------------------…
14.10.FC9W1 is out!
Any word on when the container version will be posted at the IBM Container Registry ( icr.io/informix)? ------------------------------ mark collins ------------------------------…
V14.10.FC9 installer missing librarie(s)?
Andreas, I have same problem (libisi file is missing). Both tar files in gskit directory don't have deb package. Anyhow, unpacking rpm packages show no trace of libisi: root@mate2004:/home/informix/i1410fc9/gskit/tmp# rpm2cpio gskcrypt64-8.0.55.26.linux.x86_64.rpm | cpio -idmv ./…
list sql statements
Hello Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration, prefectly , these informations (sessid, sql statement, cost, duration , cpu consum…
Informix 14 Certification
That's up to you. The IIUG is administering the Informix v14.10 Badge Exam developed in cooperation with IBM. IBM Partners are required to maintain current badges (IBM no longer offers certifications, but the partner requirements remain), but for users it is optional though valua…
Connect QRadar to Informix
Hello The QRadar doc says The IBM® Informix®® Audit DSM allows IBM QRadar® to integrate IBM Informix audit logs into QRadar for analysis. What is the IBM® Informix®® Audit DSM ? Maybe this https://www.ibm.com/support/pages/setting-ids-auditing-onaudit ? Thanks -------------------…
Guardium
On ibm pages (https://www.ibm.com/products/ibm-guardium-data-protection/databases) Informix is not listed as officially supported. Since we did some guardium - informix installations years ago, I'm curious if this is official, or IBM forgot to list Informix (as usual)? Regards Hr…
HDR server - heavy CPU load
Next step, use onstat -g glo to find out which VPs are pids 27642, 27680, 27679, & 27640 That will tell you what the server is trying to do. Another thing you can do is to run onstat -g act and onstat -g top thread cpu to see what threads are running for the same reason. Art ----…
Memory issue on Informix primary server
I encourage anyone who needs a window into steady memory growth to check out onstat -g top, which is only available in 14.10: https://www.ibm.com/docs/en/informix-servers/14.10?topic=ogmo-onstat-g-top-command-print-top-consumers-resources General syntax: onstat -g top <keyword pa…
14.10.xC7 is out now
<quote> make it easier on end users </quote> We are still talking about IBM here ? IBM = Informix Barely Mentioned…
Great!
If you visit www informix com - there is potential security risk Another IBM great job Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------ #Informix…
idle session consuming lots of cpu time, but doing nothing apparently
Hi Éric Have you been able to identify when during the life of this session the CPU seems to be consumed based on onstat -g cpu output ? Also did you check the overall system performance statistics for instance with nmon ? Maybe other processes on the server are using CPU or I/o…
Shared Memory
Hello, Today I checked the Informix shared memory by onstat -g seg on Informix 14.10FC6X3 informix [rs-om-ifx-201] on_nebula21 $ onstat -g seg IBM Informix Dynamic Server Version 14.10.FC6X3 -- On-Line -- Up 16:43:49 -- 10327040 Kbytes 2021-09-03 15:36:42 Segment Summary: id …
Long Running Query thru shell Script
Hi Amit, I strongly guess you're not going to be happy with this approach. An easier one would be capturing a series of 'onstat -g ses 0' outputs while your problem is going on, then searching and comparig them for sessions that at more active than others, or for SQL that frequen…
calculation of Required logical log
1. Read up on raw tables (beware of restrictions!) https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.admin.doc/ids_admin_0514.htm 2. Consider "smaller transactions" of inserts ... and can also use this to provide an estimate of usage (i.e. do a small subset and ch…
Spot the difference
That was my initial thought. I like the feature, but that's going to break a bunch of scripts out there. [Thankfully I don't think any of mine are impacted; our scripts only ever run onstat - to check the return code, and other onstat scripts are already parsed with grep and simi…
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…
New RFE: Improvement in the check for high serial values
Should this RFE be in the Informix area? https://ibm-data-and-ai.ideas.aha.io/ideas?project=INFX Currently it is in "Information Server - Platform" https://ibm-data-and-ai.ideas.aha.io/ideas?project=ISP ------------------------------ ~~~~~~~~~ Eric Rowell ------------------------…
Benefits of being IBM Business Partner
Hi All, What are the advantages of being IBM Business Partner? Is it true that being IBM business partner, I can download Informix Enterprise Edition in my development/testing environment for testing purpose ? Regards, ------------------------------ Muhammad Ale -----------------…
Execution of Long Restores Remotely
Or even onstat -Dr …
Bad news for informix...
Cesar, MC Software , IBM Informix Partner in Brazil is working with IBM and Informix Customers to Help IBM´s team on that too. We are on that some time already. If you need more information, just let me know. Tks Miguel #Informix…
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…
IBM User Groups Days
On May 19 and 20 IBM is running a virtual conference called IBM User Groups Days. There will be 96 presentations in six tracks on many topics including presentations on Informix and using Informix by myself, Lester Knutsen, and Jeff Fillipi as well as a presentation on the Inform…
IBM Informix and HCL partnership description available
Numerous customers have asked for a formal clarification of the IBM and HCL relationship with respect to the IBM Informix product family. Today, IBM published that document. It has been posted to the library here ( IBM_Informix_and_HCL ) and will be available on the IIUG.org sit…
Informix on AWS
That depends Mark. If you are using an HCL Informix subscription on AWS, there is no other license cost, especially not to IBM. If you are using an IBM AWS instance then yes, you need the equivalent IBM Informix license for the server Edition and size of the instance. -----------…
YIKES! 12.x documentation for onstat -g opn does not match the output
The new output is a lot easier to read but hard to parser via a script. The u and o counts are the number of threads currently using the partnum (u) and the total times the partnum (o) has been opened. The partp is new one on me, the ra (guess) will tally back to the onstat -g r…
SQL error -27001
I realized I did not post my sqlhosts entries for this. They are: my_instance_name onipcshm host1 9000 my_instance_name onsoctcp host1 tcp_my_instancea Looking at /etc/services, I see that tcp_my_instancea is set to 9000/tcp. That matches the value of the service_name part of t…
Informix 14.10 documentation
Art, So who does the documentation now? Surely IBM should be ensuring that the documenation for IBM Informix (as opposed to HCL Informix) is maintained? Regards, David. ------------------------------ David Williams ------------------------------…
Getting started with IBM .NET Provider for .NET Core
Getting started with IBM .NET Provider for .NET Core (developerWorks India) Anything like this for new version of IBM DS Drvier 11.5(IBM .NET Provider for .NET Core 2.0), Entity Framework Core 3.0 and Visual Studio 2019 ?! ------------------------------ iliyan iliev -------------…
14.10.FC2 not available to download?
I'm looking for the version 14.10.FC2 in IBM Fix Central and it isn't there. Something wrong with the IBM Fix Central ? ------------------------------ Cesar Martins ------------------------------ #Informix…
Hugepages
Anything in onstat –m Cheers Paul…
Questions about using temporary smart-blob space on SDS nodes
Ok Art, thank you so much for poiting that out. My mistake. Anyway, I think that onstat command would help him, right? Hope so.... ------------------------------ Alexandre Marini ------------------------------…
IBM Champions 2020
IBM Champion nominations are now open but only until November 4, 2019! Remember this MUST be done annually , so if you are currently an IBM Champion, you must renew. If you are not an IBM Champion or wish to nominate someone else please follow the links below. For Champion renewa…
Reviving of an old RFE that should have more votes: 16 millions data pages limitation
Hi Renaud, If after removing the shared memory segments and it crashes on next oninit probably indicates a configuration issue. Post your onconfig and sqlhosts files Regards Steven…
IBM® Informix® 14.10 Virtual Appliance
Hello there, Where can i download The IBM® Informix® 14.10 Virtual Appliance? Thanks ------------------------------ arnulfo martinez ruiz ------------------------------ #Informix…
New version Informix 14.10
We are IBM business partners, some clients have the Informix Advanced Workgroup version that includes the Informix Warehouse Accelerator product. In the new version of Informix 14.10 there is no Informix Advanced Workgroup version. My question is what happens with this licensing?…
4gl version 7.2 connection to ids 11 ?
PerLuigi, I have connected pre-IBM Informix real-life applications to Informix 12.10 without any kind of problem So yes, this is possible, and you did it!…
raw device usage tracking
Hi Benoît, I kind of think you've figured out the answer yourself already :-) The easiest way to do this is to be disciplined in the use of the storagepool and avoid dropping chunks with onspaces. If you are using storagepools you could rename the onspaces binary to onspaces-do…
IBM Informix RFE gone?
Hi, Where we should request new features? Informix just vanishes from IBM RFE pages. There is no option to filter or submit new RFE. Regards…
Aborting long transaction doesn´t rollback tx
Hi, Today we had the following messages in the log: Aborting Long Transaction: tx: 0xc0000003d86ea0a8 username: xxx uid: nnn Next, onstat -m showed : On-Line (LONGTX) The sessions seemed to continue working normally. For example, I verified that one table inserted new records.…
HCL Informix vs. IBM Informix
I'm just mildly unclear on what is happening with Informix. Is IBM in process of slow-motion divestment? I now see a mix of references to the product. For example, for AWS, I see "HCL Informix". Also, tech support comes from HCL. But, I still see references to "IBM Informix". …
Re: 12.10.FC9 1809 Error
i'm just connecting on shared memory (onipcshm in sqlhosts) regards…
Monitoring SPL Executions?
Solaris 10 Informix 12.10FC3 Today I was asked if we can monitor the execution of SPLs. Specifically, the requester wants a list of all SPLs executed in the preceding 24 hours, and the number of times each was executed. I didn't see any Server Studio reports that addressed thi…
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…
Issues With Restore
I tried it well 10 times now, but it is now saying: Warning: Fatal error in shared memory creation…
sqlhosts file
For the sqlhosts file, if you have two servers (primary and secondary for HDR), will the sqlhosts file have 3 entries? Primary One for shared memory with name of primary and two for tcp(one for each server)? Secondary Same thing(3 entries) except for shared memory, it will have…
syslocks shows negative rowid
Original post: Hi, Please anybody knows what it means the negative value in the field rowidlk ? For example: dbsname dbt tabname pr_tab rowidlk -1316080380 keynum 0 type X owner 2561937 waiter I'm looking for a lock, but I don't be able to detect it. Moreover, in onstat -k …
Move tables to another dbspace
Thank's We had performance issues in the same hour two times a day almost everyday, when is the most users sessions. The cpu goes to top, and we identify with onstat -u | egrep B--P a lot of sessions waiting for a resource, all in the same address, like this 402f086d8 B--PX-- 2…
IDS not writing to online.log
for tid in $(onstat -g ath | egrep "main=5Floop|onmode=5Fmon" | awk '{print= =20 $1}'); do onstat -g stk $tid done Just in case 'crit' should be in any of these outputs, e.g. wait4critex,=20 check onstat -u for any X flags and proceed from there. 'Weeks' you're saying?? No chec…
ids 11.50 shared memory for Workgroup Edition
Solaris 10 11.50.FC5 For the Workgroup Edition, is the maximum memory allowed shared between instances on the same server; or does each instance on the same server have access to the maximum allowable shared memory? Larry…
Re: upgrade and onbar
Hi Art the file pointed by BAR_BSALIB_PATH (ibsad001_64.so) in onconfig file exists but i have the error message when running /opt/IBM/informix/bin/onbar_d -b -p -w (-43231) An unexpected error occurred: 0509-022 Impossible to load the module /opt/IBM/informix/lib/ibsad001_64.o.…
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 …
Re: RE: Which session is using the most cpu resour
since 11.50 there is also an onstat available for that purpose - onstat -g cpu…
Performance issue after migrate to IDS from Online
Hi, I looked through all your onstats. Some observations: 1. The values used for DS_TOTAL_MEMORY and DS_NONPDQ_QUERY_MEM are way too high. SHMVIRTSIZE 201376 DS_TOTAL_MEMORY 26214400 DS_NONPDQ_QUERY_MEM 1310720 16GB RAM So that's just under 200 Mb for SHMVIRTSIZE but 26 Gb fo…
shared memory issue
Hi I am frequently getting below error, I know I am using workgroup Edition hence there is a limit, Using shared memory... however transaction are so less hence dont expect this error very frequently Warning: The IBM IDS Growth Edition license restriction limits the total share…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
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…
Desempenho
Bom dia Srs. Hoje efetuei uma verificação com o comando onstat -g ckp e obtive o retorno abaixo: Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block tra…
What is all this I/O when doing a light append to
I definitely see output for light appends in onstat -g lap when loading from external tables to raw tables, so I know it can be done even if the manuals say it can't. I'm not seeing the behavior at the moment which is making me wonder if my attempt to force a checkpoint before l…
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…
Input/Output Operations
Anyone know a command that will give the Input/output operations/second(IOPs) that an Informix 11.5 instance is being asked to handle? Please understand that what I'm asking for is different than the read/write times returned per chunk from an onstat -g iof command. That command …
IBM Data Server Provider - Db_Locale/Client_Locale
Unfortunately, I would not like to go back to CSDK since IBM is not supporting it for the future. >>The IBM Informix .NET Provider is also referred to as the CSDK .NET Provider. >>It is available for download as part of the Informix Client SDK. This .NET >>provider works only wi…
Ifxclone issue
original post: Yes, every onmode command hangs. I can't shutdown the Primary instance also, I have kill the master oninit process. response: If all onmode commands are hanging and you have to bounce the server, it sounds like it could be a defect (it's hard to say without seei…
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
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.…
shared memory
This concerns IDS 11.70.TC5IE on Windows Server 2008 . This article http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .perf.doc%2Fids_prf_750.htm defines buffer_value = (BUFFERS * pagesize) + (BUFFERS * 254) + 250000and goes on to say: âIf you hav…
Re: HDR and ER Running Together
Original post: Particularly Jacques or Madison I've had this situation four or five times now, HDR has restarted sending updates as soon as the secondary engine has been bounced, but this is obviously a manual process and suspends ER for the duration of the HDR catchup. I will …
Informix 10 evaluation expired.How can I backup ?
Hello,I install the Informix 10 evaluation a half year ago.I forgot the expiration date and did not backup the data before that date.I cannot use any command like 'dbexport','onunload',even 'onstat' and 'onmode -k' to shutdown server.How can I backup the data out and install a ne…
Memory down and shared memory not initialized
I compiled utils2_ak. When executing printFreeB I got a message the library libifsql.so could not be found. So I put the lines below in /etc/ld.so.conf and exectued ldconfig. /opt/informix/lib /opt/informix/lib/c++ /opt/informix/lib/cli /opt/informix/lib/csm /opt/informix/lib/dm…
Linux: oninit returns "shared memory base address illegal", fails to start
Art, I've been getting that error message "Insufficient free huge pages in /proc/meminfo for shared memory segment. Requested: 204800000 bytes. Available: 0 bytes. The default memory page size will be used." since I first installed and configured. The engine…
enterprise replication time to replicate data
these stats shown from cdr view profile are they since instance has been up or since I did an onstat -pz- we do a onstat -pz weekly APPLY - Running Txn Processed 406880 NETWORK - Running Commit Rate 0.12 Currently connected to 1 out of 1 Avg. Active Apply 1.17 Msg Sent 454240 Fai…
onstat -g ath
if ! kaio && ! auto aiovp then check to see if you have enough aiovps configured. onstat -g iov , the last few should not be relatively busy (< 1.0 i/o per sec.) usual suspects : check for hot spots on disk (onstat -g iof; onstat -D). check for seq scans (onstat -g tpf | awk '…
onstat -g mem questuion
original post: Hi Folks, IDS 11.50.FC5 O/S AIX 6.1 Can someone explain the significance of the "*00" at the end of a session id/pool name in an onstat -g mem output? TIA, Dan Response: I don't believe there is anything particularly significant about that, but I'm not sure the…
Shared memory connection to HDR Secondary
Folks, IDS11.50 FC8, Redhat Linux It is not allowed to have a shared memory connection to a HDR Secondary( with dbacess..), is it? Thanks, Frank --001517588cfa01cb4304b178d099…
Informix 10.00.TC5 CKPT REQ Logica Log Full
I hav'nt direct support from IBM Informix because I have Informix as a service from a supplier. My supplier support is very slow so I want to find a solution by me. Do you now how to reach directly IBM Informix support by mail od phone? Thanks…
koi -1 display from onstat -g iov (11.50.FC8)
Where is the -1 for the koi vpclass coming from in the output of the onstat -g iov command, ex: AIO I/O vps: class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors tempops fifo 12 0 i 0.0 0 0 0 0 0 0.0 0 0 kio -1 0 i 3.8 209628 207709 1919 0 444439 0.5 0 0 An…
external restore another server with different chunk name
ids version: 11.5 os : redhat as4 (original backup server) $ onstat -d Dbspaces address number flags fchunk nchunks pgsize flags owner name 4ae5b808 1 0x40001 1 1 2048 N B informix rootdbs 1 active, 2047 maximum Chunks address chun…
CPU load balancing - Tru64
On 31/08/2011 10:56, Dirk Cornel.... wrote: > " I've seen machines that have slow response, although the CPU usage is low" > > Yes, this is what we are experiencing. So my first check were the cpu's. I > also looked at I/O (the I/O was good, no problems there), and the memory was…
How to check what/where is the culprit of slowdown
Thanks Art/Madison. I had zeroed out benchmark. i'm running on version 9.4 on AIX 5(not supported anymore). looks like the io is not 0 anymore after onstat -z. i'll monitor until tomorrow if anything will be ok. thanks your for your inputs.…
Informix is now on facebook
Dear Informix fans, Did you know that IBM Informix is now on facebook? Stay on top of all the latest News related to IBM Informix. Hear about the latest announcements from IBM and IIUG, contests, interesting blogs, best practices, resources, as well as engage with us on top…
What is virtual about Informix "virtual segment of shared memory"?
In the IDS memory architecture, why is the "virtual" portion of shared memory called "virtual?" It seems to reside in that portion of physical memory that the O/S designates to share between multiple processes, but never seems to have anything to do with swapping/paging to disk.…
Transaction mode on ids 11.50
Thanks for fast respone. Database is on windows machine. I try to run that comand and im getting nothing, no error, no nothing... C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>ontape -s -B C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\…
Smarter Questions for IBM
Folks, just discovered a new website that demonstrates how serious IBM is about Informix: http://smarterquestions.org In fact almost all questions are asked and answered by IBM itself and there isn't a single one that is covering Informix - just DB2. Well done, IBM (:- I just…
Moving from Informix SE to Innovator-C
I'm currently using Informix 4GL 7.50.UC4 with Informix SE 7.25.UC6R1 on Linux and I have two databases set up with the same database name, but each in a different path, this is because the database name is specified in the 4GL programs with the DATABASE statement. I then use th…
must read.!!
way cool am baffled!!!!!! http://www.informix-zone.com/redbook-draft-version-ibm-informix-flexible-grid Thanks!!! Superboer.…
IBM buys 4J's ?
There is a lot of new documents and articles on IBM Informix Support about "IBM Informix Genero" and how convert IBM 4GL to IBM Informix Genero https://www-304.ibm.com/support/docview.wss?uid=swg21474179 https://www-304.ibm.com/support/docview.wss?uid=swg27021002 Great news! b…
This looks almost like a new datablade
http://www.fuzzyl.com/news/press-releases/fuzzy-logix-and-ibm-unveil-in-database-analytics-for-ibm-informix/ -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.…
Need onstat Interpretation Help
onstat -g con shows thread IDs, not session IDs. Check if this gives some sense to your outputs. If not, you may need to share parts of it with us... Regards. On Fri, Feb 25, 2011 at 1:19 PM, DAN MUELLER <dan.mueller@trnswrks.com>wrote: > Good Morning, > > IDS 11.50.FC5 > O/S A…
Problems with demo database
I have a problem with creating demo database on Windows 7. I have installed informix client in c:\\\\program Files\\\\Ibm\\\\Informx\\\\client-SDK directory and Ibm Informix Dynamic Server in c:\\\\program Files\\\\Ibm directory. I set the INFORMIXDIR to c:\\\\Program Files\\\\I…
get top 5 i/o busy session
How to get top 10 i/o busy session by running 'onstat -u' and order by " nreads+nwrites" column that addition values of "nreads and nwrites" onstat -u | sort -rnk9 | head -n5 will get top 5 nreads sessions onstat -u | sort -rnk10| head -n5 will get top 5 nwrites sessions…
Instance Crashed !!
What must be the ratio of Resident Memory & Shared Memory that we can allocate initially ? What is the impact of # of Buffers & its size to the size of Resident Memory. Thanks.…
Shared memory segments
Don't have an answer for you off hand, but I did fix your subject line so it doesn't look like spam. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of qingchuntrade Sent: Monday, December 27, 2010 7:54 PM…
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…
IDS Edition and snfile
The onstat utility shows the IDS version. Use onstat - from the command line. The .snfile is used by historical tools. Regards Malcolm On Nov 11, 4:48 pm, Gentian Hila <genti.t...@gmail.com> wrote: > We had installed by our software provider Informix IDS 11.50.FC6WE. > > I am …
CDR Grouper FanOut thread is aborting
Folks, Build Version: 11.10.UC2 Build OS: AIX 5.3 The ER does not work properly due to a "out of virtual shared memory " problem in one site. Is there any EASY DRUG to treat "CDR Grouper FanOut thread is aborting." ? (instead of recreating whole the ER) Thanks, Frank .......…
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
Shared memory problem
IDS 9.40 UC4 on Linux (yes, I know ...) 1. Initialising the instance with a shared memory connection it just hangs at: 01:09:26 Maximum server connections 0 01:09:26 Dataskip is now OFF for all dbspaces 01:09:26 On-Line Mode 01:09:26 Building 'sysmaster' database ... Never…
Alarm for New virtual shared memory segment
Hello, I was wondering if there is any way for Informix to alert us if it "Dynamically allocated new virtual shared memory segment". I tried getting the ALARMPROGRAM to alert, though it seems that this action does not trigger the ALARMPROGRAM. Any ideas? 16:17:26 Requested s…
951: Incorrect password or user informix is not kn
Hi, I forgot to mention that, on this instance i can connect with an unix user other than 'informix'. Doesn't this alleviates the assumption of 'a lack of shared memory or a problem with shared memory' ? Regards…
esql and cygwin
Dear Art, I think that will bring on the right way, but all DOS path entries are available in cygwin. But they are changed from C:\\\\Program Files\\\\IBM\\\\Informix\\\\Client-SDK\\\\bin to /cygdrive/c/Program Files/IBM/Informix/Client-SDK/bin for example. And I think they are c…
IBM Informix Strategy
Folks, I think it would be interesting to see the mood of the worldwide Informix community after IBM published it's ambitious plans regarding a new Informix positioning and marketing strategy. Please vote here: http://www.informix-zone.com/your-opinion-about-ibms-renewed-strat…
How to find out 'mode' of IDS through sysmaster
Hello, Is it possible to find out the mode of the Informix database I have connected to through sysmaster? I have some stored procedures and they need to know what mode the server is in (Primary/Secondary/RSS). Obviously I can do this with 'onstat -' but I need to find this ou…
New Informix Blog
Folks, this might be interesting: http://informix-zone.com/bruce-weed-informix-blog Please also remember the two important Informix events that are happening soon: http://informix-zone.com/ibm-virtual-event Thank you.…
IBM Data Management Magazine Survey
Here is the chance to vote for more Informix content in the IBM DB2 Advertising Magazine: http://www.surveymonkey.com/s.aspx?sm=BMNOoeAiELQjyeKwxwPoFA_3d_3d Pardon - I meant the IBM Data Management Magazine :-)…
shared memory parameters
Having trouble with share memory parameters. I am trying to locate each piece of the memory size number reported by "onstat -". So far I have been able to correlate changes in onconfig with changes in that onstat number. However, I haven't been able to get it all and can't seem t…
2 shared memory segments
Informix 10.00.HC5 HP-UX 11i v2 Recently, I've started getting message like the following when I restart the server Could not create single shared memory segment with resident and non-resident partitions. Proceeding to create 2 shared memory segments instead. Sometimes, the se…
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 ---------…
IDS random slow down
Jumping in here... I am guessing the diagnostics you posted were ran when the engine was in its slow state right? I'd like to see a few things: 1) What is the sqlexec thread that is running actually doing? You can get this information by looking at, in your diagnostics, the on…
shared memory not initialized for INFORMIXSERVER
When I try to start Informix Dynamix Server the following massage appears: shared memory not initialized for INFORMIXSERVER Any idea???…
shered memory not initialized for INFORMIXSERVER
When I am trying to start informix server the following massage apears: shared memory not initialized for INFORMIXSERVER Any idea??????…
how to check defunct processes/session
One way is to look at the reads and writes column in the onstat -u over a period of time for each session (the session id can be grepped out of the onstat -u output). If you find a session whose reads and writes are not incrementing it could be hung. MM…
Re: Delay in commands returning
Neil Truby wrote: > Delay before resonding to commands. > > On a certain server type (Sun M9000), and maybe others, I get about a > second's delay issuing any onstat command ... even onstat -m. See > below, took about one second. > > On any other server - a Sun v890, a Linux ser…
shared memory not initializing
Hi All, Can anybody help me. My shared memory not initializing and IDS was working fine before restore and restored was failed in the middle. I have executed oncheck -pr and getting below error. ONCONFIG config file error on element PHYSFILE. Value in reserved page: 30000 Val…
Where is informix in IBM now?
Hi All, Just want to post this question: 1. Where is informix DB in IBM organization now? 2. Are they planning to port everything to DB2? 3. I've seen some latest version in IBM website and it's downloadable but for 3 months use only. I'm worried as i've been using informix fo…
IDS - How to find users in a database
Reyna, Hi, You can find out the current users using the onstat comand. $ onstat -g ses 'Show you the users are currently connected or $ onstat -u In both of them, the session column number, can be used to see what the user are doing. $ onstat -g sql session_number Regards…
shared memory not initialized for INFORMIXSERVER
________________________________ From: Tang, Wally, CTR, DMA-Riv/IT Sent: Friday, September 18, 2009 9:28 AM To: 'ids@iiug.org' Subject: shared memory not initialized for INFORMIXSERVER Hi, On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we executed dbaccess dbn…
Informix virtual shared memory
> You need to find out where the repeating SQL is coming from by > tracking back the session number to a process using onstat -g ses and > beat the developer up! Hope its not something I wrote many years ago…
IDS instance memory
Hi, We are running 4 IDS (11.5 FC4) instances on a sun sparc machine with 8 GB physical memory. We can see the shared memory through "onstat -" command which is around 1 G. This machine is purely acting as databases server and no other application is runnig on it (like web applic…
Question about the status of the thread
On Jun 30, 2:58 pm, Peternt <roger_vi...@yahoo.es> wrote: > Environment: > > Informix 7.31 64 bits > HP-UX 11i > > Hi, > I see the output of onstat -g ses and I have one question. > Please, anybody knows which is the diference between the status > "sleeping(Forever)" and "sleepin…
Adding BLOB Chunks to DBSpaces
>My question is I added the following chunk to a dbspace using the following command. > >onspaces -a dbspacename -p /dev/mapper/rawpartition -o 8 -s 5120000 > >How come now when I run onstat -d update it shows the chunk as half the size? 2560000 KB. > >Size Free >185f9328 9 5 4 2…
connections to specific database
>Hi, > >I'm trying to find out, how I can monitor the connections to a specific database. onstat -u only gives information fo entire IDS. It sounds like something trivial but I just can't find it. > >thanks for any help >Dagmar There isn't a built in way to do that. All the onst…
IDS performance
There are not published IO stats for IDS in general and they wouldn't help you much as they would be different for different environments. Post some information and we'll try to help identify the problem. If the open community can't help you then I'll suggest contracting with us …
Monitor HDR
On Apr 14, 11:40 pm, Mo <mohitanch...@gmail.com> wrote: > Informix 11: > > We run HDR and I see waits on logbf0, logbf1. I think it's something > to do with log shipping to secondary node. Is there a way to look at > to make sure that log shipping is not the issue why I see some …
Help : Assertion Failure Type: CRASH
I've already had a look at files : /opt/IBM/informix/tmp/af.41edc39 /opt/IBM/informix/tmp/af.41bdc38 But nothing strange to me except what I've paste before is from the second file :(…
Migrating from IDS 9.40.UC6 to 11.50.UC3
On Apr 5, 3:18 pm, bluexn...@googlemail.com wrote: > onstat -g ath ? > > onstat -g stk all ? > > What IS going (on)? Thank you for replying. I was able to successfully convert database by re-running whole proccess once again. I'm not sure what went wrong diring first attempt. Th…
IBM to relegate DB2 to the mainframe and IDS (Informix) to LUW
> IBM will lead with Informix! Way ahead of you - here's the latest Oracle Training Course - http://www.youtube.com/watch?v=ByZqx30OvVs…
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/…
Re: Determining instance's oninits
On Mar 6, 9:34 am, theBP <th...@Usenet-News.Net> wrote: > red_val...@yahoo.com wrote: > > I have 3 informixservers running on a single host. One of the > > instances has experienced an assertion failure and is now > > unresponsive, so I'd like to kill its oninit processes and at…
How many Informix Employees are Left?
Of the 2100 or so Informix employees that were taken on by IBM, how many are left? Anyone have any idea? > 100 < 100 ? -- }(:…
Informix Warehouse Feature
> > IBM announce today the availability of Informix Warehouse Feature: Why no Informix based BCU ?…
IDS FC3 on Windows Vista Business x64...
Hi Jean Georges, If you type "whoami /all" from that prompt, does it say you are a member of the Informix-Admin group? If the answer is no, logoff and log back in again to refresh your token information. If the answer is yes, can you paste the "PRIVILEGES INFORMATION" here. G…
dbcopy.ec compile on AIX5.3 gcc 4.1.1
Dbcopy.ec : Revision 1.58 AIX : 5.3 gcc : 4.1.1 esql : IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC3 A lot of error message display after I modify some and go further. Is anyone compile succeeded ? Or where I can get the binary file for AIX 5.3 ?…
-25588 error after CPU & fiber channel failure
John, See if the app can connect if it uses the network connection (carsitcp) instead of the shared memory connection. Mike…
Question about sysindexes.clust
I can provide you with a copy of the onstat -p but don't have the others. I will get them in future tests (I'm hoping we are almost done for now). On Tue, Nov 18, 2008 at 3:32 PM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Eric Rowell wrote: > > Any suggestions would b…
Informix Virtual Appliance
Fernando Nunes wrote: > IBM has made available a virtual appliance with SLES 10 SP2 and the > following IBM products installed and configured: > > IBM Informix Dynamic Server 11.50.UC2DE > IBM Informix Client SDK 3.50.UC2 > IBM Informix JDBC Driver 3.50.UC2 > IBM Informix Spatial…
Re: IBM To Sell Informix
> Yes, you are correct. a parody. But a poor one at that. Suppose that > it was actually picked up on a news report? Yeah suppose. People might actually see the product's name in print. Perhaps you should make a video about it: http://www.rootstelevision.com/players/player_dear…
IBM To Sell Informix
FOR IMMEDIATE RELEASE (AP) Armnonk, NY -- In what appears to be a complete reversal of fortune for the beleagured database division of IBM known as Informix, IBM today announced that they will indeed start marketing the entire product line of database products under the Informix…
Script to build dbspace from onstat -d output
there is dup-spaces.sh that does what you want.…
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…
IDS as a "legacy" system...
I'd like to know if there are 100 ( or more ) IBM customers actually using Informix. It would be great to see a list of 100 IBM customers that are using Informix.…
Determine if informix is online?
Fernando Nunes said: > Not necessarily... > Just set INFORMIXCONRETRY and INFORMIXCONTIME to fair values... Are you implying that the default values might not be good enough? :oD > onstat - will not work remotely... (unless you use ssh to connect to the > dbserver of course :) …
View thread info?
Hi All, Thanks for your replies. I managed to identify the process that caused the problem. 1. Use onstat -g act to look at active threads 2. Perform onstat -u | grep <rstcb value of active thread in step 1> -> get session id. 3. Perform onstat -g ses <session number from step…
virtual portion memory size
I believe that parameter can be tweaked in '/etc/system' and is called 'shmmax' >From /usr/include/sys/shm.h: /* * Shared Memory information structure */ struct shminfo { int shmmax, /* max shared memory segment size */ shmmin, /* min shared memory segment size */ shmmni, /*…
The max size of BUFFERS in IDS9.40FC7 at Solaris?
That is means the maxsize of share memory segment is limited to 4GB... OK,Thanks all!…
Just FYI on the Mac front.
Jonathan Leffler's dbaccess replacement : i.e. sqlcmd compiles and run's with almost no difficulties. There was a brief moment of PEBKAC as yours truly forgot about the following environment variable. DYLD_LIBRARY_PATH Which until I included /Applications/IBM/informix/lib and…
Informix and AIX P6
Anybody running Informix on IBM P6 Hardware? Has it been smooth? We are looking at it and want to know the user community has experienced. David Link…
3 parameter/onstat questions
I just got off the chat-with-labs with John Miller. He left me with 3 questions I am hoping to get more info about, having failed to get anything useful from the version 10 docs. I'm on ids10.0.fc5. 1) He strongly recommended having the chunk mode set to expanded 'always'. He sa…
"tty" column in onstat -u
(HP-UX 11i, IDS9.30HC5) Just a comment, really, and wondering if this is the same on other systems? Doing a remote dbaccess query from one box to another, I've found that when I do an 'onstat -u' on the target machine, under the 'tty' column it shows the tty of the session on th…
Informix session details
Hi, Sometimes I see huge Reads by one or more informix sessions in onstat -u. I know onstat -g ses <sid> won't show any details of such system sessions. Well, it could be many thing in terms of house keeping by IDS but is there any way to find out more details about such session…
Ip for a network session
onstat -g ses look under "hostname"...…
Please! What is the IBM Informix Help Line Phone?
Does anyone know what the IBM Informix phone line is for emergencies? Please help if you know.…
Google Ads for Informix at IBM
I did a Google search that mentioned Informix; I got an Google Ad from IBM for Informix that led to http://www.ibm.com/software/data/informix (OK, it added a -306 to the www bit - but it got to the right place within IBM). -=JL=-…
Re: tblsnum in onstat -k
Sounds good... select * from syslocks.... is easier.. Superboer way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html On 6 dec, 01:30, mohitanch...@gmail.com wrote: > Version IDS 10: > > Is following sql correct to retrieve associated table for that lock…
tblsnum in onstat -k
Version IDS 10: Is following sql correct to retrieve associated table for that lock listed in onstat -k: select * from sysptnhdr where hex(partnum) = tblsnum; or select * from systabnames where hex(partnum) =tblsnum;…
Update from Digital 7.31.FD1to ....
Baan IV run not on the same machine and connect to the informix server with an 1GB crossoverethernetcable. so we use not Shared Memory to access the database!…
Replication question
Laurie Gustin wrote: > Hmmm - the replay position hasnt been overwritten. I have attached onstat -l and onstat -g ddr outputs. > > I added a bunch of logs last night to make sure we didnt block again until I could do more research this morning (and think more clearly..) > as you…
Re: rstcb
On 1 list, 18:46, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 1, 12:15 pm, mohitanch...@gmail.com wrote: > > > Version IDS 10: > > > In different onstat output I see "tcb" and "rstcb". I am not sure what > > it means. I generally grep for address from rstcb in onstat -u …
Informix DBA Job Opening in Lenexa, KS
On Thu, 2007-10-04 at 12:21 +0000, Zachi wrote: > In Lenexa, KS and no one from IBM-Informix there wants to join??? I imagine it would be a step down for an IBM-Informix developer to become a DBA. -- Carsten Haese http://informixdb.sourceforge.net…
rstcb
Version IDS 10: In different onstat output I see "tcb" and "rstcb". I am not sure what it means. I generally grep for address from rstcb in onstat -u output to find out about the session. But I am not sure what these mean.…
shared memory limitations
Hi folks does someone know what are the maximum shared memory size that can be used both in IDS9 and IDS10 Thanks…
How to find the location of logical log file
On Aug 20, 8:32 am, Veeru71 <m_ad...@hotmail.com> wrote: > Given a logical log file, wow can we find out its location > (dbspace) ? > onstat -l doesn't show this info. > Thanks It actually is in the onstat -l output. The "begin" column is the physical address of the begining o…
shared memory already exists
I am using IDS 9.40, I get message informix log below, after I shutdown and take offline the database: 14:38:05 IBM Informix Dynamic Server Started. 14:38:05 shmget: [EEXIST][17]: key 52564801: shared memory already exists 14:38:05 mt_shm_init: can't create resident segment Cou…
Re: shared memory not initialized
Tom I may have missed this in the variety of posts ! but do i understand this is a new installation and has never run? If so have you actually initialised the engine (oninit -i) at any time? Keith On 13/08/07, Ogiwara Tsutomu <tsutomu_ogiwara@hotmail.com> wrote: > Hi Tom. > > …
Re: shared memory not initialized
Thanks Andreas, The system is resolving the host name fine. uname -n reports informix. when i ping informix, i get a reply from the correct IP, 192.168.26.66 Still no luck Tom On Aug 9, 4:55 am, Andreas Breitfeld <abrei...@de.ibm.com> wrote: > Maybe my hint regarding the 'set…
RE: shared memory not initialized
You didn't need to run oninit -v the second time, the first time (oninit -ivy) was enough. The second time around it tries to pop memory back in the same place as the last one. Check if the first one is still running: onstat - It probably is. If not, then you may have corrup…
RE: shared memory not initialized
The holy trinity is ONCONFIG, sqlhosts and /etc/services. Your entries look ok at this point - sounds like your rootdbs either does not exist or has wrong ownership/permissions (previous note). You also need environment variables: INFORMIXSERVER=informixserver (in your case) ON…
shared memory not initialized
I have just installed Informix 10 on a CentOS 4.5 system. When I run oninit -v to start the dbserver, I get the following, and then it dumps me back to bash: [root@informix informix]# oninit -v Your evaluation license will expire on 2007-10-30 00:00:00 Checking group membershi…
ontape or IDS problem
> - Adding over 3 TB of chunks to the blobdbs. potentially it does something really inefficient trying to locate blobs in empty blobspace chunks. how many of those 3TB chunks are empty?? Suppose you have 20 empty chunks, i would drop in that case 18 chunks and look if your pro…
Re: Pb with Krakatoa on Linux
You should have at least the following lines in the /etc/ld.so.conf.d/informix.conf file: /opt/IBM/informix/extend/krakatoa/jre/bin /opt/IBM/informix/extend/krakatoa/jre/bin/classic /opt/IBM/informix/extend/krakatoa/jre/lib Sorry for not being precise in my first reply.…
Pb with Krakatoa on Linux
Thanks Claus, Well, it's better: > EXECUTE PROCEDURE sqlj.remove_jar('statbuilder', 0); SQL Error (-9431): Can't find system class or method or library (/opt/IBM/informix/extend/krakatoa/jre/bin/libjava.so). But not perfect... Of course... geo:/opt/IBM/informix # ll /opt/IBM/…
Re: Slow database creation and loading
Hello John, do not set > export MAX_PDQPRIORITY=100 PSORT_NPROCS=6 PDQPRIORITY=100 > FET_BUF_SIZE=32767 make sure you have the shm connection. i do not see any i/o on your tempdbspaces....before you start do a onstat -z can you try setting DBSPACETEMP env var: export DBSPA…
ONSTAT -U Question
'onstat -u' shows all threads for all sessions. If a session is using multiple threads (PDQ) it will have multiple entries in 'onstat -u' Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.or…
how to fix the error "hpkaioaddseg: ASYNC_ADDSEG.
OK, it happen as Andreas Kutsche says. - enough memory/swapspace/shared memory available, enough segments available the IDS allocates a lots of segments,so the error act.…
Sysprofile question
IDS 9.4 on AIX 5.2. I'm trying to monitor some statistics for multiple instances, so I'm pulling (among other things) a bunch of values from sysprofiles. I have a couple of servers that are very busy, and the value in the bufreads row keeps rolling over. Is there any way to tell…
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…
onstat -a runaway process
Why in the h*ll are you prediocally running an onstat -a? This is a default debugging mechanism, not a casual monitoring tool. Figure out what it is you want to monitor and check THAT periodically - not the whole enchilada. Much of the onstat -a output is fairly useless anyway…
IBM seeking INFORMIX authors
Hi Informix Fellows, maybe someone is interested in this: http://www.informix-zone.com/node/123 Thank you.…
shared memory already exists
HI, guys, AIX5.3 , IDS UC5 If we see the following problem, the only way is to turn off/on the power? informix@otto $ oninit oninit: Fatal error in shared memory creation informix@otto $ informix@otto $ onstat -m *** WARNING: IBM Informix Dynamic Server is no longer running. …
IDS is busy all the time
Hi, I need a hint. Maybe somebody has had the same or a similar problem: We have an IDS 10 Server which has been running with a load of about 15 % until some days ago. Suddenly (without a config change), the load is > 50 % all the time. We shut down the engine and the load went…
shared memory
In our IDS 7.31 server, onstat -g seg displays seven 'V's (Memory Segments). SHMVIRTSIZE 100000 SHMADD 100000 SHMTOTAL 0 At present 6th "V" is in use and one is free. Each memory segment is quickly getting exhausted. Why its getting utilised very quickly im running update stat…
JDBC license query
Hello A potential customer of mine is running Informix and I want to approach them with a proposal to develop software for them which would connect to their Informix DB using JDBC. I understand that the JDBC client and server ships with Informix and a trial version is available t…
Re: ISQL install problem
Hi Clive, I do have an unlimited shared memory connection, but am not sure of any others - is there a way that I can check this? Thanks Andy…
shared memory and tempdb spaces
I'm pretty new to Informix and AIX and have a bit of a problem. The Informix log is showing the error "out of shared memory segments". From the other posts I've figured that we've hit the 2GB SHM limit and are probably going to move to the 64bit platform, but in the meantime I'…
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 …
Re: Insider #75: Highlights: IBM Information On Demand 2006,The Next Informix IDS Release...
Davorin Kremenjas wrote: > > Seriously, we realize it is expensive, but it's an investment. > > An investment? > Who is supposed to come to Vienna? End-users who are using Informix and > Business Partners who are supporting them doing that. > Well, end-users already made an inves…
A question of load . . .
We had similiar problems too. What happen was one 'power user' was running Cognos Impromptu query, using non-standard catalog to create her own report, therefore, generating excess number of 'outer join' and suck out all CPU. Next time happen, you can run 'onstat -g act' to see w…
Shared Memory
HI,I hava a problem. /home/informix/etc>onstat - Informix Dynamic Server Version 9.30.UC4 -- On-Line -- Up 103 days 05:37:36 -- 269068 Kbytes How does it is calculate for "269068 Kbytes" ? tks…
Re: Informix in the press...
eric@herber-consulting.de wrote: > Sometimes wonders take a little bit longer: > > http://www.marketwire.com/mw/release_html_b1?release_id=154242 > > A press release from IBM mentioning Informix. Great !! Go Ron Flannery! Go Cindy Lichtenauer! Go IBM! Go Informix! Art S. Kag…
record locked
a combination of onstat -k and onstat -u…
Re: Informix business grew by double digits in 2006 (Q1+Q2)
>> Yelling, ranting and complaining will not grow the Informix business and >> will not change IBM's behavior. Yes, you're right, I know. That's why I concentrate my spending on increasing Ardenta's market share amongst the existing, but declining, client base. This is quite a…
RE: Contiguous shared memory segment allocation failed at 0xd0000000
SHMBASE is different in your config from standard - why? How much shared memory is allocated to this instance (onstat -g seg) ? How many locks do you need for this process (16:10:23 dynamically allocated 100000 locks) ? OR you could lock the table. You need to configure LOCK…
query using cpu
Floyd Wellershaus wrote: > Any idea why a query that does a join of a table on itself, doing a count and a group by, would cause the cpu usage to go drastically up, almost instantly ? Not pdq, just a query, on a non fragged table. > > It is doing multiple sequential scans of the…
Contiguous shared memory segment allocation failed at 0xd0000000
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000.…
Contiguous shared memory segment allocation failed
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000. Al…
shared memory not initialized for INFORMIXSERVER
Greetings all- I'm looking for a nudge in the right direction for an issue I'm having. I'm running IDS 7.31.UD3 on W2k Server SP4. localhost name is cognos INFORMIXSERVER=data_archive I am working at the console of just the server. (not connecting via network) I am getting an …
Ayuda sobre performance
Hola a todos, quisiera me pudiecen ayudar con esto que les voy a presentar: necesito saber como puedo ver los usuarios que tengo y los privilegios de los mismos. asi como el sacar estadisticas de rendimiento de la base de datos o de accesos. Gestor, claro, Informix, Sistema Oper…
onstat shared memory error
I am running INFORMIX IDS9.40 on Slackware 10.1 and everything works fine except that informix cannot run onstat due to the shared memory: permission denied error. The database chunks reside on a smart array disk system, so I did a raw /dev/raw/raw1 /dev/cciss/c0d0p3 so I woul…
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…
Checking indexes after large deletes
"Doug McAllister@Fidelity Investments" <dougmc001@gmail.com> wrote in message news:1149703655.779384.151690@u72g2000cwu.googlegroups.com... > hmmm, btc is not a valid option in my 10.00.FC4 instance and when I try > it onstat gives me the help listing. When I try it on my 9.40 > …
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
Re: Stuart strikes again - history is altered!
DE - Simple question - have you ever worked for IBM or Informix? Curious....…
who locks a record?
onstat -k followed by an onstat -u…
Re: shared memory segment size
The resident portion of shared memory depends on # of BUFFERS + # of LOCKS + LOGBUFF + PHYSBUFF + some SHM headers for more details - http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin276.htm Regards, Nilesh Friday, May 05, 2006 10:31…
shared memory segment size
Why has my shared memory segment this size? This is the output from onstat -g seg Segment Summary: id key addr size ovhd class blkused blkfree 36 1384138753 a000000 1613758464 266640 R 393773 211 37 1384138754 6a…
IDS versions & there full forms
Hi Guys , jst was looking for all the Abbreviation of Informix stuff. Can;t see an stuff at the IBM site.It was redirecting me but no page displays What all are there diff forms UC : FC SE :STandard engine rgds…
Re: Thoughts on Logical Log use requested
TBP said: >> > Humm, > > An onstat -l (just the first bit) would be useful. > > Seems like quite a high log usage. > > Do you use unbuffered logging? > > How big is your LOGBUFF?? Darn. Beat me to it. :o| -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo "But wait, …
Re: Informix marketing request list
The Informix marketing request list has been updated reflecting the progress IBM made on our proposals: http://www.herber-consulting.de/cgi-bin/IfxMarkReq.pl…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Hung Server
Art S. Kagel wrote: > Chris S wrote: > >> We've recently been having a very strange issue with one of our >> Informix Servers. It's IDS 7.31UD1 running on AIX 4.3.3. The server >> appears to go into a vegetative state and is no longer controllable >> through normal means. > > <…
data model
IBM Informix online manuals are pretty good! Check out : http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst81.htm?resultof=%…
Shared Memory challenge on AIX 5.1
One of my sites has 1 Gbyte of RAM. I have configured them to use 512Mbytes of Virtual Shared Memory and about 256 Mbytes of Resident Share Memory. RESIDENT is set to 0. During normal processing everything is OK with those settings. Occasionally the size of the virtual shared m…
Re: IDS 10
BigVinnie wrote: > I'm about 24hrs away from saying the heck with IBM/Informix and > converting everything to another database. Come on in the waters fine.…
Re: Informix in the news!
Michael Segel wrote: > Finally and most importantly, No mention of Informix at all within IBM's IM > strategy or product announcement.... > > -G Unfortunately: No one that came to IBM with Informix will be surprised. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washingto…
Re: IBM & Informix
DA Morgan said: > > Obnoxio The Clown wrote: > >> I'll have to keep an eye out for this "Laphroig" stuff. > > When you have nothing of substance resort to corrrrrecting > spelling errors? Impressive! At least I'm not the one waving his cock around, trying to pretend he's so suav…
Re: IBM & Informix
Obnoxio The Clown wrote: > I'll have to keep an eye out for this "Laphroig" stuff. When you have nothing of substance resort to corrrrrecting spelling errors? Impressive! -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)…
RE: IBM & Informix
Dirk- > -----Original Message----- > From: Dirk Moolman [mailto:DirkM@caretech.co.za] > Sent: Wednesday, November 30, 2005 2:55 AM > To: Everett Mills > Subject: RE: IBM & Informix > > Do you have a link where I can read more ? > > Dirk It's mentioned in Stuart's blurb in the l…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Mark D. Stock Sent: 27 November 2005 02:34 PM To: Traveller Cc: informix-list@iiug.org Subject: Re: IBM & Informix >I agree that it would be nice to hear about some o…
RE: IBM & Informix
> -----Original Message----- > From: Mark D. Stock [mailto:mdstock@mydassolutions.com] > Sent: Sunday, November 27, 2005 6:34 AM > To: Traveller > Cc: informix-list@iiug.org > Subject: Re: IBM & Informix > > Traveller wrote: > > Much as I like Informix and used it for over 10 yea…
Re: IBM & Informix
DA Morgan said: > > Actually Glenmorangie. Though I've three bottles of Laphroig in the > larder. ;-) Yes, Glenmorangie, made by taking the piss of people who drink real Scotch bottling it. I can definitely see you drinking it. I'll have to keep an eye out for this "Laphroig" s…
Re: IBM & Informix
Michael Segel wrote: > Obnoxio The Clown wrote: > > >>DA Morgan said: >> >>>And far too little sailing, scuba diving, drinking scotch, and writing. >> > Drinking Scotch? > LOL...I bet you just love Johnny Walker, Cutty Sark and Dewers. On thr > Rocks! Actually Glenmorangie. Thou…
Re: IBM & Informix
DA Morgan wrote: > I spend approximately 60 hours a week doing ... 1/10 that teaching. A 60 hour work week and you claim Oracle is easy to use? Sorry couldn't resist.... Seriously though work life balance is private thing. 66hrs/week would not be for me. Cheers Serge -- Serge R…
Re: IBM & Informix
> I spend approximately 60 hours a week doing ... 1/10 that teaching. As these 6 hours a week probably do not earn you a living, does Oracle pay for your remaining time to be on an Oracle defense team in Informix newsgroups ? Do you cover other newsgroups as well, like DB2, Syba…
Re: IBM & Informix
DA Morgan said: > > And far too little sailing, scuba diving, drinking scotch, and writing. If you count posting useless shit on Usenet as writing, then I think you have more than enough time for writing. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fe…
Re: IBM & Informix
M Segel wrote: > Whats that they say... Those who can... Do. Those who can't... teach? > ;-) That's what some say. But then they often also end up saying "Do you want fries with that" too. I spend approximately 60 hours a week doing ... 1/10 that teaching. And far too little…
RE: IBM & Informix
Personally I would choose anything ahead of SQL Server, I need my DBMS to run 24 x 7 and nothing I have seen convinces me SQL Server even comes close. I've never used Oracle, but would need a lot of convincing to convert from the ease of use of IDS. As I have a major influence in…
Re: IBM & Informix
You are right. They have had no bad press. Just no press and as you say when you do not the know the furture of a product , would you as a business make a decision to buy in Informix as a database when you have the choice of Oracle and MS-SQL server. I say nothing about DB2 beca…
Re: IBM & Informix
On 25 Nov 2005 17:42:08 -0800, david@smooth1.co.uk wrote: > >OK I substantiate it then...just wait until next week. OK? With real numbers and such . . . . ? I'm all ears . . .. JWC…
Re: IBM & Informix
Dirk Moolman wrote: > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Captain Pedantic > Sent: 25 November 2005 10:40 AM > > >>Contact your IBM representative? Right! > > > > > Sadly, in my case this is the sa…
Re: IBM & Informix
Traveller wrote: > Much as I like Informix and used it for over 10 years, I have not heard > of any new sales wins for IBM Informix in Europe. This causes rumours > and speculation to circulate and not in a good way, while also making > existing users of Informix even more nervou…
Re: IBM & Informix
OK I substantiate it then...just wait until next week. OK?…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malcolm weallans Sent: 25 November 2005 12:15 PM To: 'Traveller'; informix-list@iiug.org Subject: RE: IBM & Informix >Just because you haven't heard of any significan…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Captain Pedantic Sent: 25 November 2005 10:40 AM > >Contact your IBM representative? Right! Sadly, in my case this is the same, haven't seen my IBM account manager …
RE: IBM & Informix
Just because you haven't heard of any significant wins for IBM Informix it doesn't mean to say they aren't happening. I happen to know that there are some big wins for IBM involving Informix, including a very public win for a 2006 sports event - but the IBM marketing machine mig…
Re: IBM & Informix
Much as I like Informix and used it for over 10 years, I have not heard of any new sales wins for IBM Informix in Europe. This causes rumours and speculation to circulate and not in a good way, while also making existing users of Informix even more nervous. As a result I am anoth…
Re: IBM & Informix
Dirk Moolman wrote: > An interesting article about IBM and Informix > > > http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/ But this article is now over a year old. IBM have now dropped the DB2 brand, or so they tell us. It left with JP. Of course it could take a long t…
IBM & Informix
An interesting article about IBM and Informix http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/ sending to informix-list…
VMware edition
Do you know which version of VMware are supported by IBM for an implementation of Informix architecture? (the installation with Informix ER) Still thank you, Francesco…
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: IDS 7.30 do not start - NT
Your server only has 512M of memory. Check you onconfig parms and reduce the number of buffers, SHMVIRTSIZE, locks etc to reduce the amount of share memory requested, then start your server. Good luck, Brian >Hello, > >i have a problem with the informix database. It is on WIN …
Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
For more informatio in my Log file appears: 09:23:21 (3) failure, system out of semaphores 09:23:21 Dynamically allocated new message shared memory segment (size 352KB) 09:23:21 Requested shared memory segment size rounded from 344KB to 352KB 09:23:21 Requested shared memory seg…
RE: IBM .net Driver for Informix vs MSSQL .net driver
the issue here is that the .net provider for Informix is not native but a wrapper which uses ODBC in order to fix this problem IBM would need to develop a native .net provider…
unable to attach to shared memory
Hi All, Tech Specs: IDS 7.31.FD7 O/S - Solaris 5.8 Generic_117350-26 sun4u sparc SUNW,Sun-Fire oncheck and onmonitor are giving errors: shmat: [22]: operating system error Unable to attach to shared memory. onstat -g seg gives Informix Dynamic Server Version 7.31.FD7 …
Performance problems/System generated temp tables
I've got an OLTP system that has developed poor performance. I eventually tracked it down to excessive DBSPACETEMP I/O by monitoring onstat -D. The pages read/written to the temp space far exceed the I/O on our data spaces. It's been suggested in a previous post (see: Tracking d…
Shared Memory Permission Denied
Hi, when i execute onstat with informix user send this message: onstat: = Shared memory: permission denied. or when i go into onmonitor and sel. an option send the message: Unable to attach to shared memory. Permission denied Informix IDS 7.31.UD3 Unix, Solaris 5.6 thanks in a…
RE: Max Locks Forever
Sum up the "locks" column of onstat -u. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Bill Hamilton Sent: Wednesday, August 17, 2005 1:19 PM To: informix-list Subject: Max Locks Forever How would one find out…
Max Locks Forever
How would one find out the "maximum number of locks in use" for a period. lockreqs from onstat -p does me no good. I have a system that is stressed for memory and I'm running 100000 locks. They probably could do ok with less. This is 9.40.TC2 on Windows sending to informix-list…
Re: IDS 10 disk configuration
Murray Wood (IList) schrieb: > Neil > > All the events that take place at a checkpoint, including waiting for all > critical processes to get out of critical and cleaning BUFFERS, need to take > place. Then, if you have 10 times as many dirty BUFFERS in a chunk then > this compo…
Informix Upgrade Optons for an ancient Informix system
Might be able to get a Linux/Informix package deal from IBM. They were running some prgrammes toward the end of last year, not sure if they are still running.…
Latch waits
I'm seeing quite a highish level of latch waits (lchwaits) - whats the best way to reduce this? Increase the shared memory?…
Re: ODBC Memory Allocation Error
mauroc@beacon-ct.co.uk wrote: > Hi, I just googled "onstat" and found it is an Informix utility. What I > would ideally like is something I can access from within the Windows > O/S. Any ideas? > > Thanks > No having a Windows box with IDS on it I can't check but I think you shou…
IBM Informix HA Agent for SUN Cluster
Hello is there anybody who has experince with IBM Informix HA Agent for SUN Cluster? Waht kind of software is nessary ? Thanks in advance Steve…
IBM Informix HA Agent for SUN Cluster
Hello, is there anybody, who experince with IBM Informix HA Agent for SUN Cluster? Which software is nessary ? Thanks in advance Stefan…
Re: Passport Advantage: Conclusion
Any chance you could stayt with IBM if I can get them to work better with you? I talked to the north europe salesman for Informix Databases today and I've got contacts in IBM now... I'M HAPPY TO REVERSE ENGINEER THE IBM CORPORATE STRUCTURE AND GET THEM TO WORK BETTER WITH CUSTOM…
Re: Network Down
Did you ever figure out why you were getting network down message? We have benn running our database for three years and just recently we get this message. It happens only a few times a week. ONSTAT looks okay. Just ONMONITOR gets this message and applications can not access the …
Transaction Rollback
onstat -x…
Informix IBM oledb driver
has anyone tried the Informix OleDb driver provided by IBM? I need to connect to an Informix DB and wondering how good are those driver, and need some information on how to use them. Thanks Andy -- Message posted via http://www.dbmonster.com…
Re: dropping chunk
howie_lfc@hotmail.com wrote: > The offset used is 0. > > onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y > > Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 > rm /dev/vg_archive/rlvol34 > > Run a level 0 archive to /dev/null > > onspaces -c -d temp5db…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: Informix Performance Issues
"Anirudh Chitnis via DBMonster.com" <forum@DBMonster.com> wrote in message news:4d71b87ec26b42cbba3bfa8ae42593e7@DBMonster.com... > All, > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also…
Informix Performance Issues
"Anirudh Chitnis via DBMonster.com" <forum@DBMonster.com> wrote in message news:4d71b87ec26b42cbba3bfa8ae42593e7@DBMonster.com... > All, > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
JDBC Driver
Where can I get an Informix JDBC driver? The link to it on the IBM website seems broken.…
RE: Difference between checkpoints - ckpwaits
Check out http://www.oninit.com/onstat/index.html. You will find most everything you want to know about onstat output. In this particular case: ckpwaits The number of times a thread has had to wait for a checkpoint to complete before continuing. Regards, Bill Dare > -----Ori…
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…
RE: Informix UC7.41 - slow
"Simmons, Keith" wrote: > > What O/S > What version of IDS > Are you using raw or cooked disk > How many users? > What is your definition of slow? > How do you know it is slow, what is the comparison? > How much data? > volatility of data? > ? > ? > onstat -p > onstat -m Solaris…
Re: shared memory weirdness
Ian Spare wrote: >We're running a very old version of HPUX and Informix, the system will >shortly be retired so we're limping along for a short time. > >We're running out of shared memory though and it's killing the database, >to an extent it's something we're going to have live…
shared memory weirdness
We're running a very old version of HPUX and Informix, the system will shortly be retired so we're limping along for a short time. We're running out of shared memory though and it's killing the database, to an extent it's something we're going to have live with but something puz…
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…
Workgroup to domain - IDS7.3x doesn't work properly
What could I do if the w2k server, which is the informix server (7.31tc1), from a workgroup has been taken into a domain? It doesn't answer by the console to commands such as: 'onstat -' but the service is up and everyone could work. It's imposible to take out of the domain. Tha…
virtual memory segments added
onstat -g mem displays the pool names (first column) onstat -g afr <poolname> displays the allocated fragments by address. If you run onstat -g seg, you get the logical address of the shared memory segments. Somthing like... for f in `onstat -g mem | cut -d ' ' -f 1 ` do o…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
Fatal error in shared memory
Trying to set-up Informix 7.31 UC4 on Solaris 2.6 everytime I try and start informix I get oninit: Fatal error in shared memory initialization I have set SHMBASE to 0x1000000 and also tried 0x1000000 as suggested in the documentation - both fail. The system has 512Mb of RAM and…
onload consuming shared memory
Hi all, we're just about to start a full database restore to recover from a failed onload session. I just want to try and determine what might have gone wrong to see if how we can do it better next time. We want to onload a table with blob data of about 300000 rows and 11GB of …
Re: shared memory not initiaized for INFORMIXSERVER
You killed the engine, it should just re-start. Then check the logs and find out why it died Geezer From The Freezer wrote: > > I'm removing the indexes and recreating them in my informix database and all > the onstat commands were working fine. Now all of a sudden I am seeing …
shared memory not initiaized for INFORMIXSERVER
I'm removing the indexes and recreating them in my informix database and all the onstat commands were working fine. Now all of a sudden I am seeing this error when performing any onstat commands: shared memory no initialized for INFORMIXSERVER 'informixservername' Why is this?…
Mission Critical Database Rating
See http://www.sdtimes.com/news/103/special1.htm - there is a chart that actually compares/lists IBM Informix. -- Scott MacKenzie - Dine' College ISD. sending to informix-list…
Re: high buffer wait ratio
"Andrew Hamm" <ahamm@mail.com> wrote in message news:c6276a$7263f$1@ID-79573.news.uni-berlin.de... > miyaki wrote: > > Hi David, > > > > Here's partial of the onstat -g spi output, sorted by > > the number of loops. > > > that's not quite sorted properly - try > > onstat -g s…
Re: high buffer wait ratio
miyaki wrote: > Hi David, > > Here's partial of the onstat -g spi output, sorted by > the number of loops. that's not quite sorted properly - try onstat -g spi | sort -n and it should come out numerically sorted...…
Do I need more KIO's
You've got virutally no buffers, only 6000. Without knowing how much memory you have in the box I look at running this to 50000, or even 100000 and see what happens I'd set the tapeblk to 1024 instead of 16 Do you really want your logs to be thrown way? ltapedev = /dev/null I'd…
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…
Virtual Processors and CPU-Load
Your onstat -p output suggest that application tuning is required... 1. read v/s write/rewrite. Reads are 1.2 billion while writes & rewrites total under 0.5 million. Unless this is a DSS system, that's way out of whack. 2. seqscans. Again, in the perspective of the writes & re…
Re: Excess V-segment allocation - who's responsible?
onstat -g mem will give you the session (first column) along with the address that can be related to onstat -g seg malc_p@btinternet. com (Malc P) To: informix-list@iiug.org Sent by: cc:…
Re: buffers used
On Mon, 01 Mar 2004 11:12:14 -0500, tomL wrote: > hello all, > > how can i find out what is the actual percentage of buffers being used at > any given moment? Used or active? Onstat -b will display all used buffer headers, onstat -P will show a summary report of the types and …
Shared memory and SELECT-Performance
Hi all, IDS 9.4 UC3 / RH 9 I have a performance-question: The quality of our application depends strongly on the execution-time of one single SQL-Select-Statement. Of course, the parameters in it's Where-Clause are different from time to time and from user to user, but we can u…
Can someone provide link for Informix techinfo on IBM site
Can someone provide link for Informix techinfo on IBM site…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
IBM Informix ODBC driver
I'm looking for IBM Informix ODBC driver for windows. There are two different package available out there: CSDK.2.81.TC1.WIN.zip CSDK.2.81.TC2.zip (they even have the same release date) What's the difference between them ? Which one should I use ? Thanks a lot!…
Re: DiskRead-Cache always 0.00%
Manuela Biel wrote: > Hi, > > since a few days without any revelant changes in the informix-configuration, > out Disk-Read-Cache is always zero. > > Example: (onstat -p) > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 803475051 834961363 238…
Re: Open tables and onstat -g opn
Try http://www.oninit.com/onstat/onstat.php?page=gopn Andy Kent wrote: > > Is onstat -g opn documented anywhere? I can't see it in any of the > manuals I have. Anyone got any info? Any Tech Docs? > > Also where would I look to get the same info out of sysmaster? > > Andy …
Open tables and onstat -g opn
Is onstat -g opn documented anywhere? I can't see it in any of the manuals I have. Anyone got any info? Any Tech Docs? Also where would I look to get the same info out of sysmaster? Andy…
Shared memory problem
Platform : Win2000 / IDS 9.30.TC3 I get the following error when increasing the buffers. shmat [ENOMEM] [12]: out of available data space, check system MAXMEM shmdt: errno 22 mt_shm_init : can't create virtual segment. The server has 2 Gig of physical memory of which approx. 9…
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
Shared memory problem???
Environment: RH Linux 7.1 Kernel 2.4.10-ac11 Informix IDS 9.21.UC4 Dual x86 Processor 1.5 GB Memory 8 temp dbspaces, 256MB each 100 full time users during the day My Informix shared memory parameters are as follows: LOCKS 2000 # Maximum number of locks BUFFERS 180000 # Maximum …
Re: Shared memory. Error.
Hi. Make sure your permission of onstat and oninit like this. % ls -l $INFORMIXDIR/bin/onstat -rwxr-sr-x 1 informix informix % ls -l $INFORMIXDIR/bin/oninit -rwsr-sr-- 1 root informix I think oninit has wrong permisson. Regards. -- Tsutomu Ogiwara from Tokyo Japan. I…
RE: Shared memory. Error.
It looks like You are on Linux You can try to verify whether 'raw10' points to the correct block device: 'raw -q dev/raw/raw10' ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: inf [mailto:inf@terr.es]…
Re: Shared memory. Error.
Hi, Paul As you can see, the file /dev/raw/raw10 has the correct permissions: 0 crw-rw---- 1 informix informix 162, 10 ago 31 2002 raw10 but the error appears... Any suggestion ? "inf" <inf@terr.es> escribi� en el mensaje news:bor348$fgf$1@nsnmpen2-gest.nuria.telefonica…
Re: max number of connections
On Tue, 11 Nov 2003 12:42:00 -0500, Micha wrote: <SNIP>> We use both ontlitcp for remote connections and onipcshm for local > connections. NETTYPE is not defined in onconfig. How can nettype limit the > number of shared memory connections? AFAICT, the remote connections actually…
RE: Shared memory. Error.
You only can tell, that a link to a file has correct permissions, not a file itself Please, make 'ls -l /dev/raw/raw10' ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: inf [mailto:inf@terr.es] > Sent: …
Shared memory. Error.
Hi, - When starting informix the following error appears: 12:52:14 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 12:52:14 Physical Recovery Started. 12:52:14 The chunk '/home/informix/dbs/tempdbs' must have owner-ID "informix" a nd group-ID "root". 1…
moving the physical log
According to the IDS 9.4 docs, I can move the physical log like this: set IFX=D:\\IFMXDATA\\ol_bronco copy nul D:\\IFMXDATA\\ol_bronco\\physpace.001 onspaces -c -d physpace1 -p %IFX%\\physpace.001 -o 0 -s 8192 onparams -p -s 8192 -d physpace1 -y ontape -s -L 0 The IDS bitches o…
Informix customer support outside U.S
Hi Does IBM stopped supporting informix in middle east, since they have closed down informix middle east, customer support never heard of informix when contacted at IBM M.E. Regards…
RE: onstat -g iof
Hi onstat -g iof will give u disk I/O statistics HITEN -----Original Message----- From: Vaclav.Boura@cpp.cz [mailto:Vaclav.Boura@cpp.cz] Sent: Tuesday, September 30, 2003 4:22 PM To: informix-list@iiug.org Subject: onstat -g iof Hello all, when I perform onstat -g iof I see 8…
RE: onstat -g iof
Hi onstat -g iof will give u disk I/O statistics HITEN -----Original Message----- From: Vaclav.Boura@cpp.cz [mailto:Vaclav.Boura@cpp.cz] Sent: Tuesday, September 30, 2003 4:22 PM To: informix-list@iiug.org Subject: onstat -g iof Hello all, when I perform onstat -g iof I see 8…
Re: Fw: Company thought DB2 will be better than Oracle.
> Perhaps the biggest mistake Informix made was not hiring Mark There's a rumour that Informix (and now IBM) are actually paying my salary at Oracle.…
Customers ARE staying with IBM Informix
ALL: I can positively assert that according to a blind independent study of a statistically significant group of customers and business partners around the world, they are surely NOT migrating away from Informix in droves. In fact, 80% of respondents, in this survey which has …
Re: Problems with Shared Memory
U r limited to 50 connections in all ... if you are using SHM connections ... are the users spawning more than one connection to the engine when they run the program ... I would suggest increasing the number of connections to say 100 to see if it works or not ... onstat -g ses a…
RE: Problems with Shared Memory
Yes, -25588. $ finderr -25588 -25588 The appl process cannot connect to the database server server-name. But it's not true because some users are connected to. No ISAM-Error associated. TIA. -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-li…
RE: Problems with Shared Memory
4 -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]En nombre de Obnoxio The Clown Enviado el: viernes 12 de septiembre de 2003 14:46 Para: informix-list@iiug.org Asunto: Re: Problems with Shared Memory Diego Morales wrote: > > >…
Problems with Shared Memory
I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok changing them to tcp... but they are running a 4gl app and I want them throw INFORMIXSERVER shm. I check the sqlhosts and NETTYPE and I t…
[HELP] What my Informix is doing?
On 11 Sep 2003 02:54:04 -0700, steven@steven4u.net (steven) wrote: >My system is SCO OSR5 + Informix Online 7.x with 128M ram. The >database is created w/o loging. > >Is any method here let me know what the Informix is doing? > Try with some "onstats": onstat -p onstat -u ons…
Re: onstat says shared mem not init'd
I found out that the onstat works only for the administrator of the system. perhaps the user is not a member of the informix-group hth danny "Bill Hamilton" <bham@finsco.com> wrote in message news:bi5btk$1rh$1@terabinaries.xmission.com... > > GlacierWe recently installed IDS 7.…
not initializing shared memory
mt_shm_remove: WARNING: may not have removed all/correct segments what do you do about that?…
IBM TO WINDOWS INFORMIX MIGRATION
Hello all. We are currently running the following on an IBM AIX box: ESQL/C 7.24.UC7 4GL RDS 7.20.UD6 4GL 7.20.UD6 SQL 7.20.UD6 SE 7.24.UC1 and need to port over to a WINDOWS 2000 box. Would anyone with information, experiences, and recommendations email me. Thanks. <<Sm…
Re: Informix profiling / debugging - speed of sql statements ?
onstat -g sql SESSID -r 1 >> file; tail -f file or tail -f file|grep expression ... worked for me to debug (and profile) informix. tnx for having helped. I have still several problems: cannot access shared memory after having edited onconfig by hand with joe or vi. I did a ki…
Shared memory: permission denied.
Hi all, Informix Dynamic Server Version 9.40.FC1 I receice the error Shared memory: permission denied when I run onstat - and this is the output of ipcs Message Queues: T ID KEY MODE OWNER GROUP q 0 0x4190051c --rw------- root system Sh…
Informix profiling / debugging - speed of sql statements ?
"Guido Stepken" <g.stepken@t-online.de> wrote in message news:beonn4$dtp$01$1@news.t-online.com... > Hi out there ! > > After my bad experiences with informix on linux (no KAIO, SMP not > runnning with 9.30) i tried to improve speed on a complex database > . > onstat -u shows all…
PAM & Informix Article @ IBM
The IBM site now has a nice article on PAM & IDS. Looks like something finally happened on this front. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0306mathur/0306mathur.html#section3 sending to informix-list…
Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1
Thanks for all of your help. I lowered the amount of initialy reqquested shared memory and things seem to be working fine. Thanks, John M…
virtual shared memory segment
hello, this is our output from onstat -g seg : Segment Summary: id key addr size ovhd class blkused blkfree 7680 1381386241 80000000 592850944 245712 R* 144714 25 (shared) 1381386241 a3563000 201334784 6760 V 49154 0 46597 13…
deadlock
I am running IDS version 9.21.HC4XM on HP_UX B.11.00 Based on onstat -p, there were 2 deadlocks detected: bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 4922980 3521 946949636 2 0 528 231735 368007 I want to find out more about these deadlocks. Does Infor…
IBM Informix IDS Benchmarking.
Hi, So what's the story with IBM and TCO. I know the whole game is a silly PC vs. MAC contest and that its all about what works for you but.... There seems to be a push on for DB2 benchmarks from recent review of tpc.org although SQL Server seems to just beat the posted mark 10…
RE: "Slow System" Problem
you check te output from onstat -m? see the checkpoint duration o some other info in the .log file. (longs tx, etc.) -----Mensaje original----- De: Zev Berezin [mailto:zevb@bhphotovideo.com] Enviado el: Mi�rcoles, 14 de Mayo de 2003 12:20 p.m. Para: informix-list@iiug.org Asunto…
Re. Shared Memory Parameters
Hi Everyone, Which file needs to be changed on AIX 5.1(9.3 UC3) for memory parameters, is it "/etc/system" but it does not exist on unix box. SHMTOTAL is set to 0 in ONCONFIG, but the total memeory does not exceed 2GB although we have 4GB of ram, could not find any info. Any id…
Question about ODBC connections.
Hello, Informix 9.3 ODBC Driver 3.34 or 3.80 Platform Solaris 8 Have a question about being able to monitor the ODBC connections made to a Sun Server running Informix DB 9.3 or at least validate the connections are proper. In an MTS/XA environment where the transaction is dep…
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…
FW: Numbers of Locks
You can try - a) onstat -k (which also shows the owner of the lock, which can be traced to onstat -u) b) database sysmaster; select * from syslocks HTH Dirk -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On…
Numbers of Locks
Tham Huei Hwan wrote in message <96a5b7$h0c$1@news.xmission.com>... > >How to find out how many locks is hold by particular users / process ? > onstat -u has a column for number of locks, but it's a summary of the different types. onstat -k gives you more detail. You have to "j…
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 …
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
Oops - final thought - it may take a while for the onmode -z to work. If the process has done a lot of work to get to where it is, then it may take a long time for the implied rollback to take effect. So don't panic if it doesn't disappear immediately. There will be flags in the …
EMERGENCY: Logs attached
EMERGENCY: I have a down system. I am trying to to a cold restore using command "ontape -r". The command keeps failing after prompting to back up the logs. The only error message which appears on the screen is : "oninit: Fatal error in shared memory creation". Additional error me…
Re: aio vps confusion
... and in any case shouldn't he be using kaio? > >HPUX 10.20 > >HP K200 dual processor 512Mb RAM 6 disks no raid ;o( > > > >onstat -g iov > > > >Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 58 days…
linux kernel 2.4 + informix
HI ? I must setting Linux and IIF200 on DELL PowerEdge 6400 server . that server has 6Gbyes main memory, 120Gbyes hard disk. first i have install Redhat 6.2 official. and i have upgraded kernel 2.4 from kernel 2.2.16 . ( because for awaring 6Gbyes main memory at Linux) l…
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 …
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. …
Shared Memory
Hi all, I need help on how to identify what process and users trying to allocate more shared memory segments (onstat -g seg) ? and how to releases this memory segment (virtual portion) ? TQ…
Lock
Hi DBAs, How will I get a list of locks pertaining to one database in a database server? Onstat -u will give me a list of all the session with a coloumn "lock" . But this will give me only the system wide locks used. I want it perticularly for one database in a database server. …
Linux performance
John, are you using Linux RAID? It beats hell out of the CPUS! Faster than a speeding bullet but it gets that speed by sucking up all the CPU cycles it can get. Linux built in software RAID is only really good for configuring a dedicated fileserver not for any machine that nee…
Re: location of logs
oncheck -pe From: rsalido@my-deja.com > >Is there a way to find out where my logs are? I mean onstat -l gives me >a bunch of information regarding the logs but I dont think it shows in >which dbspace they reside in.....any ideas? > I just started working on this database and …
location of logs
Is there a way to find out where my logs are? I mean onstat -l gives me a bunch of information regarding the logs but I dont think it shows in which dbspace they reside in.....any ideas? I just started working on this database and I'd like to know if the logs physical and logi…
SHMAT error
Oncheck allocates a shared memory segment for sorting memory. If your kernel's shared memory parameters are too small you can get that error. Art S. Kagel "Sinha, Niraj" wrote: > > Folks, > I get following error while running oncheck comand. > I knwo that it is UNIXsystem erro…
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 …
use the output of onstat -o
hi all, I have a copy for the output of onstat -o taking from informix 7.31 under UH-UX 10.20. in this system the size of a page is 2k. Now I try to use this output with my informix 7.30 under AIX 4.3 (in this system the size of the page is 4k). I get the following message : Erro…
Replication conflicting with constraints
Madison Pruet wrote in message <3A077092.3172587E@informix.com>... >one of the engineers to figure out what the problem is by using onstat -g >cat. > onstat -g cat is not listed as a valid option when you run onstat -- I've found onstat -g cdr by guessing.. What other 'hidden'…
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…
lock waitors entry in syslocks
Dhanesh K Veedu wrote: > I have three sessions. > > Session1: Locked a table TEST in exclusive mode ( Got the lock and > being locked ) > > Session2: Trying to lock table TEST in exclusive mode with lock > mode wait to ???? ) in wait state > > Session3: …
Re:Informix on IBM SAN?
That is true. DBA job made simple. SAN and NAS are meant for these. They have huge cache built into them so that always you write to the cache. You dont have to worry about which physical fragmentation. You just have to worry about logical fragmentation. Bottleneck is your ne…
RE: Informix on IBM SAN?
I know Informix does support them and these are usually NFS mounts, so raw devices are out of the question. -----Original Message----- From: Martin, Wayne E. [mailto:WMartin@kmart.com] Sent: Tuesday, October 03, 2000 10:37 AM To: 'd_weber@telocity.com'; informix-list@iiug.org Su…
RE: Informix on IBM SAN?
Hi Doug, I basically had the same issue a couple of months back. And if I had my way I would have stuck with using good'all raw devices. There is definitely overhead whenever you use SAN or for some vendors NAS (network attached storage). Primary of which is network traffice. Y…
RE: Informix on IBM SAN?
Does Informix support these devices as most installs use raw devices? Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: d_weber@telocity.com [mailto:d_weber@telocity.com] Sent: Monday, October 02, 2000 11:35 PM To: informix-list@iiug.o…
Re: Informix on IBM SAN?
From: d_weber@telocity.com (Doug Weber) > >Does anyone have experience running Informix (or any database, for >that matter) on the new IBM SAN (storage area network) equipment? My >company is proposing that we move our Informix database tables to SAN, >and I've got some concerns…
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…
Informix on IBM SAN?
Hello! Does anyone have experience running Informix (or any database, for that matter) on the new IBM SAN (storage area network) equipment? My company is proposing that we move our Informix database tables to SAN, and I've got some concerns. Seeing as these new devices abstrac…
logical logs
onstat -u and look for the session(s) with lots of writes. Art S. Kagel Aboobacker V V wrote: > > Hi all, > > How to find out which session causing the logical logs to fill up. > > Regards > > Aboo…
RE: Why is rootdbs busy?
Have you moved your logical logs and physical log into different dbspaces? If not, that will explain high I/O activity in rootdbs. -----Original Message----- From: B. Dana [mailto:bgdana@hotmail.com] Sent: Tuesday, August 29, 2000 16:13 To: informix-list@iiug.org Subject: Why i…
RE: Informix for IBM S/390
--- kirk.waterhouse@cibavision.Novartis.com > wrote: >Why don't you re-read the whole thing from the beginning. I did. >I was describing one of the possible ways, method 3 in the list, to run >Informix on Linux on a S/390 mainframe - as I understood it - not every >possible inc…
RE: Informix for IBM S/390
From: kirk.waterhouse@cibavision.Novartis.com > >Why don't you re-read the whole thing from the beginning. No thanks, I'm bored with it. >I was describing one of the possible ways, method 3 in the list, to run >Informix on Linux on a S/390 mainframe - as I understood it - not e…
RE: Informix for IBM S/390
Why don't you re-read the whole thing from the beginning. I was describing one of the possible ways, method 3 in the list, to run Informix on Linux on a S/390 mainframe - as I understood it - not every possible incantation of mainframe configurations. I am a UNIX guy and I was …
RE: Informix for IBM S/390
--- kirk.waterhouse@cibavision.Novartis.com > wrote: >I don't know that much about the S/390. Just what I read on IBM's web site >about them running 41,000 instances of Linux on a single box - Just >because they could. > >It simply seems to be a lot of layers between Informix a…
RE: Informix for IBM S/390
I don't know that much about the S/390. Just what I read on IBM's web site about them running 41,000 instances of Linux on a single box - Just because they could. It simply seems to be a lot of layers between Informix and the metal if you run it in the mode I described - and I…
Regading to io/wup
"Manel Falcó i Aige" wrote: > > Where you saw anything about the chunk #5 ?? > by onstat -g iov ? -> gfd 5 0 167 751870 743427 8443 0 The onstat -g ioq you posted. Also look at onstat -D & onstat -g iof. > I know, I know the more machine the better ... ;o) > but…
Re: Informix for IBM S/390
From: mbeattie@sable.ox.ac.uk (Malcolm Beattie) > >It might be interesting if Informix was the next out since >they were one of the first vendors to take Linux/Intel seriously. This must be a new meaning of "to take seriously", of which I was not previously aware.... (Interesti…
RE: Informix for IBM S/390
Since IBM released Linux for the S/390, maybe you can run Informix for Linux =:-) A database running on a operating system running on a virtual machine running on an operating system running on a mainframe. The performance would have to be phenomenal. Kirk > -----Original Messa…
Re: Informix for IBM S/390
From: "AM" <amatus@poznan.uw.gov.pl> > >My question is: >what Informix products are currently available for use with db management >systems running on IBM S/390 and what dbms would be of best use for those >products? I don't think *any* Informix products run on an S/390, except …
Informix for IBM S/390
My question is: what Informix products are currently available for use with db management systems running on IBM S/390 and what dbms would be of best use for those products? Best regards, Alicja Matusiak…
About AIOs vp ...
"Manel Falcó i Aige" wrote: > > Hi, > Do the AIOs vp lunch treaths as CPUs vp do ? > According to onstat -g ath, #AIOs threaths seem to be equal to #AIOs > vp. I'm not sure of your question but let's give it a stab. If you are running KAIO turned on then there is exactly one …
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
SCO IPC
OK - I've RTFMed, but still in need of help. I am running SCO Unix 5.0.{245}, with Informix IDS.2000 Dynamic Server. Trying to initialize shared memory does not appear to work. The system utility "ipcs" does not report any shared memory being allocated, and the oninit -i seems…
is there a Trace Utility in informix? (newbie)
Daniel, 3 possible tools : 1) from UNIX shell onstat -u onstat -g sql session_id onstat -g ses session_id 2) I-Spy 3) (if you have X Windows installed) oncockpit/onperf Best regards, Sergey <daniel30@my-deja.com> wrote in message news:8kk8q9$6os$1@nnrp1.deja.co…
Fatal error in shared memory creation
When I type oninit, it said: Fatal error in shared memory creation Why ? Thanks…
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…
Shared Memory segment (5 of them)
Hi gurus, Recently, I noticed 5 extra shared memory segments created in my Informix 7.30 UC7. What could have caused this and how to remove/prevent these segments from created again? AFAIK, more shared memory segments means less efficient shared memory usage. Am I right? Thank …
problem with onstat -p "pagreads" value decrementing
Hi, Has anyone noticed a problem with the pagreads stat in onstat -p being decremented in what looks like a random way? I parse the output of onstat -p regularly and store the output into a csv file. I've noticed that after an unpredictable amount of time the value gets decrem…
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…
Re: Top Databases Used
"Art S. Kagel" wrote: > > DNP wrote: > > > > I feel sorry for you actually. > > > > I was told once that when people end up insulting you personally, it > > generally means that you've won the argument and the other person has > > nothing more left to say. > > > > Leaving that to…
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…
Re: oninit -v
From: "Stefansson" <bs@rhi.hi.is> > >oninit -v >returns an error: >Allocating and attaching to shared memory...FAILED >onint: Fatal error in shared memory creation > >What can be causing this and what could be able to solve this problem ? It could be something holding on to shar…
oninit -v
oninit -v returns an error: Allocating and attaching to shared memory...FAILED onint: Fatal error in shared memory creation What can be causing this and what could be able to solve this problem ? Thanks. B. Stefansson…
Problems with RedHat Linux 6.0 and IDS 7.30
Hi, I'm novice in Linux and after installing the IDS 7.30 on a RedHat 6.0 machine when the IDS try to create the shared memory i got a list with messgaes like this: dupfd: fd 1025 max 1024 finally i got the message: error on shared memory creation. Where I can find information …
Posting from the Informix-list
onstat -g ntd Nona…
onstat -k and tblsnum?
Folks, Need some help. An application is experiencing locking problems, and 243 errors. How can I find out which table belongs in tblsnum. Part of the output of onstat -k reports on tblsnum, I want to determine which table in which database is in trouble. Querying syslocks r…
Informix in the news
So anybody know what exactly IBM is accusing Informix of doing. Will…
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. …
Re: Onbar
> > The problem with using onstat is that it will always return all logs as > full. No. It returns only the full logs if you grep them out. The flags on the output of 'onstat -l' mark the full logs, in our version (7.2 & 7.3) they look 'U--'. It is a very simple solution. It can…
RE: tuning log buffers
This is described in the Performance Tuning Guide in detail. (I cannot locate ours at present). The top of onstat -l gives information on the use of the physical and logical buffers - namely the number o writes per I/O versus Buffer size. The guides, I recall, suggests aiming th…
network down error
We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get around 100 users connected new users cannot connect to the database. Onmonitor gives the error "Network Down". When you check shared memory with onstat it says that shared memory is not initialized but when yo…
RE: accessing shared memory
Hi John, You need to change permissions to shared mode (s) for necessary executables in $INFORMIXDIR/bin directory. thanks Ravi Yarlagadda Informix Certified Professional -----Original Message----- From: John Horton [mailto:john.horton@cognito.co.uk] Sent: Tuesday, December 14…
accessing shared memory
Hi How do I set up a user so that they can access shared memory (ie. they can use the onstat - command) . Currently only root can access shared memory (not even informix can access shared memory or use the onstat - command) I have tried stting up the group so that informix is a …
tuning question
In looking at some performance tuning notes I noticed something that said "Increment the onconfig variable LRUS by 2 until the onstat -R percentage is below 60%." After examining the output and documentation for onstat -R I can't figure out what they were talking about and why y…
Tracking conditions
If a thread is waiting for a resource which is a "condition", is it possible to find out what that condition is? informix@Lawson $ onstat -u | grep robink e2bdf798 Y--P--- 55397 robink - e62c2608 0 1 101 0 informix@Lawson $ onstat -g con | grep e62c2608 …
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.…
shared memory
Beim Start mit oninit erscheint folgende Fehlermeldung 21:00:20 shmget: [EEXIST][17]: key 52564801: shared memory already exists 21:00:20 mt_shm_init: can't create resident segment Was fehlt noch bei der Einstellung ? Wer kann mir helfen…
Help! Locks
Informix Gurus: I am trying to drop a database and I am getting an error because someone has a lock on a table or a session is just open within this database. I've tried using onstat -g sql and onstat -u to track down the lock, but no luck! I also tried selecting from syslocks i…
RE: Fatal error in shared memory creation
Check the release notes for SHMBASE parameter value. Try to start Informix with SHMBASE value 0 -----Original Message----- From: Jerome BARRET [SMTP:jejgphy@hotmail.com] Sent: 06 ������, 1999 06:43 � To: informix-list@iiug.org Subject: Fatal error in shared memory creation…
Fatal error in shared memory creation
When I want to startup for the first time, in the oninit program, this message appears : "Fatal error in shared memory creation". In the part shared memory parameter, the parameter are the default parameters. Thank you for your help…
Dynamically allocated new shared memory segment ???!!!
Dear ALL : Our system appear the following messages in seconds : 09:11:02 dynamically allocated new shared memory segment (size 8388608) 09:11:30 dynamically allocated new shared memory segment (size 8388608) 09:11:50 dynamically allocated new shared memory segment (size 8…
Shared memory limits in 64-bit environment
Is there any practical shared memory limits in HP/UX 11 (N-serie) with 64-bit Informix ?. -Jukka…
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: …
Loading into Shared Memory...
Hi, Can i explicitly ask Informix to load a table into Shared-Memory? And then later on sync the copy of table on disk \\ with the one in shared memory? Any suggetions welcome Thanks Anand Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.…
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…
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é…
7.31 upgrade problems
Thanks for all of the tips. The `onstat -g iof` showed that the vast majority of I/O was occurring on the dbspace that contained all of the tables (~33 IO/sec). The dbspace that came in second was the index dbspace (5 IO/sec). The NUMAIOVPS was also set to 2, so that was not h…
locks and lockreqs
Running 7.2 with 250 users. Very I/O intensive application. Locks are currently at 400,000, any thoughts?. Also when running onstat what does the lockreqs number represent? It is a very large number. Thanks Sent via Deja.com http://www.deja.com/ Share what you know. Learn wh…
SCO: shared memory problem...
Hello, I am having a problem that, hopefully, one of you have had before, or have heard about before. There box is a PII system with 128MB RAM running SCO OpenServer 5.0.5 with the latest patches. The error oninit -v gives: oninit: Fatal error in shared memory creation The er…
error while creating online instance
While creating a new online instance using "oninit -ivy", this is the following error message that we get. Creating infos file "/usr/informix/etc/.infos.kil_serv3" ... succeeded Writing to infos file ... succeeded oninit: Fatal error in shared memory creation We have created in…
Usage of INFORMIXSHMBASE
It replaces, or supplants, the SHMBASE ONCONFIG file parameter's value. It is the preferred attached address for shared memory if you are using a shared memory connection. Art S. Kagel Wu wrote: > > What's the usage of this environment variable -> INFORMIXSHMBASE ? > > thanx…
RE: onstat -d showing PD and MD Flags
Unlikely to be a false reading, but .. Are there tables in those chunks? Can you access those tables? You can try to bring them up with onspaces aka onspaces -s dbspacename -p chunkpath -o chunkoffset -O -y Murray Wood -----Original Message----- From: Robert Moayedzadeh …
Performance Problem
In article <7ju9ts$7uo$1@news6.svr.pol.co.uk>, Callum <callum@online- home.freeserve.co.uk> writes >I am running IDS version 7.24 UC6-1 on a dual processor RS/6000 (AIX 4.2) >with 512M of memory, the only thing running on the system is Informix. The >problem I have is that the p…
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 ___________________________…
Re: running out of Unix Shared memory segments
You may want to check how many shared memory segments are allocated to Informix and other programs; use the unix command "ipcs". If you normally have many Informix segments you could change the onconfig file parameters for SHMADD and the initial shared memory parameter to increa…
Shared Memory on Linux
How do I configure Redhat Linux to get rid of the Shared Memory Error when I try to start Informix (IDS 7.3)? Thanks. Aris…
how to caculate resident shared memory size?
hi,all could you tell me how to caculate resident shared memory size? thank you.…
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: Memory Usage on Informix 7.24
Hi Lee, What onstat commands are you running? I think you might be trying to mix apples and oranges here. We are using Sun (2.5.1) as our OS and Informix 7.24UC3. I don't know anything about NEC machines. Output from the Sun ps command can show you the size of a process=20 …
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
Cleaners
Please forgive me if this is posted twice ----------------- Online 7.24UC3 Solaris 2.5.1 Given that Cleaners are assigned to chunks in the order that the chunks are created (and I don't know the order) how can I determine which cleaner from onstat -F) is assined to which chunk? …
Informix Online on IBM Netfinity
Hi, we want to buy an IBM Netfinity 5500 M20 (2 PIII Xeon) and run Online 5.02.UC6 on it under SCO-UNIX 3.2v5.0.5. Has anybody run this constellation? I've read in this Forum about troubles with Informix and RAID. Is it so? Any warnings, considerations and/or comments a great…
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…
How can I list the databases of an instance from Unix prompt
I have tried the onstat command and it did not work. It will only list the active databases (three out of nine databases) on one of our IDS servers. I thought that <onstat -g dic> command is used to print dictionary cache information. Regards, Fred Lee fredlee@acm.org Howard wr…
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 …
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…
HP, KAIO and statistics. What's wrong ?
Eugene Nechayev wrote: > > Hi Informixers > > Ive crossed with a strange problem. > > HP-UX B.10.20 with all recommended Informix patches, > IDS 7.30 UC6 [SNIP] > > The question is what do other kio vp's DO ? > Why do I have only one kio vp that works in the system ? > > Is k…
How to find and remove exclusive lock on table or row
Hi , I've been trying to find out how to locate information on exclusive lock (is onstat -k enough) and disable it besides shutting down the IUS server. Thanks, Aik Khoon…
Shared Memory
I have a question about the shared memory segments Informix adds dynamically in version 7.x. I use onmode -F to free the unused shared memory but this seems to only ever free up one segment regardless of how much is unused. Has anybody used this to free more than one segme…
Performance tuning
Does anyone know of a simple way of getting specific information about jobs that are currently running against Informix? I'm looking for something besides onstat (i.e. querying sysmaster,) that will show me the specific sql statements being executed, and something like an sqexpla…
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 error.
Does anyone know what this error is about: shmat: [EINVAL][22]: shared memory base address illegal Thanks, Fred Lee…
Informix & IBM Data Joiner
Hi all, Does anybody use Informix DS and IBM Data Joiner If the answer positive what are the pluses and mineses Thanks ahead, Alex ---------------- TERN Technical Support mailto:alexs@tern.ru…
Re: Informix DS 7.24 Missing DBspace/chunk
Jim Will wrote: > > When I try to create a DBspace by running the following command: > onspaces -c -d ccbdbs1 -p /opt/informix/dev/chk25a -o 0 -s 250000 > The following message is returned: > The chunk specified already exists. > > So then I try to drop the chunk with the…
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…
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 -- -------------------------------------------------------------------------…
Re: Monitoring lock tables
Leonid Vorontsov wrote: > June Tong wrote: > ... > > lk_type: type of lock > ... > > I didn't bother figuring out what the numeric lock_type means, but surely > > that should be easy. > > Sorry. Explain please. What I meant was, that I presumed that, given the SQL statement,…
Shared Memory ??
--------------F10AFCC198D69640B04B5FAB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! I just installed the Informix OnLine Workgroup Server 7.20 in Sun Sparc 5 with solaris 2.5.1, but when I try to run some utilities (e.g. onspaces, oninit) it…
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…
monitor tables - how to ?
Hi, How to find out how a table is spread out across a chunk in a dbspace ? 1) If the dbspace has one chunk in it but many tables ? 2) If there are more than one chunks in the dbspace ? The onstat -t output shows only one entry for a tablespace and the address it shows is the s…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: Problem with "Changing data structure forced command termination"
PabloF@my-dejanews.com wrote: > > Hi All, > Anyone out there knows why i can read sometimes the message > "Changing data structure forced command termination." > when i execute "onstat -g ses" ? > I think there's a problem with a ODBC connection. OK definitive answer. Remember…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
Re: 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…
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: dbservername/dbserveraliases/nettype
"Scott Kolaya" <skolay1@nycap.rr.com> offerred: +>BTW be careful to not use the same port for shared memory and tcp in +>the sqlhosts on the server > +>Art S. Kagel +We've been using the same port for shared memory and tcp for a year now in +production. Yes, shared memory connec…
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…
shared memory
This is a multi-part message in MIME format. --------------F12A58D21005157C74BAD832 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hello; how do i go about initalizing shared memory for informix 7.2 on a sun? --------------F12A58D21005157C74BAD8…
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 …
Re: Informix 7.22 Online under AIX 4.1 ERRORS !!!!!
>> shmat: [EINVAL][22]:shared memory base adress illegal >> using 0xd0000000, needs 0xffffffff >> >From onconfig : >SHMBASE 0x30000000 c Shared memory base address PMFJI, but isn't this the important one? The machine specific release notes detail the correct share…
Re: LRU Parameters
Also sprach "Scott Kolaya" <skolaya1@nycap.rr.com> : :Values of: : :LRU_MAX_DIRTY 3 :LRU_MIN_DIRTY 2 : :are commonly used for OLTP processing to decrease the length of a :checkpoint. How long are your checkpoints taking? They should be very :short with those values, …
Re: DB 7.21 (HP-UX 10.20) hangs while backup
if RESIDENT is set to 1 the shared memory used by informix will not be swapped to disk by UNIX if UNIX needs more memory. It's generally not a good idea to set to 1 if you're having problems or you're limited on memory. Scott Kolaya…
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 …
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??…
Re: chunk down
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 on HP 10.20 > > Two chunks have been down as PD from the onstat -d information. > How can I fix them to bring up as PO? Assuming that the problem that caused them to be marked down has been corrected, you can use: onspaces -s …
online workgroup server 7.22 on NT Server CLI probs
I'm running online workgroup server 7.22 on NT server 4 with service pack 3. I cant however get ilogin to work. I get the 406 error. Do I need to do anthing with shared memory before this will work? How does shared memory work with NT? email to ag@roninsrv.demon.co.uk Thanks, …
-123 ISAM error : no shared memory ... TOP URGENT !!!!!
How to solve Shared Memory can't attach error in AIX 3.X ... Error Message was appeared after run dbaccess ... -529 Cannot attach to shared memory -123 ISAM error : no shared memory. Please send me a solution : brianip@magician.com.hk…
can't attach shared memory , TOP URGENT !!!
How to solve Shared Memory can't attach error in AIX 3.X ... Error Message was appeared after run dbaccess ... -529 Cannot attach to shared memory -123 ISAM error : no shared memory.…
onstat counter size
Could anyone tell me at what value the onstat counters wrap. I am particularly interested in the following: onsta -D page I/O for chunks onstat -g iof disk I/O for chunks onstat -p server profile (I/O, ISAM, CPU) onstat -g glo virtual processes From observation…
Re: Changing data structure forced command termination.
Jacob Salomon wrote: > Huh? > Hi Family. > I ran onstat -u and got some lines of output - all the daemons and the > first bunch of users in the sessions list. Suddenly the output ends, > way before it should, with the message: > Changing data structure forced command termin…
Re: KAIO vps, and bufwaits
In article <6bmtcu$jmi@drn.zippo.com>, Neil Truby <?@?.?> writes >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 t…
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: informix mirroring
Robert Higgins wrote: > i am having a problem with disk i/o - i am currently utilizing an ibm ssa > with 8 disk (4x4) with informix mirroring > when i run an iostat (aix) it shows my hardest hit drives are the ones that > are mirrored. i have hardly any hits on the regular disks…
Re: Who is blocking ?
Use onstat -k and look in the wtlist column to see who is waiting on a lock and look in the owner column to see who is holding a lock. Use onstat -u |grep wtlist_value to see who the waiting user is and onstat -u | grep owner_value to see who is holding the lock. Gerard Crocken…
Re: Who is blocking ?
I can tell you the solution for OnLine. Make a onstat -u and onstat -k. The one who has a L , at onstat -u at the first position on flags, is blocked. You have to take the "wait"-adress of this process and have too look at onstat -k at address. the owner-adress from this r…
Re: Slow checkpoints
The way with set explain on .... and so on is right to make the select statement quicker ( the math operation * 0.75 should better besolved in the frontend -> quicker ). But a checkpoint-duration is not a read-problem, its a write-problem. So check out onstat -dD and sum the rea…
Re: Another checkpoint situation
At checkpoint time one page cleaner is assigned to queue up the addresses of modified buffers to the global file descriptors for its assigned chunk. (This assumes that you are not using Kernel IO) It appears that all of your work between the check- point was for one chunk and th…
Re: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
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…
Re: memory
Thuc Nguyen wrote: > > Hi > > I am running Online 7.23 on HP 10.20 > > We want to find out why we allocate alot of memory per user and never > release it. > > Is that memory leak? Actually you are probably not allocating any memory "per user". If your default connection, or the…
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…
doubt in onstat -g -dic
I have gone through system administration manual to find out the detail column descpitions of onstat -g dic, specially 'refcnt'. I coundn't find any reference to 'refcnt'. Please mail me details of columns of onstat -g dic . thanks --VASA SRINIVASA ______________________________…
Re: OnLine Performance
In article <622aem$4h1@pepper.compnews.co.uk>, "Jon says... > >Q. can I tweak any of the onconfig parameters, also shown below, to increase >performance ? > >Q. is the buffwrits - cache% shown below to low ? I increased my buffers in >an attempt to bump it up, this worked jumpin…
Re[2]: Debugging Informix Online Crashes
I've had it work on HP. You should be able to do onstat -a shmem.xxxxx or any onstat command against the shmem file. I have. Dianne ______________________________ Reply Separator _________________________________ Subject: Re: Debugging Informix Online Crashes Author: satriguy…
Informix Online & IBM HACMP
Does anybody have any experience setting up Informix Online 7.x in an IBM HACMP environment? I am thinking about setting up a 2 node R/40 system to support a multi-database environment with about 3 to 4k users. Has anybody done this? Does it work? Is it as complex as IBM and …
Re: Informix Online 5.0 and Solaris 2.5
>"Shared memory not initailzed" does (necessarily) imply a problem with >the UNIX server's shared memory; This first line should have read ".... does not (necessarily imply a problem ...." Also, I've checked my release files and your shared memory settings seem fine. Neil Trub…
Re: memory
In article <5v76b7$pg0@cssun.mathcs.emory.edu>, Thuc Nguyen <thucn@email.utcourts.gov> writes >I looked at the log file of Online 7.23 running on HP 10.20 > >What does "dynamically allocated new shared memory segment" mean? >and how can I resolve that problem? > > >14:57:23 Chec…
memory
I looked at the log file of Online 7.23 running on HP 10.20 What does "dynamically allocated new shared memory segment" mean? and how can I resolve that problem? 14:57:23 Checkpoint Completed: duration was 2 seconds. 14:57:43 dynamically allocated new shared memory segment …
Re: Information about tables in use?!
Hi! I'd just add that there is an undocumented onstat option, -T, which does the same thing as -t, but list ALL that are cached, not only the active ones. I've found a use or two for this puppy. It's been around since 7.10.UD1 at least I think.... Rgds Karlsson Art S. Kagel…
Reply to SELECT too slow
Hi: 1:you should provide your sql statement in details,which maybe a simple select , a join,or subquery ,etc. In different case they will result in different performance. Also you should provide your table schema,index,and sqexplain. 2.I think three fector will affct your perf…
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…
Re: Shared Memory allocation error
<SNIP> > I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. > When I run a query on a view that joins many tables online begins > allocating additional shared memory until it hits an illegal address. <SNIP> > SHMVIRTSIZE 8000 # initial virtual…
Shared Memory allocation error
All: I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. When I run a query on a view that joins many tables online begins allocating additional shared memory until it hits an illegal address. At this time the query hangs but the engine stays up. If anyone c…
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: Tuning CPUVPS/AIOVPS
In article <32FFA371.749@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >On 7.11 if you run > >ONSTAT -G SCH > >What does the busy waits column mean? Is 0 a good number for AIO or CPU >VP's? >Does it mean that there are sufficent AIO or CPU vp's and nothing is >waiting or is…
Shared memory
My director told me that Digital dialed into our Unix box (AT&T running Informix 5.05) and saw that every sqlturbo is getting 5000 pages of memory. Does anyone know if this set in the tbconfig file? I can't find any information about this. If I can reduce this, it may benefit …
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 } >…
Shared Virtual Memory Question/Engine Shutdown
Our project site recently received a binary executable from a sister site which updated approximately 5000 stored procedures. The executable brought down the engine due to shared memory limitations. When looking at the data (onconfig, memory on machine, etc. as stated below), t…
Re: onstat
Steve Romankiw wrote: > > In onstat, what does "total" refer to. > > . > . > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 > 0 > 13 active, 128 total, 44 maximum concurrent > > Thanks. > > Steve Romankiw > Executive Risk Inc. From the Informix Administrat…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
RE: Table io rate
Hi All ! onstat -g iof is used to show chunk I/O activity, as the dbspace is not listed use onstat -d to find it as long as both are listed in the same order. This would show table i/o statistics if you specifically create only that table in that specified dbspace. Anoher meth…
RE: Table io rate
Sean Wong wrote: > Can somebody give me answers on following questions: > >1. How can I find out disk io, e.g. read/write access for a given table >2. How can I find out disk io, e.g. read/write access for a process Jon C. Vemo (jvemo@cyberspace.com) replied: ------------------…
Re: shmdt: errno = 22
Double check the shared memory parameters Informix suggests for 7.12 for your kernel. Good Luck, Arun…
SMI: VP level I/O stats - 7.2
I need to obtain VP level I/O statistics (like reads, writes, buffer reads, buffer writes, etc.) from 7.2 online via SMI. These pieces of information are avilable from onstat with -g iov and -g iob options. Tech support hasn't been a successful option so far! Any help or pointe…
SMI: VP level stats
I'm interested in getting VP level I/O statistics like reads, writes, buffer reads, and buffer writes. These are avilable via onstat with -g iob and -g iov, however I need to get at them via SMI.…
Re: HELP I'm in crisis
You need to avoid dynamic shared memory segments on HP at all costs. If your SHMVERTSIZE is 60000, I would suspect that would be enough. However, if your application is leaving a lot of open statements (i.e. not issueing a FREE on a prepared statement or CURSOR) then each user t…
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…
Shared memory
I guess i missed some previous discussion about shared memory problems. I'll appreciatesome info about the followinfg error message: "Cannot attach shared memmory" from the Rapid Developement System, Informix 4GL V4.10 under AIX. Ramiro Rela.…
Online 7.2 KAIO on HP-UX 10.10
Anyone successfully enabled Online 7.2 KAIO on HP-UX 10.10? I checked and re-checked all the $INFORMIXDIR/release/*/*/* stuff (KAIOON=1; HP asyncdsk driver installed). Online DSA works but all the onstat -g displays show all the I/O going through the AIO VPs. Informix tech sup…
initializing shared memory
We are runnning informix 4.1 on SCO OpenSever 5.02. When we run tbinit to initialize shared memory we get the following error: tbinit: shmat[EINVAL][22]: shared memory base address illegal using 0x80480000, needs 0x80000000 tbinit: fatal error in shared memory creation. Our…
Re: Shared Memory Not released
>Brian Li <cphdcbl@ted.cs.depaul.edu> wrote in article ><511nel$aft@shrike.depaul.edu>... >> >> Dear Informix experts, >> >> We are currently have Informix Dynamic Online running on our HP T500 >machine >> and recently have shared memory problem which is only known to be solved …
>1 Virtual Shared Memory Segment slow down
I've been told by Informix that having >1 virtual shared memory segment slows down your Informix Online Database server. Informix normally has 3 share memory segments 1 Fixed size 'Resident' shared memory segment for disk cache etc. 1 Fixed size 'Message' shared…
SHARED MEMORY
Hi All When doing kernel performance tuning for a Informix 5.0 system with 512MB memory and 50GB disk, should the the shared memory be included into the kernel parameter tuning or excluded. Watching the memory use with 'cpqmon' it appears that these calculations should be done …
SHARED MEMORY
Hi All When doing kernel performance tuning for a Informix 5.0 system with 512MB memory and 50GB disk, should the the shared memory be included into the kernel parameter tuning or excluded. Watching the memory use with 'cpqmon' it appears that these calculations should be done …
Re: SHARED MEMORY
At 12:36 PM 6/19/96 -0700, Paul Middleton wrote: >When doing kernel performance tuning for a Informix 5.0 system with 512MB >memory and 50GB disk, should the the shared memory be included into the >kernel parameter tuning or excluded. > >Watching the memory use with 'cpqmon' it a…
Online v7.11 onstat -g ?
Dear all, Whilst trying to figure out why a particular installation is slow, I have been using amongst other things the onstat utility. But, I can not locate an explanation to the headings in the <onstat -g all> print out. the manual only seem to name the various options rathe…
Informix-4GL and Informix-CGI
is there any one using Informix-4gl with Informix-CGI on a IBM RISC/6000? i have serious problems with libraries compilation.... camara@mula.mur.hnet.es…
KAIO problem with Online 7.12 on AIX 4.1.4
I am currently using Online 7.12.UC1 on an AIX 4.1.4 platform. Because my dbspaces are created with raw device chunks, the I/O's should be performed by the KAIO threads. Thus, the I/O's should be performed by the CPU VP. However, when I issue the onstat -g glo command, I notice …
Re: Loading tables in Shared Memory
peeyush (peeyush@toj.com) wrote: : Hi, : I need to know how to load some of the frequently used tables (like master : reference tables which are accessed very frequently) into SHARED MEMORY. By : loading them into shared memory, they permanently reside there until they : are unl…
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…
AS400 v. DB2
Does anyone have any information comparing IBM's DB/2 to Informix?…
Re: informix & IBM's AIX
Andrej Urbanc <andrej_urbanc@at.ibm.si> writes: >Hello there, >Could comebody give me an answer on which versions of informix run >on which versions of AIX. Is it that ver. 6.1 runs on AIX 3.2.5 >and ver. 7.1 on AIX 4.1 (with SMP support) or not? >Thanks & kindest regards, Andr…
informix & IBM's AIX
Hello there, Could comebody give me an answer on which versions of informix run on which versions of AIX. Is it that ver. 6.1 runs on AIX 3.2.5 and ver. 7.1 on AIX 4.1 (with SMP support) or not? Thanks & kindest regards, Andrej…
Re: Performance Monitoring
ctaberman@cix.compulink.co.uk ("Colin Taberman") wrote: > > > Does anyone know of any monitoring tools / packages which are available > for Informix OnLine v6. I am looking specifically for any utilities which > may be available to report for information available from the Inform…
Re: OnLine shared memory question
>From: res@din.lois.perm.su (Igor G. Popov) >Subject: OnLine shared memory question >Date: Fri, 28 Oct 94 16:55:07 +0600 >X-Informix-List-Id: <news.9512> >When I attempt to increase BUFFERS value in tbconfig, >initializing fail and print message: >tbinit: shmat[EINV…
Informix on IBM 9121
The machine of our customer is IBM 9121. IBM offers for it AIX-ESA or AIX-370. The local Informix people don't know if there is or not an Informix version for that configuration. What do you know? THANKS. --- Andres Marianovsky andres@dia.edu.ar…
Informix products in IBM SP2?
Will Informix support the IBM Scalable Power Parallel System (SP2)? A trade article (RiSc World Vol. 4, No. 5) claims Oracle 7.1 and Sybase Navigation Server will be available on this platform. curtis@crl.com…
Informix 5.0.1 for IBM RS6000
Does anyone know if this available? If not when will it be available? Rick Hamel…
Re: Online and Shared memory
ywleung@ouray.denver.colorado.edu (YIU WAH LEUNG) writes: >I went into a theoretical discussion with my workmate on how Informix handles >shared memory that is defined by using tbmonitor/Parameter/Shared memory. >He said that the size of the shared memory that defined in Informi…