Oninit® Archive
Results for “USELASTCOMMITTED”
Error -243 ISAM -154 with Select sentence
Original post: Hi, We have a program esql/c that has the following sentences: set isolation to dirty read; set lock mode to wait 30; The program makes several select, update and insert operations Recently these error messages came out when executing a select statement: error…
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
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 ------------------------------…
RE: IBM Informix Dynamic Server Version 12.10.UC4W1
Hello SangGyu, many thanks for your response. I also believe that it is the defect you indicated. Your information will help me decide what to do. Have a nice day. Greetings Heinz WESTFLEISCH SCE mit beschränkter Haftung, Hauptsitz: Brockhoffstr. 11, 48143 Münster Amtsgericht Mün…
IBM Informix Dynamic Server Version 12.10.UC4W1
Hello Heinz, This problem is probably a defect of informix. It looks similar to what is described in the APAR below. Commonly, Informix 12.10.xC4 and below are in use and last commited function is enabled. In this state, AF occurs when an alter operation is performed on a compres…
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…
IDS 12.10 - temporary dbspaces locked
Hi, I have repaired that my systems have several locks over temporary dbspaces on syslocks. I have seen some information about using RAMDISK to improve performance. Can somebody give some help about this? How to do it and if it is the case, how can I detect that kind of concurre…
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…
Buffer pools in 11.50.FC5
IDS 11.50.FC5 Solaris 10 Sparc I need some guidance on BUFFERPOOL. I am receiving the 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 threads. I am not sure how that translat…
dbexport on RSS Secondary
Im running IDS 12.10.FC6 on SLES 11 SP 4 with a primary and RSS secondary on separate boxes. At http://www.oninit.com/presentations/v117.pdf I see the following: Enhancements To Dbschema, Dbexport & Dbimport It is now possible to use the dbschema and dbimport utilities on all …
Identify tables by session
Hi, I have some concurrency problems with some tables, I use the opn option over onstat, but there is any way I can get the tables name used on each session. Because I don't have any locks for informix, so it is difficult to understand the problem! I apprecitte any help! Thanks…
IDS - Record Lock
If a table is only ever used for selects, then the locking mode doesn't matter. For OLTP type systems where concurrency is required, you should probably be using row level locking for most tables, unless some tables have mass changes, where you may want to use page level, but th…
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)…
How to know the current isolation level in ESQL/C?
On Wed, Dec 30, 2015 at 7:28 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > please see the subject. > Please don't make us see the subject repeat the question in the body of the email. > How to know the current isolation level in ESQL/C? AFAIK, there isn't a way to discover the i…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
Trying to set USELASTCOMMITTED='COMMITTED READ' do
Okay, I found my problem. We have a shell-script called onmode acting as a wrapper which was used in this case, calling $INFORMIXDIR/bin/onmode. Calling $INFORMIXDIR/bin/onmode -wf .. directly everything is fine. The value was accepted. Thanks. On 06.07.15 12:16, Ricardo Henriq…
Can't dirty read uncommitted rows?
Thanks Fernanado and Mike, I thought it would be something basic. I missed seeing that USELASTCOMMITTED was set different in testing database. Regards, Bryce.…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix online index creation/deletion mechanism
Ok Art, thanks a lot for your explaining. I am comparing with other engines mechanism, that´s why I´m asking, Art. PostgreSQL for example, waits for any transaction to complete, before the index creation, and does a full table scan 2 times, in order to be able to do a concurrent…
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.…
Isolation modes in mach11 cluster
1) table lock level is row locks, SQL for each test iteration is as follows: Begin Transaction INSERT INTO infx_cluster_test (host_name, id, data) VALUES ('JUSTINK-PC', 756, 'fp''L+h2$}vxV6NPjS;GKZZp/upua"V') SELECT serial_num FROM infx_cluster_test WHERE serial_num = (select …
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Set lock mode to wait #
Hi all, This may be an obsolete question but "what are the implications of the following statements in concurrency control:" set lock mode to wait 10 update tab_name set..... Any adverse effects if we remove the "set lock mode to wait" statement?. NB: we dont' have "transaction …
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
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,…
Locks, locks everywhere
Hi people, asking from help again, hope you all doing fine. In 1 of our [data] servers we average more than 1000 users, there are informix 4gl applications, odbc and .net (sqli), the problem is there is some application's concurrency that cause a lot of locks, and you know bette…
change non-logged database to logged database
On Thursday, August 9, 2012 9:34:02 AM UTC+2, roger wrote: > To change non-logged database to logged database. Anything I need to change in 4gl program ? If I remember correctly, the default isolation level is different between a non logged database and a logged database (dirty …
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
Isolation level specified in JDBC data source not
I am using Glassfish 3.1.2 and Informix 11.7. Through the Glassfish administrative console, I have arranged for the setIfxIFX_ISOLATION_LEVEL method on an Informix DataSource implementation to be called with a value of 5. My database guru reports, when watching the connections …
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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 …
lock problem
check your isolation level as well. are you in repeatable read? thanks…
lock table in exclusive mode
[Second send; omitted the list first time.] On Tue, Jan 24, 2012 at 13:32, Tom Lehr <tomcaml@gmail.com> wrote: > the manual states "[Lock table in exclusive] mode denies other processes > both read and > > write access to the table". > Does it also affect the dynamic allocatin…
could not insert new row into the table
Currently this problem was not solved. Currently we are doing the data entry & there are 10 concurrently users insert the data. When there are max 4 concurrently users insert data that time there is no error occurred but when concurrently user greater than 4 that time it gives a…
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.…
SET ISOLATION TO COMMITTED READ LAST COMMITTED JDB
On Fri, Apr 29, 2011 at 08:20, SERVIO VELASCO <servio_velasco@hotmail.com>wrote: > Anybody know how to use "SET ISOLATION TO COMMITTED READ LAST COMMITTED" in > jdbc. > > How is connection string? > Can you set other isolation levels in the connection string? If so, you may als…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
Error IX000 on select for update
Hello, i've have this problem: When i execute this query: EXEC SQL BEGIN WORK; EXEC SQL SET LOCK MODE TO WAIT; SELECT bdc_stato_ddt FROM informix.bolcli WHERE bdc_key_soc = '5' AND bdc_key_tipo_bol = 'V' AND bdc_key_num_bol = 168582 FOR UPDATE sometime i've receive an error wi…
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…
rootdbs size
The problem, as someone already mentioned, is that you cannot position the physical log in a different dbspace during server initialization since only the rootdbs will exist at that time. Change PHYSFILE to something rather small (less than 300MB) and remove the no longer support…
Export the databases from secondary
Yes, you can do that. You can do dbexport on HDR secondary but sometimes export taken on that way (when HDR is still active) may have different number of rows for some tables in database.sql file, and real .unl file which is in database.exp folder ... To resolve this, you must e…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
Use of "SET ISOLATION TO DIRTY READ"
Using IDS 11.5.xC6, we've had a few occasions where user queries on one particular table in our application have resulted in errors like "-243 Could not position within a table". Executing "SET ISOLATION TO DIRTY READ" first and then running the query resolves the issues. So, is…
Determining lock table size
On Sep 25, 6:42 pm, red_valsen <red_val...@yahoo.com> wrote: > How can I determine the instance's lock table size? My instance is > configured for an initial one million locks, but my users are running > PeopleSoft processes which lead to lock table overflows. I can easily > se…
Config
BRIAN FOSTER wrote: > I am doing an intial tune for a new instance of 11.5 64bit. All of our > previous instances have been 32bit so I am unsure about my current shared > > memory config... do I have too many buffers? I am also wondering whether I can > safely add 1 or more CPU V…
Re: Mach11 questions
I not sure if this help to clarify any doubt... What the manual says (the last paragraph): http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids_sqs_2012.htm Isolation Levels for Secondary Data Replication Servers If the UPDATABLE_SECONDARY configurat…
What does "Dirty Read Last Committed" mean?
The description of USELASTCOMMITTED in onconfig file is: ############ Controls the committed read isolation level. Acceptable values are: - NONE Waits on a lock - DIRTY READ Uses the last committed value in place of a dirty read - COMMITTED READ Uses the last committed value in p…
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…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
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…
Seeing one oninit working hard while others are no
No the parameter is SQLTRACE which appears to be off, at least the config line you posted is commented out: #SQLTRACE level=low,ntraces=1000,size=2,mode=global Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that…
Understanding shared lock on database
Krishna wrote: > On Aug 26, 8:57 pm, Madison Pruet <mpru...@verizon.net> wrote: >> Krishna wrote: >>> When I execute a query (a select query) against another database, I >>> notice a shared lock being placed on that database. This lock is held >>> even after the query has complet…
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…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix 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.…
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…
Re: IDS 11 optimistic locking
Hi Clifton, Keep in mind this is for reads only. If you have two writers: Session A =========== begin work; update customer set fname="FRED" where fname="Fred" Session B =========== begin work; update customer set fname="fred" where fname="Fred" They will still wait the same…
Re: IDS 11 optimistic locking [2651]
Hi Clifton, Keep in mind this is for reads only. If you have two writers: Session A =========== begin work; update customer set fname="FRED" where fname="Fred" Session B =========== begin work; update customer set fname="fred" where fname="Fred" They will still wait the same…
Oracle to IDS 10/11 migration
In IDS 11, you can always use the last committed isolation level, by - > set isolation level to committed read last committed; or setting USELASTCOMMITTED ONCONFIG parameter. Regds, Uday. = "Andreas.KUTSCHE@ = spar.at" = <andreas.kutsche@ = To spar.at> ids@iiug.org = Sent …
Table Rows locking issue, how & Why?
Hello All, I am having problems due to the rows locking issue, the problem is that with the concurrency, that i have locking one row in a table but due to this other rows in that table also gets locked, this is very critical, can you please let me know what should be done??? i …
Re: Locking in ISAM files
amit.atray@gmail.com wrote: > On Jul 27, 9:07 am, Jonathan Leffler <jleff...@earthlink.net> wrote: >> amit.at...@gmail.com wrote: >>> I intend to use, record level manual locking on ISAM files. >>> my code will be somewhat like below >>> ==========================================…
Locking in IASM files
amit.atray@gmail.com wrote: > I intend to use, record level manual locking on ISAM files. > > my code will be somewhat like below > ====================================================== > fd_emp = isopen ("employee",ISINOUT+ISMANULOCK); > > isread (fd_emp,emprec,ISEQUAL+ISLOCK)…
RE: Named user lock facility in IDS?
On Jul 23, 4:07 pm, "Ian Michael Gumby" <im_gu...@hotmail.com> wrote: > David, > > So what you're trying to do is use the database to contain data so that your > external applications can > do some form of mutex locking? > > _______________________________________________________…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
utils2_ak
Please note that support added to dbcopy.ec for the use of COMMITTED READ LAST COMMITTED isolation level (-I) is NOT compatible with cSDK versions earlier than the v3.00 which is being released along with IDS 11.10 and so will not compile. I will be releasing a backward compati…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Re: IDS & WAS
Deniz Karakus wrote: > Hi again, > Our customer using IDS9.40FC3 with WAS 5.01 on AIX 5.2 for a financial > staff, And they realized to much more lock request activity for less > trancastions. while I was searching some info, I found > IFX_XASTDCOMPLIANCE_XAEND and DISABLE_B16242…
Re: Isolation level on Informix 9.3
agnoluck wrote: > Hi, > I have this problem: > > I have a Business Intelligence application (Board MIT) who reads data > from an Informix Server 9.3 on AIX OS. > > Board connect to DB server using ODBC driver, but when read some > transacted record, operation fails. I know exists…
Isolation level on Informix 9.3
Hi, I have this problem: I have a Business Intelligence application (Board MIT) who reads data from an Informix Server 9.3 on AIX OS. Board connect to DB server using ODBC driver, but when read some transacted record, operation fails. I know exists the ISOLATION LEVEL DIRTY REA…
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…
dirty reada to committed read
Hi, Refer the follwing link. http://www.iiug.org/waiug/archive/iugnew84.html Regards, Premnath Srinivasan "eferreyra" <eferreyra@gmail. com> To Sent by: …
dirty reada to committed read
Hi, i start a program that uses ODBC for connect to an informix (7) IDS, i start the connection with isolation level of dirty read, but in some point checking the SMI tables i see connection have isolation level of committed read. I dont change the level via set isolation level …
Isolation and Truncate Table - A Volatile Combination
Well, isolation levels (specifically serializable) and truncate table are causing controversy over in comp.databases.oracle.server. For the thread, try: http://tinyurl.com/yzuxxf It goes to a 120-character groups.google.com thread. -- Jonathan Leffler #includ…
Re: Let me be the first
Obnoxio The Clown wrote: > Mark Townsend said: > >>Fascinating > > > Personally, I think it's a very bad idea. Apart from all the effort needed > to maintain MV consistency, I can't wait to find out what the new model > breaks in our existing application world. > Nothing unless y…
Locking question
Surfer! wrote: > > Hi all > > Using 4GL (7.20) I am looking for a way of doing the equivalent of a > shared table lock on a row. > > The idea is to prevent a user coming along and taking an exclusive lock > on the row (and updating the information), but at the same time allowing …
RE: Let me be the first
Hi, Madison, Does it mean, that you are going to implement MVCC (multi-version concurrency control) in IDS? What type of MVCC are you going to implement: Postgress/MySQL-InnoDB type (when UPDATE is internally converted by the database server into INSERT, and all versions of a r…
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…
Comments please
>From a developer..... We perform locks on a table such as the following: update <table> set <col> = <col>; within transactions in order to create a lock on a row (to prevent deadlock/concurrency issues). These updates are not shown in the logical logs, presumably because it…
Isolation Level
folks, I have a stored procedure that all it does is a join lookup read: CREATE PROCEDURE my_procedure ( in_parameter VARCHAR(25,0) ) returning INTEGER; -- returns some count I am interested im DEFINE _count INTEGER; select count(tabel1.my_id) into _count from …
Index Levels
Query to find index levels. set isolation to dirty read; select tabname[1,18], idxname[1,18], levels from sysindexes, systables where sysindexes.tabid = systables.tabid and levels > 2 order by 1 asc,3 desc…
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…
using words - isolation levels vs locs
Ok. this is a question about the use of the verbal expression: Isolation Levels If you set isolation to dirty read, you are setting an isolation level. If you set lock mode to wait 2, is that still an isolation level? Nothing critical here, just an argument between coworkers. T…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
unexpected table lock
>> In my opinion the DBSA has to be able to monitor the status of a table at all times. >> How do you think about it? if that is the case and your apps fall over then: set isolation to dirty read; before you access tables. dependant on the logging mode of the db (informix lo…
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: Setting Isolation Level
On 2/1/06, Ekstrand, Pam <Pam.Ekstrand@oneneck.com> wrote: > I have an IDS 9.40FC6 database which receives queries from Sql Server 2000's > OpenQuery functionality. OpenQuery will only pass one select statement, so > the "set isolation to dirty read" cannot be passed followed by…
Setting Isolation Level
All, I have an IDS 9.40FC6 database which receives queries from Sql Server 2000's OpenQuery functionality. OpenQuery will only pass one select statement, so the "set isolation to dirty read" cannot be passed followed by another select statement. Does anyone have any ideas of h…
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: Retrieving SERIAL identifiers in a concurrent environment
So, in order to exploit it as a SQL query result, I should address a statement such as this (please gimme your advice...): SELECT SQLCA.SQLERRD[2]; Is that right? Furthermore: is that concurrency-proof (is it isolated from concurrent connections)? Thanks, Keith Simmons, Keith…
Retrieving SERIAL identifiers in a concurrent environment
Hello all Working on IDS 9.30, I need to retrieve the identifier (say: SERIAL-typed ID as primary key) of the latest row immediately after having inserted it, so that I'm able to refer it in related tables. Till now I've used the simple-though-awkward (brute force!) "SELECT FIR…
Re: informix market share
RollForward Wizard wrote: > TRUNCATE BANK ACCOUNT WITHOUT WAITING > SET CAPTURE TARGET ORACLE > FLUSH ACCOUNT > COMMIT > SNAP, SHOOT, ISOLATE, and LEVEL CUSTOMER -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
Using READ_UNCOMMITTED isolation level with Informix database and WAS
Hi, I am using WAS 5 and Informix 9.4 The requirement is that the transaction isolation level should be TRANSACTION_READ_UNCOMMITTED (Dirty Read). I have set this isolation level in Resource Reference. But, when I try to select from a table which has uncommitted changes from …
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
RE: isolation level
Pankaj- Lock mode wait is designed to allow statements to grab data as soon as the conflicting application finishes with it, rather than just erring out. I'd suggest using LOCK MODE WAIT 3 to allow 3 seconds for your update to complete. If application speed is not an issue, yo…
RE: isolation level
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Pankaj Patel (DHL US) Sent: Thursday, September 15, 2005 12:39 PM To: Art S. Kagel; prateek_mjv@yahoo.com; informix-list@iiug.org Subject: isolation level Art, I have…
isolation level
Art, I have lock isolation level question. I have a DB which is more like a look up DB, once in a while it gets updates and all the tables have page level locking. When the DB is accessed remotely sometimes application errors out with 243: Could not position within a table My su…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Isolation level
Hi Gurus I want to read some Informix tables from Oracle , I have Oracle Transparent Gateway but the Oracle isolation default is dirty read and informix is commited read. When Oracle Transparent Gateway send a select to informix it sends a "commited read" and sometimes I got tab…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
1.6 billion lockreqs
Geezer From The Freezer wrote: > If I have 1.6 billion lockreqs is this going to create a major problem (lag etc) > if so does increasing the locks help? lockreqs is a counter, so there has been 1.6 billion requests for a lock since IDS was started or onstat -z'ed, but that does…
Isolation levels in Informix vs Oracle
Sorry for not being clear; Here goes: what i ment was for the report: start trx at 13:59 complete at 14:00.00001 get the account info at 14:00.00000 define what one wants in reallity the trx should be part of the results. (it did not got rolled back and it started before the…
Isolation levels in Informix vs Oracle
--Concider the following situation: --An application is trying to analyze bank's balance --during the operational day - that is, some records --in the 'account' table might change while the query is running. --In Informix, DB2, MS SQL the only way to implement the --consistent …
Isolation levels in Informix vs Oracle
Hi, As you know Informix offers 'set isolation to dirty read' - a facility to read dirty buffers. I believe DB2 UDB too offers it but not Oracle. What is the neccessity or justification for an RDBMS to offer such a feature and do applications really need it ? I was told by an O…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
How do we set the isolation level.
Hi All, We need to change the default isolation level of a database at the datbase level. Is there anyway of doing this? Regards, Vijay Kumar sending to informix-list…
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: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
locking and processes outside the transaction....
BigBob wrote: > I need to lock a ROW in an Informix DB and hold onto that lock until > the end of a transaction. My first attempt at this was to begin work, > lock, etc. This worked great for the application itself. > > However, the problems arose in system testing we found some…
Re: opinions on this SQL statement
"Serge Rielau" <srielau@ca.eye-be-em.com> wrote > I doubt the isolation level has anything to do with that. > There is no rule that states that data needs to be re-read within a > single statement. > Whether intermediate results are TEMP'ed or not is up to the DBMS' > optimizer.…
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: Setting isolation level in Ace
Another useful place to look for this sort of information is : www.ibm.com/software/data/support I put in "Isolation Levels", selected solve a problem, and the first artivel returned was : Setting Isolation Levels in Ace and Perform This document explains how to set isol…
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: Setting isolation level in Ace
andykent.bristol@virgin.net (Andy Kent) wrote in message news:<a3525a11.0403030719.34c9f1f7@posting.google.com>... > Thanks, that's the one. Any idea what values it takes? > > I remember seeing it either in some Release Notes or marketing blurb, > but I've never seen it in any ma…
Re: Setting isolation level in Ace
I tryed it... just for learning... And I learn it didn't wrok.... That was time ago... but as far as I didn't need this I haven't tryed anymore... If this thing works it would be very usefull for browsing data while it is modified... Chucho! -----Original Message----- From: a…
Setting isolation level in Ace
I seem to recall reading about some environment variable (ACEISOL or something?) that you can set to determine the isolation level an Ace report will pick up. But I can't find anything about this in the manuals. Does anyone know how this is done? Andy…
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…
how to set the isolation to informix cursor stability thru ADO (in VB)
Hi all. My colleague has a problem. Anyone help the following ? Here is my colleague' e-mail. <<QUATE>> Hi, A question about set the isolation to informix cursor stability. Usually we can set the isolation level like this, cn.IsolationLevel = adXactReadUncommitted ' or adXactR…
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…
Fast Recovery (CKPT REQ) --- Blocked:CKPT
Informix Dynamic Server Version 7.31.FD1 SunOS 5.8 I am trying to restore from tape with onbar -r but the server keeps on going into a blocked mode. The server status is shown as : "Informix Dynamic Server Version 7.31.FD1 -- Fast Recovery (CKPT REQ) -- Up 01:36:50 -- 1332224 K…
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.…
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: lock table overflow
On Wed, 20 Aug 2003 16:22:36 -0400, "Mark Denham" <mkdenham@comcast.net> wrote: > >The number of locks that you require depend upon the work being performed >and the number of concurrent users doing work. > >20k worth of locks is very small in most OLTP environments that I have…
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…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re: Informix Connect 2.80 and Isolation Levels
> Does anyone know if there is a way to set the isolation level in the connect > string? Or is there a way to set this either by user or on the Informix > Client itself so that it is always default read uncommitted. > > I use an application that connects to databases. Problem i…
RE: Informix Connect 2.80 and Isolation Levels
I have a stored procedure for users connecting over ODBC to set their isolation level. Regards, Bill create procedure "informix".dirtyread_proc() returning int; define global sql_err, isam_err int default 0; define global err_text varchar(30) default null; on exception set sq…
Re: Informix Connect 2.80 and Isolation Levels
asdfasanjas "Dean Colter" <devodawg@yahoo.com> wrote in message news:9P5za.628$0E2.101742@news20.bellglobal.com... > Does anyone know if there is a way to set the isolation level in the connect > string? Or is there a way to set this either by user or on the Informix > Client it…
Informix Connect 2.80 and Isolation Levels
Does anyone know if there is a way to set the isolation level in the connect string? Or is there a way to set this either by user or on the Informix Client itself so that it is always default read uncommitted. I use an application that connects to databases. Problem is I can n…
Deadlock problem...
> I recommend that you downgrade to "committed read". If connection isolation level is "committed read" then why "java.sql.SQLException: Could not do a physical-order read to fetch next row." is raised? Sent via Deja.com http://www.deja.com/…
Re: Isolation Level
Srinivas Sreekumar wrote: > > Hi DBAs, > > In one of my database I am getting he below status when I give onstat. > Informix ver is 7.30 running on HP UX. I want to know why the database is > blocked and says that checkpoin is reqd. I have got enough free logical > logs. I'm not…
RE: Isolation Level
Hi DBAs, In one of my database I am getting he below status when I give onstat. Informix ver is 7.30 running on HP UX. I want to know why the database is blocked and says that checkpoin is reqd. I have got enough free logical logs. Informix Dynamic Server Version 7.30.UC3 -- …
Re: Isolation Level
eonder@my-deja.com wrote: > > Hello, > > I have found in the informix forum that for setting isolation level for > ACE report exist the environment variable SACEISOL. Is there an > environment variable for set isolation level for 4gl, isql, dbaccess > tools? No, but there is an …
Isolation Level
Hello, I have found in the informix forum that for setting isolation level for ACE report exist the environment variable SACEISOL. Is there an environment variable for set isolation level for 4gl, isql, dbaccess tools? Regards Enrico Sent via Deja.com http://www.deja.com/ Befo…
Re: ACE program and isolation levels
From: r_pastore@my-deja.com > >How do you set the isolation level in an ACE program? No matter what I >do I get a grammatical error saying it doesn't understand the construct. >The statement I'm using is: > >SET ISOLATION TO DIRTY READ > >I've tried with and without semi-colon, …
ACE program and isolation levels
How do you set the isolation level in an ACE program? No matter what I do I get a grammatical error saying it doesn't understand the construct. The statement I'm using is: SET ISOLATION TO DIRTY READ I've tried with and without semi-colon, before/after database statement and i…
ACE program and isolation levels
How do you set the isolation level in an ACE program? No matter what I do I get a grammatical error saying it doesn't understand the construct. The statement I'm using is: SET ISOLATION TO DIRTY READ I've tried with and without semi-colon, before/after database statement and i…
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…
shared fields between tables
Lora, This is another case of "Tell me how to make the solution to my problem that I can't make work, work." You're not the first to do this nor the last. PLEASE, post the problem not your solution and we can help. Based on the description here I have no idea what you want to…
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: Isolation Levels
On Tue, 26 Sep 2000, Daryl Craig-Elliot wrote: >Running IDS 7.30 UC7-1 for Linux. > >I noticed whilst trawling the iiug archives two environment variables >for setting default isolation levels for ACE & PERFORM, SACEISOL & >SPERISOL respectively. > >I was wondering if there is a …
Isolation Levels
Running IDS 7.30 UC7-1 for Linux. I noticed whilst trawling the iiug archives two environment variables for setting default isolation levels for ACE & PERFORM, SACEISOL & SPERISOL respectively. I was wondering if there is a similar variable for setting a general isolation level…
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…
Re: read dirty
Peter Czurak wrote: > I am developing an application in VB6.0 using ADO2.1. I want to Set > Isolation dirty read, How can I do that through ADO? > > Thanks > > Peter > pczurak@bigfoot.com Set the IsolationLevel Property of your ADODB Connection to the value adXactReadUncommi…
Re: Strange Informix Error messages
Nick Palmer wrote: > > Hi all, > > Hopefully someone here can shed some light on some problems we are having. > We are using IDS 7.31 on an HP box (HP/UX 10.20 I believe) and running a > client/server app using the Informix ODBC drivers. Sometimes when we are > using our app, we…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Read access to informix tables
From: Rudy Fernandes <rferdy@americasm01.nt.com> > >Change the query's isolation level to DIRTY READ, by adding the following >statement before your query > >set isolation to dirty read; >select .... Didn't I say that? :0) ________________________________________________________…
General concurrency question
We have a simple record locking schema for concurrency control in a critical code section: 1) WAIT UNTIL LOCK RECORD NOTFOUND 2) INSERT LOCK RECORD .. 3) INSERT ROW .. 4) DELETE ROW .. 5) DELETE LOCK RECORD The step 1 seems to work and sets users to wait their turn (waiting the…
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…
Lock Contention Mystery
4GL/IDS Gurus: We're currently running an on-line 4GL 6.01 application to maintain Item Information such as description, cost, retail, store authorization on an IDS 7.20 running on HP-UX 10.10 (HP K400 machine). During the night and on weekends we run several *concurrent* UNLOA…
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…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: SELECT FOR UPDATE problem
In article <881pv7$ul7$1@duke.telepac.pt>, "P.S." <psilva69 @ hotmail.com> wrote: > But if I use a repeatable read isolation level every select I execute (even > those that aren't meant to be for update) will lock the selected rows to > every user (even those trying to make a s…
SELECT FOR UPDATE problem
But if I use a repeatable read isolation level every select I execute (even those that aren't meant to be for update) will lock the selected rows to every user (even those trying to make a simple report to printer. Isn't it so? BTW we are using the COMMITED READ mode. Thanks for…
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…
Committed read
I am working on stock trading database where there is a 'quote' table accessed by multiple web users in commited read islation level. onstat -k shows a shared lock for placed. Now I want to alter table and change the page level locking of the table to row level. It returns an err…
update statistics concurrency with application SQL
roswil@my-deja.com wrote: > > In article <85ge56$se5$1@nnrp1.deja.com>, > roswil@my-deja.com wrote: > > Is there any real or serious problem with running update statistics > > concurrent with application's SQL ? Does locking occur that severely > > impacts contention between …
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…
ISAM error -113 in IDS 7.31
Micha Meier wrote: > > We are getting the error -243, ISAM -113 from time to time, in IDS 7.31.UC2 > on Solaris_x86 5.7. The funny thing is, that it says > > -113 ISAM error: the file is locked. > > Another user request has opened the file (table) that was requested in > exclu…
Isolation levels?
I am using 7.3 on NT I have looked in the Informix Guide to SQL: Syntax and on page 1-741 it lists all the supported transaction isolation levels. It lists Read uncommited exec sql begin work; set isolation to dirty read; or exec sql begin work; exec sql set transaction isola…
Dirty read isolation level
I've been playing around with changing some of my queries from read committed to dirty read, and I'm wondering, the only difference here should be not placing locks on the rows processed by the query, so it can't go any slower right?…
ODBC - Isolation Level
Hi All, I need to set Dirty Read as the default Isolation level for ODBC Users. The database has Unbuffered logging. Please, help. Informix 7.30 UC8 Solaris 2.6 DataDirect Connect ODBC 3.50 for Windows 9x/NT Crystal Reports, MS Access Is there any way to set the isolation leve…
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: lock problem
From: "Sackwitz, Antje" <Sackwitz@vst.vossloh.de> > >coming from the Oracle world I focus a problem in my informix database. >In a table with a lot of concurrent activities on that table (insert , >update, select) >and having a lot of rows the select very often runs into a lock a…
lock problem
Hi, coming from the Oracle world I focus a problem in my informix database. In a table with a lot of concurrent activities on that table (insert , update, select) and having a lot of rows the select very often runs into a lock and therefore can't proceed the select. How can I con…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Isolation Level and sacego V4.1V
IIUG Gurus, we use some reports with sacego V4.1V and have set 'SACEISOL=dirty read' on the application server. From time to time the isolation level was not set and the Informix data base reported a lock table overflow (the max. of 256000 locks are configured). It seems that it…
Adjacent Key Locking!!
Hi, Has somebody heard something about Adjacent Key Locking??? If you have isolation level repeatable read and selecting, deleting or updating an indexed table (row locking) than the next row will also be locked. Does anybody know the reason for that or where I can find informat…
Re: 4gl experts ( Mr. Leffler?) please help, how can I speed up this 4gl?
In article <37B96EAE.41EA7DA0@bloomberg.net>, kagel@bloomberg.net wrote: > Obnoxio The Clown wrote: -- SNIP -- > > Can't argue about the rest, but why do you say this? I've never > > seen any empirical proof that page level locking offers any > > performance benefits... > > I'm…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Re: ODBC - "ODBC Call Failed" - PLZ HELP
>> 1) Have an ODBC driver that is capable of prefixing each query to the >> Informix engine with the isolation level change outlined above. Openlink Multi-tier drivers have this capability. You can specify a series of SQL statement that get executed automatically everytime a ses…
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…
Row lock level
Jorge Puente Beltran wrote: > > Hi all, > > Could someone explain me how Ifx manage lock level? I'm working with an > IDS 7.30 and suffering the next: > > I got a table with row lock level. It has a unique cluster index by two > of its columns. I´m locking one row…
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…
Re: Isolation level and ODBC
Richard Spitz wrote: > > Hi Informixers, > > in the c.d.i. archives, I found several statements that the isolation > level could be set via ODBC through a SQL passthrough statement with > the proper command "set isolation to <...>". > > What is the scope of this statement? I have…
INSERTING INTO A DATABASE TABLE CONCURRENTLY
Vincent Birlouez wrote: > > Hello, > > Is it possible for more than one process to insert rows into a databse table > at the same time? > > I have more than one "C" processes that want to insert rows into the same > table concurrently. Some of them succeed but others fail with an…
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…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
isolation level question ?
Hi, I know the difference between the cursor stabililty and repeatable read, but what I need is to lock only the latest row fetched (as cursor stability) and the lock is released only when the transaction commits or rolls back , not when the cursor is closed (as repeatable re…
isolation level "indexed repeatable" ?
Hi. browsing through the "Informix Universal Server Performance Guide 9.1" I noticed a fifth isolation level. Or to be more precisely, the "repeatable read" is split up in "indexed ..." and "sequential ..." (page 2-34, LOCKS parameter). Is this another isolation level? The Synt…
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?…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Anthony Mandic wrote: > > David Williams wrote: > > > Imagine 1 page with 2 rows one it. > > > > 1. Page level locking > > > > User A updates row 1 > > At the same time user B updates row 2. User B has to wait for > > User B to commit. > > You're forgetting l…
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.…
Informix access concurrency in MT environment
Hello, We have previously designed a shared library in HP-UX 9.04 (Position Independent Code), with esql/C. We want to port our shared library in multi-threaded environment HP-UX 10.20 As a result, our shared library will be called by threads at approximate…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: ODBC, NT and Workgroup problem
As I don't need transactional work, I have executed this: ontape -s -L 0 -N my_BD_name and all 244, 243 and 271 errors have gone away. Before do that I also try changing bloking to page and so on, but my problems continued. Salute. In article <362FF485.7BF59F08@inx.net>, …
Re: ISOLATION LEVEL
On 26 Oct 98, at 21:00, John Kasprzyk wrote: > I thought the isolation level was 'committed read' not 'read committed'. It depends: there is now support for the ANSI terminology. SET TRANSACTION is roughly equivalent to SET ISOLATION, but what follows is laid out differently. …
Re: ISOLATION LEVEL
I thought the isolation level was 'committed read' not 'read committed'. And that it requires that what you are select has been committed to the database. Since you are attempting to read everything in the table and you are requesting that all the rows be committed, you get an e…
ISOLATION LEVEL
Hi! I have a problem with the ISOLATION LEVEL. Session 1 ======== begin work; set transaction isolation level read committed; update table1 set... where cle = 1 ... ... Session 2 ======== begin work; set transaction isolation level read committed; select * from table1 ... ... …
Re: ODBC, NT and Workgroup problem
Walter S. Tyszka wrote: > > Perhaps the type of locking used by the datasource is not the issue? > The isolation mode (or concurrency) of the user's process is what you > need to consider. > The sugestion by Mr. Kagel to "SET LOCK MODE TO WAIT n" is one posible > solution. Anoth…
Re: ODBC, NT and Workgroup problem
We already have those two set as the default database setting. But, we still get these errors from time to time. Any other reasons why? Thanks. Jun Nolasco nolasco@inx.net Walter S. Tyszka wrote: > > Perhaps the type of locking used by the datasource is not the issue? > The…
Re: Best database for web backend on Linux?
In article <70oiem$phd$1@news.bctel.net>, "Thor" <thor@echidna.net> writes: >we're still talking at cross purposes here. >if we're using "browse-mode" as the starting point .... > >The Optimistic Locking is: > >t1. Read >t2. Re-Read with Lock >t3. Update >t4. Commit / Rollback > …
Re: ODBC, NT and Workgroup problem
On Thu, 22 Oct 1998, Jun Nolasco wrote: > But, why is it that even with row level locking, these errors still > occur eventhough no one else is currently using the record in question > (but with others holding locks on other records)? And from the error > messages, it looks like…
Re: ODBC, NT and Workgroup problem
Perhaps the type of locking used by the datasource is not the issue? The isolation mode (or concurrency) of the user's process is what you need to consider. The sugestion by Mr. Kagel to "SET LOCK MODE TO WAIT n" is one posible solution. Another would be to "SET ISOLATION TO DIR…
Re: ODBC, NT and Workgroup problem
But, why is it that even with row level locking, these errors still occur eventhough no one else is currently using the record in question (but with others holding locks on other records)? And from the error messages, it looks like it is the index record that is locked, not the d…
Re: ODBC, NT and Workgroup problem
Jun Nolasco wrote: [Reply SNIPPED] > asevillano@gesfor.es wrote: > > > > Hello all, > > I have a problem in a NT 4.0 with INFORMIX Workgroup 7.23 and ODBC (Informix- > > cli). When I insert a lot of records with a unique program there is no > > problem, but when I execute severa…
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…
Re: Best database for web backend on Linux?
In article <70jkv7$t5q$1@news.bctel.net>, "Thor" <thor@echidna.net> writes: >Why are you assuming that row level locking requires you to lock the data on >read/browse??? LONG transactions are even better when you can get atomic, >row-level, locks rather than page locks. Unless …
Re: Best database for web backend on Linux?
In article <70ijo9$r3i$1@news.bctel.net>, "Thor" <thor@echidna.net> writes: > It sure saves a tonne of coding (grab the sybase docs and read the = >timestamp work they suggest for high availability and avoid blocking, = >yuck). I think that you're speaking of Sybase's "browse mo…
Ace set isolation level
Found my answer. TechInfo # 3285 Short Description: Using SACEISOL to set isolation level in an Ace report Long Description: [Note: This applies to versions of Ace 4.12 and 6.00 or greater -dranney] >From: candiceh (Candice Hern) Subject: Re: isolation le…
Ace reports and Isolation levels
Is there any way to set an Insolation level within an ACE report?…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: Locking and Isolation Levels
We have a 24 x 7 system (well, almost) and our approach is to carry out a lot of small transactions to allow the users to work between the cracks. We select the primary keys of records to be deleted into a temporary table. Then we loop through the table, deleting each associate…
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 …
locking and transaction isolation level
Hi, my company has an DB-bases product which lives of many and huge transactions (transactions which have an duration of 1 minute). We have an ONLINE DB 7.23 UC1, customers of us use INFORMIX ONLINE 7.22 - 7.30. All versions of the ONLINE DB have the same problem(?) which can be…
Re: Is this a Bug or not?
I am trying to "Insert" a record. Isolation levels will help for "Select" , "Update" and "Delete" only NSI001 wrote: > You need to set the isolation level appropriate. The yout problem will be > fixed. > > Klaus Nonne > kn@nsi.de…
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
INFORMIX-CLI and isolation level
Hi, is anybody know if i can change the default isolation level when i work, for example with Access, through INFORMIX-CLI ? The database mode i work this is 'Buffered Log' so the default isolation is 'Committed Read'. But i prefer to work with dirty read to ignore locks on que…
Re: Is this a Bug or not?
You need to set the isolation level appropriate. The yout problem will be fixed. Klaus Nonne kn@nsi.de…
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: Locking and Isolation Levels
rbruenin@my-dejanews.com wrote: > > We have an application that adds records to a table. It runs constantly and > uses a stored procedure. The first thing it does is > Lock Table in Exclusive Mode > > At night we have a purge process that drops records from this same table. …
Re: Locking and Isolation Levels
rbruenin@my-dejanews.com wrote: > > We have an application that adds records to a table. It runs constantly and > uses a stored procedure. The first thing it does is > Lock Table in Exclusive Mode > > At night we have a purge process that drops records from this same table. …
Re: Locking and Isolation Levels
I'm not sure of what your intending to do. Informix supplies row level locking. If you have a pending transaction that inserts, updates, or deletes a row no other session can modify that row until the transaction completes. What is the prge process supposed to do? Why did you see…
Locking and Isolation Levels
We have an application that adds records to a table. It runs constantly and uses a stored procedure. The first thing it does is Lock Table in Exclusive Mode At night we have a purge process that drops records from this same table. It also does a Lock Table in Exclusive Mode…
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…
isoalation level
This question is for anyone using PeopleSoft. Does PeopleSoft recommend a certain isolation level for the database? My system is currently using CR for isolation. the problem is it is doing alot of locks. I think think this may be causing some performance problems. Paul J. Brais…
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: Baan IV / NT / SQL Server
We've been running on SQL Server since Oct 96 with 50 users. pcwong ott888208@intranet.ca rlwan@my-dejanews.com wrote: > Has anyone out there successfully run Baan IV, on a NT platform, using the SQL > Server engine? From my research, there are a number of companies running B…
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…
Baan IV / NT / SQL Server
Has anyone out there successfully run Baan IV, on a NT platform, using the SQL Server engine? From my research, there are a number of companies running Baan & NT, but they're using Informix or Oracle. The business unit will have less than 20 concurrent users so row locking vs p…
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…
Problem with isolation level and ODBC
Hi all I'm an amateur programmer with Visual Basic and this is the first time I use ODBC. My problem is that when I connect to the database via Informix CLI, the sesion runs with REPEATABLE READ and I need to change that isolation level but don't know how to do it. H…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: "LOCK MODE TO WAIT" seemingly ignored
Mark Stevans wrote: > Hi. I'm programming in ESQL/C on Solaris for Informix 7.12. After my > "CONNECT" statement, I issue the statement "SET LOCK MODE TO WAIT", and > then my app does lots of "INSERT" operations. No problem when I run the > app alone. > > But when I try to ru…
"LOCK MODE TO WAIT" seemingly ignored
Hi. I'm programming in ESQL/C on Solaris for Informix 7.12. After my "CONNECT" statement, I issue the statement "SET LOCK MODE TO WAIT", and then my app does lots of "INSERT" operations. No problem when I run the app alone. But when I try to run multiple copies of my app conc…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: Informix vs. Sybase vs. SQL Server vs. Oracle
Andreas Zeugswetter wrote: > Oracle's only advantage is with concurrent read and update, > since it does not need a read lock. > But if you use dirty read isolation, you don't have read locks in > Informix either. Oralce read a row without read lock and get current value withou…
Re: Informix vs. Sybase vs. SQL Server vs. Oracle
Liu jun wrote: > > Laura P. Grahame wrote: > > > > I am looking for guidance on selecting a database backend which can handle > > the multiple simultaneous row updates without slowing. > > That sounds like you want to select a DBMS backend with high performance > of Currency Cont…
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: Pessimistic Locking via ODBC
I use a stored procedure that I call from ODBC execDirect which returns to me the available number from table the procedure is something like this procedure next_serial() returning int set lock mode to wait 15 begin work select max(next_num) into next_num from tab1 let new_num = …
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <3482318D.C4112DA5@voicenet.com>, "Scott C. Gray" <ickyspam_gray@voicenet.com> writes >David Williams wrote: >> >> In article <3481D92B.75AA9F0D@voicenet.com>, "Scott C. Gray" >> <ickyspam_gray@voicenet.com> writes >> >> page level locks give HIGHER PERFORMANCE yes B…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
David Williams wrote: > > In article <3481D92B.75AA9F0D@voicenet.com>, "Scott C. Gray" > <ickyspam_gray@voicenet.com> writes > >> page level locks give HIGHER PERFORMANCE yes BItUT the reduce > >> concurrency and hence LOWER RELIABILITY. > > > >Be careful with your wording...…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <3481D92B.75AA9F0D@voicenet.com>, "Scott C. Gray" <ickyspam_gray@voicenet.com> writes >> page level locks give HIGHER PERFORMANCE yes BItUT the reduce >> concurrency and hence LOWER RELIABILITY. > >Be careful with your wording...locking granularity has nothing at >…
Re: Isolation Level
Try: onstat -g sql. This will give you an output line for each session that include isolation level, as well as database, lock mode, and some other status information. -Bill > > Hi. > > How can I know the current isolation level for a session? > > Thanks. -- Bill Ennis …
Re: Isolation Level
Alain Martin wrote: > > Hi. > > How can I know the current isolation level for a session? Try: onstat -g ses <sid> Look under the column: Iso Lvl Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix …
Isolation Level
Hi. How can I know the current isolation level for a session? Thanks.…
Re: isolation level RR
katarina, If you don't use transaction, may be you will get what you want. Good luck! -- ********************************************************************** SI Business Team/S/W Dept./Sales Dev. Daou Technology Inc. 6F,DaeAh Bldg.,707-7,Yuksam-Dong Kangnam-Gu,Seoul,Korea Tel:…
Re: isolation level RR
} Date: Tue, 11 Nov 1997 16:52:58 +0100 } From: Martina Lang <martina.lang@mch.sni.de> } Reply-to: martina.lang@mch.sni.de } Organization: SNI Munich } To: Katarina.Hamzova@swh.sk } Subject: Re: isolation level RR } Katarina Hamzova wrote…
Re: isolation level RR
} Date: Tue, 11 Nov 1997 16:52:58 +0100 } From: Martina Lang <martina.lang@mch.sni.de> } Reply-to: martina.lang@mch.sni.de } Organization: SNI Munich } To: Katarina.Hamzova@swh.sk } Subject: Re: isolation level RR } Katarina Hamzova wrote…
Re: isolation level RR
Katarina Hamzova wrote: > How does isolation level repeatable read work > I thought it places share locks on every row > selected in queries in transaction - > i did this: > begin work; > set isolation to repeatable read > select * from table where ... > ... > i expected it p…
Re: isolation level RR
Katarina Hamzova wrote: > PLEASE HELP ME > > My question : > How does isolation level repeatable read work > I thought it places share locks on every row > selected in queries in transaction - > i did this: > begin work; > set isolation to repeatable read > select * from tabl…
isolation level RR
PLEASE HELP ME My question : How does isolation level repeatable read work I thought it places share locks on every row selected in queries in transaction - i did this: begin work; set isolation to repeatable read select * from table where ... ... i expected it places locks o…
NEWERA -- Pessimistic locking
In pessimistic locking changes are automatically applied to the database when a row loses focus (or is it concurrency). But in my application I want to prompt the user to accept the changes or not. No problem, put message in the beforeRowApplied event and return true or false. T…
LOCK IN ROW
Hi Folks, I have a problem, when updating a row in my database (defined with buffered logging) as part of a transaction, another user than try to make a select statement in the refered table can't do it. The problem is a lock placed in rows other than the one updated. The t…
Re: HELP: Lock rows in Informix SE
In ver 5 SE or ONLINE, you may get locking error even if the row you are trying to update is not locked. There is something called adjacent row locking. E.g., if row A, B , C are in sequence, and you try to update B, we lock not only B, but A and C as well. We need to do that …
Re: HELP: Lock rows in Informix SE
In <34282B0B.82B@bloomberg.com> "Art S. Kagel" <kagel@bloomberg.com> writes: >It looks like you are being locked out of the row or page that you want >to update. What is the table's LOCK MODE (select locklevel from >systables where tabname = "mytable";)? If page mode (lockleve…
Re: HELP: Lock rows in Informix SE
Florian Kerbl wrote: > > UPDATE tablename > SET field = value > WHERE condition > > The above only works if the affected table is not already open. If the > table is open we get the following error messages: What do you mean "table is not already open". What other transactions …
Re: Lock Escalation
Does "SET LOCK MODE TO WAIT" affect uses performing SELECT statementes? I have not been successful in preventing users from getting errors 243, 244, 245 or 246 on SELECT statements by using "SET LOCK MODE TO WAIT". We typically check for these errors and retry the select. "SET…
Re: Lock Escalation
Herb Blacker wrote: > > Can someone please tell me if Informix v7.x does the following? > 1. I have a central table with row-level locking, committed read isolation. > 2. I have 30-50 people at a time doing updates to the table at random times > 3. I have 3-4 people doing queries…
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: Row and page locking
davin_harvey@dsti.co.uk wrote: > > Hi everybody, > > Does anyone know if there is a difference in the time it takes to > place a row lock rather than a page lock? No difference. It is just that if many rows on a page are to be locked in a typical transaction row …
Re: Need Locking Edification
Cosmo Lee schrieb: > We're having a problem that when we are running deletes from a table, > users are locked out from completing Selects, and Inserts fail. We > can't quite figure out why this happens . . . > If you want to have maximum concurrency, set the isolation to dirty…
Re: LOCKING, Too many concurrent updates on the same record (from mono- to SMP)
JF DENIS wrote: > > Hello, > > Here follows a porting problem of an application. > This appl was running on a mono-processor Unix system and has now to be > ported on a SMP Unix system (reason = the volumes to handle in the new > environment are much more important). > <snip> > …
Re: Dirty Read via ODBC?
In New Era 3.0 you can use simple SQL statements (set isolation level) . As yet I have not determined any way to use their ixSQL objects for this purpose. My reading of the documents and 4gh files says they have not implemented this capability yet.…
LOCKING, Too many concurrent updates on the same record (from mono- to SMP)
Hello, Here follows a porting problem of an application. This appl was running on a mono-processor Unix system and has now to be ported on a SMP Unix system (reason = the volumes to handle in the new environment are much more important). environment = Informix (on Unix), but it…
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…
Illustra locking an Index ?
We have some concurrancy problems in Illustra that we think we have tracked down to a table/index level lock on an index. The confusing part is that this is happening when the base table is being updated but the column(s) being updated are not in the key OR the index. We are ther…
Cursor Stability Isolation Level
Hi, I have a question regarding the use of an isolation level of Cursor Stability and the use of a normal cursor. Reading from the Informix Guide to SQL:Tutorial version 7.2 p.7-14 "When Cursor Stability is in effect, the database server places a lock on the latest row fetched.…
Re: informix cli - windows nt
default isolation level depend on the way you're using your db (ansi, log, etc.); i don't known which language you are using: i had this problem with visual basic and i used an "sqlexec" to run the correct "set isolation to .." (in passthrough mode) or a stored procedure in a dum…
informix cli - windows nt
Can anyone tell me what the default isolation level is for the informix cli, and if possible how to change it ? Manoj Schroff, Two Way TV Ltd, UK +44(0)181 996 8221 manoj@mailhost.twowaytv.co.uk http://www.twowaytv.co.uk…
Re: SET TRANSACTION question
Peter Whittleton wrote: > > Anyone used SET TRANSACTION (or SET ISOLATION LEVEL) to change the > isolation level of a transaction? The docs state that '... after > a COMMIT WORK statement completes the transaction or a ROLLBACK WORK > statement cancels the transaction, the isola…
SET TRANSACTION question
Hi all Anyone used SET TRANSACTION (or SET ISOLATION LEVEL) to change the isolation level of a transaction? The docs state that '... after a COMMIT WORK statement completes the transaction or a ROLLBACK WORK statement cancels the transaction, the isolation level is reset to the…
Re: isolation level
Oscar Goldes wrote: > > Hello, > Is there any "rule of thumb" about which isolation level to use when using > Informix SQL? I know, it all depends on the application, but what is the > "usual" level for a client-server system? > Can it be commited read, or must it be higher or lo…
Re: isolation level
On 15 May 97 at 20:36, Oscar Goldes wrote: > Is there any "rule of thumb" about which isolation level to use when > using Informix SQL? I know, it all depends on the application, but > what is the "usual" level for a client-server system? Can it be > commited read, or must it be…
isolation level
Hello, Is there any "rule of thumb" about which isolation level to use when using Informix SQL? I know, it all depends on the application, but what is the "usual" level for a client-server system? Can it be commited read, or must it be higher or lower? Of course, there are specia…
Re: message.log: lock table overflow
Xiong wrote: } } In informix message.log file, I found the following messages : } } 20:21:42 lock table overflow - userid ..., sessionid ... } ... ( Similar lock table overflow messages omitted ) } 20:28:40 lock table overflow - userid ..., sessionid ... } } …
Re: ACE report
Ace reports use committed read as the default isolation mode. For safety's sake, using 4gl (or ESQL-C etc.) for reports like these make sense because of their letting you use dirty read as the isolation mode. Jane Johnson <johnson@holidayco.com> wrote in article <3309F6B6.20CD@…
ACE report
Hello: does anyone know the isolation level when I use ACE to generate report? We are writing some ACEs to generate report from System tables(mainly for DBA use, it generates similar report as onstat utility). We are concerned with locking the system tables while the reports are …
RE: Index Read Errors
> We're using stored procedures to update a set of tables on a data server > which are maintained by an invoice payment app used concurrently by 100 > or so users. The application sets isolation to DIRTY READ for each > session, yet during periods of heavy usage, stored procs ar…
Index Read Errors
We're using stored procedures to update a set of tables on a data server which are maintained by an invoice payment app used concurrently by 100 or so users. The application sets isolation to DIRTY READ for each session, yet during periods of heavy usage, stored procs are failin…
Re: Locking...
I've worked on a number of large multi-user informix databases and where there are a number of users inserting / updating data in a table it has always been necessary to have row level locking. It's not correct to state that row level locking only locks the row you're updating, …
Re: Locking...
On 2 Dec 96 at 22:59, Romulo Albuquerque wrote: > I wish to know what locking mode is better: Row or Page Locking ? Please > help me. As Bob Dole is alleged to have said: "Depends". Page locking is more efficient (faster), but can cause unnecessary locks (reduces concurren…
How to determine isolation level ?
Hi all, Does anibody know how to determine what isolation level is currently in effect ? Any help will be greatly appreciated. Best Regards, QWERTYS Ltd. Sergei Vasilyev, 10, Elektrodnaya St.,…
Re: Set transaction isolation level read unco
>Is it possible in Informix to set the transaction isolation level >of a read-only transaction to read uncommitted, so that the >transaction sees the uncommitted writes of other ongoing transactions? >(In Oracle I have found that it is not possible.) Use the following: SET ISOL…
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: How to handle deadlocks ?
In article <4piahv$stp@soft.softouch.bc.ca> joachim@softouch.bc.ca (Joachim Achtzehnter) writes: Date: Mon, 10 Jun 96 23:21:33 GMT From: joachim@softouch.bc.ca (Joachim Achtzehnter) If you follow a fixed locking order you can avoid most deadlock situations. Whet…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
RE: sysproc* lock problems
Johnny, This sounds a lot like bug #22101. But, I had thought that it was fixed in version 5.02. Mention the bug number to tech support and perhaps they can give you an explanation. (FYI, back when we had this bug, it could only be fixed by upgrading.) --Craig (craig@c…
sysproc* lock problems
Wondering if anyone could shed some light: We are having problems with two processes concurrently executing the same stored procedure. The second process dies with locking errors, because the first process has exclusive row locks on sysprocplan and sysprocauth (I determined this…
Re: get a unique phone # (10 digit) from a table. SLOW
1. Check your Indexes.("set explain on" and check the cost) 2. Create composite index.(if needed) 3. Check isolation level. (You should set the isolation level to "Repeatable read" or "Cursor stability"). 4. Check your lock mode.( set lock mode to wait x seconds). 5. Application …
Re: Do SELECT statemetns create any locks on a 5.X OnLine Engine
In article <4hi2fn$2om@lynx.dac.neu.edu>, tgill@lynx.dac.neu.edu says... >I am writing an application that I don't want to interfere with other >applications accessing (doing update/inserts) the same database. Will >declaring a cursor with hold for a query select * from some_tab…
Re: Isolation levels
Diana Li (lid) wrote: : In 6.0 and 7.10 also, I think, Informix isolation levels are : dirty read : commit read : cursor stability : repeated read At least from 4.0 on, OnLine has offered Dirty Read, Committed Read, Cursor Stability, and Repeatable Read. I believe that what we…
Re: Isolation levels
In 6.0 and 7.10 also, I think, Informix isolation levels are dirty read commit read cursor stability repeated read…
Isolation levels
I'm looking for up-to-date information on isolation level support in Informix (for use in a soon-to-be-published paper). Early in 1994 I was told Informix supports isolation levels Uncommitted read (UR), Committed read (CR), Cursor stability (CS), and Serializable (SR). Can any…
RE: sysprocplan Locking?
Neil, > Under what conditions might sysprocplan get locked? What version of which engine are you running? > We have a problem on one program which is used by man users and > we tracked the concurrency problem to a lock on sysprocplan. > Where do we start looking? Depend…
sysprocplan Locking?
Under what conditions might sysprocplan get locked? We have a problem on one program which is used by man users and we tracked the concurrency problem to a lock on sysprocplan. Where do we start looking? --------------------------------------------------------------------------…
Re: Performance Testing
Elisa, Your email address elisa@ccserv.cc.nccu.edu bounces (or there's something up with our mail system)... Are you using OnLine? Which version? I'm not sure that there is a fixed limit on the number of users. You are constrained by the number of semaphores in the o/s kerne…
Performance Testing
Hi, I have a very critical problem here. How many users the Informix DB engine can handle concurrently? In detail, how many read locks, write locks, and login locks can be handled in the same time by Informix DB engine? In what condition, the DB engine probably die. Had anyone h…
[Q] Concurrency/Locking Technique Problem
I am new to Informix and I've reached the problems in design of application for concurrent database use. Would somebody please to answer the following questions: 1. Does the ISOLATION LEVEL work outside a transaction? I tried CURSOR STABILITY ISOLATION LEVEL and have got a …
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: Default ISOLATION LEVEL???
bpayne@netcom.com (Bob Payne) wrote: >What is the default isolation level in 4GL? We are running both 5.X and >7.1 versions of the engine. Our 'experts' say its REPEATABLE READ, but >we are having problems proving that. >Can anyone help? I believe it is committed read, or th…
Re: OPEN fails when active set includes a locked row
In <bpayneD795tz.CLy@netcom.com> bpayne@netcom.com (Bob Payne) writes: >We ran an experiment here on both versions 5 and 7 online engines. >Locked a row with one process and tried to update several rows with >another process. We never even got to the update because the OPEN of …
Re: Default ISOLATION LEVEL???
I4GL does not set the isolation level -- therefore the default depends on the database. If it is logged and MODE ANSI, the default is REPEATABLE READ. If it is logged but not MODE ANSI, it is COMMITTED READ. If it is unlogged, the log mode approximates to COMMITTED READ. All …
Re: Default ISOLATION LEVEL???
Bob Payne (bpayne@netcom.com) wrote: : What is the default isolation level in 4GL? We are running both 5.X and : 7.1 versions of the engine. Our 'experts' say its REPEATABLE READ, but : we are having problems proving that. If your database was created in ANSI mode, then it is …
Re: Default ISOLATION LEVEL???
Bob, Isolation levels are more of a server issue than 4GL. The default isolation level for OnLine is "committed read", *unless* you have created your database as a mode ansi database, then you get stuck with "repeatable read" isolation level. You can reset the isolation level …
Re: Default ISOLATION LEVEL???
In <bpayneD714n5.5L5@netcom.com> bpayne@netcom.com (Bob Payne) writes: >What is the default isolation level in 4GL? We are running both 5.X and >7.1 versions of the engine. Our 'experts' say its REPEATABLE READ, but >we are having problems proving that. The default isolation …
Default ISOLATION LEVEL???
What is the default isolation level in 4GL? We are running both 5.X and 7.1 versions of the engine. Our 'experts' say its REPEATABLE READ, but we are having problems proving that. Can anyone help? -- +------------------------------------------------------------------------+ |…
Re: Phantom Inserts
In article <3iicrs$7b7@jac.zko.dec.com>, chen_p@perfit.zko.dec.com (Paul Chen) writes... . . . Curiously wondering how others accomplish this... > >Actually, it is not necessary to prevent concurrent inserts in the >entire table in order to guard against phantom inserts. In Sy…
Re: HELP - No more locks
xrizzi@arcride.edu.ar writes: >HELP! >I insert a row in tables, ON-Line return the error -134. >In 'tbconfig' I have LOCKS = 2000 and in use there is 13 locks. >The ovlock = 78. >-------------------------------------------------------------------- >Message Log File: /usr/informi…
Re: from SE to Online: Experience??
If you port application made for SE you should set Online to be most simillar to SE: - use 'set isolation to dirty read' in the begining of application - set lock mode to row for any table with concurrent use: 'create table ... ( .. ) lock mode row', or 'alter table ... lock mod…
Re: ACE dirty read
>From: Tom Hogarty <hogarty.pad@sni.de> >Subject: ACE dirty read >Date: 18 Oct 1994 11:07:03 GMT >X-Informix-List-Id: <news.9309> > > A colleague has recently asked me about setting dirty read > in an ace report. As I don't need to use this tool any more > I had to say that I hav…
Re: row level locking and dead-lock prevention
>>From article <worp.51.001736A2@knoware.nl>, by worp@knoware.nl (Bart van der Worp): >> I have a question with respect to locking, dead-lock prevention and row >> (or key) level locking. [...] We are designing a automatic message >> exchange system. Some data is to be maintain…
Re: how to find out current isolation level?
David Hovemeyer (daveho@earlham.edu) wrote: : Hello, : Is there a way to find out (through ESQL/C) what the current : isolation level is? By querying a system table, perhaps? : Thanks, : Dave I don't think there is a simple way. If you keep track of your isolation through enc…
How do you find out who has locked a table/row/page in Online?
Is there anyway to find out which user/process has currently locked a row (or page/table) in Online using 4gl (or esql/c)? Would also be helpful if I could tell if the lock was shared or exclusive without changing the isolation level or attempting to set a lock. Thanks in adva…
Re: Record Locking
> Andy Kent writes: > |> My guess is that you are falling foul of the 'feature' whereby > lock > |> testing is applied to every row *touched* rather than every row > brought > |> into the program. > Possible, but rather unlikely. For this to occur, you'd have to > be using an i…
Re: Undocummented: SET ISOLATION TO DIRTY READ
Glauber, The SET ISOLATION statement is documented in the Informix Guide to SQL:Reference, versions 4.1 and 5.0. It is also documented in the Informix Guide to SQL:Syntax in version 6.0. The other options (besides DIRTY READ) are COMMITTED READ, CURSOR STABILITY, and REPEATABLE …
Re: Undocummented: SET ISOLATION TO DIRTY READ
SET ISOLATION TO affects the level of isolation of a process while it retrieves rows. Isolation is the opposite of concurrency. Here is a short and rough description of the different levels of isolation: DIRTY READ acquires no locks (minimum isolation). COMMITTED READ insures th…
Re: Error -246
In article <2p1ddq$g0e@emory.mathcs.emory.edu>, jmathwig@STL-03SIMA.ARMY.MIL (Jim Mathwig) writes: |> Hi All, |> |> Need assistance with this row vs. table locking issue! |> |> When executing the following query: |> |> "SELECT rowid, * from table_name WHERE rowid = 425 FOR UPDATE…
Re: Dirty Read info
In article <1993Nov8.145344.22870@athen.mch.sni.de> gm@athen.mch.sni.de (Guenther Moschen) writes: > >I'm looking for some background of Informix's "Dirty Read" mode. > >Specifically: How is it invoked? Can it be turned on/off for an entire > >session, or on a per…
Re: Dirty Read info
In article <CFz2I7.698@andyne.on.ca> stevenb@bbs.andyne.on.ca writes: > >I'm looking for some background of Informix's "Dirty Read" mode. >Specifically: How is it invoked? Can it be turned on/off for an entire >session, or on a per-query basis? > >Steven > > > It can be turn on …
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: <No Subject Supplied>
In article <1993Jul8.143903.18109@informix.com>, davek@newjersey.informix.com (Dave Kosenko) writes: > > naomi@qip.anasazi.com writes: > |> > Alternatively, if you don't actually need Committed Read isolation, just > |> > SET ISOLATION TO DIRTY READ, and it will work fine. > |> >…
Re: TPC-A and -B Benchmarks
In a recent append, alexk@infmuc.informix.com writes... >To run TPC-C benchmarks a certain isolation level is required (as far as >I heard). This isolation level is not yet supported by Oracle... >Any comments on this?? The TPC-C benchmark, as I was given to understand, runs 4 o…
Re: Will key locking strategy in OnLine be changed?
> Not long ago I read an article in this group about the strategy used > in OnLine whereby locks are placed on adjacent keys when a row has been > inserted or deleted. Someone mentioned that they heard that this will > be changed in a future release. > > What I would like to know…
Re: ISOLATION LEVEL...
>From: uunet!sam.amgen.com!chriss (Chris Silvester) >Subject: ISOLATION LEVEL... >Date: Tue, 10 Nov 1992 00:29:58 GMT >X-Informix-List-Id: <news.2099> >I'm working with 4gl and Online and I was wondering if there is any internal >variable that indicates the current isolation lev…
Re: ISOLATION LEVEL...
Chris Silvester asks: > >I'm working with 4gl and Online and I was wondering if there is any internal >variable that indicates the current isolation level, or some other way of >checking the current isolation level. Any help would be appreciated. Since the isolation level is tr…
ISOLATION LEVEL...
Hi All... I'm working with 4gl and Online and I was wondering if there is any internal variable that indicates the current isolation level, or some other way of checking the current isolation level. Any help would be appreciated. Thanks in advance, Chris S.…
Re: 2ph commit references
You could try `Concurrency Control & Recovery in Database Systems' by P A Bernstein, V Hadzilacos, N Goodman (Addsion-Wesley, ISBN 0-201-10715-5). It covers 2PC (and 3PC) and locking and all sorts of things. Its fairly easy to read mostly, but not bedtime reading unless you suff…
OnLine lock mode status
Path: emory!swrinde!cs.utexas.edu!qt.cs.utexas.edu!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!banana.cis.ohio-state.edu!ackley From: ackley@banana.cis.ohio-state.edu (john james ackley) Newsgroups: comp.databases.informix Message-ID: <1992Jan29.143251.3709@cis.ohio-state.edu> D…
Re: concurrency problems
Scott Myers writes (re concurrency problems) : > These errors are probably associated with trying to access rows that are > locked by another user. > > When you create tables with OnLine, the default is to use page level locking > (page size is typcially 2K bytes). To get r…