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…
12.10.FC15W1AWE Blocked in LONGTX
Could it be that the rollback was still going, but had hit the LTXEHWM threshold? onstat -x would have shown some movement if that was the case. If the logs had got to the point where the next log had an open transaction, you could have tried adding logs manually with onparams -…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
Hi, Some other items OFF_RECVRY_THREADS is used to define the number of apply threads on the secondary LTAPEBLK I believe is used for the size of replication buffers SEC_APPLY_POLLTIME needs tuning on secondarys onstat -g laq (and the undocumented onstat -g laqp that gives timi…
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…
Bizarre CM/Connectivity Issue on 12.10.FC14
I finally received an explanation from support on what seems to be going on here: With a distributed query like select count(*) from sysmaster@dummy:systables; This is a server-side issue with Connection Manager involved for distributed query, the coordinator (local) server needs…
Block during checkpoint
HI Here I attach the onstat -g ckp output plus onstat -d // ------------------------------ ABeMie ------------------------------…
gTA cannot be killed
If I'm getting this right, onmode -Z is meant for I-Star 2-phase-commit distributed transactions, whereas onmode -H is for XA global transactions. The later (XA transactions) typically are not owned by Informix and should be taken care of by the XA transaction manager that initia…
Long Running Purge Script
Hi Art, Thank you for your insightful clarifications. Thoroughly appreciate your help. With the best regards and thanks, Saradhi Motamarri +61430022130 Sent from Yahoo Mail for iPhone ------Original Message------ Saradhi: See my responses below: So, IDS is behaving well. But I wo…
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.…
locks persists while client app is down
If you confirm that the locks belong to Global Transactions (aka xa transactions), then there is no direct way to clear them without a restart (and they will probably survive the restart??). One way is checking the RFE in: http://www.ibm.com/developerworks/rfe/execute?use_case=v…
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 ?…
Issue in transactions with informix using DRDA
Hi Art, I think you mix up distributed (XA) transactions and distributed SQL. From my point of view, distributed SQL, as described in the feature list would be the access from one DB server to another (such as select .... from database@foreignserver:table where ...). In contrary…
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…
Trying to set USELASTCOMMITTED='COMMITTED READ' do
I'd like to set onconfig parameter USELASTCOMMITTED from "NONE" to "COMMITTED READ" dnymically using onmode -wf, but whatever I tried I always get an error "onmode: Unknown option READ". So the value given as two words is not recognized as one always. I tried this on Solaris usi…
Finding users locking the database
Hi Luis, Thanks for the answer, is there a way to check the script being executed in the global transaction of even the originator (actual program/application) running? So if possible we can terminate the program from the originating system?…
Stuck transaction
On 05/05/15 15:47, MICHAEL HOFFMAN wrote: > Hi All, > Informix 11.5.FC9 running on Solaris 10. > I found a transaction using 'onstat -x' that is definitely stuck. > > 119696f88 -LH-G 0 0 logid 81731 81763:0x189257c COMMIT 0:00 0 > > The problem is that those log numbers date back…
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…
Database in (LONGTX) need identify case user
Yes, you can avoid the long transaction problem by doing these things: 1. Limit globally affecting transactions like massive updates and deletes. There are tools and techniques to break these operations down into smaller pieces that avoids the problem altogether. 2. Make sure…
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 ?…
informix 11.70 growth edition features
Upps, that would mean a Growth/Workgroup edition could not be part of a XA distributed transaction including other databases on different sites (not necessarily Informix, whatever edition) ? I was thinking that would be only an I-Star function in case the IDS engine itself was t…
identifying a lock seemingly without an owner
Hi Andrew, you seem to suffer from a orphaned XA transaction, which cannot be closed, because the initiating process has died. Informix 10.0 was very vulnerable for this kind of problem, when you have and unclean shutdown of your application server (such as kill -9). We even had…
select for update
HI, Coud I use 'select for update' clause to prevent others read the same record? the default isoaltion level is 'committed read', ids version is 11.5. in windows one: I excute： dbaccess stores_demo; begin work; set isolation committed read retain update locks; sel…
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 crashes in flexible grid create table commit
Hello All, I am using Informix version 11.70.FC4GE. I have two nodes set up in a flexible grid, with ER active. Whenever I try to create a table within a begin/commit block, IDS crashes. So, this causes a crash when trying to execute the commit: begin; execute procedure ifx_gr…
XA question
We are seeing global transactions that are started by our Glassfish server (by way of the Informix XA JDBC driver version 3.70.JC4 under the control of the Glassfish XA transaction monitor) that do not die. That is, even though ostensibly Glassfish is telling Informix that a giv…
Migrating from 7.31 to 11.70 with ER?
I think I've done exactly that. The global catalog is on 11.70. The replication is being run from 11.70. I assume that's what you are referring to. Unfortunately, one can't run cdr sync... from 11.70 when replicating over a 7.31 server due to incompatible syscdr tables. Or at le…
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…
Error with XA transactions
Hi All, Hope someone familiar with XA transaction setup via WebSphere can provide me some answers. We recently switched from Connection Pooling to XA transactions via WebSphere, connecting to some Informix 9.40 databases. We started receiving SQL Exception error messages "The da…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Re: Why does this transaction on my IDS 11.70FC2 freeze it up?
On May 12, 6:45 pm, Todd Roy <tm...@hotmail.com> wrote: > IBM finally got back to me and told me it was a probabe defect and as a work-around > told me to turn off MULTI_INDEX with an optimizer directive. > ie: > > SELECT {+AVOID_MULTI_INDEX(orhanmle)} > count(*) > from orhan…
RE: Why does this transaction on my IDS 11.70FC2 freeze it up?
10545,L6Q Apparently they are having problems reproducing. I actualy sent them a copy of the problem table. Date: Thu, 12 May 2011 23:21:05 +0100 Subject: Re: Why does this transaction on my IDS 11.70FC2 freeze it up? From: domusonline@gmail.com To: tmroy@hotmail.com CC: informi…
RE: Why does this transaction on my IDS 11.70FC2 freeze it up?
IBM finally got back to me and told me it was a probabe defect and as a work-around told me to turn off MULTI_INDEX with an optimizer directive. ie: SELECT {+AVOID_MULTI_INDEX(orhanmle)} count(*) from orhanmle where anml_sire_key = 743101 or anml_dam_key = 743101; wor…
Get instance names from PIDS?
On Apr 21, 2:45 pm, Jack Parker <jack.park...@verizon.net> wrote: > onstat -g dis > doh <facepalm>…
Lock owner not found issue - between parenthesis
original post: Hello, friends. (IDS 11.50.FC6W1 on a linux_64 machine) It seems really a silly question, if not a "strange" one, like I´m thinking, but here it is: My table, with lots of users are indicating these current locks: Locks address wtlist owner lklist type tblsnum row…
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…
RE: IBM Informix Database Server a Forrester Total Economic Impact Study - Link Does not work
Ho hum... Here's a key paragraph: This study illustrates the financial impact of adopting Informix database software for a distributed global retailer with 4,000 instances of Informix located throughout the globe. In conducting in-depth interviews with a large global retailer us…
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…
Re: how to terminate global transactions?
On 28.06.10 11:19, Davorin Kremenjas wrote: > On Jun 27, 6:51 pm, Frank Langelage<fr...@lafr.de> wrote: >> On my Informix instance I have two global transactions holding some >> locks. See onstat -G and onstat -x output below. >> How can I get rid of them? >> Also after a server…
how to terminate global transactions?
On my Informix instance I have two global transactions holding some locks. See onstat -G and onstat -x output below. How can I get rid of them? Also after a server reboot they are still there. onmode -Z <address> or onmode -H <address> do not work (see below). IBM Informix Dynam…
Meeting Communications Industry Imperatives with the Right Data Management Framework
Meeting Communications Industry Imperatives with the Right Data Management Framework Because of intense competition and demands from consumers, Communications Service Providers and Equipment Providers alike, are looking for ways to accelerate deployment of new services and incre…
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…
Re: how many transactions/sql statements server has executed
On Apr 29, 6:58 am, LonelyWolf <lonelywolf1...@gmail.com> wrote: > On 23 huhti, 20:54, "da...@smooth1.co.uk" <da...@smooth1.co.uk> wrote: > > > > > > > On 23 Apr, 09:09, LonelyWolf <lonelywolf1...@gmail.com> wrote: > > > > Hi > > > > I'd like find out how many transactions and/or…
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…
THIS BOARD NEEDS A MODERATOR TO SCREEN POSTINGS...
On Thu, 2009-10-22 at 14:04 -0400, FRANK ROTOLO wrote: > FROM JERKS LIKE OBNOXIO BEFORE THEY ARE PUBLISHED!.. OK, SO I COMMITTED A > MISTAKE BY POSTING MY RESUME HERE, BUT SOME OF YOU NEED SOME GROWING UP TO DO! > ALTHOUGH IBM HAS NO CONTROL OVER THIS BOARD,I HOPE THEY TAKE NOTIC…
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…
RE: Clean Reads/Database timing out
Larry:: You failed to mention the type of database, ANSI or non-ansi logging database will make a big difference. It will change the default isolation level and how lock are handled. If you are in version 11 or higher you should set the isolation level to committed read last co…
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)?…
Re: EXT3 & EXT4 filesystems are NOT safe.
Art Kagel wrote: > Friends, Colleagues, Clients: > > According to Linus Torvalds, Linux's EXT3 filesystem is not safe since > it writes its meta data to disk before committing the related data > changes to the file. This can mean corrupted files if the system > crashes between t…
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…
Update statistics returns erro -255
Hi, We run update statsitcs in parallel on our database on IDS 11.5 FC2X2 on an HP-UX is64 server.? Some tables and indexes are fragmented across multiple dbspaces. Sometimes the update statistics returns and error code of -255 on several tables: finderr -255 -255??? Not in tra…
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…
Why you can't trust IBM when it comes to committing to Informix.
Ian, I think the space needs to be forked into at least three, not two: 1. Commitment to maintaining and supporting a product. 2. Committing to "investing in" a product (which usually means new features, new platforms, etc.) 3. Committing to marketing and promoting a product. …
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"...…
RE: TPS
I think, I can make Mark's question more specific: - Each transaction is making 25 bufwrites, 400 bufreads average (that is, transactions are pretty complex, most logic in SPL) - Only committed read-write transactions are counted; - 24x7 system - 3 Terabyte instance, unbuffere…
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…
syntax of insert like mysql
vomaringo@yahoo.com wrote: > is there an option to allow : > insert into customer (fname) values ('a'),('b'); > No, using pure SQL you'll need two inserts to do that. If you are using a host language you can use an INSERT cursor to insert as many rows as you like with a single …
Performance Tuning of batch insert and batch update using JDBC API.
In addition to Marco's comments, how exactly are you doing the DB2 9 load?... Is it truly an insert or is it a "load" operation that is "not logged"?.... Bypassing transaction logging can surely save time. ============================================================ The informat…
generic question: update statistics low drop distr
Robert Roussey(IT) wrote: > I thought I remember JM saying that US-medium on a table will drop > distributions and rebuild them anyways? > Well, almost. Medium and HIGH both drop the existing distributions and insert new ones in a single transaction. If the process is interrupte…
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.…
Re: IDS on a Mac?
david@smooth1.co.uk wrote: > On 18 Oct, 16:29, "Ian Michael Gumby" <im_gu...@hotmail.com> wrote: > >> BTW, when will Oracle get their act together and do temp tables right? >> Anyone who's had to suffer through their bastardized "global" temp tables >> can appreciate that a *real…
Select without locked row
It is REALLY useful to include the threaded msg to which you are posting for those on the list using DUMB mailers to monitor the list - like me ;-( IB this is the thread with the work queue message table, yes? There are ways of handling that, but let's take a direct approach. N…
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.…
Duplicate serial in Informix 7.2.3
On Jul 25, 2:18 pm, pedro <pedro.e.sa...@gmail.com> wrote: > Hi, > > I've developed an webservice application which accesses an informix > database. > When the service is invoked, the application executes some business > logic, opens a transaction inserts values in 3 tables (let'…
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…
RE: Named user lock facility in IDS?
On Jul 23, 4:07 pm, "Ian Michael Gumby" <im_gu...@hotmail.com> wrote: > David, > > So what you're trying to do is use the database to contain data so that your > external applications can > do some form of mutex locking? > > _______________________________________________________…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Maximum Transactions Insertion Per Second
Using multiple connections (ie multiple threads or multiple copies of the insert application), a PUT cursor in a host language like 4GL or ESQL/C opened WITH HOLD, maximum sized communication buffer size ( environment var FET_BUF_SIZE=32767 or global host variable FetBufSize = 32…
Re: Informix beats Oracle
Tool wrote: > Well I guess I was thinking this was a bit more than "SET ISOLATION TO > DIRTY READ". > > What's the difference between that and this new feature? Now I'm > totally bamboozled. > Does this mean that in IDS you could not read a locked row at all before > this new > …
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…
Transaction Question
On 24 Apr 2007 07:28:58 -0700, Dave <In4MixDBA@gmail.com> wrote: > Hello All, > > We have the following transaction situation. Is it possible within a > transaction, "begin work" ......"commit work" to insert records to a > log table and have those records committed regardless o…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: IDS License Revenue
Serge Rielau wrote: > To get back on topic. The number stated officially in the Q4 call was > +32% new-transaction for "distributed databases". > (That comment by the CFO is verifiable via the webcast and anyone who > doesn't believe it should send a note to SEC...). > > Given …
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…
SNAP & SAN
Hi, I try to clarify this a bit more ... After restoring the snapshot, you have an "image" of the data exactly as it was while the server was blocked when taking the snapshot. The command "onmode -c block" explicitly writes a checkpoint so that all data will be on disk and the …
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…
Parametro TXTIMEOUT
vesf wrote: > Hola, quisiera saber si alguno de ustedes me puede informar que quiere > decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se > refiere. Gracias de antemano. Salu2... > /Translation Hello, I wanted to know if some of you can tell me what the onconf…
MSDTC Transaction
When I launch a MTS transaction against an Informix 9.40UC2 or 10.0UC3, the transaction appears to be completed in the client side, but in the server a global transaction with flags --X--G never ends, blocking other operations over locked resources with errrors like: Error -21…
Looking for Replenishment Software
We have a custom Warehouse Distribution system written in 4GL (Fourjs BDL) using an IDS database. About 150,000 part numbers and 10 years of transaction history. Our Parts Replenishment is a hand coded program that lacks intelligence for trends/spikes/etc. Can anyone recommend …
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 …
Indexes on a Fragmented Table
Actually, the default behavior of indexes on fragmented tables in Informix is completely equivalent to the behavior of local indexes on fragmented tables in Oracle: each fragment of index, created without 'IN dbspaceXXX', is created in the same dbspace, as table fragment. 'Detach…
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…
Re: index duplicate values, how much ?
Well, think you are not right, consider this test: The test runs in a database with unbuffered logging. create table t (id integer, name varchar(20)) in testdbs lock mode row; insert into t(id, name) values (0, 'KARL'); insert into t(id, name) values (1, 'MAX'); insert into t(…
Aborted Long Transaction
HPUX-11 IDS 9.21.HC4 I have been seeing some weird errors in my online log. 08:32:09 Aborting Long Transaction: tx 0xa2f427f0 no user info due to XA or distributed (2-phase commit) transaction 08:32:09 Aborting Long Transaction: tx 0x9e236188 no user info due to XA or distri…
Re: Method to determine if in a transaction?
Matt: Yout can create your own 2 line C UDR (User Defined Routine) to return this information. Below are the step and code you can use. I did this on Solaris 2.8 and version 10 of informix. Hope ths helps, John ===============SOURCE CODE FOR trans.c====================== #in…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
RE: Method to determine if in a transaction?
Matt asked: > Is there a way, in SPL, to determine if you are already in a transaction > or not? I know it is possible to try to create a new transaction and > then catch the exception if it fails, but I am wondering if there is a > simpler approach - a global variable or somethi…
Method to determine if in a transaction?
Is there a way, in SPL, to determine if you are already in a transaction or not? I know it is possible to try to create a new transaction and then catch the exception if it fails, but I am wondering if there is a simpler approach - a global variable or something.…
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…
Re: Another IDS Feature Request
Art S. Kagel schrieb: > Several days ago I proposed the following as part of a reply. I got no > comments on it. Did everyone miss it? Or is it just dumb? > > Explicit globally accessible cursors. It would make writing middleware > and WEB services with context so much easier…
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!…
Another IDS Feature Request
Madison Pruet wrote: > Art, > > The main purpose of a cursor is to maintain a position in a table so that > you can get the next/prior record. How does that play in this? Would the > cursor remain open? Would this function somewhat like a queue? Or are we > simply talking abo…
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 ?…
RE: Question regarding global variable.
Feng Huang (huangcf) wrote: > I have tried to implement the code to use global variable. It works for > different connections. But I run into one problem. Actually my previous > example wasn't accurate enough. The function contains some insert/update > for several tables. The key…
RE: Need to create my own environment variable in Informix
Hi All, I found a temp solution of writing a dummy function or a procedure that will return the value and when we need to change the value we just alter the function\\procedure. Don't know how effective it would be against a select from a memory resident table. In Oracle and SQL …
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…
Re: Manually Unlocking records in IDS
... unless it's a global XA transaction "Art S. Kagel" <kagel@bloomberg.net> a �crit dans le message de news:42CAAF2E.6020406@bloomberg.net... > JoeT wrote: > > Hi... > > > > I have a PHP application under development and have an annoying > > problem. > > > > I am purposely tryin…
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:…
Re: HELP ME WITH THE FAQ....Please review
mweallans@panacea.co.uk wrote: > David, > I'm qute willing to help with "What exactly is a long transaction" but > it needs a complete rewrite. It currently recommends using "onarchive" > and I'm not sure if that is still distributed. I don't even know if > informix would recom…
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…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
Re: loadfile with quotation marks -> csv-file
try_and_err wrote: > Jonathan Leffler <jleffler@earthlink.net> wrote > >>Well, 'sqlcmd -R' is equivalent to 'sqlreload'; you can only directly >>specify '-i' on the command line with one of those two options. >>However, there's nothing to stop you using a LOAD or RELOAD statement…
Re: loadfile with quotation marks -> csv-file
Jonathan Leffler <jleffler@earthlink.net> wrote > Well, 'sqlcmd -R' is equivalent to 'sqlreload'; you can only directly > specify '-i' on the command line with one of those two options. > However, there's nothing to stop you using a LOAD or RELOAD statement. > If you have v77.03 …
Re: loadfile with quotation marks -> csv-file
Jonathan Leffler <jleffler@earthlink.net> wrote > Well, 'sqlcmd -R' is equivalent to 'sqlreload'; you can only directly > specify '-i' on the command line with one of those two options. > However, there's nothing to stop you using a LOAD or RELOAD statement. > If you have v77.03 …
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.…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
Update statistics
There is a way to drop distributions without running 'update statistics low' You may use the SQL command: DELETE FROM sysdistrib WHERE tabid = (SELECT tabid FROM systables WHERE tabname = '<the_table_in_question>'); Disadvantage of this approach is that this is a hack rather t…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Re: 4gl development question
Neil wrote: > The way our 4gl application has evolved we make use of system calls to > execute other programs rather than linking in that functionality > directly to the calling program. > > For example this leads to the following type of code > > program1: begin work > …
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…
4gl development question
The way our 4gl application has evolved we make use of system calls to execute other programs rather than linking in that functionality directly to the calling program. For example this leads to the following type of code program1: begin work ....... co…
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 …
Re: Isolation levels in Informix vs Oracle
DA Morgan wrote: > Serge Rielau wrote: > >> Sidenote: SEQUENCE is "dirty read" by definition and it is quite >> popular in Oracle :-) >> >> Cheers >> Serge > > > By whose definition? Certainly none I have ever heard. > The freedom of double-quotes Daniel. Open your mind: If you o…
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?…
Re: Problems with locks and committed read
You say the problem only occurs in MODE ANSI databases? this may suggest you don't have any commit or rollback statements. In a non mod ansi daatebse without begn and commit, every sql statement would be treated as a single transaction and would be so the lock would be released i…
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…
Remote LONGTX with no userthread in 9.30 UC6 W4
...forgive the long copy and double post on ids (was having problems posting here), but it has been a while, I'll post at the top to save you time... What is the difference in the following commands? onmode -H <address> forget heuristically completed transaction onmode -Z <a…
Remote LONGTX with no userthread in 9.30 UC6 W4
...forgive the long copy, but it has been a while, I'll post at the top to save you time... What is the difference in the following commands? onmode -H <address> forget heuristically completed transaction onmode -Z <address> heuristically complete specified transaction The admi…
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,…
Re: Remote LONGTX with no userthread in 9.30 UC6 W4
TBP wrote: > rdtbra wrote: >> We use here IDS 9.30.UC6W4, running in SunOS 5.7. Both Informix >> and Solaris are 32 bits. For the second time we have reached a >> situation where the instance shows a LONG TRANSACTION marked with >> flags --H--G and userthread 0. When this instan…
Remote LONGTX with no userthread in 9.30 UC6 W4
Hello all. We use here IDS 9.30.UC6W4, running in SunOS 5.7. Both Informix and Solaris are 32 bits. For the second time we have reached a situation where the instance shows a LONG TRANSACTION marked with flags --H--G and userthread 0. When this instance is started, after the fas…
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: 2 Different Database Transactions
Dorn Bhechsonggram wrote: > That's OK. I got it by doing as follows: > > begin work; > insert into db1@server1:tab1 values ... > update db2@server2:tab2 set ... > commit work; Yes that's the best way. You couldn't do it the other way without somehow starting an XA-style trans…
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 …
Informix isolation levels
First of I have read the manuals. I am have difficulty with and application that have written to work against Informix or Oracle and the developer is saying that the way Informix handles transactions is wrong. In Oracle, user1 begins a transaction and updates a row, but doesn'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…
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…
Transaction id and transaction isolation
"Alex" <azp74@hotmail.com> wrote in message news:dca1064b.0307202358.43aac613@posting.google.com... > Hi > > Two questions. I am using Informix IDS 9.4 on Windows. > > 1. I would like to be able to get hold of the transaction id while > still in the tranasction but I have been …
RE: Long transactions
Two other options: 1) set up an HPL job; you can run it from the command line (if you really don't want to use dbload, then this would be my recommendation). 2) switch your database to non-logging, run your load (leave out the "commit"), switch database back to logging, then imme…
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 portfolio
> Do jou have any information, desciption or links about informix : > - support to 2pc and 3pc Presumably you mean distributed transactions (2- or 3- phase commit)? I don't know about 3pc but Informix supports XA as well as a proprietary distributed protocol (when talking direct…
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…
Error NO. 243 and 144
Informix Dynamic Server 7.31UD2R1 on HP-UX 11.0 There are two programs with same syntax tries to run almost at the same time and sometimes end up in getting this error. Any ideas or solutions to avoid this will be highly appreciated. Both are using Committed Read Isolation lev…
HELP: DBD::Informix issues
Hey guys, I have the following issues with connecting to my DB using Perl. But first some background: I create my DB like: CREATE DATABASE george_db_upp IN maindbs WITH BUFFERED LOG; I use DBD::Informix version 1.00.PC2 Running IDS 9.3: Here's my script: -----------------…
Re: Informix versus oracle
Brandt Edwin wrote: > my apologies, comment taken out of context... > > the context of which you could not have possibly have known. > > allow me to clarify > > i simply meant that when in an sqlplus session, if I issue the command > update, insert, whatever i have to actually …
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…
Row Locks When Transaction Logging is turned off
No --- transaction logging and locking are not the same thing. In fact without transaction logging, the role of locking is even more critical. M.P. "Anthony.Oje...." <Anthony.Ojeda@LW To: ids@iiug.org .com> cc: Sent by: Subject: Row Locks When Transaction Logging is turned off …
Re: Doubt on logical log - revisited
The important concept here is pages vs. buffers. We never write less than a page, so when we flush a logical log buffer, we don't write any unused pages in a logical log buffer, however we will write a partially full page, meaning there will possibly be _some_ white (empty) space…
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…
Committed Read is not enough for fetching BLOB rows...
Hi, I have committed read isolation level between transaction. But in some cases I found that the select queries got error -164:ISAM err: Blob stamp is incorrect. I read the detailed message of this error and I was very surpprised on that. For example I have a transaction usin…
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…
Re: World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!
>what were the benchmarks for transaction failure and recovery time? >how about distributed transactions? >what's that? postgesql doesn't have transactional integrity? no Yes, it does have transactions. >distributed transaction support? oh. oh well. i wonder who came up >w…
World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!
what were the benchmarks for transaction failure and recovery time? how about distributed transactions? what's that? postgesql doesn't have transactional integrity? no distributed transaction support? oh. oh well. i wonder who came up with the benchmarks. i need a real dat…
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…
Re: some questions about Informix
And better solution - without logical restore problems: --------------------------------------------- create table seq ( id serial not null ); create procedure seq_set_val( val int ) define global g_seq_val int default 0; let g_seq_val = val; raise exception -746 end procedur…
some questions about Informix
> > User1 > > begin work; > > execute function sequence('same_name'); > > User2 > > begin work; > > execute function sequence('same_name'); > > If you use CURSOR STABILITY isolation level, then it is no problems with > multiuser access for 'sequence'. I test and ther…
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…
LONGTX message during engine startup
Here's the message: Informix Dynamic Server Version 7.30.UC2 -- On-Line (LONGTX) -- Up 00:06:56 -- 323584 Kbytes Blocked:LONGTX From online.log: 15:33:11 Continuing Long Transaction (for COMMIT): tx 0x8fc70cb4 no user info due to XA or distributed (2-phase commit) transact…
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…
Problem with distributed transactions
Hi, We are using an Informix 7.23.UC11 On-Line Database, on HP-UX 10.20 with MC-/Service Guard on two HP9000-K380, and TUXEDO v6.3. Following a crash on one server, due to a hardware problem, we use the second server for he high-availability of the application, we obtain one di…
Informix OLEDB and MTS
Hi all, I using the OLEDB Provider 2.0 from Informix, but I think this Driver doesn't support transaction within MTS. Because of this I used the Informix ODBC Driver 3.30 32Bit wich supports transactions, but this Driver is very slow. Does anybody know if there exist an OLEDB Pr…
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…
Re: Memory problems? Please help.
From: "Vincent Kennedy" <vkennedy@torex.co.uk> > >I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > >They used to be executed during a shell script containing abotu 30 >programs. >However, this was poor for maintenance and distribution so one exe was >com…
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…
Transaction within a Transaction
Here's one suggestion : 1. Create your initial audit trail row BEFORE commencement of the transaction. 2. Record programmatic failures as part of the ROLLBACK code. e.g IF blah_blah_1 = 'not good' THEN ROLLBACK WORK; CALL update_audit( trx_id, "Failed at bl…
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…
Error -256
r_pastore@my-deja.com wrote: > > Hi, > I'm seeing error -256 when monitoring (onstat -g sql) an > application running Online v 7.30. I know the error means that the > program is trying to start a transaction when there is no logging. The > problem is that the application …
Stored procedure locks
Mukund D Shevkar wrote: > > I have 2 stored procedures running simultaneously (written by development > team) and updating same table for some cause. > How can I set another procedure to wait until the time first procedure > completes. > How can I issue a lock on a row instead of…
Some questions about Dynamic Server - HELP
Hi, I am preparing a comparision of different RDBMs for my boss. I am curious about some questions (I can't find answers on Informix site). What phisical limitations for database elements does Dynamic Server have? I.e.: maximum count of tables = max size of one table = max size…
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…
Row locking in dynamic server
Rüdiger Breit wrote: > General question: how can I achive row locking in a > multi user environment. Seems not to work for me > > I experiences a problem with row locking with > Dynamic Server 7.3 under Linux. Even a simple > test would not run: > > Databse create with ANSI comp…
Segmentation faults in Solaris
I just recently started working on a Solaris system (SunOS 5.5.1, INFORMIX-4GL Version 7.20.UD1 INFORMIX-Universal Server Version 9.14.UC6X5 ) and I've been trying to port some programs that have been working just fine on SCO and AIX. Two of them die with a segmentation fault …
Distributions and dostats
In article <81edpn$249$1@nnrp1.deja.com>, kagel@bloomberg.net writes >In article <81cbr3$j13$1@news.xmission.com>, > Dick.Brieck@chase.com wrote: >> >> >> Greetings. I have a few questions regarding using distributions with >IDS. >> We're currently using >> IDS 7.30.UC6 on Sola…
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: SE Trigger/Exception problem
ackerbau@us.ibm.com wrote: > > A couple of thoughts (that may or may not apply): > > 1. Can you share the code? Might make it easier to pinpoint the problem. > Sure, but it's nothing out of the ordinary I don't think. Trigger and SP at end of this message. > 2. Have you incl…
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…
Re: ANSI mode DB's and DBIMPORT
David Williams wrote: > > In article <7u5mee$qf1$1@news.xmission.com>, Mark D. Stock <mdstock@myda > s.freeserve.co.uk> writes > > > >FProse wrote: > >> > >> Ran into an 'interesting' situation this weekend using > >> dbexport/dbimport to move an ANSI db between two servers (the …
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…
SPL exception for success?
I have a SPL routine that is giving the following exception for success. The command is (with definition): DEFINE bXtractSuccess BOOLEAN; Let bXtractSuccess = 'T'::BOOLEAN; The trace output is: expression:"T"::boolean evaluates to t let bxtractsuccess = t exception : lookin…
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.…
Re: record locks and timeouts
Mike Cabaniss wrote: > > Two questions on IDS: Good clear newbee questions. > 1. when doing an update a lock placed on the individual record or table > level? Depending on the table's lock mode, row or page (default page), a lock is taken on the data row or the page on which i…
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…
Correct use of the X/Open XA-Interface
Hi everybody! We want to do the transactional publish/subscribe in the context of a X/Open XA distributed transaction. We must think of two application scenarios: 1) the UDR's are called through ESQL, in a global distributed transaction context managed by CORBA OTS 2) the UD…
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…
xa_start TMJOIN supported ?
Thanks Mark - some more questions if I may .... You say that there can be locking problems between services in the same txn - is a "service" what is described in the manual as a "branch" ? I'm not clear of the relationship between branches and (global) transactions. Does this …
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.…
Informix 7.31
David McNight wrote: > > I am running 7.30 UC5 on a NCR MP-RAS 3.02 system. What does 7.31 > provide that 7.30 does not have? Does 7.31 support 4GL 7.20? Thanks > for any input :-)) IDS R7.31 feature enhancements include: o Non-logging tables. o Rename index command. o RETAI…
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…
Generating the referential constraints order from database
Gabor is correct! We can DEFER the constraint checking to the end of a transaction, meaning we must decide that INSIDE a transaction. Constraint checking will revert to the default (IMMEDIATE) as soon as the transaction ends. You can, however, change to DETACHED constraint chec…
threads + connections (same process)
I've had a problem with a certain database: open two connections within the same process, but different threads (Unix) and try to write to and commit to the same row simultaneously from the two different connections. Not only does table lock not occur correctly, but both thread…
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…
transaction isolation levels, and locking
Say I have two separate transactions. In the first transaction, I update a row in a table, but have not yet committed the change. Now, I would like for the second (and all other) transactions to see the *previous value* (which is the last value committed) of the changed row, u…
Tracing ALL sql queries - is it possible?
Thanks for the info. How much does it cost? In article <7drjvf$m8j$1@bgtnsc01.worldnet.att.net>, "Randy Reiter" <rreiter@sqlpower.com> wrote: > Yes - with ZERO database server impact. Refer to www.sqlpower.com. > > Below is a product overview and description of the two Sql Po…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Re: ZERO Impact Performance Monitor for Informix BETA program
Chuck, Per your question, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Pow…
Re: web datablade and security
PRESS RELEASE: The following Sql Power SniFFFer products for ZERO impact database service level and SQL transaction performance monitoring are about to be released in a few weeks for Informix: 1. '7x24 Global Sql Monitor' for 7x24 ZERO impact end user and database server Servic…
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…
A1A Informix Jobs Mail List >> Join our mail list
Sql Power Tools March 24, 1999 12 Barnfield Ct, Upper Saddle River, N.J. 07458 PRESS RELEASE: ZERO Impact Monitoring of Informix database servers: =================================================================== Sql Power Tools is pleased to announce…
Re: Q: How is the transactional behaviour in an Informix DB implemented?
Filip, Informix supports XA if that's what you're after. We use 7.22 with Tuxedo 6.3. There are some restrictions on what statements you can use in your Tuxedo servers, since Tuxedo (or whatever TM) now manages the transactions and the connections: you can't commit, rollback, co…
Q: How is the transactional behaviour in an Informix DB implemented?
Dear all, The X/Open DTP (Distributed Transaction Processing) standard defines the protocols to make a DB transaction capable. Can anyone explain me how these protocols are implemented in an Informix DB system? Are there any general rules which are usually followed when makin…
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?…
How setup a database on different host.
Liu Jiachuan wrote: > > Hi, everybody. > > I want to ask you some question. > My environment is that the OS platform is SCO unix release 5.0.4, and the > informix is online 7.3. I don't know whether the informix can support the > distributed database. I have fulfilled that the pr…
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…
Re: Two-Phase-Commit
You won't be able to do distributed transactions between an ANSI and non-ANSI database. rainer.von-bongartz@dil.de wrote: > I want to set up a two-phase-commit protokoll between an > unbuffered and an ANSI compliant database. > > I only get errors saying "cannot reference exter…
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: Update big tables !
Rok, You can move in two directions: 1. Increase logical log space. 2. Reduce size of the transaction by inserting COMMIT WORK operator(s). If update information comes as a flat file, you can split it and run more than one update process (sequentially or in parallel). No…
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 …
Re: Logical log size
Hi Carlson, first of all, rows that will not be changed during an update operation will not be logged, that is, if you set a field's value to the same value it contained before, this will not be marked as an update and therfore will not be logged in the logical logs. If you cha…
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…
Logical log size
I looked all around and couldn't find any info, so, here goes . . . How much logical log space is used on an update? I will be updating two columns (smallint) of each record on various tables in my system, along the lines of . . . update table_name set upd_a = new_v…
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…
onstat -x / onlog output
Hi there, I'm seeking for a way to track a transaction identified in onstat -x in the onlog -l output. Who can explain, how I find the XID from the transaction's address given in onstat -x ??? All the transactions I'm interested in are GLOBAL XA transactions, coordinator is IMS …
Re: Stored Procedure
The following modification should work: > let j = 1; begin work; > foreach cur1 for select testschalter into i from import > if i > 100 and i < 1000 then > update import set testschalter = j where current of cur1; > commit work; begin work; > let j = j + 1…
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…
TP/XA Informix and Transaction Servers
Hi ! Follwing is a press release from Informix, dated December 10, 1996. It states that Informix will support Microsoft's Transaction Server and that they will develop integrated client-connectivity components for = use with Transaction Server.=20 I'd like to find out if this p…
Microsoft Transaction Server & Informix
Hi ! Follwing is a press release from Informix, dated December 10, 1996. It states that Informix will support Microsoft's Transaction Server and that they will develop integrated client-connectivity components for = use with Transaction Server.=20 I'd like to find out if this p…
Re: locking
In <01bd4bfd$5f328f40$6df3e7cc@service.beijing.informix.com> "Birdman" <fanjun@writeme.com> writes: >ANTS <sui@naseej.com> wrote in article <6e1dbo$bpd$1@news.xmission.com>... >> We have a 4GL program whenever it runs it will lock several tables. The >> problem is that the lock…
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…
Re: week of year function
> easy. Adjusting for leap years, the DOW for any given date shifts > forward one day from the previous year (2 in a leap year) ... Only if that date in question is after Feb. 28. For instance, March 1, 1995 was a Wednesday, March 1, 1996 was a Friday, two days as stated in yo…
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…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Anthony Mandic <no_sp.am@agd.nsw.gov.au> wrote in article <3490B6CD.202C@agd.nsw.gov.au>... > Johan Andersson wrote: > > > So, *are you listening Anthony*, I propose the following test application, > > with an ever increasing transaction complexity, to show that the finer > > gra…
Re: Couple of problems...
} > Status: R } > } > Hello, } > } > I have two problems not related to each other. } > } > (1) I am using Informix ODS 7.10 and want to extract data onto ASCII files } > after left-padding and right-padding certain fields so that the load files } > working on these files…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: How to load table without log
dbload has an option for committing after X number of records. -Bill Adam Sorati wrote: } } Eng: online 7.23.UC1 } OS: AIX 2.4.1 } HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. } DB: 1.3 GIG } } Could someone please advise me of the best way to load } a table without using the …
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 ______________________________…
XA client support on NT
Does anyone know which level of Informix client do I need to get the XA (distributed transaction processing two phase commit API) support on NT 4.0? I currently have ESQL/C 7.20.TE1 for NT installed, and don't see any of the XA client DLLs. Will the NT client XA support work for…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: how does ODS uniquely id transactions?
Wanda, I don't have an answer for you but I can back you up with my own little investigations. I tried it myself out of curiosity and got the same results. So this is not an entry in the journal of irreproducible results. I found some other anomalies: - When I specified a us…
Re: Check whether in transaction or not
On Mon, 14 Jul 1997 15:12:30 -0400, while dropping acid Art Kagel <kagel@dg1.bloomberg.com> spewed: :Jayakumar George wrote: :> :> Hi , :> :> Is there a way to check whether we are in a transaction in 4gl. :> :> (Apart from using a begin work with whenever error statements). : :…
Re: Check whether in transaction or not
Art Kagel wrote: > > Jayakumar George wrote: > > > > Hi , > > > > Is there a way to check whether we are in a transaction in 4gl. > > > > (Apart from using a begin work with whenever error statements). > > Just set a global variable when you begin work to keep track of your > cur…
Re: Check whether in transaction or not
Jayakumar George wrote: > > Hi , > > Is there a way to check whether we are in a transaction in 4gl. > > (Apart from using a begin work with whenever error statements). Just set a global variable when you begin work to keep track of your current transaction status. Art S. Kagel…
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: Performance degradation question w/transactions
Roger Tomas <tomasr@agcs.com> wrote: :John Cowles wrote: :> :> Test 1: :> ------- :> :> Insert 100,000 rows into the table. :> Each insert is an individual transaction. :> Here is the excerpted SQL file I executed: :> :> begin work; :> insert into rows values ('key…
Re: Performance degradation question w/transactions
Roger Tomas <tomasr@agcs.com> wrote: :John Cowles wrote: :> :> Test 1: :> ------- :> :> Insert 100,000 rows into the table. :> Each insert is an individual transaction. :> Here is the excerpted SQL file I executed: :> :> begin work; :> insert into rows values ('key…
Re: Performance degradation question w/transactions
John Cowles wrote: > > Test 1: > ------- > > Insert 100,000 rows into the table. > Each insert is an individual transaction. > Here is the excerpted SQL file I executed: > > begin work; > insert into rows values ('key_0', 'anything', '0', 'today', 'today'); > co…
Re: Adjacent Key locking
Denham.M@amstr.com wrote in article <5n70ge$53r@cssun.mathcs.emory.edu>... > Nicholas > > As far as adjacent key locking is concerned, forget it. If my memory serves me correctly > this was an issue with V5 and earlier engines. Not V7. > > I cannot of course vouch for the fact th…
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?…
Re: What is a long transaction
Hi Stephane, I do this all the time. I use dbload which allows to specify how many rows to load before doing a commit. I suggest taking a look at that utility. A long transaction occurs when you ask the system to log a great of information in one transaction. The engine logs…
Re: Oracle & Informix connectivity/coexisting issues question
Dave Dargo wrote: > > > >4. Does Informix or Oracle provide assists for database access in a > mixed > > >database environment? > > Each supports their own product and ignores the other one. > > Actually, Oracle provides the Oracle Transparent Gateway for Informix. > This produ…
Re: Oracle & Informix connectivity/coexisting issues question
> >4. Does Informix or Oracle provide assists for database access in a mixed > >database environment? > Each supports their own product and ignores the other one. Actually, Oracle provides the Oracle Transparent Gateway for Informix. This product allows Oracle clients to acces…
Re: SQL code -246, ISAM code -154 problem.
On Wed, 22 Jan 1997 15:53:49 -0500, Peter Jennings <peter_jennings*@uk.ibm.com> wrote: >Peter Jennings wrote: >> >> Running OnLine V5.0 under AIX. >> We have a begin/commit process that locks a >> parent record by updating a column with its >> current contents. We find that if t…
Re: SQL code -246, ISAM code -154 problem.
Peter Jennings wrote: > > Running OnLine V5.0 under AIX. > We have a begin/commit process that locks a > parent record by updating a column with its > current contents. We find that if two users > try to update different rows in the same child > table, the first will suceed and t…
Re: FW: SQL code -246, ISAM code -154 problem.
The error and scenario you describe can be cause by one of three problems that I've encountered: 1) bug# 14829 - successive inserts and deletes can lead to negative pn_npdata. This occurs in some 5.0x version of online and is real fun to track …
Re: SQL code -246, ISAM code -154 problem.
P. Jennings wrote: }Running OnLine V5.0 under AIX. }We have a begin/commit process that locks a }parent record by updating a column with its }current contents. We find that if two users }try to update different rows in the same }child }table, the first will suceed and the other …
SQL code -246, ISAM code -154 problem.
Running OnLine V5.0 under AIX. We have a begin/commit process that locks a parent record by updating a column with its current contents. We find that if two users try to update different rows in the same child table, the first will suceed and the other fail with SQL code -246, IS…
FW: SQL code -246, ISAM code -154 problem.
We need more info to help but one thing you may want look at is your Isolation level. if you are not using dirty read you may run into locking problems of this type. Russ... }---------- }From: Peter Jennings[SMTP:peter_jennings*@uk.ibm.com] }Sent: Monday, January 20, 1997 2:…
Re: Oracle vs Informix comparison
David Williams <djw@smooth1.demon.co.uk> wrote: >In article <58if4p$oca@dfw-ixnews2.ix.netcom.com>, Rajashekar >Sundaramurthy <rajsekar@ix.netcom.com> writes >>You wrote: >> >> You are describing a synchronous replication scenario wherein the >>updating transaction waits for the…
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: Asynchronous Replication
David Williams wrote: > > In article <574i98$4d9@cssun.mathcs.emory.edu>, Carol Davies > <cdavies@csc.com> writes > >We had a demo of beta 7.2.2 from Informix yesterday for CDR. The GUI > >configuration administration is indeed run from a NT PC, and then > >configuration info is…
NewEra - pessimistic locking
I have an application which has two windows, both afcl tabbed windows with a master Supertable and several detail supertables. I want to use pessimistic locking on both the master supertables. Within the application, there is a requirement that the user is able to add a new rec…
Re: MULTIPROCESSOR OPTION 7.13
Allen Jantzen <allenj@ndr.com> wrote in article <327fa20d.27552573@news.netline.net>... > The Informix DSA Administrators Guide, version 7.1, page 10-18 says > > "On some two-processor computers, you should only run one CPU virtual > processor because the overhead of synchronizin…
Re: Locks in SPL
In article <32566B57.3F45@explorer.csc.com>, "Chao Y. Din" <cdin@explorer.csc.com> writes >Frank Orr wrote: >> >> Could someone please advise if they know of a way to force spl to wait >> a given period of time before returning an error when it encounters a >> locked row? >> >> I…
Re: Locks in SPL
Frank Orr wrote: > > Could someone please advise if they know of a way to force spl to wait > a given period of time before returning an error when it encounters a > locked row? > > I know you can set lock wait in 4gl and c but I don't believe this will > work in SPL. Also, is t…
Re: Is This Behavior Documented?
M. Livenspargar wrote: > > And if so, where?? > > I have a table with one column of datatype serial. The table has 2 > rows when I execute the following SQL in DBAccess: > > set isolation to committed read; > begin work; > insert into table1 values (0); > select count(*) from tab…
Re: Is This Behavior Documented?
M. Livenspargar wrote: > > And if so, where?? > > I have a table with one column of datatype serial. The table has 2 > rows when I execute the following SQL in DBAccess: > > set isolation to committed read; > begin work; > insert into table1 values (0); > select count(*) from tab…
Re: Is This Behavior Documented?
M. Livenspargar wrote: > > And if so, where?? > > I have a table with one column of datatype serial. The table has 2 > rows when I execute the following SQL in DBAccess: > > set isolation to committed read; > begin work; > insert into table1 values (0); > select count(*) from tab…
Is This Behavior Documented?
And if so, where?? I have a table with one column of datatype serial. The table has 2 rows when I execute the following SQL in DBAccess: set isolation to committed read; begin work; insert into table1 values (0); select count(*) from table1; rollback work; The 'select count(*)…
Re: Change of Logging Status: Implications?
Will Hartung - Master Rallyeist wrote: > > [ From no logging to logging problems ] > > I, personally, am a big fan of transactions. They let programmers do > all sorts of horrible things to the data, and then when they discover > a problem, they just go "Oops! Just Kidding!" and …
Re: Re[2]: HELP Informix Locks
tvarnas@compulink.gr (Apostolos Varnas) wrote: <snip> >it depends how the data you want to update is distributed on the pages.At the >worst case if it is distributed across 1000 pages you will need 1000 locks. <snip> >Assuming your data is stored contiguous it is then placed o…
Re: WWW and cgi and Informix
Robert Stuart (bobs@panews.press.net) wrote: : > "Larry Timmins" <timmins@ix.netcom.com> wrote in article : <01bb5cde.bb160c20$82f0b9cd@the-big-mipper>... : > : > If anyone is also working on distributed applications, involving PCs : with : > browsers : > surfing their Informix …
Re: WWW and cgi and Informix
> "Larry Timmins" <timmins@ix.netcom.com> wrote in article <01bb5cde.bb160c20$82f0b9cd@the-big-mipper>... > > If anyone is also working on distributed applications, involving PCs with > browsers > surfing their Informix database via HTML, Frames, and CGI (*perl, > isqlperl) scri…
Re: Advice for an Oracle Jock
> > Oracle has a bit of a technology edge right now. If the specific problems >you will be asked to address fall in that area AND you must solve it quickly, >then choose Oracle. But, you will pay and pay and pay through the nose for >the convenience. This edge is in the dist…
Re: Error -121 (cannot write log record) on update in Informix SE 5.01 in a Transaction
TA TUAN wrote: > > Informix SE 5.01 seems to have a problem with some kind of > transaction. > As reading a table, we update each rows of the same table, one row at > a time. If we commit after each update, no problem. In the case of a > global transaction (commit after the last…
Re: Error -121 (cannot write log record) on update in Informix SE 5.01 in a Transaction
TA TUAN wrote > >Informix SE 5.01 seems to have a problem with some kind of >transaction. >As reading a table, we update each rows of the same table, one row at >a time. If we commit after each update, no problem. In the case of a >global transaction (commit after the last updat…
Re: Error -121 (cannot write log record) on update in Informix SE 5.01 in a Transaction
In article <4oje35$hp5@news.sct.fr>, TA TUAN <tatuan@worldnet.fr> writes >Informix SE 5.01 seems to have a problem with some kind of >transaction. >As reading a table, we update each rows of the same table, one row at >a time. If we commit after each update, no problem. In the c…
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…
lock table doesn't!
I've hit a problem with Online v7. I have a 4gl application that allows (some) users to shell out. If I select this option, run dbaccess and run the following sql : begin work lock table update blah blah... commit work Online seems to ignore the lock table and locks each ro…
Re: Logical Logs
Dave writes: > Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with …
Re: Log files in Online 5.x
Hi, Unfortunately the only way I know of to change the log file size is to re-initialize. You can however add more log files which will help the long transaction situation. Just add some logs and then do a level 0 archive to enable them. -Bill > > Can anybody tell me an easier …
Re: Log files in Online 5.x
dave, > Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with very sm…
4GL WITH HOLD PROBLEMS
This is a multi-part message in MIME format. --------------20645BD73F63 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Can anyone help with the following problem? if so, could you post any comments or email me on jonathan@emltd.co.uk Thanks -----…
4GL HANGING PROBLEMS
Situation: I am using a cursor declared WITH HOLD to step through a series of records. I have two other cursors, an update cursor to lock the row and a normal cursor tpo refresh t he screen details, which are used as I step through the rows. All three cursors are prepared at the…
Tips on a highly available & scalable dbms needed
We are trying to select a relational database that will have the following properties: - Windows NT compatible: use native NT threads, and not be just a Unix-port to NT. Plus all of the product (tools, APIs, etc.) must function in the NT environment. - Scalable: up to 100 milli…
REPLICATION SERVER
REPLICATION SERVER ******************** Few months ago we had posted a news about out Global Replication server that replicates data among hetrogeneous databases online and real time maintainig transactional consistency an…
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
james.lawrence@epamail.epa.gov (Lawrence James) wrote: >In article <1f7cc$c2716.d4@news> Matthew Houseman <mhouseman@arborsoft.com> writes: >>isn't oracle replication simply PL/SQL? it may be easy to >>use, but don't we all feel the need for speed for this sort >>of technology…
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: HELP! My log is gone and I can't get up
In article <DJMxpo.vo@cuug.ab.ca> kniver@cuug.ab.ca (Roy Knive) writes: >Newsgroups: comp.databases.informix >Path: news.voicenet.com!netnews.upenn.edu!dsinc!spool.mu.edu!howland.reston.ans.net!swrinde!newsfeed.internetmci.com!in2.uu.net!uunet.ca!news.uunet.ca!cuugnet!kniver >Fro…
Re: Query - Two Phase Commit
Hi Suchitra, If you need Two Phase Commit implemented within the DBMS you need to use OnLine, not SE. SE does not have any built in support for distributed transactions. OnLine fully supports distributed transactions, with 2PC. Chris Jenkins Suchitra Rao wrote: > I wish to de…
Re: Market Share
tkyte@us.oracle.com (Thomas J Kyte) wrote: [snip] >No it doesn't. SE is basically a cheap, small database with NO >Multithreaded Server >Parallel Anything >Transaction Logging >BLOB Support >Database Mirroring >Distributed Features >24x7 Support >Row-level Locking >Replication …
Re: Faulty BEGIN COMMIT on Informix 4.1
andro@ibm.net (rk) wrote: > > Need assistance from Informix gurus out there! > > Is there any guarrantee that statements inside a BEGIN-COMMIT would be > done atomically. We are using Informix 4.1 on top of AIX 3.2, and we > have discovered that several times the BEGIN-COMMIT in …
Re: Faulty BEGIN COMMIT on Informix 4.1
On Oct 27, 4:03am, rk wrote: > Subject: Faulty BEGIN COMMIT on Informix 4.1 > Need assistance from Informix gurus out there! > > Is there any guarrantee that statements inside a BEGIN-COMMIT would be > done atomically. We are using Informix 4.1 on top of AIX 3.2, and we > have d…
Faulty BEGIN COMMIT on Informix 4.1
Need assistance from Informix gurus out there! Is there any guarrantee that statements inside a BEGIN-COMMIT would be done atomically. We are using Informix 4.1 on top of AIX 3.2, and we have discovered that several times the BEGIN-COMMIT in our programs missed a statement or tw…
US-TX-DFW Database Administrators
Job Opportunity Form Date: 10/18/95 Position Title: Database Administrators Industry: Lottery and Government Services Transaction Processing Systems Position Description / Experience: Years Of Experience: Varied Database Administrator positions available for candidates…
US-TX-DFW Transaction Processing Developers
Job Opportunity Form Date: 10/18/95 Position Title: Transaction Processing Developers Industry: Lottery and Government Services Transaction Processing Systems Position Description / Experience: Years Of Experience: Varied Multiple positions at a variety of skill levels…
US-TX-DFW Client/Server GUI Developers
Job Opportunity Form Date: 10/18/95 Position Title: Client/Server GUI Developers Industry: Lottery and Government Services Transaction Processing Systems Position Description / Experience: Years Of Experience: Varied Multiple positions at a variety of skill levels for …
Re: Out of data space error from 4gl
In article <RDLhNeP.tingb@delphi.com> tingb@delphi.com "Ting Barrow" writes: > Anyone have a fix or info? Simple program goes off and gets a record > based on sequence number, then goes to one of seven tables (based on code > in the returned record) to get actual data. No curs…
Re: BUFFERED LOGGING: Is it safe??
In article <42q2ib$9ah@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> wrote: >I want to make some minor amendments to Clem's answer, simply to clarify >the multi-user aspects of buffered logging... Most of your corections were correct, there was one exception how…
Distributed database
} Hello everybody. } } I've got a problem with data distribution - distributed database - over } network. We've got a "star network". Each site is connected with central } site. The problem is that the connection is via magnetic tape. } Could You advice me how to manage transacti…
Distributed database
Hello everybody. I've got a problem with data distribution - distributed database - over network. We've got a "star network". Each site is connected with central site. The problem is that the connection is via magnetic tape. Could You advice me how to manage transaction executio…
Re: Transaction Logging Multi-DB
>When using multiple databases and transaction logging is needed only >for one(db A), does logging need to be "on" for the other(db B)? The >application programs running in db A do lookups in db B, and vice >versa. We were told that for the "cross lookups" to work, logging >must …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: The truth behind UPDATE STATISTICS...
In article <bpayneD8F2A7.4wn@netcom.com>, bpayne@netcom.com says... >Could ISQL be doing the same sort of thing: >Opening an implicit transaction that needs to be committed before it >(the UPDATE STATISTICS) is actually flushed? Just a thought. It should be fairly easy to show …
Re: Not in Transaction Error Message -255
>From: Ruchi_Patel@avid.avid.com (Ruchi Patel) >Date: 9 Mar 1995 20:49:39 GMT >X-Informix-List-Id: <news.12087> > >I am working with online 6.0 version on HP 9000 platform. The database >uses unbuffered transaction logging. The 4gl program gives -255 error >message when I am tryi…
Safe Kill
We have a need for a shell which we can distribute to some of our supervisors to kill processes for users who have not logged out of a database. Don't ask why, the reason is ugly. A friend of a friend picked the following shell off the network sometime ago and recommended it's …
Switching Horses - Unix/Informix to NT/MS SQL Server
We're looking hard at this for a high volume, transaction processing application that would front end an Informix accounting/distribution system. Anybody have any good or bad experiences to share? We are evaluating this because of the increasingly better tools on SQL Server, an…
Questions about Informix Functionality
Hello. I am an ORACLE DBA, but I have been tasked to evaluate a product that uses an Informix RDBMS. I know very little about the Informix world, so forgive me if the answers seem obvious to you. 1. Can Informix support distributed processing, if so, what version? What distrib…
Which is faster? Cursors or Prepared statements?
I'm in the midst of reviewing an application which runs slowly and currently does not implement any locking (frustration sets in very quickly!). I want to accomplish two things: 1. Implement either COMMITTED READ isolation or CURSOR STABILITY in the main foreach loop FOR HOL…
Re: Shareware like I-Net
: A friend in need is usually on the net ! Veronica helped me find the package last night... What follows is the README file. Looks promising, brought it over to my system this AM. Joel ------------------------------------------------------ DSQL - Distributed SQL Ve…
Re: Loading database from script files
>From: sinues@prcd.prc.mrms.navy.mil (John Sinues) >Subject: Loading database from script files >Date: 10 Aug 1994 09:42:32 -0500 >X-Informix-List-Id: <news.8098> >I have an ASCII file containing a number of INSERT-INTO statements. I >want to execute this file and load an Infor…
Announcing ENCTALK (Encina)
Posting this for a friend --------------------------------- enctalk@imc.com Encina Transaction Processing Discussion An unmoderated discussion of transaction processing topics relating to the Encina transaction processing system. Discussions include client/ server architectu…
Announcing TE-TALK (Top-End)
Posting this for a friend: ------------------------------------------------ An unmoderated discussion of transaction processing topics relating to the Top End transaction processing system. Discussions include client/ server architecture, Distributed transaction processing, X/O…
Announcing Tuxedo Discussion Maillist Server
Announcing TUXTALK, TUXEDO Transaction Processing Discussion Mail List This is a moderated discussion of transaction processing topics relating to the TUXEDO transaction processing system and associated connectivity/productivity tools. Discussions include client/server architec…
Announcing Tuxedo Discussion Maillist Server
Announcing TUXTALK, TUXEDO Transaction Processing Discussion Mail List This is a moderated discussion of transaction processing topics relating to the TUXEDO transaction processing system and associated connectivity/productivity tools. Discussions include client/server arch…
ON-LINE GURU? Part time possible
I am looking for a high volume, large database specialist who knows Informix better than anybody else in the context of distributed, business transaction processing. We are a direct marketing company that works for many of the major PC software companies, processing software upg…
Re: Multi-thread client support in databses like infomix, sybase...
Sachit Malhotra (malhotra-sachit@cs.yale.edu) wrote: > We bought informix and got stuck with it. It cannot support a multi-threaded > client. > Informix has an SQL server which is multi-threaded, and each thread > looks after a process. But it cannot handle a process with multipl…
Re: Multi-thread client support in databses like infomix, sybase...
Well, if I understand DB-Library/CT-Library correctly, it support more than one session with a server in a single client process. And SQL Server itself has always been multithreaded... David Sachit Malhotra (malhotra-sachit@cs.yale.edu) wrote: > I have a question for all the da…
Re: Record Locking
bathini@netcom.com (Suresh Kumar Bathini) writes: >Hi There: >I have two clients in their transactions as below. >Client1----> > begin work > fetch a record R1 > > ..... > update R1 > commit work >Client2-----> > begin work > fetch a record R1 > update R1 > commit…
Re: Record Locking
Suresh Kumar Bathini (bathini@netcom.com) wrote: : Hi There: : I have two clients in their transactions as below. : Client1----> : begin work : fetch a record R1 : : ..... : update R1 : commit work : Client2-----> : begin work : fetch a record R1 : update R…
Record Locking
Hi There: I have two clients in their transactions as below. Client1----> begin work fetch a record R1 ..... update R1 commit work Client2-----> begin work fetch a record R1 update R1 commit Work Both the clients fetched the same record but client2 updat…
Multi-thread client support in databses like infomix, sybase...
I have a question for all the database wizards. Are there any databases around which can support a process with multiple threads? We bought informix and got stuck with it. It cannot support a multi-threaded client. Informix has an SQL server which is multi-threaded, and each thr…
Re: Two simple questions
>From: charliep@earlham.edu >Subject: Two simple questions >Date: Fri, 13 May 94 10:02:55 -500 >X-Informix-List-Id: <news.6728> > >Two questions from a neophyte: 2? I make it 5. >1. Does Informix support an API to SE and/or OnLine? I am looking for > something like Oracle…
Two simple questions
Two questions from a neophyte: Does Informix support an API to SE and/or OnLine? I am looking for something like Oracle's OCI or Sybase's DB-LIB rather than the pre-compiled ESQL. How is the concept of "user" handled in OnLine? When I looked at the ESQL demo programs there is…
RELEASE AT&T System 3000 Servers Achieve World Class Performance
This was written and released by AT&T Global Information Solutions ================================================================== AT&T System 3000 Servers Achieve World Class Performance Dayton, Ohio -- March 2, 1994 -- AT&T Global Information Solutions today announced reco…
Re: Record Locking and Performance Concerns
In article <2kvn5i$26j@rmg01.prod.aol.net> afajimw@aol.com (AFA JimW) writes: >A prospective client is concerned that our proposed Informix-based solution >won't provide the necessary level of performance. This is a real-time system, >with perhaps 10 users. I need to get some per…
Re: 4gl problem
John Musselman writes: > My Prob: The date is updated, BUT if a user updates a row and the does a next > followed by a previous (fetch_next and then a fetch_prev) the data displayed is > the OLD data... but if the user selects the same row on a subsequent query, it > refelects t…
Re: Informix TP-XA
As you pointed out in your posting below: >"INFORMIX-STAR is not supported in this version of INFORMIX-TP/XA". >I wonder whether it has anything to do my problem since I am running >I-STAR TCP/IP across the two machines. This is precisely why you get an error when your transact…
Reading locked rows
Hey folks, We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We talk to it using inet-pc 4.10 and powerbuilder running on windows. Today's question #1 is about reading locked records. Here's the scenario: buffered logging data base "foo" with table "bozo". …
concurrency control mechanism
Hi! I need to know what concurrency control mechanism informix 5.01 uses for concurrent distributed transactions. I know that it uses locking. Is that a 2PL? or does the sheduler compromize the serializability? Thanks a lot. sameer…
Global Data Dictionaries
Salutations! I'm currently doing some research on Global Data Dictionaries, and was wondering if anyone out there in net.land would be able to add to what I've been able to find (my bibliography is included below, in case that is of interest). My (perhaps incorrect) definition …
Re: ESQL/C transaction
In article <1rgqc7INN72m@emory.mathcs.emory.edu> unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah) writes: >I have multiple libraries of ESQL-C functions. A lot of them call one >another. Some functions also have begin/rollback/commit transactions. >Problem I face is before…
Re: Bug while fetching rows in OnLine 5.0
}From: uunet!cocamrd.mel.cocam.oz.au!sms (Steve Szalla) }Subject: Bug while fetching rows in OnLine 5.0 }Date: 10 Mar 93 01:43:25 GMT }X-Informix-List-Id: <news.2807> }There seems to be a bug in OnLine that affects whether rows can be }fetched depending on the isolation level us…
P Publishes Highest Performance for TPC-C Benchmark - Uses INFORMIX-OnLine
On Tuesday, February 2, 1993, IBM released the FIRST TPC-C benchmark results executed on open (non-proprietary) systems. The next day, February 3, 1993, HP released the second set of TPC-C benchmark results on open systems. Both benchmarks used INFORMIX-OnLine as the database m…
IBM Publishes First TPC-C Benchmark on Open Systems
Subject: IBM Publishes First TPC-C Benchmark on Open Systems On Tuesday, February 2, 1993, IBM released the FIRST TPC-C benchmark results executed on open (non-proprietary) systems. The next day, February 3, 1993, HP released the second set of TPC-C benchmark results on open sy…
OnLine and Tuxedo (clarification)
Someone called me to task, via email, on my response to the question about Tuxedo and OnLine, where I stated that TP/XA was required for 2 phase commit. Let me clarify that OnLine 5.0 has 2PC for homogeneous OnLine transactions, i.e. if you are using a regular front end (DBacces…
Re: Informix & Tuxedo
Excerpts from netnews.comp.databases.informix: 8-Jan-93 Re: Informix & Tuxedo David Kosenko@informix.c (782) > Note that two phase commit can only be accomplished using OnLine and the > TP/XA product. Two phase commit cannot be accomplished with SE. It > cannot be accomplished w…
Safe Updates of a bazillion rows
Naomi Walker writes: >If I want to update one column (all rows) in a table that has, say, >a million rows, with two indices, and I dont want to blow out my >lock table, or log files, is there a safe way, short of turning >off logging and doing an exclusive lock and begin/commit …
Re: Safe Updates of a bazillion rows
> If I want to update one column (all rows) in a table that has, say, > a million rows, with two indices, and I dont want to blow out my > lock table, or log files, is there a safe way, short of turning > off logging and doing an exclusive lock and begin/commit work? > > We are b…
Introduction of the Server's 5.0 manual set called "New Features."
Excerpts from mail: 10-Feb-92 Introduction of the Server'.. William Daul@uunet.UU.NE (3974) > Two-phase commit (INFORMIXSTAR only). The new two-phase commit > protocol allows you to manipulate data in multiple databases on > multiple OnLine database servers within a single trans…
Looking for info on Informix-Star
Path: emory!swrinde!cs.utexas.edu!uunet!zephyr.ens.tek.com!uw-beaver!ubc-cs!mprgate.mpr.ca!kho From: kho@mpr.ca (Peter Kho) Newsgroups: comp.databases.informix Message-ID: <1991Oct24.201217.10674@mprgate.mpr.ca> Date: 24 Oct 91 20:12:17 GMT References: <1525@das13.snide.com> Send…
Re: Repost: SCO UNIX Informix Development Package FORSALE!
Path: emory!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!wupost!uunet!zephyr.ens.tek.com!uw-beaver!ubc-cs!mprgate.mpr.ca!kho From: kho@mpr.ca (Peter Kho) Newsgroups: comp.databases.informix,misc.computers.forsale Message-ID: <1991Oct24.161645.8009@mprgate.mpr.ca…
Re: XA Compliant RDBMSs
Path: emory!wuarchive!sdd.hp.com!hplabs!hpcc05!hpyhde4!hpycla!hpcuhc!dhepner From: dhepner@hpcuhc.cup.hp.com (Dan Hepner) Newsgroups: comp.databases Message-ID: <2060011@hpcuhc.cup.hp.com> Date: 8 Apr 91 21:22:26 GMT References: <1120@tetrauk.UUCP> Organization: Hewlett Packard, …