Oninit® Archive
Results for “onstat -g”
Current Role
Thanks Art, We'll have to parse the output from onstat -g ses 0. dk…
sysrstcb
Thanks Art. So the only way to look the session and the table is use onstat -g opn to get TID then, search for SID at sysrstcb?…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Hello Andreas, SMI tables sysmaster:syssqltrace[_*] show me „the past" and are very useful for history analyses and similar. When I am trying to find reasons why systém is „slow" currently, onstat -g ses [Aa]ctive, onstat -g ses [Rr]unning, onstat -g spf and in 14.10 onstat -g to…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
SMI equivalent of onstat -g spf
True, but also applying to onstat -g spf, afaik. ------------------------------ Andreas Legner ------------------------------…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help. Arr ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
onstat -g ses returns "Changing data structure forced command termination"
IT42548 - onstat -g ses <sessid> throws "Changing data structure forced command termination." Thanks Manesh Informix Support ------------------------------ Maneshkumar Sivalingam ------------------------------…
flags (onstat -g ses)
Primary thread for the session https://www.oninit.com/onstat/pda.php?id=onstat%20-g%20ses Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC…
Checkpoint duration and TXNS Blocked
What is onstat –g ckp showing ? How long would you like the transactions to be blocked for 'cos at the moment is 0.000 seconds J Cheers Paul…
monitoring session memory
Onstat –g afr can be useful as well…
Block during checkpoint
HI Here I attach the onstat -g ckp output plus onstat -d // ------------------------------ ABeMie ------------------------------…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
How to tell if logs are caught up in HDR
Thanks I will check the message log. What in particular am I looking for in the information given in onstat -g dri ?…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Issue with statistics
What does this onstat -g ses show me? I am seeing session id's, total memory, used memory and the 20 or so lines that shows all have dynamic explain = off. Also the onstat -g sql says unable to open input file sql. Not sure what these were for...…
SEQSCANS Counter in sysptprof
To find your query turn on sqltrace in low mode. You can then search for the part number of the table in the query plans displayed by 'onstat -g his'. Bear in mind that 'onstat -g ppf' reports part numbers in hex and 'onstat -g his' uses decimal. Ben.…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
identify what is allocating memory
original post: <some stuff deleted> @Jacques , Thank you for your explanation. Please, can you answer my question below? If I get the sum of the column totalsize of all lines on 'onstat -g mem' (Pool+blkpool), should be close value of the used memory for the segments at 'onst…
overzealous checkpoints
onstat -g ckp (or look at sysadmin:mon=5Fcheckpoint if the problem is=20 further in the past.) -> what's triggering these checkpoints (Trigger in onstat, type in monitor = table) ?…
Buffer pools in 11.50.FC5
Perhaps a stupid question but are all your dbspaces using a 2 kb page size? Does 'onstat -g buf' just show one pool? Ben.…
IDS not writing to online.log
yes, I can't see logical logs and checkpoints in online.log. What should I look for in onstat -g ath and stk ?…
False non-exclusive access when select a table
Hi Andreas, onstat -g opn previously saved (namely before restart) doesn't show any records for the partnums of table's indices. The partnums (for the table and indices) are in the outputs of onstat -C all and onstat -g ppf. Thanks. Roger…
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)…
Long checkpoint
Thanks Art, we only have 11.7FCx. haven't used 12.10 yet but good to know about 'onstat -g ioh'. Regards, Ron…
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…
CDR question on big transaction
In the source side, 'onstat -g nif' show the state is 'RUN,BLOCK'; In the target side, 'onstat -g nif' show the state is 'RUN';…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
onstat -g ath
In the vp-class column of onstat -g ath output, some of the entries has an asterisk appended (i.e. 1cpu*). What does that signify?…
Optimising index builds
The index isn't using light scans, according to onstat -g scn, for whatever reason. The environment variable isn't (according to TFM) active in 11.70: the engine decides itself. cheers Neil…
onstat -g nif
Folks, What might be the possibilities that will generate "RUN,BLOCK " in the State column of the output? We have significant ER data replication slowness issue... Thanks, Frank onstat -g nif IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 09:53:53 -- 8359540 …
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
onstat -g ckp Question
Morn'n Folks, IDS 11.70.FC7 Linux On one of my systems at a certain time each nithe I get checkpoint after checkpoint. This goes on for about a minute or two and results in several checkpoints per second. In onstat -g ckp, the trigger is IPL. I do not see this doc'd and the sys…
onstat -g osi
onstat -g osi neat command does not appear to be documented anywhere Is it ?…
problem with IDS 11.70FC4 and RedHat 5.6
Hi, What is the output of onstat -g seg ? Its good to tune VP_MEMORY_CACHE_KB 10240 also. rgds schillache…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
onstat g opn - lockmode
Hi , Ifx 11.50 FC9X6 , AIX 6.1 (with 1 RSS read-only synchronized) Monitoring the instance , I'm trying figure out why one stock historical table persists keep 60% of the table size into buffer pool a few days (checking with onstat -P) (60% = 10GB). So, I'm looking some histori…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Wait and Queue statistics
Can anybody provide clues on how to interpret onstat -g wst and onstat -g qst output please? I looked at the standard documentation but not much useful. Thanks, idos…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
onstat -g mem question
I'm seeing some memory segments I need some info on: SCDR2988661 V c00000004d9e7040 4096 800 1 1 SCDR3298189 V c00000004dc15040 4096 800 1 1 SCDR3298495 V c0000000541b8040 4096 800 1 1 SCDR3299197 V c00000004de08040 4096 800 1 1 SCDR3374788 V c000000048582040 4096 800 1 1 I'm s…
ph_task scheduled tasks
onstat -g dbc output is "Database Scheduler is Disabled.". How can this be enabled? -Prasad…
onstat -g ath
Can someone point me to a doc explaining what the status of IO Wait means with the above onstat command. I have attempted to explain it to my Unix admins, but they just don't get it...and claim the San never is busy... Thanks in advance ... Peter Logan Senior Database Administr…
onstat -g mem questuion
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…
Informix process reads a lot of pages
I try onstat -g ses and onstat -g ses <session id> but results was: IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line (Prim) -- Up 8 days…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Get instance names from PIDS?
On Apr 21, 2:45 pm, Jack Parker <jack.park...@verizon.net> wrote: > onstat -g dis > doh <facepalm>…
sysmaster query
Hi, Is there any sysmaster query which is substitute of onstat -g ses <session id> command ?…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
onstat -g dis
Hi All Where the information "onstat -g dis" comes from ? I have a 11.5 environment with 3 existing instances, I dropped an old instance but I can see its name in "onstat -g dis". This doesn't cause any issue for operation but I am wondering where this info comes from ? Regard…
ONSTAT -G DIC
Hi Everyone, First thing. IDS 9.4. My customer told me that the last line of onstat -g dic output is showing a big value of Total number of dictionary entries: Is almost 99.000 Question: Is that bad? How can I know if it's bad? And if it is, how can I set DD_HASHSIZE and DD_HA…
wait for mutex ... IDS hang....
Frank wrote: (4) mutex holder ??? it shows session 88852, but onstat -g ses 88852 shows nothing ( see below) informix@dora $ onstat -g lmx IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 4 days 03:03:29 -- 2120544 Kbytes Locked mutexes: mid addr name holder lkcn…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
onstat -g rea
exist a query over sysmaster with similar output of 'onstat -g rea' or 'onstat -g act'?. Thanks…
Re: onstat -g iof
Please check because I'm talking without looking at any documentation: kaio_reads/writes are I/O operations. Each operation can read/write more than one page. I/Os per second is a nasty number... Why? As far as I remember it's the number of I/Os done divided by the time the inst…
soctcppoll and soctcplst
Hi, What is the difference between a thread called soctcppoll and soctcplst ? I'm confused with the output of onstat -g ath…
How to check informix DB bottlenecks
Hi All, How to check the informix tables for bottlenecks? i am having problem our database and the user are explaining that it is a DB problem. I verified the logs and there's no valid error on the log file... I've used onstat -g sql, onstat -g ses, onstat -g lmx, onstat -k for…
onbar restore hanging
Hi, Do onstat -g iof moving or not on individual chunks? rgds schillache…
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 ---------…
onstat -g arc select statement
Hi All, is the someone who knows the onstat -g arc select statement equivalent? Thanks,…
Help with debugging Queries
Yes, in the output from onstat -k you see a column called owner. You can grep this value from an onstat -u output. The output from onstat -u will include session ids (I think in column 1 but I can't run the cmd right now) that can be used with onstat -g sql to determine what sql …
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Table accessed
I am pretty sure that version of Informix has the onstat utility. When a session connects to the database look at the output from onstat -g sql, locate the session id of the connected user and then run onstat -g sql <session id>. If the user is accessing a table it will show up t…
onstat shows memory held by finished sessions
Hi, I am using IDS 11.50 on HP-UX 11. The onstat -g ses shows the sessions which are complete. For example the program is finished but still the onstat -g ses shows insert session. The session details show it as "current SQL statement". Is the session still holding the memory? I…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Question about ISAM reads vs output of onstat -u
Environment: Informix 7.31 S.O. HP-UX 11i The ISAM reads (output of onstat -g ppf) and disk reads are the same ? I followed the next steps: 1. session a: onstat -z 2. Session b: I run a query in dbaccess 3. Session a: onstat -g ppf | grep 0xb00091 (a particular table reads in…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Migrating from IDS 9.40.UC6 to 11.50.UC3
onstat -g ath ? onstat -g stk all ? What IS going (on)?…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
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/…
AIO VP has more load then KAIO
Hmm, it could be you have set explain turned on, or tracing enabled in a SPL? You could try looking at onstat -g ioq aio in conjunction with onstat -g iof to see what files the aio vps are writing too. Jacques…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix allocating shared segments
It does sound like it could be a server memory leak. What you would want to do is to start monitoring onstat -g mem and onstat -g seg output. In the onstat -g mem output you would want to do comparisons on pool sizes and look for any pool or pools that might be continually growin…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
hadr checks
hi all if there is a possibility that hadr is not 100%, what checks are there that can be run besides the usual onstat -g dri, etc? thanks…
onstat -g prc
How do you interpret the output of "onstat -g prc"? and/or how do you tune the PC_POOLSIZE (PC_HASHSIZE?) ? Any feedback is appreciated. onstat -g prc | more IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 2 days 08:36:59 -- 3711120 Kbytes Stored Procedure Cache: …
Ip for a network session
onstat -g ses look under "hostname"...…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
onstat -g wst setup
I'm trying to run onstat -g wst to get some wait stats; the command returns a message "Wait statistics not enabled". I've scanned the manuals and see no reference as to what needs to be enabled to get the wait stats. Any help will be appreciated. IDS 9.40 AIX 5.2 Thanks folks.…
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
description of onstat -g ntt
hello Can anyone help me here with the onstat -g ntt I can find any good description of the meaning of the field below. In fact an explanation of all the q info would really be appreciated q-exceed 555/ 960 From sample below is this good or bad for q-exceed global network info…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
monitoring load
IDS 10, RedHat Linux Which onstat tells me that there are threads waiting to be processed? - onstat -g wai or - onstat -g rea TIA. Bob…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
onstat -g ath
Where I can found a documentation for the column "status" of this output? example: cond wait netnorm on a other screen with "onstat -g sql [sid] -r 2" I see many SQL command. C:\\\\>onstat -g ath | grep sql File STDIN: 35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec 37 1d…
onstat -g sql
problem : We have a user who has dba rights on his database.(Informix version 10) He can execute the "onstat -u" command to see which users are active. Now he's asking to have have the possibility to do "onstat -g sql" to see more detailed what the users are doing. This we can n…
Re: Onstat -g sts
Vaclav Boura wrote: Version and platform info would help a bit. Shutdown and restart IDS then open a case with IBM. Art S. Kagel > Hello all, > I have this problem : > > 01:08:38 Found during mt_shm_free 4 > 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) > 01:08:38 Bad block…
Re: Onstat -g sts
Vaclav Boura wrote: Version and platform info would help a bit. Shutdown and restart IDS then open a case with IBM. Art S. Kagel > Hello all, > I have this problem : > > 01:08:38 Found during mt_shm_free 4 > 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) > 01:08:38 Bad block…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Onstat -g sts
Hello all, I have this problem : 01:08:38 Found during mt_shm_free 4 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) 01:08:38 Bad block header 0x7000000f7fd1000 blk-64 07000000f7fd0fc0: 00000000 00000000 00000000 00000000 ........ ........ 07000000f7fd0fd0: 00000000 00000000 0…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Track a session to a Buffer
Hi All, I just had a case where onstat -u returned a 'B' as the first flag in the second column for over 100 sessions. The wait column for all the sessions had the same hex number. Is it possible to track down the session that is causing all the others to wait? I tried onstat…
AW: Multiple instances
>use onstat -g env Very cool, I did not know this. Thanks.…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
onstat -g iog
Hi all, In IDS10.0 , When I type the command onstat -g iog , it is displaying the output like this: AIO global Info: 7 aio classes 4 open classes 64 max global files But my system contains only 2 aio classes( 1 which comes by default and the other which I have added using onm…
How to get ip address of client ?
Hi guys, is there any way to obtain ip address (not a symbolic name) directly from server ? onstat -g ntt returns symbolic name, onstat -g dmp <hex addr> netsch_t - the same. Any ideas ?…
Informix database filling up rapidly
Run onstat -u and onstat -g ses for each session. There must be an application creating temp tables or doing queries that take a long time and are not using indexes.…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: MGM Mutex Locks hangs the system
What OS and version? What Informix version? What mutex locks? onstat -g mgm gives? onstat -g lmx gives? onstat -s gives?…
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.…
onstat -g sql equivalent for tbstat
Hi, I am using IDS 5.x on Linux (red hat 7.1) I would like to monitor the sql statements being run by some process I know in IDS 9.x you can do a onstat -g sql, then a onstat -g ses <sesid> However this option is not available with IDS 5, or that informix toolset. Neither does t…
Re: onstat -g wmx
>Query sysmaster directly? What does that show? > >onstat -g ses for each session? > >onstat -g stk all? > >onstat -g con ? > >Let us know what you find.. > Unfortunately it was last Saturday when this came up and it not occurring now and is unlikely to happen again in the near …
onstat -g wmx
When I run the above command I get Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 23:38:35 -- 12256256 Kbytes Mutexes with waiters: mid addr name holder lkcnt waiter waittime 1290 207947720 global cach -1 …
Re: IDS 10 erratic run times
1.ok... what does condition bp_cond mean? does anyone have an internals manuals? 2. onstat -g stk is not for the thread I wanted a) onstat -g ses <session id> for the session what is the name of the threads that are running. b) onstat -g stk <thread id> for each session…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
orphaned lock process
you might see the btcleaner in action; onstat -uk and onstat -g ath may tell you. try run update stats for this table superboer.…
orphaned lock process
you might see the btcleaner in action; onstat -uk and onstat -g ath may tell you. try run update stats for this table superboer.…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
onstat -g spi output
Anyone care to comment on the output below. The waits seem excessive for threads 14 and 141. Unfortunately this version of IDS 9.40FC5 [HPUX/Itanium] does not support onstat -g stk so I cannot really see much about the threads. Onstat -g spi Spin locks with waits: Num Waits …
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: HDR question
I normally take it granted whatever comes from Madison especially for ER/HDR. Also, not sure if this may help any thing to you. 1. onstat -g ddr 2. onstat -g rqm FULL Hari…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
virtual memory segments added
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…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Ostat -g sql
Hi, Running onstat -g sql returns the command that the session runs. Do you know from which sysmaster table it gets this information? Thanks, Vasilis…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: query performance tools
"Richard Kofler" <richard.kofler@chello.at> wrote in message news:40C211D6.35DCC9D7@chello.at... > Give onstat -g stm a try! Huh?…
onstat -g sql in 9.4
We use the output from onstat -g sql <sessid> to assist with problem resolution. The value of 'Last parsed SQL statement' is very helpful to find problematic SQLs. We are upgrading from 7.31 (AIX 4.3.2) to 9.40 (AIX 5.2) and have noticed that in version 9.40, the 'Last parsed SQ…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Re: 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...…
high buffer wait ratio
Andrew Hamm wrote: > > What's the output of > onstat -g iov | head -7 WRONG!!! I mean, what's the output of: onstat -g iof onstat -g iov onstat -F | head -7…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
ER and onstat -g sql
After recently switching from HDR to ER (needed a third server online) I've noticed that I'm getting the "Changing data structure forced command termination." message far more often than I used to, every time I run it in fact. I was just wondering if anyone else has noticed this…
ER and onstat -g sql
I've just switched some of our servers from HDR to ER to put a 3rd server into the mix. Everything seems to be running dandy, only when I run onstat -g sql I almost invariably get the "Changing data structure forced command termination." message. Has anyone out there seen this b…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
pid in onstat -g ses
IDS 9.40.FC3 AIX 5.2 I have one application that always shows up with a pid of -1 in onstat -g ses. It is an EDI application from Inovis. These are all tcp/ip connections to the server. Does anyone know exactly how the server determines the pid if the process is started from an…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
RES: onstat -g ddr
I dropped and rebuilt the replicates and it worked pretty fine. Thanks. Julio -----Mensagem original----- De: Simmons, Keith [mailto:keith.simmons@office2office.biz] Enviada em: segunda-feira, 19 de janeiro de 2004 11:08 Para: 'Julio Cesar' Assunto: RE: onstat -g ddr Julio **…
onstat -g ddr
This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C3DE68.01B85AD0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi again! I had to drop all my logical-logs to change their size values, but after that I got …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
What do session statuses mean?
What does a status of "cond wait(await_MC1)" in onstat -g ses mean? Thanks Andy…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
SMI and onstat -g stm
Hi All, We are using IDS 9.30.FC2 on HP-UX. Can anyone point me how to get the same result as onstat -g stm using SMI ? Thanks Jia-Chiy…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
RE: 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: onstat -g iof
Vaclav.Boura@cpp.cz wrote: > Hello all, > when I perform onstat -g iof I see 82 sqexplain.out at the end. What does > it mean ? > 84 > sqexplain.out > …
RE: onstat -g iof
It also puts a big performance overhead on your system - slows it down. Don't use it unless totally necessary. -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, September 30, 2003 3:04 PM To: informix-list@iiug.org Subject: Re: onstat -g i…
onstat -g iof
Hello all, when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it mean ? 84 sqexplain.out 86 sqexplain.out …
onstat -g iof
Hello all, when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it mean ? 84 sqexplain.out 86 sqexplain.out …
[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…
maxlen in onstat -g ioq
Again a performance issue. When I run onstat -g ioq, I find several AIO I/O queues that have high maxlen numbers, even when there haven't been too much activities. Aren't these numbers too big? [How] Can I change that? (Informix 9.30.UC2 on Linux SLES7) Many regards, R�diger …
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
onstat -g wts??
hosname:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled My question is How can I enable the wait statistics?…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Onstat -g stk
Few days back, I have upgraded our Informix database from 7.24UC3 to 7.31FD2X1. After that whenever we try to see the onstat -g stk <process id>, it shows same process. pls find below the stack output for arcbackup thread. Actually, I wanted to find out whether is there any old d…
onstat -g ntt - in sysmaster
Hi I want to write a query in sysmaster to get the following information:- netscb thread name sid open read write address 2605cdc0 sqlexec 3109 17:59:55 18:00:22 18:00:22 the above is taken from onstat -g ntt I am interested in open, read and write time which I believe pertain…
Queue statistics
Hi! What should I do to enable queue and wait statistics ( those shown with onstat -g qst , onstat -g wst ) ? I have IDS 2000 V 9.20 on an Unixware 7.1 box . Thanks. Sorin Ifrim…
onstat -g dis
Hi all. Does onstat -g dis print information about the current engines, or about all the engines that during ages existed on that box ? Thanx, Bogdan Neagu…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
onstat -g arc
Hi, how could I resolve the obtained date from 'onstat -g arc' ? It's sth. like: 101/10/190.29:22 Greets, Andi…
RE: questions onstat -g
do an onstat -- and you will get alll -----Original Message----- From: Marat S. Salimov [mailto:maratkotik@mail.ru] Sent: Tuesday, November 21, 2000 4:30 PM To: informix-list@iiug.org Subject: questions onstat -g Where can I find reading about meanings of onstat -g ... columns.…
questions onstat -g
Where can I find reading about meanings of onstat -g ... columns. By example onstat -g ioq: dskcopy onstat -g sch: busy wait, spin/waits…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Replication conflicting with constraints
For Enterprise Replication... onstat -g ddr display the snoopy/replay position onstat -g grp display information about the grouper onstat -g rqm display information about the queues onstat -g nif information about network transfer of replicated data onstat -g dss inform…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
RE: rootdbs size?
From: William Rice <ricew@operamail.com> > >onstat -c >onstat -m >onstat -d >onstat -D >onstat -p >onstat -P | tail -5 >onstat -R >onstat -F >onstat -g seg I feel like I'm stuck in a time loop! ______________________________________________________ Get Your Private, Free Email a…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
onstat -g Question
Yuri Dovgart wrote: > Use onstat -g arc. This must help. Note that backups to /dev/null will also be "recorded". Rudy…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Posting from the Informix-list
onstat -g ntd Nona…
checkpoint spikes
When onstat -g ioq shows a backlog for aio, try incrementing NUMAIOVPS. A a rule of thumb, two aio VPs per frequently accessed disk. Nona…
Finding CPU hogs
Is there any way to determine which user session might be causing oninit to hog the CPU? Can any of the onstat -g commands help?…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Last parsed SQL statement
When onstat -g sql <sessionid> is executed is gives the Last parsed SQL statement. Is there anyway of querying the sysmaster database to get this statement?…
onstat -g mem
Please where can i get some explanation about onstat -g mem…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Q: Counters reset for onstat
The counters for the output of the onstat commands get reset every so often. What controls these #'s being reset? How often do they reset? The arguments that I am looking at are: onstat -g iof onstat -g ioq onstat -g iov Sent via Deja.com http://www.deja.com/ Share w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Effect of disk striping on disk layout
Are you using kaio? (You can check this by running onstat -g ioq - if there are kio vps listed then you are). Neil…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
partition profile
Hai.. All.. When I type onstat -g ppf, I found Partition profiles disabled Does anybody know about this ?…
Auto-disconnection for idle session 2
To complete my first mail, Does anybody know where to find date/time showed in onstat -g ntt in sysmaster tables? TIA, David...…
Re: The last executed SQL statement
Once again to add to the Clowns' reply. run onstat -u and look for the userid in question, this will show y ou which sessionid to use in the onstat -g..... Terry Obnoxio The Clown wrote: > >How to obtain the last executed SQL statement? > > If you're using IDS, onstat -g …
Re: The last executed SQL statement
>How to obtain the last executed SQL statement? If you're using IDS, onstat -g sql <sessionid> or onstat -g ses <sessionid> HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: Q:How to find list user sessions with database
You could also use onstat -g sql instead of onstat -g ses <sessid>. Steve Berg spb@nb.com On Wed, 15 Jul 1998, CONWAY Graham wrote: > Hi, > > Please excuse me if this is obvious. > > Does anyone have a simple way (sysmaster query or onstat option) of listing > the sessions on …
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
onstat -g dic
Someone knows what is the result of onstat -g dic ?? Thanks.…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
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…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
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 ______________________________…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Light Scans
Hi, You can monitor them using onstat -g lsc Chris Jenkins Denham.M@amstr.com wrote: > > Do you know how to monitor if they are being used?…
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.…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Onstat -g ses Output
Does anyone know where I can get a explanation of the Onstat -g ses <sessid> output for Online DS 7.10? Thanks Cheryl L. Kendricks-DBA cherylk@spamis.jcdc.doleta.gov…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…