Oninit® Archive
Results for “onstat -g rah”
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 ------------------------------…
YIKES! 12.x documentation for onstat -g opn does not match the output
The new output is a lot easier to read but hard to parser via a script. The u and o counts are the number of threads currently using the partnum (u) and the total times the partnum (o) has been opened. The partp is new one on me, the ra (guess) will tally back to the onstat -g r…
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…
Connections over SSL
Clients need to have read permission on the files configured in SSL_KEYSTORE_FILE and SSL_KEYSTORE_STH .…
Creation on read only user.
Hello, 1. I have 2 user in my instance i.e. 'USER1' and 'USER2'. 2. 'USER1' and 'USER2' can Execute SELECT, INSERT, UPDATE, and DELETE statements as they gave got 'CONNECT' database level privilege, that comes with default 'PUBLIC' role. 3. I want to create 'USER3' that should…
Informix 11.70: Stored Procedure SQL exceptions
Alexandre, I should also explain that I set up a WHILE loop to read from a select cursor. Thanks, Bob…
EXTERNAL table read
Hi, How can I read one external table as an usual table, is it possible? Can I do select from one external table created by another program? As I only have seen operations over external table after create...??? Thanks for any help, SP…
Not sure if I have a problem with CKPs
Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
SQL using the index
If I find one index has high buffer read, How to know which SQL use this index?…
Restore secndary from primary fails
Issue was solved. Primary had a backup filter and secondary couldn't read the backup from STDIO…
Could not position with in a table
Hi Mukesh. You probably have uncommitted changes to that table by another session, which results in exclusive row locks. If your application has the default SET ISOLATION TO COMMITTED READ, it will abort when it tries to read those rows. When you start a new session, execute SQ…
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…
Dbexport very slow
dbexport supposedly unloads the tables by reading sequential. Update statistics should be irrelevant in this case. What about the amount of data produced by that massive inserts?…
Users from a database Import
I'm missing something to this whole thing. If Public has connect, it has read, write update and delete. I want the user to have only read and write to the entire database. Doesn't every user have public so he has read, write, update and delete?…
dbexport
my command doesn't seem to work. Reading the documentation...…
reading committed data on hdr
We are using informix IDS 12.1 with an HDR in near_sync mode. Some applications read data from hdr. We found that uncommitted data is also read n hdr that some times rollaback and information delivered at that instance does not recoincile. One solution might be keep the hdr in fu…
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.…
Cannot read from sysprocplan
Hi, we are seeing an error through an application when it tries to do a select on the database, but if we go on the server and use dbaccess, the select statement works. Anybody know anything about these errors? 12/08-09:22:26.211 [01] <002:0001:> (01) ==> inf_exec_stmt: (-211,-1…
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…
Secondary stuck in Fast Recovery
Hi, from reading other posts, it seems like I need to restore secondary so I will give that a go now.…
SQL have most IO read
HI, How to monitor which SQL has the most IO read operation? thanks for your time.…
Re: RE: Dev server restore fails
Hey Martin, believe me when I say I have read and read and read before I ask my questions. I think I have at least 6 different manuals for informix 11.5 and I'm guessing they have to be 10,000 pages. :)…
Negative pages read in chunk
I have some system monitoring that captures pages read from each chunk. This is simply "select fname, pagesread from syschktab" For the most active chunk in the instance this statement returns a large negative number (-1,181,472,262). However an onstat -D returns a larger positiv…
updatable SDS
I just found the answer: The only isolation modes that are not supported at the Secondary server are REPEATABLE READ and CURSOR STABILITY.…
Data loading quesiton
the customer will run the read only application on HDR, so reinitilize the HDR is not workable , the read data is about 60TB, ifxclone take about 9 hours.…
External table problem
I'm reading from a file and for the rejectfile of course informix should write…
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)…
dbspaces corrupted
Thanks so much. After fixing the read-only problem on the dbspace how does one bring the chunk back on-line?…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
virtual segment question
I read the online.log, it's dynamic lock allocation lead to the problem…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
can we have to hdr servers ?
In fact i will use it for backuping the production. Is the rss read. Only. Likr hdr ?…
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.…
CREATE FUNCTION() containing ORDER BY clause
Excellent point Fernando! It seemed very obvious as I read your response. Thank you for pointing that out.…
Ifxclone issue
Is it logging anything at all on the primary or secondary? is the primary still available for reads and writes or does it hang?…
Auditing HDR server
good evening, can we audit an hdr server ? which is, by definition, on read only mode :) thanks in advance…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Dirty Read with Coldfusion
Hey, all. We're running ColdFusion 9 against an 11.70.FC7 instance, and it insists on using Committed Read. I set up a sysdbopen() to set it to DIRTY READ, but it doesn't seem to honor that, almost as if CF9 is explicitly executing SET ISOLATION TO COMMITTED READ (or, more like…
Indexes on Null values
For oracle, I have read that nulls are not indexed. How does Informix handle null values on a column that has an index? Thanks…
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,…
btr
How can the BTR be 334 while the %cached for reads is 91% to 95% ? (This is ids11.70.TC3IE )…
Re: help with informix on windows oncheck -pr erro
thanks for link Fernando I will do some reading…
Informix Auditing
Hello, I want to know the difference between following two audit Mnemonic. ACTB Access Table RDRW READ ROW Thanks in advance.…
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…
hello
wow give this a look http://www.panews15.net/biz/?read=6647671…
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…
Informix Locks On Select count(*)
Also, Will setting isolation to dirty read help with this? Thanks…
Informix process reads a lot of pages
Hello, I have a problem with Informix 7.31.UD8 on Linux. One of the Informix process reads a lot of pages. Can I see what does do this process? Why this process reads pages, when nobody use IDS?…
ONBAR restore error
I'm trying to restore a ONBAR backup It was a full system backup using ONBAR -b -w to disk When I try and restore it using ONBAR -r -w I get the error below in ism_watch what is the error and how can I fix it thanks Up since: Thu Oct 13 12:19:10 2011 Version: Informix_Stora…
4GL Read file
Hi, I want to use the new OPEN FILE, READ FILE, CLOSE FILE in Informix 4GL. Could anyone direct me to detailed documentation on it? I can't find any description on how to detect EOF in the READ statement as the READ statement does not seem to return a flag. Any help will be appr…
reading: Bad file descriptor
I'm trying to restore an onbar backup that is done to disk does the error reading: Bad file descriptor in ism_watch refer to a corrupt onbar file or something else ?…
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…
Informix ... and marketing.
Informix ... and marketing. Please read this important post! : http://t.co/k0QfC0s #Informix…
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.…
must read.!!
way cool am baffled!!!!!! http://www.informix-zone.com/redbook-draft-version-ibm-informix-flexible-grid Thanks!!! Superboer.…
ER error
If I am reading it right cdr finderr 1 1 A connection does not yet exist for the given server. Is replication actually working ?…
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…
informix dropping idle connections
Thansk for info Art John cant read your post…
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…
Tremendous number of reads
Hi guys, any ideas how to investigate or determine the casue for the following ? Platform Solaris 9 on sparc, Informix 9.4FC5 New application causes a very high cpu-load, and we see about 2BILLION reads on a specific index in 1 day (more then 4 million in a minute) for 2 other…
data access control
Folks, IDS11.10 UC2 AIX5.3 We granted READ permission on most of our tables to Public. So all valid users have the default read privileges. We are going to have an exception : An newly added user will be prevented from reading some tables that are granted to Public already. W…
An interesting read...
http://radar.oreilly.com/2010/03/joe-stump-talks-location-and-n.html What makes it more interesting is that some of the readers relate the inability of MySQL not being able to scale as something all databases are unable to scale. XPS anyone? Sorry for those who don't think out…
Cannot read systemcatalog
Hi guys, During execution of "update statistics" scripts, which are build based on the performance guide and the recommendations of John Miller we have following issue on Solaris with IDS 9.4UC7. Database is in buffered logging mode. In the scripts , for every 100 statements we…
Is there a gateway issue?
I'm reading on c.d.i UseNet. It seems that there are replies that are referenced that I don't see. Is there an issue with the gateway? JWC…
Congratulations to Warren Donovan as the Fastest D
Warren, If your out there "Congratulations" I just read you are the fastest DBA. -- Eric B. Rowell --000e0cd70dbe5a2de90477181a6b…
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…
onbar backup exited 151
Thanks Martin, You are right... Secondary Server can't be backup... Upon reading most all informix forums and your confirmation. Regards.…
Create index errors
Sorry - bad bit of reading on my part! Could it be number of extents/extent size for the index?…
Re: SSD --- The reliability of
Question how many times do you read write to a hard drive in a year? Question how many times do you think you will read write to a ssd in a year? Then go and buy a usb stick and read write to it then come back and tell us how long it took you break it. And how many read write op…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
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…
dirty read isolation in views
Is it possible to create views with dirty read default isolation -or- run views in dirty read isolation? IDS 9.4UC8 Redhat Enterprise Linux 3 AS DISCLAIMER This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments theret…
Change the informix database to read only
Dear All, I want to put one of my informix database to read only mode. Can anybody provide the solution to change the database to read only mode. Thanks, Gulshan…
v11.50.fc2 excessive kernel reads
I just installed v11.50.fc2 on an Aix 5.3 system. Only changes to the config file was that I changed the sqltrace to be global and not user ... and I added SCANNER num=2,treashold=500000,rangesize=100,alice=6 previous that was not set ... Since the upgrade the kernel reads on …
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…
If there were no onstat...
Noonan! I hate when I screw up a contraction... Think the title was also bumbled... should read If there was no onstat. MM…
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.…
Anyone else read CRN ?
CRN - Computer Reseller News , a CMP publication... April 28th issue. IBM insert in the plastic wrap. Its a SWG advert. Interesting notes: 1) Information Management pillar had 5 products listed. The most of any brand ... 2) Note to Jerry K. Does it make sense to sell IDS as …
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…
Informix Helps Clean up London
Please read this case study for details. http://www.informixcity.com/downloads/LB_Camden.pdf…
Informix strong in the UK
Please read the following case study demonstrating Informix is still active in the UK. http://www.informixcity.com/downloads/Exel%20Case%20Study.pdf…
Extent DB
I will read a bit more. The key answer came from Marcus. After reading a lot I thought: Disk->DbSpace->Chunk but now I think Disk->chunk->DbSpace Thanks for helping Freudi…
HDR Secondary mode Log transfer handling
How the Informix handle the locking between the read only access and updates from Primary Database to Backup database?…
Error reading buffer on onunload
Hi i'm running informix 7.31 on a Compaq Proliant 3000. If I perform an onunload of small database, for example 130 Mb, it will finished without errors, but if I perform an onunload bigger than (15 Gb) . It returns the following error : " Error reading buffer ". The tape device…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
RE: Some interesting reading
I was trying to find the origins of Informix & Oracle. Someone told me that Roger Sippl & Larry worked for the same company, had different ideas, resigned, and started their own databases. But I don't know if this is true, or just a story. While searching for more inf…
RE: Some interesting reading
You forgot http://en.wikipedia.org/wiki/IIUG -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Dirk Moolman Sent: Thursday, June 07, 2007 16:29 To: informix-list@iiug.org Subject: Some interesting reading http:/…
Some interesting reading
http://www.storyofinformix.com/ http://en.wikipedia.org/wiki/Informix http://en.wikipedia.org/wiki/Larry_Ellison Dirk Moolman Database and Unix Administrator Agility Technologies (HealthCorp) "People demand freedom of speech as a compensation for the freedom of thought whic…
Re: Is IBM actually doing something with IDS?
> Otherwise they would > not have introduced Oracle like features , like > read consistency (read don't block writes > and vice-versa). And since it is Informix I > can bet it will do a better job than Oracle > at read consistency without locking. > Also RAC like shared disk fea…
look like something reputable
anyone in IT knows whats happened re: isoft CSC NHS IT corporate raiders corporate scum (read posts to comp.databases.pick informix people)…
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.…
Must Read!!!
Excellent material is available for test drivers on code providing enormous in depth information of the suggested test programs. Don't miss it! http://www.it-techexperts.com/Tutorials/KometTest.asp…
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…
Must Read!!!
New material has been added for the Silktest and WinRunner feature descriptions focusing on the day to day functionality provided by both the tools used for software testing. http://www.it-techexperts.com/Tools/SWFD.asp…
Connecting to IDS 9.4 from Linux x86_64
[authlive] should read [mydb]…
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…
A Must Read !!!!!
I have not been able to find a proper tutorial for WinRunner & LoadRunner at a single place. This has been a good effort to share WinRunner knowledge and I am sure that this Blog would grow into an excellent resource over the time. http://test-techtools.blogspot.com…
How do I read a file with Informix 4GL?
What is the best way to read a flat file using Informix 4GL? Thanks…
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 …
an XBSA reference implementation?
Hello, Does there exist an XBSA reference implementation? I would like to read the source. Thank you, Vasili I. Galchin…
an XBSA reference implementation?
Hello, Does there exist an XBSA reference implementation? I would like to read the source. Thank you, Vasili I. Galchin…
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…
Here you can read books free and buy all tickets
Here you can read books free and buy all tickets you can find all tickets here: http://allticket.yourfreewebspace.com/ you can read books free: http://onlinebook.yourfreewebspace.com/ http://bookonline.yourfreewebspace.com/…
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…
Cached reads going to 0.00%
I've noticed this a couple of times in onstat, for no apparent reason cached reads go from 95% or so to 0.00% and then slowly build back up to 95% over the next 24hours or so. There's a cronjob that runs at 8, noon, 5 and midnight that records a few interesting statistics on the …
KAIO READ ERROR
Hi All, Through the working day I can constantly see error messages containing the information: KAIO: error in kaio_READ, kaiocbp = 8ac9e608, errno = 14 11:30:44 fildes = 8 (gfd 6), buf = 8be2e400, nbytes = 61440, offset = 37412864 Sometimes IDS goes down if the system is doin…
Database read only
Hi, I need to put my database in read-only mode to previne access while we migrate the data to the other database. I'm using Informix 7.31.UD6 on HP-UX. I would like to know to proceed in this case? Thanks. Rodrigo…
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 …
Changing database to read-only
Hello, I am trying to find out the procedure for preventing updates on an Informix database by changing it to read-only. Is there a stored procedure to do this? What would anyone recommend? Version 9.21UC4 HPUX 11.11 Thanks in advance, Howard…
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?…
Onar failure
My Apologies for poor spell checking. The Title should read OnBar Failure.…
Dirty Read Default
I thought I heard a while back about an environment variable setting to change the default isolation level to DR. Does anyone know about this, or maybe I was just dreaming. The users of our data warehouse have been running selects against tables with the default of Committed Re…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: Stored Procedures Limitation
oopps it should read pre 7.3 ..…
column level encryption
hello all, i am correct in reading that column level encryption is available in IDS version 10 but not 9.3/9.4? thanks tom…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: Splitting rows without temp tables
"I'm interested in this concept of read-only access not allowing temporary tables. You can even build temporary tables on an HDR secondary, the ultimate read-only database." Just testing.... ;-p…
Re: Shocked! Shocked, I tell you!
Don't ask...it's why I'm so annoyed. They read this here.... Hmmmmpffff....…
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.…
Read Block Size on Disk
Hi all, what block size is used when informix is reading from disks ? Is there a difference between the block size on solaris and linux ? thanks gerd ______________________________________________________________ Verschicken Sie romantische, coole und witzige Bilder per SMS! J…
Re: what elkie holland said about me on usenet july 23rd 2001
Never heard of him till I read your post, Thank you for a most entertaining afternoon...…
Re: IDS 10 erratic run times
oops should have read Neil's post more carefully!…
Reading DBF from Informix
hello, can anyone tell me if exists any patch or something else for Informix that help me to read/write DBF files from Informix without using ODBC?…
Why Informix is Best
Not horseshit it was on the Slides at the may IBM Infobahn at Bedfont Lakes in the UK. I was at the front where even I could read it...…
ISM ism_catalog question
I was able to retrieve the information I needed using the mminfo command. Thanks to anyone who took the time to read this post.…
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…
Reading environment variables
People, Is there a way to read the environment variables from within dbaccess? for example select '$INFORMIXDIR' from systables where tabid =1' Thanks in advance Kenneth…
Informix Logocal Logs
Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football…
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…
Re: script for SQL Capture
michael i get an error reading header on this file after download tom…
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…
Re: Informix locking & transactions
Lock Mode is Row Isolation Level is Committed Read.…
cannot read system catalog
--0-1004379464-1102954650=:32339 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Hi, Using IDS 9.21 UC4. Solaris 8.0 we have this problem with users trying to connect to the database running. it gives the error 'cannot read system catalog (sys…
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'?…
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…
Problems with locks and committed read
Hi ! well, once again... another question on locks, and isolation level. This time it's rather "critical" for me. I've got 2 processes. One of them => insert data in some tables. The second => try to select row in it. (in fat , it select in it) the two transactions are initi…
Dirty Read dbschema?
Hello All, I have a question regarding dbschema. I have a script that copies data on a nightly basis to a reporting database. I wrote the script to capture the schema each night so that any schema changes are automatically incorporated. Occasionally, I cannot capture the schema …
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: 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…
Read only connection
Hi. I have installed IBM Informix Connect 3.82 32 BIT driver for connecting to a Informix Dynamic Server 9 for Linux. I have configured the driver and works fine but I don't know if I can restrict read access. Is there any option for configure the driver in a read only connectio…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Read sqexplain.out on client machine
Hi, Server IDS 9.30UC2 on linux. Client Apache/PHP/CSDK 2.81 on another linux box. I want to show the query cost and access plan in a web page, How can I retrieve it? I know that in page 10-13 of the IDS Performance Guide it says : <quote> When the current database is on anot…
Question on split reads...
Quoting from page 17-10 of the IBM Informix Dynamic Server Administrator's Guide (IDS 9.4 on Solaris 8) -- "A data page is read from either the primary chunk or the mirrored chunk, depending on which half of the chunk includes the address of the data page.". If the disks containi…
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…
Commit-read question
I am experiencing a quirk of some sorts. I am running the query below with a wait 30 against a table that has an application stepping thru recordid #'s checking for the next record that has a status of "not processed". Once the application does other modifications to other tables…
Is dirty read enough ?
This is a multi-part message in MIME format. ------=_NextPart_000_007B_01C339B8.442F6BB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, everyone , Here I encounter a problem, in our system some tables were accessed by many clients at the s…
Re: Is dirty read enough ?
> THIS IS A MESSAGE IN 'MIME' FORMAT. Your mail reader does not support MIME. > Some parts of this will be readable as plain text. > To see the rest, you will need to upgrade your mail reader. --PART.BOUNDARY.2960.4671.p057.1056372883.3930 Content-Type: text/plain Content-Trans…
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.Dirty reads
Hi Everybody, What would be the impact on database and its integrity if the application has used DIRTY READ during INSERT. Thanks in advance. Sushil... _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://cl…
IDS starting read only
----LNX_Thu_Mar_06_2003_10:17:52_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, = is it possible to start IDS 7.31.xDx (and IDS 9.30.xCx) 'read-only' , e.= g. starting with all checks for chunks / physical and logical logs…
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…
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 …
Read in ACE
I have SE 7.20.UE2. I have an ACE report project where I have to do a SELECT with 55 compares in the WHERE clause. So I thought maybe I could put the 55 items in an ASCII file, READ them into an ACE report program that would put them in a temporary file. After all, there has go…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Read only
Hi Can anyone tell me whether it is possible to make a Data source for the informix 3.32 32 bit ODBC driver read-only. Thanks Greg…
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…
Dirty Read
I have created a stored procedure in SQL7.0 which retrieves data from a linked server. The linked server is an Informix database - I want to set the query so it reads an uncommitted/locked records. I have set SQL7.0 to read uncommitted record which seems to be working, but how …
read dirty
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…
ace report & dirty read
How should I run a report with sacego in dirty read mode ? Thanks.…
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…
Row locked on reads even under dirty read
Hi again, family. This is not so much a call for help as it is a request for discussion. Here's the way the problem was presented to me: The programmer, Charlie, complains to me that his app is getting a slew of error 244/154 (or, if not waiting on locks, 244/144). (Exactly how…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
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…
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…
Read Cache %age on IDS
What are the general recommendations on improving the read cache %age.…
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…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Kevin read this
--------------- cc:Mail Forwarded --------------- From: Siroui Pink AT NYPBMIS1 Date: 10/06/99 09:13 AM To: informix-list@iiug.org AT INTERNET Subject: Testing from Siroui, Time Inc Service Desk ______________________________ Forward Header _______________________…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
syschkio view
Hi all, I am trying to understand the syschkio view. What is the relationship between read/pagesread. I read in an article that read means # of read operations and pagesread means # of pages read.Therefore, I identified situations where the number of reads is less than the numbe…
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…
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…
Mirroring parallel read
Can anyone confirm whether my understanding is correct in regard to Informix mirroring and parallel read performance. Informixs' implementation of parallel reads from mirrored DBspaces is thus: Data from the first half of the chunk is read from the primary DBspace and data from…
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…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Re: ISAM ?
Guru wrote: > > What is a difference between ISAM reads, disk reads, page reads, buf > reads ? > I can watch it by onstat but I don't know exactly what it is. > Can YOU help me? Sure. dskreads are the number of read requests made to disk, some may be multiple page reads which i…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
don't read%
Subject: PLEASE DON'T READ THIS MESSAGE From: MONEYMAN.COM Date: Sat, Apr 11, 1998 1:27 AM EDT Message-id: <6gmuvl$4f2653@news.mitm.net> **************************************************************** * This Article was Posted By an unregistered version of: * * …
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: Optimizing..
Know your schema, update statistics, and read sqexplain.out.…
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: Load vs unload time differ. why?
yes... a write does take longer than a read.…
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…
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…
Unix to DOS/Windows Tape
I have a series of tape backups done "tapecopy' in Unix 3.2.2. How can I read them in Windows/DOS machine? The "tar" programs generally available don't read them. I am desperate to recover these text files. Thanks…
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…
Reading a file with 4GL
Does anyone know how to read data from a text file into a 4GL program? I want to read data from a configuration file and initialize some program variables. Thanks in advance, Mike…
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…
Replication
Hi, I would like to know if the replication is always a database (master) to a database (read only) ? I would like to have one database master and 4 databases (read only). Is it possible ? Could we have one database read/write and use the replicat…
SMI: VP level stats
I'm interested in getting VP level I/O statistics like reads, writes, buffer reads, and buffer writes. These are avilable via onstat with -g iob and -g iov, however I need to get at them via SMI.…
Indexed read on "order by X desc"
Is it possible to do a indexed read when doing order by desc ??? TIA, -Lin…
Re: Locks/Committed Read Problem
Committed Read implies that it can only return committed data. Therefore, if one process has the row locked (always the case if it is updated and still in a transaction), then the other process can not read the row until it is committed or rolled back (the transaction is closed)…
Re: Set transaction isolation level read uncommitted?
On Sun, 14 Jul 1996 03:08:37 -0400, "Chao Y. Din" <cdin@csc.com> wrote: >> >> SET ISOLATION TO DIRTY READ >> > > SET TRANSACTION LEVEL TO READ UNCOMMITTED. > > Usign SET ISOLATION TO DIRTY READ allows you to switch between dirty-reads and non-dirty reads during the SAME…
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: Split comp.databases.informix!
Kerry's list looks reasonable to me. I too am skipping much more than I read.…
Barcode reading
The following are some snippets of code that show an example of how we read from barcode readers. The readers that we use are capable of being programmed. You can set a code sequence that is automatically sent at the beginning and the end if required of each barcode. The code 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…
Re: HELP : ODBC's physical-order read error message
Sure looks like you are trying to read a locked record…
Re: informix newsgroup
Same as what you did to read/send this/previous messages. Dave.…
test
Don't read this. Apologies for the inconvenience.…
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?…
YOU MUST READ THIS!!! NOW!!!
Allright, I know what you're going to say... This is just pure spam, I should be flame-broiled, thrown on a bun, chewed up, swallowed, digested, and shit out. But just listen to this for a sec. We've all seen it in various forms on local BBS systems, on CI$, AOL, and here on t…
Informix buy Borland?
I read somewhere that Informix was thinking about buying Borland? Has anyone else hurt anything more about this?…
Re: Reading Audit Files?
> Does anybody know of any utilities that would allow me to make sense of > the data contained in an audit file? We don't run transaction logs, but > we're wondering if the audit files might possibly yield useful info about > how data was entered into the table, and when and/or …
Reading Audit Files?
Does anybody know of any utilities that would allow me to make sense of the data contained in an audit file? We don't run transaction logs, but we're wondering if the audit files might possibly yield useful info about how data was entered into the table, and when and/or by whom.…
Reading over locked rows
Hi, i've a program which unload tables to an ascii file and updates a specific column in the rows after they are written to the file. Isolation mode is set to repeatable read to avoid rows to be written to the file which are not committed. Everything was fine but if there are …
re: read ascii in Informix
Here is a program I have been using for a few years that will read an ascii file in Informix. It is 'c' code with a sample of the Informix '4gl' code needed to run it. Have Fun Stuart Litel slitel@netcom.com ------ cut here----- /*From: slitel@netcom.com */ /* fileio.c for u…
Intersolve ODBC Q&E
I'm looking for feedback on Intersolve's ODBC Q&E Ver 2.0 software. I've read the marketing info,but if anyone reading this is actually using it I'd like to know what you think. Regs, Rick rodonnel@ibl.bm…
How to read Flat files from 4gl
I have a requirment to read the flat file from 4GL. Is there any way to do it. Thanks in advance <shanke11@singnet.com.sg>…
Re: Informix Transactions
If you lock the table in exclusive mode and you wish to read from it, use SET ISOLATION TO DIRTY READ; before your select statement.…
Reading BTrieve-file�p2
To narrow my question down, I only want to be able to read the file from one end to the other, and on my way extrat the information in each record. So to say that I don't need to be able to perform querys on the file, but only read trough it.. If that's impossible, is there a wa…
Re: INFORMIX/ UNIX/ C/ --ATL-
> If you do not want to read it, hit "d" -- that is all. d-- ?? That's how we got c--. -- cwoodall@vth1.vth.colostate.edu…
Read only databases - CD_ROMS
Hope you can help me, I'm trying to find a starting point. I am currently working on a project that will involve databases which will be distributed around the world on CD-ROM. There will be regualr updates (monthly or quaterly) and in each case all preceeding data will be repla…
Re: Reading DBEXPORT tape
I've received the same "invalid arg" errors when trying to read a tbtape archive using dd. I've only had this problem on Solaris. J. Dority…
tbunload for Online 6.0
tbunload and tbload utilities for OnLine 5.0 writes and reads databases and tables only to tape. Is there true, that OnLine 6.0 tbunload and tbload writes and reads to and from files ? Lines: 2 Vadim Ketchashin, St-Petersburg, Russia…
Reading C-ISAM Files
I need to be able to read files written in a C-ISAM file format. If someone could please detail the file format, provide source code to do the job or point me to where I could get the infor- mation I would appreciate it. Please address responses to matthew@aryabhat.umsl.edu. Th…
read this
Hello: We are looking for a client/server database for course management. This database will be installed on a database server which is connected to the campus network. The course database will be used to provide course and lecture information. Students should be able to do quer…
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 …
Re: Reading locked rows
Scott Ford writes: |> user 1 -> begin work; update bozo |> set col2 = 10 |> where col1 = 'a'; |> let's say that the previous value for col2 was 5. note that |> we HAVE NOT yet done a commit work. |> |> user 2 -> set isolation to dirty read; |> select * from bozo; |> …
Re: Reading locked rows
In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: >Hey folks, >We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We >talk to it using inet-pc 4.10 and powerbuilder running on windows. >Today's question #1 is about reading locked records…
Re: Reading locked rows
> > In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: > > >Today's question #1 is about reading locked records. Here's the > >scenario: > > buffered logging data base "foo" with table "bozo". > > table bozo has two columns "col1" (primary key) & "c…
Re: Reading locked rows
In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: >We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We >talk to it using inet-pc 4.10 and powerbuilder running on windows. >Today's question #1 is about reading locked records. Here's the…
Reading locked rows
Hey folks, We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We talk to it using inet-pc 4.10 and powerbuilder running on windows. Today's question #1 is about reading locked records. Here's the scenario: buffered logging data base "foo" with table "bozo". …
ESQL/C: reading in to a structure
This must be a naive question, but I would appreciate if some one help me with this. How do I read a sql query response to a C lang. structure? For eg. if I have a table t with { x int, y varchar(40), z char(20)} In my prorgam if I execute a query "select * from t " using a c…
Re: Reading tbtape
> > Is there a way to read the tape after a tbtape has > been done to assure what was written? > Depends which tbtape you mean... Since we have been bitten by media failures, we verify all our archive and log tapes on production systems. To read the log tapes, we use tblog.…
Reading tbtape
Hello everyone, Is there a way to read the tape after a tbtape has been done to assure what was written? Thanks! Brian MacWilliams --------------------------------------------------------------------------- Brian MacWilliams IND. TECH. & DB ADMIN BR …
Test - do not read
This is a test. This is only a test. For the next 60 seconds .......... Wayneo burke_w*cdx_miss@msm.cdx.mot.com…
Dirty Read & Upd.Statistics
Hey expert ! I have a question, which you may be able to answer. Could there be any problem if in an online system you have to processes, which executes in parallel, when the 2 processes are: 1 Update statistics ... …
Re: stuffing the read buffer
mukesh@elsouth.wsnc.org (Mukesh Rathor) writes: >>Under DOS, a character can be placed in the front of the keyboard >>buffer using the BIOS interrupt 16h, service 05h. This character ... > > or under Sys V 3.2.x. I wrote a 4GL simulating sperform 2-screens > interface. …
stuffing the read buffer
>Under DOS, a character can be placed in the front of the keyboard >buffer using the BIOS interrupt 16h, service 05h. This character >is the next one read by the Informix application and can be used >in ON KEY code to push carriage returns into the keyboard buffer, >which Inform…
Cannot read system catalogue!!
Path: emory!swrinde!zaphod.mps.ohio-state.edu!think.com!snorkelwacker.mit.edu!tamsun!mtecv2!root From: alfonso@mtecv2.mty.itesm.mx Newsgroups: comp.databases.informix Message-ID: <5153@mtecv2.mty.itesm.mx> Date: 20 Feb 92 18:47:54 GMT Sender: root@mtecv2.mty.itesm.mx Reply-To: al…