Threads from 2003
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Re: PowerBuilder and Informix
Mel Haynes Jr wrote: > ... > ... I love PB, but am afraid of the future > sometimes and when it came to finding PB developers to assist me in my area, > I had a hard time finding anyone. As a developer, I also found it hard to > find jobs that require PB. Thats just my opinion, .…
Re: query performance SE vs IDS
vomaringo@yahoo.com (Jack) wrote in message news:<682ae665.0312300319.5f59a97b@posting.google.com>... > Hi, > > i'm looking for arguments to explain why several dbaccess on a single > table are 2 times slower with ids than se. i understand this test > isn't quite pertinant.The ta…
Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
yeh all symbolic lins have fallen completely, Now what to do regards RATHORE ----- Original Message ----- From: "Ronald Cole" <ronald@forte-intl.com> To: <informix-list@iiug.org> Sent: Wednesday, December 31, 2003 12:01 PM Subject: Re: hi Cant load informix online 5.2 on linux…
Replication Issue
Hello All, We are trying to setup a replication between two informix database servers and we have struck up in a issue which we are not able to solve. We would be grateful if any of you can help us in solving out. The issue is We have a two server ol_server1 and ol_server2 we…
Re: MIME
I think Dirk raises a very significant point. How many people would be sending out emails as MIME without knowing. How does anybody know if they are sending mime? With so many email packages, anti-spam packages, etc how can anybody be sure? regards Malcolm ----- Original Me…
Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
"Neil Truby" <neil.truby@ardenta.com> writes: > Install it in /opt/informix as required to do by the bug, then use find > . -print | cpio -pvd or some other method to copy the contents of > /opt/informix to /usr/informix. Have symbolic links fallen completely out of fashion? --…
MIME
Sorry about the MIME - I sent my e-mail out as plain text, but they get converted to HTML by the anti-spam software Dirk Moolman Database and Unix Administrator MXGROUP "People demand freedom of speech as a compensation for the freedom of thought which they seldom use." -Kie…
RE: Happy New Year
Very cool, I must try this - had similar ideas but never tried them :-) -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Malc Sent: Tuesday, December 30, 2003 7:37 PM To: informix-list@iiug.org Subject: Re: Hap…
Re: PowerBuilder and Informix
I have been using Powerbuilder since version 5 about 10 years ago against Informix and have to say it has been a great product for building database apps. I have rebuilt the same app in VB and have not had nearly the functionality or ease of use I had with Powerbuilder. The dataw…
Re: java app shuts down Informix Server
I have been away on vacation, but did read through all the comments that were made and I appreciate everyone's feedback. Like I said, I am not to blame the database server for what has happened, but from what I have been told it may have been simply a network issue. I have seen j…
Subject: hi all Cant load informix online on /usr/inormix
This is a multi-part message in MIME format. ------=_NextPart_000_0037_01C3CF78.CA4376F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello friends. I tried 1. - When you get the error message type 'OVERRIDE', (all caps and without > the apos…
KCIUG January Meeting
Happy New Year from the Kansas City Informix Users Group Steering Committee. We hope you are looking forward to an exciting year with you local users group, as we are planning a number of informative and exciting events. Our first meeting of the year is just one month away, and…
Re: dbimport - memory fault
Eduardo wrote: > > I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try > to do a dbimport command "(dbimport <database> -d datadbs1)" I recive > the following error message: "memory fault - core dump". This error > occours when dbimport start to import the Stored…
Size limitation on dbload?
We are using dbload for our ETL process. We ran into an error today for the first time on an existing process. The error is Cannot open raw data file -> (dirname)/(filename). error occurred: 1 The file is 3 GB, and 3 million records. This is much larger than our normal loa…
Re: query performance SE vs IDS
On Tue, 30 Dec 2003 06:19:42 -0500, Jack wrote: > Hi, > > i'm looking for arguments to explain why several dbaccess on a single table > are 2 times slower with ids than se. i understand this test isn't quite > pertinant.The table is organize differently. The sqexplain shows an e…
RE: RDS 7.2 on Solaris 9
Which 7.3 version was your var talking about? 7.30, 7.31, 7.32 and which release? Dont think it is a good plan to implement something which is not supported. We have been using 7.30 on a number of platforms for years without significant problems and are upgrading some customers …
Re: dbimport - memory fault
"Eduardo" <cboccio@yahoo.com.br> wrote in message news:3274f7d5.0312300441.171ba080@posting.google.com... > I have already done what you suggested, but I need a permanent > solution. It�s because in each 4 months I have to run this process. > Please, send me as soon as possible t…
Re: query performance SE vs IDS
Hi, I agree with "Obnoxio" and I would add: a) Have you runned "update statistics" (high, medium ? ) b) Do you are talking about "select" tables, or "update", or "delete", or "load" ? c) Have you try using "directives" ?? Regards. H N Y (happy new year ) Obnoxio The Clown <obn…
Re: dbimport - memory fault
Hi, I'm using IDS 7.31.UD6 (in AIX 4.3.3 and AIX 5.2 ) and I had already the same problem. There is a problem, when developers are typing the text of Stored Procedures and they use "Tab" key ... The dbimport aborts sometimes. In our case, we have created views in Informix regard…
Re: dbimport - memory fault
Hi, I'm using IDS 7.31.UD6 (in AIX 4.3.3 and AIX 5.2 ) and I had already the same problem. There is a problem, when developers are typing the text of Stored Procedures and they use "Tab" key ... The dbimport aborts sometimes. In our case, we have created views in Informix regard…
RDS 7.2 on Solaris 9
I am being told by our Informix var that the 7.3 RDS tools are buggy and have issues with their product. We currently use 7.2 with SCO. We are/were planning on buying a pair of Sun V880's with Solaris 9. Although IBM won't sell or support it on Solaris 9 will the 7.2 tools run…
Please ignore test
Sorry, but my company expects me to access news groups through Google which has been giving me grief. I am also required by company policy to use a completely identifying sig, even for test posts. Sincerely, Christopher Coleman Acting President Kansas City Informix Users Grou…
Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
On Tue, 30 Dec 2003 00:19:02 -0500, RATHER wrote: Just install in /opt/informix and use the old 'tar trick' to move the files. As root: cd /opt tar cf - informix | (cd /usr; tar xvf -) cd /usr/informix rm -fr /opt/informix Art S. Kagel > Hi all > And Thanks Mr Tsutomu and mr …
Re: Happy New Year
Malc wrote: > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:bsqe95$dc7n$1@ID-64669.news.uni-berlin.de... > >> I hope you rot in hell, you stupid, HTML-posting, tosspot f*cker. > > Unusually succint, OTC. Santa not brung you what you wanted? I got the chain…
Re: Maintenance prices DOUBLED?
Truly sad... Chucho! Obnoxio The Clown wrote: > Maelwys Filidh wrote: > > >>Don't know about support pricing, but new licence pricing certainly had >>changed the last time I asked for a price (5 users IDS Workgroup). It took >>over 2 weeks to get a quote from IBM, and it was 5…
query performance SE vs IDS
Hi, i'm looking for arguments to explain why several dbaccess on a single table are 2 times slower with ids than se. i understand this test isn't quite pertinant.The table is organize differently. The sqexplain shows an estimate cost equal to 1. i don't think so it could be less…
Informix 9.3 compatibility
Need to work on application with following arch ( Red hat Linux AS 2.1 , Weblogic Server 8.1, Informix 9.3). My first query is whether Informix provides a flavour for Red hat Linux. Secondly , my client has Hp-UX UNIX box, so he is keen to use the existing licenses. So it possib…
Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
Hi all And Thanks Mr Tsutomu and mr Fernando Ortiz, I am trying to install in different filesystem thatn /opt/informix i have created /usr/informix and want ot install it in the " /usr/infomix " directory. not in /opt/informix. Any more sugesstion please. Thanks nad Regards Ha…
Re: Good news!
Neil Truby wrote: > Excellent publicity for IDS, ... > > ... The very essence of Linux - anti-proprietary, > open-source, free entitlement-to-use ... > ... But I just wonder where it all will end .... IDS 9.x released as open - source... (just dreaming...) Chucho! -- Atte, …
Bus error after migration to 64bit
Hi all, after an so upgrade to sun solaris 2.8 we had the informix updated as well to informix 7.31.fd6. For development porpuses we're using IBM Informix-ESQL Version 9.53.FC2R1 and gcc version 3.3.2. After this upgrade, our application can be compiled but it's crashing …
Happy New Year
This is a multi-part message in MIME format. ------=_NextPart_000_008B_01C3CDFC.C4B429A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Every New Year brings hope, new opportunity and change. If you are seeking contract or permanent employment …
Re: The Joys of the Jet Engine
Geoff, If you attach two Informix tables separately and run a query using both of them in Access, it downloads the two entire tables before joining them. The solution is to create Informix views containing all the conditions and joins, and returning only the columns you need, so…
dbimport - memory fault
Hi, I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try to do a dbimport command "(dbimport <database> -d datadbs1)" I recive the following error message: "memory fault - core dump". This error occours when dbimport start to import the Stored Procedures. Somebo…
INFORMIX Security best practices
I'm working as a consultant, several of our customers use INFORMIX Databases (From 5.x, 7.x to 9.x). I haven't been able to get vendor's information related to security such as best practices, configuration, etc on the IBM Web Site. Also, as far as I know, there is no books on …
Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
Hi, As Tsutomu said it's a bug in the RPM package of Red Hat 8, I know two workarounds: 1. - When you get the error message type 'OVERRIDE', (all caps and without the apostrophe). 2 . export RPM_INSTALL_PREFIX=/opt/informix export INFORMIXDIR=/opt/informix install without any …
Re: Difference Between dbaccess & isql
This is a multi-part message in MIME format. ------=_NextPart_000_0033_01C3CDF0.19D7E410 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Blankdbaccess should be fully compatible with isql with the exceptions = that it does not support…
Difference Between dbaccess & isql
This is a multi-part message in MIME format. ------=_NextPart_000_00EF_01C3CE0C.C2BF4430 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BlankHi All, We are working on Informix 9.3... Our current installation doesnot have isql utility... …
RE: hi Cant load informix online 5.2 on linux -8 ( rpm file)
Hi RATHER. Probably this is a rpm bug. Upgrade your rpm or use rpm for Redhat 7.3 (rpm Version 4.0.4). OR Search google. I do not test, but how about the following ? Use rpm2cpio, un-rpm to /opt/informix. Move /opt/informix to your targer directory. Execute installonline. Rega…
Re: Query Optimization ... Is this all I can get??
Anthony Presley wrote: > > Although your first option would work in my case, it would be a mess, > as they would have to be OUTER joins of the address and phone table, > and the joining of some 100K with 300K with another 150K takes some > time [although, this was my original sol…
Re: Maintenance prices DOUBLED?
Maelwys Filidh wrote: > > Don't know about support pricing, but new licence pricing certainly had > changed the last time I asked for a price (5 users IDS Workgroup). It took > over 2 weeks to get a quote from IBM, and it was 50% more expensive than > from Informix, not to menti…
RE: Maintenance prices DOUBLED?
St�phane Gadoury wrote: > Can someone clarify what is exactly the difference between Workgroup & > Enterprise ? > > We also had a HUGE increase because IBM is going cpu based instead of > users. We have a total of 72 cpu...imagine the price tag !!!! IBM would love everybody t…
Re: Maintenance prices DOUBLED?
Captain Pedantic wrote: > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:bsbk9r$bqmj1$1@ID-64669.news.uni-berlin.de... >> Paul Watson wrote: >> >> > Maybe IBM's right hand is still not speaking to the left:-)) >> >> What? Surely not! > > In my experience its r…
Re: IIUG94UC2-ifx user group
Very curious... indeed... So if you agree it is iiug's IDS 9.4UC1E1 then: .zip = 64,609,640 bytes .cpio = 189,731,840 bytes IOTW: 196,751,360 it's a bad size... that might be causing the cpio problems... conclusion?: A bad download?? but you mention you donwloaded 3 times...…
Re: IIUG94UC2-ifx user group
Very curious... indeed... So if you agree it is iiug's IDS 9.4UC1E1 then: .zip = 64,609,640 bytes .cpio = 189,731,840 bytes IOTW: 196,751,360 it's a bad size... that might be causing the cpio problems... conclusion?: A bad download?? but you mention you donwloaded 3 times...…
Reporting Suspicious Financial Transactions
I want to monitor any suspicious financial transaction which take place in a bank through electronic transfer. There are three tables Customers, Account and transaction_type. How can I write a SQl to report the following: Detect an outbound Electronic transfer that is unusuall…
hi Cant load informix online 5.2 on linux -8 ( rpm file)
Hello friends REcently i download Informix online5.2 ffrom iiug.org site for Liunx. Now i am trying to load this online5.2 version on linux 8. I have already user informix created and am giving the followin coomand from the root. rpm -i --relocate /opt/informix=$INFORMIXDIR 1…
OT: Test
I am just testing Google Groups.…
Re: Good news!
Curious that the link document was dated 11-03 and Redhat v 6.2 (the platform deployed upon) was two versions behind the currently available version of the Redhat product at that time (version 9.0 of Redhat was GA in Sept 2003). Of course IDS v 9.4 has been out for quite a bit o…
Problem inserting Blob data (invalid LO argument )
Dear All, I have IDS 9.4 on Win 2000. I have installed client sdk 2.81, i have also installed Informix JDBC Driver 2.21.JC5. I have a blob table. I could insert data into the table through java. Now i have installed IDS 9.3 on Sun Solaris and when i try to insert data, i get the…
Good news!
Hi all!! http://www-306.ibm.com/software/success/cssdb.nsf/csp/tknc-5u72ge Only for me ? Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* h…
Re: Parametes in SQL-Statement ?
On Wed, 24 Dec 2003 05:52:29 -0500, Sandro wrote: Use a stored procedure. Art S. Kagel > Hi there, > > is it possible with informix-sql creating an sql-statement with parameters > like in ms-access? > > sample with access: > > SELECT ArtikelName FROM Artikel > WHERE (((Artikel…
Re: oncheck -me option
On Tue, 23 Dec 2003 20:25:12 -0500, Wayne T wrote: Browse the archives again! That option was never documented and has since been dropped for several reasons: It does not work safely! You risk your data if you use it. This was covered on the list a few days after the initial…
Is Sysmaster update possible??
Hi, I am creating a new instance, "test1" from an existing instance, "test". I use the Unix command, "DD" to copy the chunk data from test to another chunk for "test1". When the "test1" instance comes up, the onstat -d command shows the chunk point to the link from the "test" in…
That's me done
I've now finished for the year, back to work Monday 5th Jan and in the interim period I shall NOT be spending a microsecond thinking about = anything Informix so 'bye to you all! Play nicely while I'm away ;-) Malc…
That's me done....
I've now finished for the year, back to work Monday 5th Jan and in the interim period I shall NOT be spending a microsecond thinking about anything Informix so 'bye to you all! Play nicely while I'm away ;-) Malc…
Re: Maintenance prices DOUBLED?
Paul Watson wrote: > <quote> > The following apply to the Workgroup Edition CPU limitation for IBM > IDS Workgroup Edition, IBM IDS Workgroup Edition, and Internet > Foundation > Workgroup Edition > > CPU LIMITS. Licensee may install and use IBM Informix Dynamic Server > Workgro…
RE: Maintenance prices DOUBLED?
The Workgroup edition was originally for small customer sites and ran also on NT. It includes pretty much all the features of Enterprise but the marketing behind it is different and so is the price tag. I don't know of any limitations within the product since I used both and co…
Re: Informix SE 7.25 on SCO OpenServer 5: query takes a ver
----- Original Message ----- To: Classics@iiug.org At: 12/24 10:01 ----- Original Message ----- To: michael@jadegroup.co.uk At: 12/24 9:51 My guess, and several suggestions: Make sure that the stats are up to date and at the recommended levels (see the Performance Guide or get…
Re: Maintenance prices DOUBLED?
"Tim Ertl" <tim@lmrgroup.com> wrote in message news:<bs9phq$3hj$1@terabinaries.xmission.com>... > We just got socked by a HUGE increase in Maintenance. Has anyone else? We are on IDS Workgroup (concurrent user) and Passport Advantage and the support costs (US) were reasonable an…
Re: Temporary table
TRY IT: In a database: ----------------------- spa@dsa2 --------------- Press CTRL-W for Help -------- create temp table rfo (a int) with no log ; insert into rfo values (100) ; NOW, IN OTHER SESSION, IN THE SAME DATABASE OR IN OTHER DATABASE IF IN THE SAME INSTANCE : --------…
Re: 25572 during connecting to another server
Hi, See your file (in unix systems ): /etc/hosts /etc/hosts.equiv Best regards. RFo "S. Radtke" <rt@pascal.de> wrote in message news:<br7bbe$4v9h$1@ID-210235.news.uni-berlin.de>... > Hi all, > > > perhaps anyone can help me. > > At first i have a …
Re: Problem installing 9.40 on AIX 5.1
Hi, Go to directory where you want to be the $INFORMIXDIR cd /$INFORMIXDIR Then, try run the command: ls -l installserver IF the file does not exist, look if you have a IDS.cpi or IDS.tar file and if it exists, run the correspondent cpio -ivcdBum or tar -xvf command. Merry chri…
Re: How I can import all database ???
Hi, I have already had troubles with dbexport / dbimport in 7.31 versions before 7.31.UD6W8, because in some stored procedures text developers used the "tab" key to separete words in it. We decide to separate the <database>.sql file, cutting the part after create views, create t…
Re: Problems with views?
Hi, Please, The view is referencing to another table in the same database ? Or is referencing to a table (or join tables) of another database ? If the second, the another database is informix , o other as DB2 ? Look if there is other application running a 'select' or 'update' …
RE: IIUG94UC2-ifx user group
Same letters with just a 'L' added!!! ... Merry Christmas and a Happy New Year G > > "Jonathan Leffler" <jleffler@earthlink.net> wrote in message > news:gqaGb.17595$Pg1.3210@newsread1.news.pas.earthlink.net... > > > What's worse, Linux seems to have the use of the -c flag backwa…
SQL Statement with parameters
Hi there, is it possible with informix-sql creating an sql-statement with parameters like in ms-access? sample with access: SELECT ArtikelName FROM Artikel WHERE (((ArtikelNr)=[Artikel:])); <---[Artikel:] is the parameter!!! thank for all answers.... Sandro Germany…
Parametes in SQL-Statement ?
Hi there, is it possible with informix-sql creating an sql-statement with parameters like in ms-access? sample with access: SELECT ArtikelName FROM Artikel WHERE (((ArtikelNr)=[Artikel:])); <---[Artikel:] is the parameter!!! thank for all ansers.... Sandro Germany…
Re: Maintenance prices DOUBLED?
Don't know about support pricing, but new licence pricing certainly had changed the last time I asked for a price (5 users IDS Workgroup). It took over 2 weeks to get a quote from IBM, and it was 50% more expensive than from Informix, not to mention horribly complicated. This was…
Re: Query Optimization ... Is this all I can get??
Yes - (amendment to my own response) - it's usually best to head an index with the most selective column, unless you have lots of queries that only reference the other column(s) or have an ORDER BY or GROUP BY that requires the index to be in a particular sequence. As for UPDATE…
RE: How to remove ER ?
Ph. Chantry wrote > > We use ER to replicate databases. > Our replication scheme involves 3 servers: 1 master 9.40.uc2, 1 slave > 9.40.uc2, 1 slave 9.30.fc3. > > ER works very bad (server crashes, and so on), so that we > stop replication > ("cdr stop") on the 3 servers. > Now I …
onbar/ism to filesystem only
Hello, question for migration to ONBAR/ISM: Today we are doing database backups with ontape or onarchive into the file system only. Later the database backup files get copied to tapes with the normal file system backup every day. Now we want (ontape) or must (onarchive) change …
RE: Maintenance prices DOUBLED?
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Colin Bull Sent: Tuesday, December 23, 2003 9:20 PM To: informix-list@iiug.org Subject: RE: Maintenance prices DOUBLED? Tim Ertl > > We just got socked by a HUG…
Re: IIUG94UC2-ifx user group
Xavier wrote: > Hi, > It doesn't work for me... > > I treid to read archive on debian > The size is : 196751360 > > > I used this syntax : "cpio -icvdBum < IDS2000.cpi" > ...and this message : "cpio: premature end of file" > > I tried this to list the content : > cpio -itv < IDS…
Re: Informix Object Interface C++: ITQuery.ExecToSet question
Vadim Yezhakov wrote: > On 10th December 2003 (or thereabouts) yezhakov@mail.ru (Vadim Yezhakov) wrote: >> How can i view ErrorText after executing ITQuery.ExecToSet >> method. For example, after executing ITQuery.ExecForStatus, >> ITQuery.ErrorText() returns the definition of oc…
Re: Query Optimization ... Is this all I can get??
Thanks for everyone's advice. Unfortunately, I am using a combination of Java and I4GL (moving everything to Jasper Reports at the moment), and was just using the "FOREACH" as an example. In reality, it is a for loop. I first added the (type, type_id) index, and then did an up…
Re: -360 Cannot modify table or view used in subquery
In my last message, I wrote: "The subquery means be a DB2 database", I did want mean that the sintax in the subquery that you wrote: "(SELECT NROHIS FROM GN_PACIENTE INNER JOIN TBPERPRIMARI ON TBPERPRIMARI.PRICDCIP || "00" = GN_PACIENTE.NROHIS WHERE pricdsituacion = 1 AND priidti…
Re: -360 Cannot modify table or view used in subquery
Hi, Pay attention, When you want update a table using a subquery, you cannot use the table that you update to 'select' a resultset of rows to decide which rows you update. I mean: If you update a column in the table, and the 'resultset' of rows selected in the subquery can chang…
RE: Maintenance prices DOUBLED?
Hi list, Can someone clarify what is exactly the difference between Workgroup & Enterprise ? We also had a HUGE increase because IBM is going cpu based instead of users. We have a total of 72 cpu...imagine the price tag !!!! Thks ! -----Message d'origine----- De : owner-infor…
oncheck -me option
Hi all, Does any body know what's IDS version I can use "oncheck -me partnum <taget extent>" This option allow to merge all extents into single extents and will not drop and recreate the table. Any info would be appreciated. --Wayne PS: or any similar tool do same as above and…
Re: IDS 9.40 on SLES 8 install problem
Thanks for the suggestion, Sean. You were right, a guy from Informix Muenich answered the same question on Linux-Informix IIUG forum. It seems I did not read release notes carefully enough - a glibc update is needed. Dragi "Sean R. Durity" <sdurity@cornercap.com> wrote in messa…
Re: How to remove ER ?
Did you try: cdr delete server {server name} This has to be run on every server. You can drop the syscdr database as long as replication is stopped and then run: dbaccess $INFORMIXDIR/etc/dropcdr.sql This will cleanup the cdr stuff from the sysmaster database. Ph. Chantry wrote…
Re: IDS 9.40 on SLES 8 install problem
I installed the same version yesterday on Suse 9.0 Pro on Xeon cpu (IBM e-server) without any problems. I had to get an older version of Java (1.3) from Sun for JDBC to install. Using raw devices, not flat files. I think that's the only difference. I have not made any changes to …
Re: Spurious error 197?
--0__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: multipart/alternative; Boundary="1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1" --1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: text/plain; charset=US-ASCII Content-tran…
RE: Spurious error 197?
This error will occur if you have done an express-mode high performance load job. You must archive the dbspace the data was written to before you can write to that dbspace. -Dave David Buchholz Senior DBA Vital Processing Services -----Original Message----- From: malc_p@btinter…
System Function that will give you current Saturday Date
Hi All, Is there a system function in Informix that will give you a current specific date of a week (specifically current Saturday). IDS 9.4 Dynix/Ptx 4.5.3 Thank you ALL…
RE: Maintenance prices DOUBLED?
Well sheesh, if you're being push to SQLServer then why not take the big leap and try Oracle? As for the VAR's... They're positioned to offer nice discounts where big blue won't, so I wouldn't sweep them aside completely.. -----Original Message----- From: Tim Ertl [mailto:tim@…
Re: Maintenance prices DOUBLED?
Paul Watson wrote: > Interestingly I was told by IBM today that Workgroup no longer exists I am "sceptical" about this assertion. > Ben Thompson wrote: >> >> Tim Ertl wrote: >> >> > We just got socked by a HUGE increase in Maintenance. Has anyone else? >> >> No, and this is co…
Re: Informix Client SDK and .Net connection question
There is an article in the MSDN that covers this topic at length, but in a fairly general sense at http://msdn.microsoft.com/architecture/application/default.aspx?pull=/library/en-us/vbcon/html/vboriintroductiontoapplicationsettingstorage.asp The opening sentence is "Dynamic p…
RE: Maintenance prices DOUBLED?
Wow! I did not expect such an outpouring of interest! So far I have received a number of VAR phone calls. In e-mail I have had several IBM Customers say they saw the same price increase I did but a couple of UK customers said they saw prices stay the same. I am NOT intending to …
RE: Maintenance prices DOUBLED?
Tim Ertl > > We just got socked by a HUGE increase in Maintenance. Has anyone else? > > 12/2001 we had $5k > 12/2002 we had $6k > 12/2003 we have $10,600 (after bartering down from $11,056) > > This is bad news for me since some of our management group > seems to love > the idea …
RE: Maintenance prices DOUBLED?
Tim- We had something similar when we were put into Passport Advantage. Our solution was to drop our Enterprise server licenses and replace them with Workgroup type licenses. Even with going to 10 WE servers and 80 WE users (as opposed to 40 Enterprise users), the support cost…
Re: Spurious error 197?
What is interesting is that it says "partition" recently added to. That seems to imply that the extents of a tblspace have been added to. But I don't see why that would require a level-0 archive. You didn't by any chance do an oncheck -pt of the table before doing the level-0?…
Re: Honest Answer Hard to Achieve
Maybe take a look at http://aubit4gl.sourceforge.net. You might get an idea here. --- Smitty <wolphie@hotmail.com> wrote: > Our company is using Informix SE 4.0 (1990) and want > to upgrade to > Informix SE 7.x. The primary reason being so we can > use ODBC to > connect to the W…
Spurious error 197?
IDS9.30HC5, HPUX 11i, 4GL 7.20 Just had this on one of our test systems when writing to a table: ===================================================================== -197 ISAM error: Partition recently appended to; can't open for write or logging. If this internal error recu…
Maintenance prices DOUBLED?
We just got socked by a HUGE increase in Maintenance. Has anyone else? 12/2001 we had $5k 12/2002 we had $6k 12/2003 we have $10,600 (after bartering down from $11,056) This is bad news for me since some of our management group seems to love the idea of M/S SQL server. Anybody…
IDS 9.40 on SLES 8 install problem
Hi! I am trying to run Informix IDS 9.40UC2E1 on SuSE SLES 8 (single-proc P4). Installation goes OK, but when oninit is supposed to initialize the root dbspace chunk, it quietly dies (failing to remove SHM segments and semaphores). This is what oninit -iv says before it dies: …
How to remove ER ?
Good morning/evening, We use ER to replicate databases. Our replication scheme involves 3 servers: 1 master 9.40.uc2, 1 slave 9.40.uc2, 1 slave 9.30.fc3. ER works very bad (server crashes, and so on), so that we stop replication ("cdr stop") on the 3 servers. Now I want to rebu…
Unknown error message -958
OS : Windows 2000 Server Database : Informix 7.31 TD1 Programming : Centura Team Developer 1.51 PTF 6 I have the error "Unknown error message -958" with the instruction "create temp table....". I have not this error all times. Please help Me ! Cyril…
Re: Perfomance Tuning
This may help read performance but it will do nothing do speed up checkpoints. In fact increasing the number of buffers could make for longer checkpoints because it is less likely that LRU_MAX_DIRTY will have kicked in between checkpoints, so there's likely to be more data left t…
Re: ontape/onbar
You are right, ontape and onbar are not intended to allow you to recover individual dbspaces / databases at a *logical* level. Sure you can restore an individual dbspace but IDS will force you to replay the logs so that all dbspaces are consistent in time before it will let you a…
Re: IIUG94UC2-ifx user group
Hi, It doesn't work for me... I treid to read archive on debian The size is : 196751360 I used this syntax : "cpio -icvdBum < IDS2000.cpi" ...and this message : "cpio: premature end of file" I tried this to list the content : cpio -itv < IDS2000.cpi -rw-rw-rw- 1 39155 136…
Re: Informix SE on Linux
http://www.iiug.org regards "MuellervK" <muellervk@isdcad.de> a �crit dans le message de news:4ca25542.0312090843.4be7903d@posting.google.com... > I look for the free Informix SE 7.x for Linux released 1998 > for testing an old peace of software > but unfortunately I could not …
Re: Honest Answer Hard to Achieve
I am an independent consultant with nothing to gain by the advice I am giving. Basically I have been working in the Informix arena for about 16 years and my advice is that you should bite the bullet and buy new licences for Informix-4GL at the same time as doing the engine upgra…
Re: Informix Object Interface C++: ITQuery.ExecToSet question
yezhakov@mail.ru (Vadim Yezhakov) wrote in message news:<2d8b1865.0312101455.2c43a3c3@posting.google.com>... > Hello. > I have a question. > How can i view ErrorText after executing ITQuery.ExecToSet method. > For example, after executing ITQuery.ExecForStatus, > ITQuery.ErrorTex…
Query Optimization ... Is this all I can get??
Hello all .... Always with the query questions .... so I come to you once again. 1st -- my textbooks on this subject are rather sparse, and a bit ... un-useful. Anyone have any good links / articles / books on query optimization? 2nd -- the actual problem .... I have a SIMPL…
old FourGen users: beware of Gillani Inc.
Former FourGen users If you want to get away from older versions of FourGen, be very wary of approaching Gillani Inc for discussions. An old FourGen site from way back made contact with them, culminating in Gillani Inc sending a solicitors letter of demand for backpayment and de…
Re: storing the value of PI
What worries me is that I actually understood the following :) Clifton PS. Merry Christmas, Everyone :) "Jonathan Leffler" <jleffler@earthlink.net> wrote in message news:fOPBb.7058$_r6.1008@newsread1.news.pas.earthlink.net... > Ravi Krishna wrote: > > "Jonathan Leffler" <jleff…
Any help on this would be great !
Could some one figure this out ? Here is the scenario, on my restore everything works fine. Only thing is that I do not see the usual message in the bar_act.log for each logical log restore stating that it completed all the logical logs, it only shows the last logicat log been re…
Re: PowerBuilder and Informix
Although it is subjective: "fairly basic database applications", I think Power Builder is very expesive for that matter... it's something like U$5,xxx or more (enterpirse edition). In regard of "many Informix/PowerBuilder developers"... they are not much... that is even a commo…
Re: Honest Answer Hard to Achieve
I think Application migration could be a bigger job than a database migration. Although recently we migrated all our application mainly 4gl from online 5.1 to 9.3 without almost no problem except for some bizarre SQLCA constructs that just stopped working as expected and some qu…
Fw: [informix-alums] Ex-Informix CEO pleads guilty to securities fraud
----- Original Message ----- From: Mark B Sigler To: informix-alums@yahoogroups.com Sent: Friday, December 19, 2003 09:29 Subject: [informix-alums] Ex-Informix CEO pleads guilty to securities fraud http://www.usdoj.gov/usao/can/press/html/2003_12_18_white.html http://biz.yahoo.…
Honest Answer Hard to Achieve
Our company is using Informix SE 4.0 (1990) and want to upgrade to Informix SE 7.x. The primary reason being so we can use ODBC to connect to the Windows world (to use report writers, make VB/Delphi front-ends, etc.). But we have 1000s of existing 4GL programs and need them all…
Informix Client SDK and .Net connection question
Hello all, CSDK Driver: IBM Informix CSDK 9.52 2.81.TC3B2 For the IfxConnection.ConnectionString since you cannot use "DSN=XXX" as in the specs,how do you set up a connection string on production without hardcoding the uid and pwd information. Thanks Inadvance Chavan Koya…
Re: ontape/onbar
Jogi, You can restore a single instance with the following commands (please confirm the syntax in the Informix manuals): 1. onmode -O -d <dbspace_name> 2. "onbar -r <dbspace_name>" OR "ontape -r -D <dbspace_name>" So if you have your databases in their own instances, one can r…
PowerBuilder and Informix
We are evaluating the use of PowerBuilder 9 for building fairly basic database applications hitting an Informix 9.x server. Some of this is re-writing/re-working a 4GL application. I would like to know if there are many Informix/PowerBuilder developers out there and if they recom…
RE: strange database-problem
I think we all run into these silly problems. Sometimes you need to take a break and then come back to a problem a bit later again. Dirk -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Philipp Walderdorff Sent:…
bug in date function??
TO_CHAR(TO_DATE(TO_CHAR(odklon.datodk, "%0d%0m%Y"), "%0d%0m%Y")+6 UNITS MONTH, "%0d%0m%Y") AS DATE_FIN What is wrong with this statement. If datodk=31-05-1988 I get the following error: Error: The result of a datetime computation is out of range. (State:22008, Native Code: FFF…
Where can i download 4GL for windows?
Hi all, does there has any trial version of 4GL for windows that i can download?…
Difference between Enterprise Replication and HDR
Hi can any one you, please tell me what is the difference between Enterprise Replication and High Availability replication. I have worked extensively with HDR, but i dont know what is ER. Can I get the information on ER and how it works and what are the requirements and specifia…
Re.Extents & Indexes
Hello Everybody, Env : 9.30 uc3 AIX 5.1 1) Is there any limitation on the first extent ? This is the current scenario. Dbspace name - xyz Data dbspaces - 8 (each 2gb * 2 chunks) Index dbspaces - 4 (each 3 gb) Fragmented by round robin. First extent size 1000000 Now if I chan…
Re: PAM authentification
The bug is also in 7.31.xD6. You need to upgrade to 7.31.xD7 to get rid of the bug. Take care. Clifton "Rastislav Janac" <rastislav.janac@dignitas.sk> wrote in message news:bqniro$1n4$1@terabinaries.xmission.com... > > > Dear all > > we are using Client SDK 2.81 (inculding log…
Need a Printer Pop-Up Selection Screen/Box
Hello Printer Selection BOX I need a script/c program/whatever that does this I have about 30 Printers Need to display all of them in a box/screen (like text pop-up screen) and allow user to select one (using navigation keys, left,tight,up,down) For eg: -----------------------…
CISAM .idx structures
Is there any published tech specs on the CISAM idx structures for CISAM v 7.2.X? We are having issues with some of our reads/writes to the .dat files and we wanted to do some low level investigations on the indecies. If we can't get that some info on what typically is held in an …
Re: ism_rm hangs
Actually, it doesn't appear to be hanging, it appears to be pegging the cpu. But there is no memory growth, no disk activity, and rebooting or restarting the service doesn't seem to help.…
Re: Solaris memory usage
3.76GB is the number I've seen (and used) for Solaris 32bit. cheers j. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "Art S. Kagel" <kagel@bloomberg.net> To: <informix-list@iiug.org> Se…
Re: Emulation the Terminal
Yep! It's an informix bug... Maybe someone has a solution for this... (4GL 7.32?) I workarounded the problem defining an ON KEY clause that do the job for the interrupt key... inside the clause activate int_flag (LET int_flag = TRUE) and do an EXIT [INPUT|CONSTRUCT]... whateve…
Re: sql editor from informix
--0__=09BBE492DFF3D94E8f9e8a93df938690918c09BBE492DFF3D94E Content-type: multipart/alternative; Boundary="1__=09BBE492DFF3D94E8f9e8a93df938690918c09BBE492DFF3D94E" --1__=09BBE492DFF3D94E8f9e8a93df938690918c09BBE492DFF3D94E Content-type: text/plain; charset=US-ASCII sqleditor w…
Re: sql editor from informix
Sjaak van Esdonk wrote: > Anyone know where i can download it from ? > Google for ifxsql and winsql -- Atte, Jesus Antonio Santos Giraldo ----------------------------------- jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list…
Re: sql editor from informix
--0__=08BBE492DFC958BE8f9e8a93df938690918c08BBE492DFC958BE Content-type: multipart/alternative; Boundary="1__=08BBE492DFC958BE8f9e8a93df938690918c08BBE492DFC958BE" --1__=08BBE492DFC958BE8f9e8a93df938690918c08BBE492DFC958BE Content-type: text/plain; charset=US-ASCII Hi Sjaak, …
Coming Available
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_01C3C63A.2CE58CF0 Content-Type: text/plain If this is not the place for this, please forgive the intrusion. I am a 4GL p…
Multi-byte characters
Hi All, Does Informix data type support multi-byte characters. I need to insert data with multiple languages. I have a field with nchar(20). If i insert a english or french data of length 20 chars it inserts in to the table. But when i want to insert korean data of same length, …
Re: Solaris memory usage
From: $INFORMIXDIR/release/en_us/0333/IDS_7.3 22. This product supports the Informix LMA (Large Memory Addressability) feature. Informix LMA provides the ability to support system configurations with greater than 4GB of RAM. Most UNIX systems are limited to at most 4…
Emulation the Terminal
Hello, unfortunately i have near completion Christmas a Problem with the terminal-emulation for an applications. Problem: 4GL-Program is compiled without any problem. Therefore, i can use the applications but the applications response not correctly with the Break-button, the a…
Solaris memory usage
Can anyone tell me how much contiguous memory Solaris will allow Informix to use ? (Solaris 8, IDS 7.31 FD3) I remember a couple of years ago, working on AIX there was a limit on the memory usage, and memory in Unix would be split, which impacted on performance. Is this als…
sql editor from informix
Anyone know where i can download it from ?…
Onbar without ISM
can informix back'ed up using ONBAR without install ISM?…
strange database-problem
I am using: INFORMIX-4GL Version 1.10.00B/2.10.00B Copyright (C) 1986-1987 Informix Software, Inc. My Problem: Problems with changing the database: "Incorrect database or cursor name format" The program is compiled at a computer running on XENIX (UNIX), The applicati…
Re: AW: remote synonym for table with boolean column (bug?) [2371]
--0-1885777015-1071805810=:41590 Content-Type: text/plain; charset=us-ascii This is a known "That's just how it works" problem. There is no work around according to tech support. I was lucky and didn't need the boolean column mapped in the synonym, so I created a view in the sou…
Re: Change varchar column
Madison Pruet wrote: > "Mark" <kbl@net-yan.com> wrote in message news:<brq3mc$243e$1@news.hgc.com.hk>... > >>Dear all, >> >>During a table schema migration task, I unloaded data from a table, drop the >>table and re-create the table with changed some column from varchar(10) to >>…
Little help please
Hi Folks, I am fairly new to the Informix area and have downloaded the (I presume) limited version ids9.4 from the IBM website. I have loaded both IDS9.4 and the ISA tool successfully and am able to connect both via the browser to the database and also locally to the database in…
RE: java app shuts down Informix Server
Mel, if what you're seeing looks like this: 07:00:42 Assert Failed: No Exception Handler 07:00:42 IBM Informix Dynamic Server Version 9.40.HC2 07:00:42 Who: Session(10, informix@myserver, 0, ce9ed5a0) Thread(15, btscanner 0, ce9bd26c, 1) File: …
Re: The Joys of the Jet Engine
"Roff, Geoff" <geoff.roff@office2office.biz> writes: > Access 97 ... > The business are refusing to give up MSAccess... Access is single threaded. Access 97 has some *serious* bugs. Have you tried upgrading to Access 200[023]? There may not be a solution here as the business h…
Re: java app shuts down Informix Server
--0__=08BBE493DFE831C68f9e8a93df938690918c08BBE493DFE831C6 Content-type: multipart/alternative; Boundary="1__=08BBE493DFE831C68f9e8a93df938690918c08BBE493DFE831C6" --1__=08BBE493DFE831C68f9e8a93df938690918c08BBE493DFE831C6 Content-type: text/plain; charset=US-ASCII Content-tran…
Re: DSN-less and oledb connection scrint for Informix using OpenLink
In the interest of saving space I've trimmed off the text of the response. Wouldn't these values just apply strictly to the IBM provider? Different providers have different required fields, correct? I've looked at the OpenLink documentation, but it seems to assume that everyon…
AW: remote synonym for table with boolean column (bug?) [2371]
Some additional information on that: 1. You can't even do a remote select on that column; 2. You still can do remote select on other non-boolean columns of that table ------------------------------------------ Alexey Sonkin Senior Database Administrator > > I've just found a…
remote synonym for table with boolean column (bug?)
Hi, everybody, I've just found a very strange problem that reproduces in 9.21uc4 and 9.40uc2: 1. Create table containing boolean: create table test_tab (aaa boolean) 2. In another database (on the same server), create remote synonym for that table: create synonym test for test:…
remote synonym for table with boolean column (bug?)
Hi, everybody, I've just found a very strange problem that reproduces in 9.21uc4 and 9.40uc2: 1. Create table containing boolean: create table test_tab (aaa boolean) 2. In another database (on the same server), create remote synonym for that table: create synonym test f…
Re: Need fetch row by row, without foreach loop (SPL)
What is exec data blade?…
java app shuts down Informix Server
Hi all, I am getting reports from a customer saying my Java application is causing the Informix server to crash. He reports that it started causing problems when they started processing large amounts of data ( millions of rows? ). They have had to restart the Informix server sev…
Re: DSN-less and oledb connection scrint for Informix using OpenLink
--0__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: multipart/alternative; Boundary="1__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144" --1__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: text/plain; charset=US-ASCII The followi…
Re: Where can I get the client API?
Hi, You could use CSDK to access the server. CSDK is a collection of APIs used to develop applications for Informix servers. You can write your application in C, C++, ESQL/C. The product consists of 4 APIs that can be used on Unix - ESQL/C, LIBC++, LIBDMI and ODBC. On Win…
Re: Where can I get the client API?
--0__=08BBE493DFCB52A38f9e8a93df938690918c08BBE493DFCB52A3 Content-type: multipart/alternative; Boundary="1__=08BBE493DFCB52A38f9e8a93df938690918c08BBE493DFCB52A3" --1__=08BBE493DFCB52A38f9e8a93df938690918c08BBE493DFCB52A3 Content-type: text/plain; charset=US-ASCII Hi, You ca…
DSN-less and oledb connection scrint for Informix using OpenLink drivers
I've recently started to work with performing queries against an Informix 2000 database using the OpenLink drivers and ADO. I've figured out to use a DSN connection string in my VBScript, but I would prefer to use a DSN-less connection. I would also like to try an oledb connecti…
The Joys of the Jet Engine
Informix Dynamic Server Version 7.31.UD5 DYNIX/ptx 4.0 V4.4.10 i386 SunOS 5.8 Generic_108528-20 sun4u sparc SUNW,Sun-Fire-480R Access 97 ODBC Driver INFORMIX 3.80 32 BIT I unfortunately have a business user created MSAccess group of databases that defies belief, but, guess who …
Shared memory problem
Platform : Win2000 / IDS 9.30.TC3 I get the following error when increasing the buffers. shmat [ENOMEM] [12]: out of available data space, check system MAXMEM shmdt: errno 22 mt_shm_init : can't create virtual segment. The server has 2 Gig of physical memory of which approx. 9…
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.…
RE: Default Select Order
This is a multi-part message in MIME format. ------_=_NextPart_001_01C3C544.D8890614 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You can use, the rowid, column. =20 Ex: =20 select c.rowid, c.code, c.name from customer c wher…
ism_rm hangs
Windows 2000 informix dynamic server 9.3 ism_rm occasionally hangs. It always hangs on the same command, removing a particular volume. The hang doesn't happen all the time, and we haven't discovered a pattern or trigger for it yet. Has anyone experienced this? Does anyone kn…
Default Select Order
This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C3C54B.0BBDC0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BlankHi All, I have a Select * from <tab> where <col> = "some condition" Can i know wat is the defa…
IDS 7.30.UC10 crashing on AIX
Please help: Customer has 7.30.UC10 on AIX 4.3.3. It has been running very smoothly for a long time until this week when Holiday Sales picked up. now it crashes a few times a day. Any advice on this would be appreciated. Thanks! This is the error message they are getting: IDS …
RE: Change varchar column
How did you measure space used? Engine version? Schema? oncheck -pt output (before and after)? > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Obnoxio The Clown > Sent: Thursday, 18 December 2003 6:28 …
Re: Change varchar column
Have you checked your FILLFACTOR? Bernstein, Rick wrote: > Are indexes built on this changed column? > Each occurrence of this changed column in an index will now consume > 256 bytes instead of 11 bytes. > > Rick > > -----Original Message----- > From: Obnoxio The Clown [mailto:…
Re: Need help on the correct SQL syntax
Miyaki, Try the below syntax: DELETE FROM [Order Details] where orderid IN (select orderid from Orders where customerid = 'VINET') Good luck. Xuanhai >>> miyaki <lcib@yahoo.com> 12/17/2003 12:19:14 AM >>> Hi all, What is the valid delete command in Informix tha…
RE: Change varchar column
Are indexes built on this changed column? Each occurrence of this changed column in an index will now consume 256 bytes instead of 11 bytes. Rick -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Wednesday, December 17, 2003 9:28 AM To: infor…
Change varchar column
Dear all, During a table schema migration task, I unloaded data from a table, drop the table and re-create the table with changed some column from varchar(10) to varchar(255), then re-load the original data back to the new table. We found space used increased from 1GB to 1.5GB …
Need fetch row by row, without foreach loop (SPL)
There is a way, any way to do this in SPL? Can be using external proc, C, anything... thanks.…
FW: Log errors - network ?
I am getting the following errors running my logical logs (continuous backup). We've been having A LOT of network problems lately, and my question is - could these also be network related ? I can only think that somehow I am getting tcp errors, and this is affecting Unix (or t…
RE: new server - NO RAID5 !!!!
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Art S. Kagel Sent: Wednesday, December 17, 2003 1:25 AM To: informix-list@iiug.org Subject: Re: new server - NO RAID5 !!!! [snip] > too little knowledge of the stora…
Re: Need help on the correct SQL syntax
I think this syntax is only supported in XPS. If you have IDS or other... you are out of look and have to use some kind of correlated query ie: WHERE EXISTS(...) miyaki wrote: > Hi all, > > What is the valid delete command in Informix that can > referring to 2 tables? > > E.g. …
Re: Informix thread management
OK, but on the other hand I *have* seen very small queries get blocked when for some inexplicable reason IDS calculated a DS_MAX_QUERIES of 6, which is a mystery in itself. (They haven't set the DS values in the onconfig, but according to the calculation in the manual it should b…
Need help on the correct SQL syntax
Hi all, What is the valid delete command in Informix that can referring to 2 tables? E.g. delete from table1 where table1.field1 = table2.field2 Similiar to the SQL statement as below used in Microsoft SQL server. DELETE FROM [Order Details] FROM [Order Details] AS OD JOIN Or…
Need help on the correct SQL syntax
Hi all, What is the valid delete command in Informix that can referring to 2 tables? E.g. delete from table1 where table1.field1 = table2.field2 Similiar to the SQL statement as below used in Microsoft SQL server. DELETE FROM [Order Details] FROM [Order Details] AS OD JOIN Or…
Re: Need help on the correct SQL syntax
I think this syntax is only supported in XPS. If you have IDS or other... you are out of look and have to use some kind of correlated query ie: WHERE EXISTS(...) miyaki wrote: > Hi all, > > What is the valid delete command in Informix that can > referring to 2 tables? > > E.g. …
Re: Anyone seen this behaviour before ?
TBP <TheBIgPotatoe@Nospam.Nothere.Co.Uk> wrote in message news:<brn87n$vi0$1@sp15en20.hursley.ibm.com>... > mad_villan wrote: > > I have a HDR pair which were working fine up until lately. The primary > > runs in a veritas clustered environment - secondary is standalone. > > Conf…
Re: problem with informix cursor
On Fri, 16 May 2003 09:48:49 -0400, ephesus wrote: > i found informix sometimes may miss some records in fectch cursor,could > someone tell > me why? > thx Version? Platform? Front-end tool? Troublesome SQL? Come on, you have to give us SOMETHING to work with here. If this is…
-360 Cannot modify table or view used in subquery
Hello everybody, My query : UPDATE GN_PACIENTE SET GRUPO = "G00" WHERE NROHIS IN (SELECT NROHIS FROM GN_PACIENTE INNER JOIN TBPERPRIMARI ON TBPERPRIMARI.PRICDCIP || "00" = GN_PACIENTE.NROHIS WHERE pricdsituacion = 1 AND priidtippersona < 6 ) I read the Informix error messages…
Problems with views?
Hi I have a problem with our system which is yielding error -243. Platform: Windows 2000 Informix 9.21 TC6R1 Single user development environment VB6 front end Scenario: Running a stored procedure which involves a view as part of a SELECT may sometimes cause the error "Could no…
new server
Current: Sun Enterprise 6000 dedicated database server, solaris 8 - patch level current; hardware mirroring; 4 attached arrays; various mixture of disks old and new; 1 instance at 430 gig. Due to recent growth, a new server has been purchased: Sunfire 6801 that can support up to…
Problems with views?
This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C3C3E5.F75CFF60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I have a problem with our system which is yielding error -243. Platform: Windows 2000 Inform…
Anyone seen this behaviour before ?
I have a HDR pair which were working fine up until lately. The primary runs in a veritas clustered environment - secondary is standalone. Configuration is fine. However, when i recently failed over to the second node in the cluster the instance came up cleanly BUT there was a con…
Onbar can't restore IDS
Hi All. I try to restore Informix dynamic server 7.31 uc5 on SCO Open server and it failed with errors. 2003-12-16 12:28:52 5971 5970 /u/informix/bin/onbar_d -r -w 2003-12-16 12:31:32 5971 5970 Successfully connected to Storage Manager. 2003-12-16 12:31:32 5971 5970 XBSA Error …
Needs Help, Error 243 / 111 by creating tmp Table
Hello, I have following problem, sometimes the following Sql Command fails: SELECT distinct b.pabx_id, b.dev_cl_gr,b.dev_class,b., a.switch FROM OUTER filtconftable a, alarm b WHERE a.pabxid=b.pabx_id AND a.group=b.dev_cl_gr AND a.subid=b.dev_class …
update, concatenation strings
create table test ( test1 char(30), test2 char(30) ); insert into test values ("aaa","bbb"); insert into test values ("bbb","bbb"); insert into test values ("ccc","bbb"); update test set test1=test.test1||"xxx"; select * from test; How to concatenate strings in update stateme…
RE: Need the experts , Informix freeze or down
Hi Shay send me online.log regards HITEN .S.BHAWSAR -----Original Message----- From: shay@formula-travel.com [mailto:shay@formula-travel.com] Sent: Tuesday, December 16, 2003 3:23 PM To: informix-list@iiug.org Subject: Need the experts , Informix freeze or down Hi gurus, I n…
Re: Informix thread management
Thanks for a most informative post Art - as ever. On the site I'm on at the moment users often connect with PDQPRIORITY=HIGH and I'm sure I've seen several run at the same time and not get blocked. They just don't seem to get to do much in the way of parallel processing - though…
Need the experts , Informix freeze or down
Hi gurus, I need urgent help ,informix freeze for some reason and no command can be run except onstat command. I cannot stop the service and restart ,don't see any locks (onstat -u). The CPU is free also the memory. Users cannot connect to informix and connected users cannot wor…
RE: CREATE DATABASE permission.. IT'S OK!!
Hi ALL, Does it work whith IDS 7.31.UD6?. Thanks. -----Message d'origine----- De : Sadi G�rsoy [mailto:sadi@login.com.tr] Envoy� : mardi 16 d�cembre 2003 07:46 � : IIUG Objet : Re: CREATE DATABASE permission.. IT'S OK!! Hi David. This parameter really worked. Thanks. Sadi ----…
Re: CREATE DATABASE permission.. IT'S OK!!
Hi David. This parameter really worked. Thanks. Sadi ----- Original Message ----- From: "Link, David A." <DALink@west.com> To: "Sadi G�rsoy" <sadi@login.com.tr>; "IIUG" <informix-list@iiug.org> Sent: Monday, December 15, 2003 4:19 PM Subject: RE: CREATE DATABASE permission You …
Re: Perfomance Tuning
Guys thanks for your contributions. there are some points that have helped me like, A checkpoint cannot proceed while a user is in a critical session.Have been actin on this. Thanks guys. "Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message news:<br7lpe$sc7$1@terabinaries.xmiss…
Informix Under Windows 2000
Please let me preface that I am not new to Informix, just new to Informix 7.3x using Windows 2000. I am wondering if there are many users of Informix using Windows 2000. I am interested in how you configure your disk partitions, memory parameters (max value of SHMVIRTSIZE), remo…
RE: Logical log backup on XPS
Ontape utility does'nt come along with XPS. We have to use onbar. But we need to do a bit of configuration for the same.(as mentioned by Murali). Else we can set LOG_BACKUP_MODE to NONE. Another problem was that I had just 6 logical logs with 1 mb each, which was too less. I rei…
RE: Very slow archives - the Very Old Page bug perhaps?
Sorry, I forgot to mention the need to make one oninit -iy after the dbexport's and before the dbimport's, sorry again Gustavo Tobares Administrador de Sistemas y DBA Centro de C�mputos - Red Megatone TE: 0342-4500972 - Fax: 0342-4500940 -----Mensaje original----- De: andykent…
Re: Disappointing test results from 9.40
Having redone the tests on a Linux server, I think I agree now that we may be hitting the bug highlighted by Jonathan Leffler and UK Tech Support.. The results on the Linux server, in contrast to those on HP, show a clear reduction in the alter fragment time when logging was ena…
Help on Update query
Hi , I have the below select query which will pick up the max effseq record for each effective date. select effdt,max(effseq) from ps_p1_abs_accrual where emplid='110999' group by effdt ------------------------------------------------------------------------ EFFDT EFFSEQ ----…
Informix Freeze or Down
Hi All, I need the group help on this issue (Informix support doesn't seems to help). OS is window2000 RAM 3GB 2 CPU Informix 7.31 TD3.1 For some reason informix cannot accept new connections or serve existing connections. No command except onstat -???? is working. The only way …
Kluge with serial values--Is it safe to use negative values in the
Due to circumstances beyond my control, and constraints that are 'challenging', we are considering a kluge using serial values. It is ugly and trust that it will be a last resort. I am in essence creating a gap in the serial values and letting the serial next value work as it n…
Informix ODBC Driver Memory Allocation Failure
Hello all, We have been running one Windows service written in dotNet. Some times the service was logging the following error in the "application log" in the Event Viewer. The message is as below ------------------------------------------------------------------------- …
Dbimport error 625
Hi guru I did a "dbimport" of a database, previously exporting from an IDS 9.30 OS WINXP, in an IDS 9.40 always on OS WINXP, but I obtain the following error: *** execute sqlobj 625 - Constraint name (n134_189) already exist. What it means? Note, The engine just was installed a…
RE: CREATE DATABASE permission
You can add the following line to you ONCONFIG and it will only allow the user "Informix" to create databases. DBCREATE_PERMISSION informix -----Original Message----- From: Sadi G�rsoy [mailto:sadi@login.com.tr] Sent: Monday, December 15, 2003 5:29 AM To: IIUG Subject: CREATE D…
Re: A Big cursor problem in SPL. Anybody help?
Ravi Krishna wrote: > "TBP" <TBP@Nospam.Nothere.Co.Uk> wrote in message news:ka6Db.736$S63.521@newsfep3-gui.server.ntli.net... > > >>>this will work but this is a very bad solution. creating a view inside a SP means an >>>object is created inside a SP. Depending on how your SP is…