Oninit® Archive
Results for “TXTIMEOUT”
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…
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…
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…
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…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
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…
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)…
upgrade from 11.70.FC4 to 12.10.FC4 onconf questio
HPUX 11.31 (11vi3) HP BL870c from 11.70.FC4 to 12.10.FC4 I'm testing our ERP upgrade to IDS 12.1 on our test server and after running the upgrade and checking the differences in the old and new onconf file I got a question or two. The new onconf doesn't have a VPCLASS aio setti…
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…
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?…
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.…
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
Original post: Fernando, Yes it has been a long time. Hope all is well with you. I tried onstat -G and the list was empty. I just stopped and restarted the instance and 2 locks immediately appeared ( same table ). The application was down at the time and they were no other co…
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…
DB Tuning question
Your bufwaits ratio is 27.6% indicating massive contention for the buffers or for the LRU queues. Increase the number of LRUS to at leas 128. Unless you zero'd the stats or started the instance less than an hour ago, your buffer turnover rate is fine indicating that you have suf…
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,…
Monitor CPU usage by Informix session
We had a situation where an Informix session brought the production Instance down to its knees. We restarted the instance and it happened a second time. Here are the server details: HP-UX uxprod1 B.11.31 U ia64, IBM Informix Dynamic Server Version 11.70.FC5, HDR cluster. The pro…
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…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
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.…
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…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
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?
> Thanks for your help. > Yes, it was a Java Application Server using distributed transactions and > this ran out of PermGen space so I had to kill -9 it. > Today I cannot figure out anymore why the transaction was not rolled back. > The instance is used for testing and developin…
IDS 9.4 Recursive Exception error
You are running a very old version that is out of support and this looks very much like a very old bug that was fixed long ago. The solution is to upgrade to a supported version that has the fix. The current release is 11.50.xC6 Art Art S. Kagel Advanced DataTools (www.advanced…
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…
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…
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 …
Checkpoint Duration
You do not show the ONCONFIG setting for the CLEANERS parameter. If LRUS is set to 256, CLEANERS should be set to 256 also (but at least the greater of 128 or the number of chunks). With too few page CLEANERS the write operations during a checkpoint will take longer and the criti…
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…
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…
Buffer manager internal error
Operating system? Amount of physical memory? <abdoell@yahoo.com> wrote in message news:7975e1ea-3985-463a-86cd-7b4950f7b8c8@p10g2000prf.googlegroups.com... > Dear Expert, > I need your expertise help, i got error as i put below. > What i need to know is, how to calculate SHMADD…
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…
How to solve -243 error ?
DEADLOCK_TIMEOUT is for distributed deadlocks which cannot be directly determined by the local instance (local deadlocks are determined immediately). TXTIMEOUT is for distributed XA transactions that become non-responsive when a remote participant drops out. DRTIMEOUT is for Ente…
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.…
Parameter tuning?
WH MAX wrote: > Pls see the instance profile and shared memory parameters below. > The problems I noticed are > 1. low read-cache-hit 35% > More BUFFERS. > 2. low write-cache-hit 79% > Doesn't matter. > 3. a lots of bufwaits and seqscans > Could be anything, but most likely an …
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. …
Re: informix 9.3 to 9.4 issue
analog todd wrote: > Hello, > I'm having some serious issues with a production instance of Informix > and I can't figure out why. > I'd been running 9.30.UC7 for over a year solid, no complaints. > Monday night, I installed 9.40.UC8 and its been awful. What am I > I presume tha…
Re: informix 9.3 to 9.4 issue
analog todd wrote: > Hello, > I'm having some serious issues with a production instance of Informix > and I can't figure out why. > I'd been running 9.30.UC7 for over a year solid, no complaints. > Monday night, I installed 9.40.UC8 and its been awful. What am I > missing? I've…
checkpoints Excessively slow
ABDESLEM ARBAOUI wrote: > hi all > > we have IDS 7.31 UC4 on unix with 2GB Memory > Platform info will normally help also: Sun, AIX, HP-PA, HP-Itanium, x86 Linux? First thing I'm going to suggest is an upgrade at least to 7.31UD8 if not going whole hog and moving to 11.10! Bey…
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…
Re: long checkpoints
I'm just curious: What's the row size of the table that's getting all the inserts? And how does that compare to your system's page size? Apostrof wrote: > hi, > i have some problem with the long running checkpoints in IDS 7.31.UD8 > on HP/UX. > every day a batch utility making…
Re: long checkpoints
On 21 Nov., 14:01, Apostrof <abdullah.ako...@gmail.com> wrote: > hi, > i have some problem with the long running checkpoints in IDS 7.31.UD8 > on HP/UX. > every day a batch utility making hig volume of insert and updates. and > this batch works about 5-10 minutes(checkpoint times…
long checkpoints
On Nov 21, 8:01 am, Apostrof <abdullah.ako...@gmail.com> wrote: > hi, Abdullah, You've got a lot going on. First thing I see is there should be a checkpoint between the two you've published since you have CKPTINTVL set to 200 or 3 mins 20 secs. Hopefully this is just because …
Replication performance problem related with DRINTERVAL
On Nov 8, 8:58 am, Yasar Akman <akman.ya...@gmail.com> wrote: > Hi, > > we are moving our application from tru64 to aix. Our application is an > real time application and performance is very important. We are doing > some tests on informix on the new platforms. But replication s…
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…
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'…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: IDS 9.4 instance can't initialize dbspace
Gary Quiring wrote: > Continuing the saga from my ontape restore to a different server I am > taking the suggestions to use archecker and IDS 9.4 to do a table > restore. My current server is 9.4. > I created an IDS 10 directory and changed all the paths and ENV vars to > use …
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.…
Checkpoint times
Hi Art, Informix mirroring is active, no RAID. Raw Devices with KAIO are used. But maybe you were right about the slow disks, I have measured datatransfer with dd and the disk with rootdbs seems to be slow. Mirror disk is reacting fast. I will shutdown the primary chunk and work…
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…
IDS 9.49 UC2 -> UC7 PDQ changes?
Schuran, Sven said: > Hi, > > We changed from UC2 to UC7 on a Linux box with 2.4 kernel. > > With the same configuration, UC7 runs out of memory, but I don't know why. > > PDQ is enabled. When I disable PDQ everything works fine. > One thing, the working sessions nearly all have …
Re: IDS Performance Problem
Thanks a lot everyone, for your valuable comments and helping me in tuning my IDS. I will implement these changes very soon. Regards, Navaid Arif ----- Original Message ----- From: Navaid Arif To: ids@iiug.org ; classics@iiug.org ; peoplemix@iiug.org ; informix-list@iiug.…
RE: IDS Performance Problem
Hi Navaid. How about the following. 1. Change priority btscanner. onmode -C high 2. Add btscanner onmode -C start If you re-bounce IDS, btscanner will set default. Regards. -- Tsutomu Ogiwara from Tokyo Japan. >From: "Navaid Arif" <navaid.arif@access.net.pk> >To: <ids@iiug.…
IDS Performance Problem
On Feb 7, 6:25 pm, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Dear All, > I am trying to fine tune my IDS. My system configuration is mentioned below. I am worried about XXX, I have 4 GB physical memory on IBM-P5 machine. I have set BUFFERS to 8000, # of LRUs to 8, # …
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 …
IDS 10 instance can't initialize dbspace
HI, Reduce your PHYSFILE 1008538 # Physical log file size (Kbytes) to a small value! Frank On 5 Jan 2007 13:52:28 -0800, Gary Quiring <gquiring@gmail.com> wrote: > > Continuing the saga from my ontape restore to a different server I am > taking the suggestio…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Parametro TXTIMEOUT
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...…
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 …
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
How do it get writes form the lrus in V10
Thanks to everyone for our response. I now understand that having all chuck writes is ok. Nilesh Ozarkar wrote: >> I think I should be getting LRU writes. >> > > Why ? does checkpoint takes too long to complete ? or checkpoint duration > is affecting transaction response time ? …
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: 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…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
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: Informix IDS 9.4 failed to initialized shared memory
Hi Chivi. Make sure your release notes in your $INFORMIXDIR/release/. If you config kernel parameter, the post the folliowing. oninit -v -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Chivi" <egmondragonm@yahoo.com> >Reply-To: "Chivi" <egmondragonm@yahoo.com> >T…
Informix IDS 9.4 failed to initialized shared memory
Chivi wrote: > I just installed Informix IDS 9.4 on Mandrake 10.1 Kernel 2.6.x > > I setup the onconfig file. the following are some of the parameters I > set: > # Root Dbspace Configuration > > ROOTNAME rootdbs1 # Root dbspace name > ROOTPATH /home/informix/…
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…
Need help!! Sql to Informix Migration
Not a lot of buffers for starters, this looks like an 'out-of-box' config, grab the performance guide, have a quick read and the use pf most the parameters will 'as if by magic' become clearer [cutting] > > SERVERNUM 1 # Unique id corresponding to a server > …
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 …
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…
Re: database reorg for large databases?
I'd never use dbimport for this - far too long. I'd do a select reorg using ALTER TABLE ... FRAGMENT IN, or maybe HPL. the ALTER FRAGMENT can be made to zoom along faster by setting PDQPRIORITY, and enormous (say 7200 second) checkpoints. <Darren_Jacobs@carmax.com> wrote in m…
database reorg for large databases?
Dear Darren, Option 4 : (variant of option 3 - how sapdba works) Instead of unloading and reloading all tables: for all dbspaces, do make sure you have a recent L-0 archive --just to be on the save side turn off logging of the database ; create new_dbspace; for all tables in db…
database reorg for large databases?
I'd never use dbimport for this - far too long. I'd do a select reorg using ALTER TABLE ... FRAGMENT IN, or maybe HPL. the ALTER FRAGMENT can be made to zoom along faster by setting PDQPRIORITY, and enormous (say 7200 second) checkpoints. <Darren_Jacobs@carmax.com> wrote in m…
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…
Informix UC7.41 - slow
Geezer From The Freezer wrote: > Hi, > > My Informix installation seems to be running quite slowly. It's running on a Sun > Blade > 1000 with 2 x 750Mhz processors and 2Gb RAM. > > Here is the onconfig file - anything obviously wrong or tuneable? Yes :D No such version as UC7.4…
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…
DB comes down w/ BUFFERS > 350000 ... UR down to 95%
Hello, This looks like bug 161674 "LINUX 32-BIT SERVER SILENTLY DIES DURING INITIALIZATION IF 'BUFFERS' ARE 260000 OR MORE. MAY BE RELATED TO '__PAGE_OFFSET' IN LINUX KERNEL" Fixed in 7.31.UD7. Regards Guy Anthony Presley wrote: > Hello all, > > Our DB has noticeably gotten s…
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'?…
long checkpoints
Karen, What platform are you on? Is it supporting KAIO? (take a look at onstat -g iov) It seems, you need to increase NUMAIOVPS to smth reasonable (like: number of physical disk drives) Is there any reason for setting " NOFUZZYCKPT 1"? If is very useful to take a look at onst…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Informix Tuning Problem
Andy Leung wrote: > My server run very slow for this few weeks.. I've checked the %cache go 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92 97670 146260 …
Re: Informix Tuning Problem
UPDATE STATISTICS? Andy Leung said: > My server run very slow for this few weeks.. I've checked the %cache go > 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: I may have missed it in your long post, but I didn't see anything about disc layouts or number of CPUs. Also I may have missed it as well but I couldn't see any output from "onstat -g iof" or "onstat -g iov". I have commented on your onconfig anyway. > OK …
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: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
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…
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.…
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…
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…
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…
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.…
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…
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.…
My Informix Never free up memory!
You need to review your code, you appear to have a memory leak and/or you are not freeing resources as you should. You could throw clint at the code, it's very good at spotting problems steven wrote: > > Hi, group > > My ESQL/C program run a insert/update loop to load about 90,…
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…
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…
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 …
Re: Err 243
> Dear, > I found an err code 243 in my online.log, CPU loading at that time was > around 90%+. does anyone know what the problem is??? and solution??? > here is my config. > > LOCKS 200000 > #BUFFERS 1536000 > BUFFERS 1126400 > NUMAIOVPS 2 > …
no checkpoint
Yes, I am using 64 bit Informix, The max LRU can be 512. So the only drawback from long checkpoint interval is longer recovery?? that's it??? "Franklin Tang" <franklin@macauslot.com> ���g��l��s�D :badmbv$eqo1@ctmsun0.macau.ctm.net... > Dear All, > I just want to know if I…
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 …
KAIO and HPUX 11.0 with multiple Informix 7.31 instances
It works fine for me, IDS 9.20 FC2 on HP-UX 11.0 Your SHMVIRTSIZE looks very small. Do you notice further segments being allocated (via onstat -m, or onstat -g seg)? If so, you should increase the size of SHMVIRTSIZE until this doesn't happen. Also, although not realted to yo…
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…
ODBC Connection Timeout?
Does anyone know if the TXTIMEOUT parameter in the $ONCONFIG file would time out an ODBC connection after the specified period of inactivity? We have a client making an ODBC connection to our informix server and it is losing it's connection intermittently. Any other ideas on wh…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: 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…
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…
Re: IDS 9.21 shared memory question
Also onmonitor has known bugs where it will change parameters without telling you when it should not! Description for Defect 112476 ONMONITOR WILL SAVE TXTIMEOUT VALUE IN HEX - THIS CAUSES IECC 4.0 TO ERROR "VALUE FOR TXTIMEOUT CONTAINS INVALID CHARACTERS" Workaround: Change th…
performance with very active threads
During a checkpoint you only have 8 cleaners utilized to flush 63 LRU's. That's 4 passes. Make LRUS=64 and CLEANERS=64. That's one pass. Let the disk subsystem figure out any contention. They're pretty good at that:) Also increase CKPTINTVL to every 30 minutes. Why have a …
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…
Oninit showed zeor CPU time
In article <8liipe$fnp$1@nnrp1.deja.com>, Wayne Trieu <trieu@ti.L- 3Com.com> writes >Hello, > When I do "ps -ef | grep oninit" I got couples "oninit" process >run but at lease three on them showed CPU time is zero. I wonder why and >how to I find out which oninit does what? …
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…
Shared memory as default communic. protocol
>ubject: Shared memory as default communic. protocol >From: meloi@my-deja.com >Date: 26.04.00 17:11 W. Europe Daylight Time >Message-id: <8e70tr$636$1@nnrp1.deja.com> > >We have Baan IVb2 >Porting set : 6.1c.04.02 >OS-release : AIX4.3.2.0 >IDS Version: 7.31.UC5 >Box:BULL RL >CPU…
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…
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…
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…
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…
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…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
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…
Re: Extremely Slow
From: CN Liu <cn@mail.sinyih.com.tw> > >The local Informix engineer told us to do 2 things: (1) increasing >number of logicl files to at least 6 and (2) updating statistics. Now we >have done these (the number of logical files is now 20 = 160MB total, >and I will increase it to 6…
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: error 25588
Dieter Powroznik wrote: > Hi! > > >From time to time our Informix-Dynamic-Server produced the > following error: > > -25588 The appl process cannot connect to the database server server-name. > An error in the application can produce this message. Check your > CONNECT statement …
Re: error 25588
I think you should also check your NETTYPE settings in server configuration. Best Regards, Octav On Tue, Aug 17, 1999 at 12:51:59PM +0200, Dieter Powroznik wrote: > Hi! > > From time to time our Informix-Dynamic-Server produced the > following error: > > -25588 The appl process…
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…
Re: shared memory error SCO install
Brian, You didn't specify what version of the engine/OS you are running. But you should change your SHMBASE to 0x82000000 aand SHMVIRTSIZE to 8192. Then check your release notes. With SCO you may have to install a patch or make changes to your kernel. HTH Joe ------------------…
RE: Problem with shared memory
In article <7k3kfv$4b2$1@news.xmission.com>, "Bernstein, Rick" <rbernste@alarismed.com> wrote: > > System : IBM RS6000 model F50 AIX v 4.2.1 (Dual processor) 512Mb memory > On this system we have 2 informix instances running : > 1 Informix version 7.3 UD6 (Recently upgrade fro…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
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…
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…
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…
RE: Checkpoints taking too long!!
One thing I have learned when it comes to tuning is that the first thing I should do is diagnose what is going on before I start changing parameters or anything else. If you had small checkpoint times before is becouse at that time the engine had little work to do. Now it doesn't…
Re: Checkpoints taking to long!!
>Hi > >I've run into a problem with the checkpoints on my production system - >they used to be all around 0 seconds long with the occasional 3 second >checkpoint - now they have increased to more like 10-15 seconds average >with a top of 20 seconds. We are running 730UC5 on a Se…
Checkpoints taking to long!!
What's triggering your checkpoints? Are they occurring at the interval, i.e. every five minutes, or more frequently? If they're every five minutes, try a more dramatic reduction of max and min dirty, say 10 and 5. Neil bridget wrote in message <36F82B39.C6D6833E@auckland.ac.n…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
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…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: 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…
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: +…
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…
chekcpoints, BUFFER settings, and optimization
I am trying to increase throughput and speed for an OLTP system using Informix 7.22 UC1 and would like some advice. The platform is a SUN Ultra Enterprise 5000 with 7 UltraSPARC 248 MHZ processors and 1 Gig of memory. I would like to minimize the length of checkpoints and maxim…
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 …
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…
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: txtimeout value for unlimited time
In article <33809ADD.5CAA@romac.com>, Timothy Jones <tojones@romac.com> writes >I want to set the TXTIMEOUT variable in the onconfig file so that it is >unlimited time. The default is 0x12c 300 seconds, but I see no >documentation for unlimited. > >Any help would be appriciated.…
txtimeout value for unlimited time
I want to set the TXTIMEOUT variable in the onconfig file so that it is unlimited time. The default is 0x12c 300 seconds, but I see no documentation for unlimited. Any help would be appriciated. TJ…
Re: Checkpoint duration increase with 7.22.UC1
Hi David, CLEANERS are set to 80. Amount of KB to write during the checkpoint will be 6880 KB, must be appr. 6.5MB. I don't know anything about their disk layout. But if they have more than one chunk per disk and if they are using KAIO, then they risk parallel writing to one dis…
Re: Checkpoint duration increase with 7.22.UC1
In article <5lak28$ssn@cssun.mathcs.emory.edu>, Kernoal Stephens <kernoals@earthlink.net> writes >I recently upgraded from 7.13.UC2 to 7.22.UC1. > >With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds. >I used the same onconfig settings with 7.22.UC1 and my average >che…
Re: Checkpoint duration increase with 7.22.UC1
In article <5kq94e$o4q@cssun.mathcs.emory.edu>, Kernoal Stephens <kernoals@earthlink.net> writes >I recently upgraded from 7.13.UC2 to 7.22.UC1. > >With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds. >I used the same onconfig settings with 7.22.UC1 and my average >che…
Re: Shared Memory allocation error
In article <5j3fd5$bt0@cssun.mathcs.emory.edu>, Mark Stannard <mws@appi.ci.in.ameritech.com> writes >All: > >I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. >When I run a query on a view that joins many tables online begins >allocating additional shared mem…
Re: OnLine 7.13 performance problems - comments please?
Ntruby@netcomuk.co.uk wrote: > > . .dra.com!feed1.news.erols.com!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com� > . !rill.news.pipex.net!pipex!netcom.net.uk!not-for-mail > From: Neil Truby <ntruby@netcomuk.co.uk> > .Newsgroups: comp.databases.informix > Subject: OnLine 7.13 perf…
Re: OnLine 7.13 performance problems - comments please?
Hi, Your output shows quite a few waits in several areas. One thing you can try if you can spare the resources is to change your lock level on database tables to row level locking (if not set there already). This will ease contention for the tables. Your read cache is about as …
Re: OnLine 7.13 performance problems - comments please?
Neil Truby wrote: } } We're running OnLine 7.13 under Solaris 2.4, on a Sparc 20 with 160M of } memory. The load is increasing, and the users are complaining about } performance. } } Here's my onstat -p in the 12 hours since I zeroed the stats: } } Profile } dskreads pagreads bu…
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…
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…
Re: HELP on shared memory segments increasing in a MAD way
In article <wrbucmplma.fsf@tglobe3.tollpost.no>, ogj@tglobe3.tollpost.no says... > >Fernando.Collalti@orbit.net ("Collalti, Fernando") writes: > >> Hello, problems, problems, problems...... >> It seems that after less than 1 hour the engine collapses. >> With HELP from Neil Truby…
Re: HELP on shared memory segments increasing in a MAD way
Fernando.Collalti@orbit.net ("Collalti, Fernando") writes: > Hello, problems, problems, problems...... > It seems that after less than 1 hour the engine collapses. > With HELP from Neil Truby now is getting better(decreasing > LRU_MAX_DIRTY and LRU_MIN_DIRTY) > > The system: HP9…
Re: HELP I'm in crisis
Collalti, Fernando wrote: > > Hello, > > System: HP HP9000 E35, 132MB RAM, Online 7.12.UC3 > These are my NEW Shared Memory Parameters: > LOCKS 2000 # Maximum number of locks > BUFFERS 30000(old=5000) # Maximum number of shared buffers > NUMAIOVPS …
Re: NO RESPONSE FROM SERVER PROCESS
Montree Saengchannukul wrote: } } Help me,please !!!!! } I use INFORMIX V.7.2 on IBM RISC/6000,AIX V.4.1.4. } (memory 256 MB,2 cpu) } I have some problem: } When my user can't connect to database (through ODBC) he tells me. } And in that time I call "onstat -i" it…
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: Loads of Paging Happening
Fernando writes: }We have a Delphi application that runs for more than an hour, the paging on }the }system is incredible!! After less than an hour the system "sits down"...... }I'm not able to use the system anymore. Not even thake the engine off-line. }The system is HP 9000 E35…
Re: Incredible paging on the system
Sorry, I didn't see the original post but, FWIW, this might help explain the problem. : > We have a Delphi application that runs for more than : > an hour, the paging on the system is incredible!! : > After less than an hour the system "sits down"...... : > I'm not able to use t…
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: Incredible paging on the system
Collalti, Fernando wrote: > > Hello, > > We have a Delphi application that runs for more than an hour, the paging on > the > system is incredible!! After less than an hour the system "sits down"...... > I'm not able to use the system anymore. Not even thake the engine off-line. >…
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…
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…
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…
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: 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 …
Turn off a PC:Problems on C/S
From: rsantis@ing.puc.cl (Renato Santis) Subject: Turn off a PC:Problems on C/S > [ Article crossposted from comp.unix.wizards,comp.unix.programmers > comp.databases.informi ] > [ Author was Renato Santis ] > [ Posted on 3 Apr 95 07:07:05 -0800 ] > > [background explanation dele…
Turn off a PC:Problems on C/S
[ Article crossposted from comp.unix.wizards,comp.unix.programmers,comp.databases.informi ] [ Author was Renato Santis ] [ Posted on 3 Apr 95 07:07:05 -0800 ] I have a dozen of instalations using Informix-Online & Star with several clients (PCs). When a PC make a query, and th…
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: 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…
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…
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…
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…
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…
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…
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, …