Threads from 2004
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Re: missing install instructions/pieces
On Thu, 30 Dec 2004 08:46:36 -0500, "Jean Sagi" <jeansagi@myrealbox.com> wrote: > > >I have to mention that IBM fixed the download for the trial, and I was able to download. > >... very impressed with the reponse ... > > Stripped down version or the full-featured version? JWC…
Re: Informix on AIX (newbie).
--0-1254431829-1104530637=:49662 Content-Type: text/plain; charset=us-ascii Any ascii terminal, such as vt100 will display dbaccess and onmonitor. Onstat and oncheck don't even have interfaces. They are pure commandline. Nuno Paquete <nmp@ispgaya.pt> wrote:> onstat -- will show…
HAPPY NEW YEAR!
Happy New Year! *<:-)…
Re: Informix on AIX (newbie).
> onstat -- will show you all the onstat options ( which will apply to your > instance ) > onmode -- will show you all the onmode options. > oncheck -- will show you all the oncheck options. > > echo "select * from sysdatabases" | dbaccess sysmaster will show you all > the databa…
Re: SPL DATETIME bug ????
This performance fall off is only on datetimes, if the where clause uses integers then it's fine. If I drop the datetime select into the exec blade the performance is back to 0.3 Art S. Kagel wrote: > Paul Watson wrote: > > The difference is that effectively the second query/s…
Re: Savepoints - Was: Isolation levels in Informix vs Oracle
Mark Townsend said: > > albeit with a number of specious implications. People in glass houses, etc. :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" …
Re: Isolation levels in Informix vs Oracle
Mark Townsend said: > rkusenet wrote: >> "Mark Townsend" <markbtownsend@comcast.net> wrote >> >>>The feature battles with Informix are long, long over. >> >> what about performance battle :-) > > As far as Informix is confirmed, it was all very much "The horse never > rode and th…
Re: Isolation levels in Informix vs Oracle
Mark Townsend said: > Obnoxio The Chav wrote: > >> Pull the other one. It has (festive) bells on it. :o) > > Ew. TMI and can't you get an ointment for that ? It's not that bad. It only comes once a year, which is. :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire…
SPL DATETIME bug ????
what does: let l_dte1 = "2004-09-29 09:57:58.00" let l_dte2 = "2004-12-29 09:57:58.00" select count(*) from table1, table2 where join and datetime between l_dte1 :: datetime year to fraction(2) and l_dte2 :: datetime year to fraction(2) do????? assuming that your datetime is…
Re: Savepoints - Was: Isolation levels in Informix vs Oracle
Mark Townsend wrote: > Serge Rielau wrote: > >> DA Morgan wrote: >> >>> A commit completes the transaction and the savepoints evaporate. >> >> >> Thanks, that makes Oracle and DB2 compatible and SQL Server the odd >> one out. >> >> Cheers >> Serge > > > Well .... expect that Orac…
Re: Oracle ?
On Wed, 29 Dec 2004 13:10:55 -0800, DA Morgan <damorgan@x.washington.edu> wrote: >Obnoxio The Chav wrote: >> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] >> >>>IT isn't glamorous any more. >> >> >> IT was glamorous? > >Don't you remember back when all you had to do was …
Re: Isolation levels in Informix vs Oracle
rkusenet wrote: > "Mark Townsend" <markbtownsend@comcast.net> wrote > > >>The feature battles with Informix are long, long over. > > > what about performance battle :-) > > As far as Informix is confirmed, it was all very much "The horse never rode and the bridge never crossed"…
=?iso-8859-1?Q?Feliz_A=F1o_2005?=
... Y Al terminar este a=F1o 2004 demos gracias=20 por todo aquello que recibimos del universo y de nuestro creador.=20 Gracias por la vida y el amor , por las flores,=20 el aire y el sol, por la alegr=EDa y el dolor,=20 por cuanto fue posible y por lo que no pudo ser.=20 Ofrez…
=?iso-8859-1?Q?Feliz_A=F1o_2005?=
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_01C4EEBE.9181DB20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ... Y Al t…
Re: Informix on AIX (newbie).
Sorry Fernando Ortiz escribi�: > <SNIP> > % dbaccess sysmaster > > Chose New -> # Type the following query # > > select * from sysmaster Ops! select * from sysdatabases > > Type {esc} -> chose run > > HTH sending to informix-list…
Re: Informix on AIX (newbie).
Hi Nuno, % dbaccess Chose database -> Select -> { choose the database } Or % dbaccess Chose Query-language -> { choose database } -> Info -> { choose table } Or % dbaccess sysmaster Chose New -> # Type the following query # select * from sysmaster Type {esc} -> chose r…
Re: Oracle ?
Captain Pedantic said: > "Serge Rielau" <srielau@ca.ibm.com> wrote in message > news:32dvsrF3khii0U1@individual.net... > >> On a big scale IBM is setting the agenda with >> eBusiness and onDemand computing. > > Please, stop it! No more, I beg you! > My sides are aching ... ... …
Re: Oracle ?
Captain Pedantic said: > "Serge Rielau" <srielau@ca.ibm.com> wrote in message > news:32dvsrF3khii0U1@individual.net... > >> On a big scale IBM is setting the agenda with >> eBusiness and onDemand computing. > > Please, stop it! No more, I beg you! > My sides are aching ... ... …
Re: Isolation levels in Informix vs Oracle
Mark Townsend said: > Obnoxio The Chav wrote: > >> Mark was trying to drag the discussion into a feature battle >> that was irrelevant to the issue at hand. > > Au contraire. The discussion was around a justification for dirty read. > The OP opined that dirty reads were useful f…
Re: SPL DATETIME bug ????
Paul Watson wrote: The difference is that effectively the second query/spl has replaceable parameters so it can only be partially optimized at SPL compile time. The final optimization is performed at execution time which is likely the extra run time. Fortuneately you are runni…
Re: Informix on AIX (newbie).
--0-447906701-1104438541=:67945 Content-Type: text/plain; charset=us-ascii Assuming you only have one instance of informix running, you can just type in 'dbaccess' and all the databases for that instance will display in the dbaccess window. onstat -- will show you all the onsta…
Re: Oracle ?
"Serge Rielau" <srielau@ca.ibm.com> wrote in message news:32dvsrF3khii0U1@individual.net... > On a big scale IBM is setting the agenda with > eBusiness and onDemand computing. Please, stop it! No more, I beg you! My sides are aching ...…
Onspaces script
Does anyone have a script that can generate the onspaces commands for an instance? I need to setup a replication server for HDR. I looked in the IIUG software repository but could not find one. I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally be upgrding t…
DB Load Performance
I'm helping a group with a database reorganization. System info: 4-way 332 MHz IBM F50, 3GB RAM Local SCSI disks for OS & file system 2 RAID-10 arrays on separate SSA enclosures AIX 5.1 running IDS 9.30.UC1 This group used constraints to create primary keys (53) and foreign keys…
RE: SPL caching on secondary - BUG
I got a message from the tech support, that the problem is fixed in 9.40uc7 (I suppose, the release the development is working on) ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: Sean Baker [mailto:SBaker@moneymailer.com] > > > > >…
RE: Informix locking & transactions
how many rows are present in your tables?, it may be that your queries are doing a sequential scan on the table which may result in the problem that you are experiencing, you may do the following to verify 1. make sure the table is created with the row level locking 2. run the q…
Want some extra cash, try this
want some extra cash, try this THIS REALLY CAN MAKE YOU EASY MONEY!! A little while back, I was on my computer having a grand old time, just like you are now and came across an article similar to this that said you could make thousands dollars within weeks with only an initia…
RE: Informix locking & transactions
Bob- What you may be missing is when you declare your cursor, be sure to include "FOR UPDATE" in your SELECT statement. That way the engine will lock all rows of your cursor as it reads them, rather than waiting until you issue the UPDATE statement. Or, if you're only dealing …
Re: Informix locking & transactions
BigBob wrote: > I need to lock a ROW in an Informix table and hold onto that lock until > the end of a transaction. During this transaction, 2 seperate Java > processes MIGHT start and want to update a table held in that > transaction before it is released. Is there any way to …
Re: Re: IDS Support for KAIO on Linux kernel 2.6+
KAIO is not actually suported on kernels 2.6. IDS 9.4 works on kernel 2.6 but just for the fact that an application that runs on 2.4 will surely works on 2.6 too. Once I read that Informix would support KAIO on linux when kernel 2.6 was out, that was on 2.4 times. And we have t…
Re: Re: Re: missing install instructions/pieces
I have to mention that IBM fixed the download for the trial, and I was able to download. ... very impressed with the reponse ... Chucho! -----Original Message----- From: Paul Rowland <paulrowland@yahoo.com> To: Jean Sagi <jeansagi@myrealbox.com> Date: Thu, 30 Dec 2004 04:40:59…
Re: SPL DATETIME bug ????
may be is the fact that the variables are of type string? If they are datetime variables the it migth be the fact that they are variables not constants as in the prior example, and of course that might be a performance problem. Chucho! -----Original Message----- From: Paul Wat…
Re: missing install instructions/pieces
I downloaded the Linux Informix from the www.informix.com, it was a smoother install, however I noticed the Java/HTTP pieces of Informix installed only when I had Apache running. Thanks for your help.…
Re: Informix locking & transactions
BigBob wrote: >I need to lock a ROW in an Informix table and hold onto that lock until >the end of a transaction. During this transaction, 2 seperate Java >processes MIGHT start and want to update a table held in that >transaction before it is released. Is there any way to acc…
Informix on AIX (newbie).
Hi goup, I need to start administering an Informix database that runs on an AIX server. I've no problem using unix systems (specially linux) but I don't know how to star interacting with the database. I've got some good manuals about Informix, but I'm a little confuse with the w…
Re: IDS Support for KAIO on Linux kernel 2.6+
Serafin Veloso wrote: > yes, it works - with suse 9.1 out of the box installation - testet with IDS > 9.4 UC5 To clarify my last post, Informix works brilliantly on SuSE 9.2 but KAIO does not. Ben.…
Re: IDS Support for KAIO on Linux kernel 2.6+
Serafin Veloso wrote: > yes, it works - with suse 9.1 out of the box installation - testet with IDS > 9.4 UC5 Well I am trying it out with SuSE 9.2 (kernel 2.6.8-24.10-smp) and it doesn't work. Did you go through any special steps? ONCONFIG settings? BTW - I am finding that ev…
RE: SPL DATETIME bug ????
check the explain for both query, I believe they are deferent. In the first query the optimizer know the range of date at optimization time, but in the second it do not. In each query he build deferent query plan. You should force the optimizer to work as the first query using di…
Re: SPL DATETIME bug ????
Paul Watson wrote: > This is all in SPL, Solaris 8, 9.40UC3 > > select count(*) > from table1, table2 > where join > and datetime between "2004-09-29 09:57:58.00" > AND "2004-12-29 09:57:58.00" > > returns 0.3 seconds > > but > > let l_dte1 = "2004-09-29 09:57:58.00" > let l_…
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > Obnoxio The Chav wrote: > >> DA Morgan said: >> >>>Please don't go sideways here. I was merely pointing out that SAVEPOINTS >>>are not exactly a red herring. You can be a bit less defensive methinks >>>as no database vendor is 100% ANSI compliant. >> >> >> Pleas…
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > Obnoxio The Chav wrote: > >> DA Morgan said: >> >>>>>that as other jobs utilize resources it refines its estimate taking >>>>> them >>>>>into account. >>>> >>>>Yeah, that would never happen in the way I coded my progress >>>> monitoring. >>>>Gee, let me switch t…
Re: Isolation levels in Informix vs Oracle
Obnoxio The Chav wrote: > DA Morgan said: > >>Please don't go sideways here. I was merely pointing out that SAVEPOINTS >>are not exactly a red herring. You can be a bit less defensive methinks >>as no database vendor is 100% ANSI compliant. > > > Please don't tar us with the mud…
"no more extents" error
Our process is uploading data to a table. Expected data is around 50 GB. First extent was set to 40GB and next extent to 4 GB. However the process stops after uploading around 33 GB of data. The error message is as follows: 271: Could not insert new row into the table. 136: ISAM …
Re: Informix locking & transactions
BigBob said: > I need to lock a ROW in an Informix table and hold onto that lock until > the end of a transaction. During this transaction, 2 seperate Java > processes MIGHT start and want to update a table held in that > transaction before it is released. Is there any way to a…
Re: Re: missing install instructions/pieces
EXCELENTE !! Chucho. -----Original Message----- From: Fernando Ortiz <fortiz@lacorona.com.mx> To: Rokken <paulrowland@yahoo.com> Date: Wed, 29 Dec 2004 09:03:44 -0600 Subject: Re: missing install instructions/pieces Hi Paul, You may take a look to a quick guide I'm doing: htt…
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > Please don't go sideways here. I was merely pointing out that SAVEPOINTS > are not exactly a red herring. You can be a bit less defensive methinks > as no database vendor is 100% ANSI compliant. Please don't tar us with the muddy brush of your illogical thinkin…
Informix locking & transactions
I need to lock a ROW in an Informix table and hold onto that lock until the end of a transaction. During this transaction, 2 seperate Java processes MIGHT start and want to update a table held in that transaction before it is released. Is there any way to accomplish this? Let …
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > Obnoxio The Chav wrote: > >>>Does Informix >>>have the concept of a save point (named point within a transaction you >>>can later rollback to if required) ? >> >> >> Red herring. > > Why so? It is part of the ANSI standard is it not? But it had nothing to do wi…
Re: Isolation levels in Informix vs Oracle
rkusenet said: > > "DA Morgan" <damorgan@x.washington.edu> wrote in message > news:41d31d31$1_4@127.0.0.1... >> Obnoxio The Chav wrote: >> >> >>Does Informix >> >>have the concept of a save point (named point within a transaction you >> >>can later rollback to if required) ? >> >…
Re: Oracle ?
DA Morgan said: > Obnoxio The Chav wrote: >> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] >> >>>IT isn't glamorous any more. >> >> >> IT was glamorous? > > Don't you remember back when all you had to do was walk > into a pub and let it slip you were an expert at hex? *_…
Re: Isolation levels in Informix vs Oracle
DA Morgan said: >>>that as other jobs utilize resources it refines its estimate taking them >>>into account. >> >> Yeah, that would never happen in the way I coded my progress monitoring. >> Gee, let me switch to Oracle right away, it does things that I have a >> library for. > …
Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
Hi, I am a Data Recovery Specialist and Professional Data Recovery Software Developer in New Delhi. I've placed the Complete SOURCE CODE of One of my Data Recovery Software for Sale (for Educational Purpose) on the following link of my website: http://www.datadoctor.biz/3.htm …
Re: missing install instructions/pieces
Hi Paul, You may take a look to a quick guide I'm doing: http://www.lacorona.com.mx/fortiz/informix/tcp.htm It's no fully translated yet, but at least you can use the server part. HTH Rokken escribi�: > I downloaded the Linux package, IIUG-IDS-9-4-UC2-linux.zip to install > o…
Re: A VoIP usergroup
There is an Informix related forum over there? -----Original Message----- From: erika_angella@yahoo.com To: informix-list@iiug.org Date: 29 Dec 2004 02:04:08 -0800 Subject: A VoIP usergroup Hi Friends, I found a new VOIP forum, where there is a good syndication of VOIP technic…
compressed indexes
Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, Floyd…
Re: Informix perfomance and CPU use.
Leopold Bloom said: > > First of all Marry Christmas, if you share this celebration. If > not, > hope you and your people are OK and happy. "Bah! Humbug!" is the traditional Christmas greeting here. :o) > I have been gathering information about this system. At t…
compressed indexes
Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work…
compressing indexes
Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work…
Isolation levels in Informix vs Oracle
Sorry for not being clear; Here goes: what i ment was for the report: start trx at 13:59 complete at 14:00.00001 get the account info at 14:00.00000 define what one wants in reallity the trx should be part of the results. (it did not got rolled back and it started before the…
SPL DATETIME bug ????
This is all in SPL, Solaris 8, 9.40UC3 select count(*) from table1, table2 where join and datetime between "2004-09-29 09:57:58.00" AND "2004-12-29 09:57:58.00" returns 0.3 seconds but let l_dte1 = "2004-09-29 09:57:58.00" let l_dte2 = "2004-12-29 09:57:58.00" select count(…
A VoIP usergroup
Hi Friends, I found a new VOIP forum, where there is a good syndication of VOIP technical white papers. It is really worth checking out - http://www.techieindex.com/ug/voip/index.jsp…
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > > Actually it can guage completion on statements it is just seeing for the > very first time. It evaluates CPU utilization, i/o, and other factors to > create the initial estimate, based on system load, and then refines the > estimate over the time the process r…
Re: Isolation levels in Informix vs Oracle
Mark Townsend said: > > From within the same session (connection to the database), you can see > uncommitted data. Outside the session, no. That's handy. > Is it actually good practice to do a lot of seperate DMLs (100 ?) > affecting 100K rows in Informix without issuing a co…
RE: Oracle ?
From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] > > IT isn't glamorous any more. IT was glamorous? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass"…
RE: Illegal Stored Procedure Entry" message
Try to 'update staistics for procedure'; There is a chance that You'll get an error with the name of the problematic stored procedure � ------------------------------------------ Alexey Sonkin � ________________________________________ From: owner-informix-list@iiug.org [mailto:o…
missing install instructions/pieces
I downloaded the Linux package, IIUG-IDS-9-4-UC2-linux.zip to install on Fedora core. I had no trouble setting the environment, or using cpio or installing the server, using installserver or running the RUN_AS_ROOT.server piece. I received no errors and was returned to the prompt…
Illegal Stored Procedure Entry" message
--0-1812285848-1104274518=:69443 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, When I running a : dbexport DB-name I get allways a "Illegal Stored Procedure Entry" message without reference to Store Procedure. what can i do, for get a full …
long restores
I'm restoring level-0 backups from one server to another (IDS 7.24 & HPUX 11 on both). The archive only takes a couple hours, but the restores take over 6 to complete. When finished, the database comes online fine with no problems. I just can't figure out why the restore takes so…
RE: Oracle ?
Just a note on version 9.21 (the 9.2x versions) - IBM (the head of Informix database development) admitted themselves that this was a very bad version, and that people should move off this version ASAP ! This is probably why they would prefer not to support this version - but 9…
SQL Query question
Hello, I have a question regarding combining queries. We have this CMS (Smartsite) for our website which has a meeting and a calendar module. The module works with the following values; nr, StartDate, EndDate, title The nr-value is the unique pagenumber of the linked page. Start…
Test
Testing…
Isolation levels in Informix vs Oracle
--Concider the following situation: --An application is trying to analyze bank's balance --during the operational day - that is, some records --in the 'account' table might change while the query is running. --In Informix, DB2, MS SQL the only way to implement the --consistent …
Re: Isolation levels in Informix vs Oracle
the cutlets, top with parsley, lemon slices and cracked pepper. Serve with spinach salad, macaroni and cheese (homemade) and iced tea... Spaghetti with Real Italian Meatballs If you don?t have an expendable bambino on hand, you can use a pound of ground pork instead. The sec…
Re: Re: Isolation levels in Informix vs Oracle
in baking dish, layer with vegetables seasoning and butter. Bake at 325� for 30 - 45 minutes. Serve with hot dinner rolls, fruit salad and sparkling water. B�b� Buffet 1 Show off with whole roasted children replete with apples in mouths - and babies? heads stuffed with wild ric…
RE: How to connect as different user using dbaccess ?
Sergiy, Art, The problem is that is a very bad idea to pass the password in a command line. Any user who has access to that machine is able to get this password by simply issuing 'ps -ef' I don't have any complete solution for that. In some cases, the following approach works …
Re: Isolation levels in Informix vs Oracle
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:41c8c7d3$1_3@127.0.0.1... > Dave Griffen wrote: > > > One of > > the things I use it for is to check the progress of batch jobs. If I know a > > program is going to insert 100,000 rows into a table, I can use dirty re…
Scope change.
I have been gathering information about this system. At the end really strange things end up not being true. This is another time it happens. Though the people that were responsible of this before -and supposed to be knowledgeable in Informix- told me the system I posted…
Re: How to connect as different user using dbaccess ?
Hi Sergiy, connection -> connect -> {choose server} -> type user -> type password -> {choose database} The trick is, you can connect to the same instance. HTH smitin@gmail.com escribi�: > Hi there, > > pretty stupid question but I can't find an answer yet : how to provide > u…
Re: how to read data from database on other machine
Hi Danny, Yes, ServerA must have listed serverB in his sqlhosts, and also serverB should have listed serverA in his own sqlhosts. But also the users must be trsuted in the remote hosts, this can be done listing the host in each other /etc/hosts.equiv file. HTH Danny De Koster…
Re: how to read data from database on other machine
Danny De Koster said: > > I was wondering how we can read data from an Informix (IDS) database on > another machine. > Do I need to metion in the sqlhosts file the other database server? Yes. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gue…
RE: Ho!
Gentsch, Sam said: > >> >> Always. Santa only gave me a lump of coal. >> >> -- >> >> Bye now, >> Obnoxio > > At least you will not be cold. Nope! It's not enough to keep a fire going, and it's snowing... :o( -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il fau…
How to connect as different user using dbaccess ?
Hi there, pretty stupid question but I can't find an answer yet : how to provide user name and password if I want to use dbaccess ? So far I tried dbaccess - - <<! connect to dbname user 'user' using 'passwd'; ! 32412: USING clause unsupported. DB-Access will prompt you for a p…
how to read data from database on other machine
Hi all, I was wondering how we can read data from an Informix (IDS) database on another machine. Do I need to metion in the sqlhosts file the other database server? etc.... thanks for any tips!! Danny…
RE: Ho!
> > Always. Santa only gave me a lump of coal. > > -- > > Bye now, > Obnoxio At least you will not be cold. Sam sending to informix-list…
null values in composite key columns
Hi all I have three columns A,B,C . In Column 'C' there may be few null values . My where condition contains these three columns. My question is 1 ) indexing only A,B or indexing A,B,C. Thanks Deena __________________________________________________ Do You Yahoo!? Tired of sp…
Re: Ho!
John Carlson said: > On Fri, 24 Dec 2004 09:13:25 -0000 (GMT), "Obnoxio The Chav" > <obnoxio@serendipita.com> wrote: > >> >>This is definitely only a one "Ho!" Christmas, but all the same: Bah! >> Humbug! > > That bad, oh Obnoxious One? Always. Santa only gave me a lump of coal.…
RE: Can not Display Special Characters in informix LVARCHAR
------------------------------------------ Alexey Sonkin > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of kalpana > > Dear All, > We have Informix 9.21 running on Solaris and using Java for > application de…
RE: Deadlocks and ONSTAT deadlock trace files
select first 10 * from sysmaster:sysptprof order by deadlks desc ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Pero > Sent: Friday, December 24, 2…
IDS 7/9 on NT Network chunks
Folks, I'm trying to do something on IDS9.4 NT (NT4 and W2K) that doesn't seem to be documented anywhere. I'm trying to create database chunks on network-attached drives. I'm getting erratic results. Using only NTFS filesystems I create the database file with mks "touch" and …
IDS 7/9 on NT Network chunks
Folks, I'm trying to do something on IDS9.4 NT (NT4 and W2K) that doesn't seem to be documented anywhere. I'm trying to create database chunks on network-attached drives. I'm getting erratic results. Using only NTFS filesystems I create the database file with mks "touch" and …
reading a structure containing pointers using softice !!
hi, In simple words 'How to view / Read the various elements values in a structure at a particular point of my DRV ?' The Story is ->>>> i am using softice for tracking/hunting a bug . I am able to locate and get the address of the structure from the stack. eg:- Consider, lpvD…
Insider #54: Editorials, sponsorship programs, & More...
IIUG Insider (Issue #54) December 2004 Highlights: Editorials, sponsorship programs, & More... Online at http://www.iiug.org/news/insider.html ================================================================ Welcome to the International Informix Users Group (IIUG) Insider! Des…
Ho!
This is definitely only a one "Ho!" Christmas, but all the same: Bah! Humbug! -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guard…
Re: Deadlocks and ONSTAT deadlock trace files
only in application's log On 26 Nov 2004 08:25:22 -0800, serge.vedrine@domtar.com (Vedster) wrote: >Hi. > >I am a DBA who is new to Informix technology. My application produced >5 deadlock situations yesterday. In the /tmp directory I have 5 >ONSTAT_DEADLOCK_* files. How can…
Re: OT: Looking for copy of auditors security check software
Deloitte has this software and you can pay them not to much On 24 Nov 2004 06:41:37 -0800, triton45@hotmail.com (Andy) wrote: >We are scheduled to have our IT systems audited next month by Deloitte >Touche Tohmatsu. I would really like to get a copy of their security >check so…
Re: Solaris 9 on x86 with IDS9.21 UC2
R Bankay said: > Thanks for that experience. I was fairly sure that > it was not supported that was why I was asking around > for experiences. Maybe you could upgrade the engine first? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" …
Re: SQL - Finding Orphans?
William Fields wrote: > Hello, > > I'm having a hard time coming up with an SQL statement that returns just > orphan records. Here's what I've got (don't worry too much about the format, > I'm issuing this statement from Visual FoxPro): You cannot do this using the Informix OUTE…
Re: Runner C functions for TEXT and BYTE
Try at, there are lot of samples http://www.iiug.org/software/index_I4GL.html On Fri, 17 Dec 2004 10:13:40 +1100, "Andrew Hamm" <ahamm@mail.com> wrote: >Hi folks, > >before I spend some time maybe re-inventing the wheel, does anyone have >some C source for functions that manip…
Re: Byte data
You can make this by small 4gl aplication. Look at chapter about blobs. main DEFINE mtxt RECORD LIKE tablewithdata.* LOCATE mtxt.pictureField IN FILE <fileName.jpg> select * into mtx.* from tablewithdata where .... free mtx.picturefield end main On Th…
informix vesion numbers
People, Can someone please explain to me informix version numbers. I am espically interested in the meaning of C1, in for example UC1 and the differences between 9.30.UC2 and 9.40.UC3, or 7.30.UC5 and 7.31.UD5. Thanks Kenneth…
Light Scan and Caching
Hi, During a light scan, does the data get cached in virtual portion of the server. Bye.…
Re: SQL - Finding Orphans?
SELECT dt_caseid, dt_deseqnoptr FROM u_dkttext WHERE NOT EXISTS ( SELECT de_caseid FROM u_dktentry WHERE u_dktentry.de_caseid = u_dkttext.dt_caseid AND u_dktentry.de_seqno = u_dkttext.dt_deseqnoptr ) -- Regards, Doug Lawry www.douglawry.webhop.org "William Fiel…
remote ontape
hi, (I hate to say this, but it was working)I used to backup my local machine using a remote tape drive, until recently a message came saying permission denied..!!! (as far as I know nothing has changed, but...) can any one please give a hint....…
Re: Solaris 9 on x86 with IDS9.21 UC2
Bob Bankay said: > We currently are running Solaris 8 with IDS9.21UC2. > We have filled our disks and need to add external drives with new > controllers. Unfortunately Solaris 8 has no drivers for these > controllers, so I think we need to upgrade to Solaris 9 + IDS9.4UCxx for >…
Re: Informix performance and CPU use.
Leopold Bloom said: > Hello, > > We are having some problems with an Informix database and, as I�m > pretty new to this environment, would appreciate any help. > > We have an Informix instance running on a 2 way Intel box with > Windows 2000. This system has 3 Gb memory. …
Solaris 9 on x86 with IDS9.21 UC2
We currently are running Solaris 8 with IDS9.21UC2. We have filled our disks and need to add external drives with new controllers. Unfortunately Solaris 8 has no drivers for these controllers, so I think we need to upgrade to Solaris 9 + IDS9.4UCxx for compatibility; however I a…
Informix performance and CPU use.
Hello, We are having some problems with an Informix database and, as I�m pretty new to this environment, would appreciate any help. We have an Informix instance running on a 2 way Intel box with Windows 2000. This system has 3 Gb memory. The main symthoms I can s…
Can not Display Special Characters in informix LVARCHAR
Dear All, We have Informix 9.21 running on Solaris and using Java for application development. At present we have our Database as ISO-8859 we are planning to use UTF-8 . I have set up a new database for UTF-8 with the following steps 1.Export the database 2.Set DB_LOCALE to en_…
Re: loselect.c
bart, do you get the same problem against 9.40? 9.21 is a very old product and has passed its official end of service date. Bart Huls wrote: > Hi, > > Can someone tell me why when I compile the loselect.c (delivered with the > ClientSDK) with Micorsoft Visual Studio 6 or Borla…
Re: matt parker alias evonlindt herzog@yahoo.com
http://tinyurl.com/5em8l said: > matt parker alias evonlindt herzog@yahoo.com vonlindtherzog@yahoo.com > matt parker alias eric_vonlint_herzog@yahoo.com > tanja_dchenka@yahoo.com > matt parker alias e vonlunsen herzog@yahoo.com van lint hout@yahoo.com [SNIPPED] Have you tried UP…
Unicode Support
Hello All, I am trying to build a VB .Net application to access an IDS 9.40 database. This database must be able to store Chinese characters and also European characters. I am using Cli-Sdk 2.81.TC3 and the ODBC included in this package to access the database from VB .Net. If …
matt parker alias evonlindt herzog@yahoo.com vonlindtherzog@yahoo.com
matt parker alias evonlindt herzog@yahoo.com vonlindtherzog@yahoo.com matt parker alias eric_vonlint_herzog@yahoo.com tanja_dchenka@yahoo.com matt parker alias e vonlunsen herzog@yahoo.com van lint hout@yahoo.com matt parker alias evan lint herzog@yahoo.com vonlinthout@yahoo.com …
RE: Pagesize question
Dynix/ptx on IBM/Sequent also uses 4k pages (you can still get IDS 7 for it !!), but as IBM have canned the hardware and O/S it's a bit irrelevant any way !! Keith -> -----Original Message----- -> From: DeeWee [mailto:1@2.3] -> Sent: Wednesday, December 22, 2004 6:39 AM -> To: …
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > Dave Griffen wrote: > >> One of >> the things I use it for is to check the progress of batch jobs. If I >> know a >> program is going to insert 100,000 rows into a table, I can use dirty >> read >> to see how many rows it has inserted so far and can give a good…
Time stamps of rows
Hi, I need to read rows which are inserted later than a particular row. eg; If i have the following rows f e c a x is it possible to read only the rows after c(i.e a,b). One way i feel is to know the timestamps of rows. Is there any other method to do so. Bye.…
Re: Pagesize question
"Art S. Kagel" <kagel@bloomberg.net> schreef in bericht news:41c8ac1e$0$17969$afc38c87@... > Martin Fuerderer wrote: >> Hi, >> >> you can use "onstat -b" command to confirm >> page size. In the last line of the output it gives >> e.g. "..., 2048 buffer size" - which means that >>…
Re: Isolation levels in Informix vs Oracle
Dave Griffen said: > > As for not wanting to start a flame war...Your posting on an Informix > message board and your using exclamations after every Oracle viewpoint > mentioned...seems like your looking for a flame war to me. Yes! Let's have a flame war! It's been ages since th…
Re: Isolation levels in Informix vs Oracle
"PK" <pk26au@yahoo.com> wrote in message news:667bf0c6.0412150133.7e4ce123@posting.google.com... > Hi, > > As you know Informix offers 'set isolation to dirty read' - a facility > to read dirty buffers. I believe DB2 UDB too offers it but not Oracle. > > What is the neccessity or…
Lock mode to wait
Hi folks How I can "set lock mode to wait" in a remote database from a local database session with 4gl program. I have problems with locks when ejecute remote sql Thanks for your help Rubén IT & Business Projects AX - APLICACIONES EXTREMAS www.aplext.com -- Este mensaje ha s…
Re: Informix and RAID
Spurgeon, John P wrote: <SNIP> > and also on this subject, Art S. Kagel wrote: > > >>Then you're purchasing your RAID controllers from the wrong vendors. > > > Fair enough. If RAID 10 is important to you, then I would hope there is > a vendor out there that builds a controller/dr…
Re: Error accessing IDS 9.4 on Windows
dlgllhn@inhisstepssoftware.com wrote: > Guy Bowerman wrote: > >>The "not trusted" error relates to TCP trusts. You would need to > > connect > >>with a user name and password, or add the client user or machine to >>%SystemRoot%\\system32\\drivers\\etc\\hosts.equiv on the server. …
Re: Error accessing IDS 9.4 on Windows
dlgllhn@inhisstepssoftware.com wrote: > I'll try that. So, a user has to have an actual login to the physical > Informix Server in order to access it? Doesn't sound like a good idea > to me. This is not required of any other RDBMS I have used. Is this a > remnant of Informix…
RE: Memory resident tables
Gustavo Tobares said: > > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last days I put some tables memory resident and monitored > with onstat -b and I believe with have enough buffers to put some others > tables, my question is: > > Can I put memory residen…
Re: New dbaccess message
--0__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A Content-type: multipart/alternative; Boundary="1__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A" --1__=09BBE5E2DFF2FB6A8f9e8a93df938690918c09BBE5E2DFF2FB6A Content-type: text/plain; charset=ISO-8859-1 Content-tr…
Stored Procedure Parameter
Hello All, I received a question from one of our developers regarding a parameter passed into a stored procedure. This particular application has one main database and several hundred other databases per instance. The stored procedure will reside in the main database. When they …
RE: Memory resident tables
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_01C4E77E.F198B930 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some …
RE: Informix and RAID
> Db Solution said: > > The argument of loosing a second disk is not a very good > one. With the > > current MTTF of disks these days the chances of loosing 2 > disks in a > > array in the same day are very slim. > > Ha! Ha! Ha! Ha! Yeah, whatever mate. Keep taking the tablets. >…
loselect.c
Hi, Can someone tell me why when I compile the loselect.c (delivered with the ClientSDK) with Micorsoft Visual Studio 6 or Borland's C++ Builder 5 and run the program against an Informix Dynamic Server 2000 Version 9.21.HC5 it will bring the engine down with the message: 13:46:…
RE: Onbar - some advice please
I do a level 0 backup every morning at ~03:00 and restore that level 0 to a PIT of 07:00 to a report instance. Runs every morning and never fails. Running 9.40.FC3 with Tivoli Storage Manager 5.2. I also restore to a test and QA instance weekly. I have also restored a monthly…
New dbaccess message
Hi all. Work environment: SO : Solaris 9 (64 bits) IDS 9.4.UC4 (32 bits) dbaccess In this new version (for me) when we exit from dbaccess after begin a transaction with out commit or roll back this transaction anf if we chose commit (from menu) we receive a message : Warni…
Re: Onbar - some advice please
Hi, generally I recommend a newer release of 9.40 (i.e. 9.40.xC4 or the current 9.40.xC5) rather than any 9.30 release. These 9.40 releases all support PIT (point-in-time) restores. To be honest, there is still a known problem in these releases, but that can be seen only when …
Re: Multiple like conditions
johnjohn-gg@triceratops.com said: > I can't seem to find the answer to this question in the SQL docs or the > group archives. I've even tried some experimentation without luck. > > I'm doing a select with multiple conditions AND'ed together. On one > field, I'm trying to use wi…
Trigger on Schema Changes
Does Informix support adding a trigger on any database schema change, like addign a new stored procedure or changing the definition of a table. I would like to add an audit mechanism to my database and log or prevent schema changes. Thanks Alexis…
long checkpoints in 9.40.fc4
We have converted to the following: hpux-11i (64 bit) 4 proc 8 gig ram IDS 9.40.FC4 HP SAN Cooked files This same system ran on a 7.31 database on Solaris (intel)(2 procs) just fine 0-3 second checkpoints. Anybody have any ideas on what I can check/do to fix this. Stephen Scott…
Multiple like conditions
I can't seem to find the answer to this question in the SQL docs or the group archives. I've even tried some experimentation without luck. I'm doing a select with multiple conditions AND'ed together. On one field, I'm trying to use wildcards to match one of several conditions.…
CLIPPED on vars like nchar columns does'nt work?
Clipped on variables like nchar columns in RDS 7.32.UC2 SCO seems to not work. database xxx main defina v like systables.tabname let v= "x" display ">", v clipped, "<" end main Output: >x < Regards, W.…
Error accessing IDS 9.4 on Windows
I have finally gotten the trial version of IDS 9.4 running. I can access the stores database using ODBC and Delphi. But when I transfer the test Delphi Application to another PC and try to access it I get "Client host or user is not trusted by the server." I then added this us…
Onbar - some advice please
This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C4E6D6.A6F943C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have a number of customers who really need to use onbar. They need point-in-time recovery, parallel backups, …
RE: Pagesize question
Hi, you can use "onstat -b" command to confirm page size. In the last line of the output it gives e.g. "..., 2048 buffer size" - which means that such a system uses 2 kB page size. [ On some platforms IDS's page size is 4 kB rather than 2 kB, but as far as I know on Tru64 i…
DB-Crash
Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992 Complete. 12:26:44 Logical Log 11992 - Backup Started 12:26:44 Logical Log 11992 - Backup Completed 12:26:45 Fatal error in ADM VP at…
Using offset in select statements
I need to limit the output of a SELECT query for display purposes, and am looking for some options to "recreate" the "OFFSET" function as used in PostgreSQL. For example, the full select has 100 rows, but in the first query I only want rows 1-20, then 21-40, etc. What are my opt…
RE: Pagesize question
DeeWee wote > > we are using informix 7.31 FC6 and unix tru64 5.1b > > unix pagesize command tells 8192 > onmonitor shows Page Size 2 Kbytes > > if informix uses pages, what size are they? > They are not the same. Tru 64 uses 8K pages. Informix uses 2k pages. (This might be co…
Onderwerp:7 vs 9
--- BEGIN WORK.... -- $DECLARE sel CURSOR WITH HOLD FOR SELECT f INTO :f FROM lvo; ------------------------^^^^^^^^^^ .... -- $EXECUTE IMMEDIATE "ROLLBACK"; ----But the rollback here closes the cursor - it doesn't free it, but it -- does close it. does it?? the cursor is wit…
Pagesize question
we are using informix 7.31 FC6 and unix tru64 5.1b unix pagesize command tells 8192 onmonitor shows Page Size 2 Kbytes if informix uses pages, what size are they?…
Managing tables in an INFORMIX database running on SCO UNIX
Hi, I am having trouble navigating my way in the informix database on SCO UNIX operating system. Can anyone assist? Location of tables, viewing data in tables, exporting into access, running SQL commands. Thanks, Manka…
Re: get syntax error when loading data to a informix database
The second form should work. What are you using as a field delimiter? Informix defaults to a pipe "|". If you are using some other character you will need to include the delimiter phrase ... LOAD FROM "pathname" [DELIMITER "char"] INSERT INTO table-name co…
Re: get syntax error when loading data to a informix database
Umesh wrote: > Hi > I have ids 9.4 oon windows and csdk. l successfully connected > to the database using Visula Basic 6. > When l build a string for example > SQL1 = "select * from hse2 where field1 matches " & "'a*' > and execute using : DbaseConn.Execute (SQL1) it works fine.…
Re: get syntax error when loading data to a informix database
Umesh said: > Hi > I have ids 9.4 oon windows and csdk. l successfully connected > to the database using Visula Basic 6. > When l build a string for example > SQL1 = "select * from hse2 where field1 matches " & "'a*' > and execute using : DbaseConn.Execute (SQL1) it works fine. >…
get syntax error when loading data to a informix database
Hi I have ids 9.4 oon windows and csdk. l successfully connected to the database using Visula Basic 6. When l build a string for example SQL1 = "select * from hse2 where field1 matches " & "'a*' and execute using : DbaseConn.Execute (SQL1) it works fine. When l try to load data …
Washington Area Informix User Group meeting - January 27, 2005
Happy Holidays and Best Wishes for the New Year! ______________________________________________________________________ Our Next Quarterly Meeting is: Thursday, January 27, 2005 Time: 9:00-5:00 Location: IBM, Bethesda offices, Building 6710, Wing B Room 21B167. 6710 Rockledge D…
Re: Data Director for Web problem
hjohnson@keeneinfo.com said: > > We have tested this several times and it acts the same way every time > so this is definately the problem. I can get around the problem but > Informix needs to know about this so they can address it. Who do you > think would be the best person t…
putting serial numbers to the rows retrieved
Hi Everyone, I am in need of a SQL in which I need to get rows from a table but it should have a column with serial numbers starting from 1 to as many number of rows. To explain well, if I am getting 10 rows from a sql, a column, let us say, serial_no, I should get which should…
Re: Data Director for Web problem
Paul Watson wrote: > Harry > > what you are trying to do and the versions should be fine, and we run > our internal systems as you describe. Stick with 4.13 it's a better > version with some added predefined functions, although some only appear > to be in the FC version. > > On…
HPL 9.40 UC5 express load problem
This thread is actually a continuation or actually an underlying problem of a previous thread I posted yesterday "IDS 9.40 UC5/linux update statistics crashes engine onlarge table". I am copying a snapshot of a table from an HPUX system running IDS 9.21 FC7 with 15 million rows …
Re: IDS 9.40 UC5/linux update statistics crashes engine on large table
Ok, this crash may be the result of a different issue. I was getting the load ready to create a new db and copy of the table (as you mentioned) and figured out that the rows in the original unload file and the rows in the new table created do not match. I went through my steps …
IDS 9.50
Hi folks! Somebody knows when IDS 9.50 will be released and what features = introduces. Regards, Diego…
Memory resident tables
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_01C4E467.C99EF9E0 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some …
RE: Informix and RAID
Martin Fuerderer wrote: > Another thing to consider is trusting only the statistics that > you've forged yourself, a point of view that often can be changed > only through an adverse life experience. And probably we should > not force any die-hards to miss such an opportunity fo…
RE: Oracle ?
Can you post a picture? If that is allowed...Hmm, I should know this. > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Mark Townsend > Sent: Thursday, December 16, 2004 12:12 AM > To: informix-list@iiug.org …
Level-0 restore and sysmaster problem
I'm building a cloned HPUX 11 & IDS 7.2 machine. I can initialize the database and bring it online with no problems. When I restore from a level-0 archive (using ontape) there is a problem converting the sysmaster database. Everything is fine in quiesent mode, but switching to on…
Re: 7 vs 9
--0__=09BBE5FEDFC727078f9e8a93df938690918c09BBE5FEDFC72707 Content-type: text/plain; charset=KOI8-R Content-transfer-encoding: base64 If the error indicates that you are running out of space, the difference between 7 and 9 is the type of index (attached/detached). An attach…
Re: Informix and RAID
You can add me to the list of folks that lost 2 drives in the same hour. It happened a few years on a RAID 10 system with two A1000's. The system didn't even feel it!! I can thank Art K. for that one because Sun was also pushing RAID 5 but with all of his posts (and help) I we…
Re: 7 vs 9
rotor said: >> The default behavior of CREATE INDEX in IDS 9 is to create a >> detached index versus IDS 7 which creates an attached index. The >> attached index requires less space. I believe the SQL Syntax >> manual gives the algorithm for the calculation of the detached >> i…
Re: Oracle ?
Data Goob said: > Obnoxio The Chav wrote: >> Mark Townsend said: >> >>>Obnoxio The Chav wrote: >>> >>>>Serge Rielau said: >>>> >>>> >>>>>Mark Townsend wrote: >>>>> >>> >>>>Anyway, can you guys go have your pissing contest over in the cdo >>>>hierarchy or in cddb2? >>> >>>Fair eno…
Re: 7 vs 9
rotor wrote: OUch, sorry you say -106 not -131. This is because of the open CURSOR WITH HOLD which prevents the index build from acquiring an exclusive lock on the table. Close the cursor or get rid of the WITH HOLD clause so it closes on the ROLLBACK. Don't know why it would…
Re: Informix and RAID
Hi all, maybe Richard should stop driving alltogether ... ? ... and consider safer occupations, e.g. parachuting, rock-climbing or para-gliding ;) Anyhow, we are talking about risks here, and the term risk describes always a (very) relative concept. What is a high risk and the…
Re: 7 vs 9
> The default behavior of CREATE INDEX in IDS 9 is to create a > detached index versus IDS 7 which creates an attached index. The > attached index requires less space. I believe the SQL Syntax > manual gives the algorithm for the calculation of the detached > index initial exte…
Re: Onderwerp:7 vs 9
> Sounds like you have been exploiting a bug: Which server has bug by Your mind? 7 or 9? > i would close and free the cursor here!!!!!!! Yes, I can find workaround by myself. But the real broblem is described below. We've developed information system which works about 8 years. T…
Re: 7 vs 9
> > sql error -242 (isam -106). > there's not enough disk space to build the index. How do You decide? My manuals tells about "non-exclusive access". How this can be in one session on temporary table? -- ���������� �������� ���� ������������ http://webmail.delfi.lv sending to in…
Re: 7 vs 9
--0__=09BBE5FEDFD617EF8f9e8a93df938690918c09BBE5FEDFD617EF Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable rotor wrote: >>$EXECUTE IMMEDIATE "CREATE TEMP TABLE lvo ( id INT ) WITH NO LOG"; >>$EXECUTE IMMEDIATE "CREATE INDEX lvo ON lvo( id …
Re: Oracle ?
Serge Rielau said: > Obnoxio The Chav wrote: >> Serge Rielau said: >> >>>Mark Townsend wrote: >>> >>>>Serge Rielau wrote: >>>> >>>> >>>>>IBMs primary business is innovation, It is NOT fighting Oracle or >>>>>Microsoft. >>>> >>>>Tell me one innovative thing that IBM has done with …
OT: Let your customer find fast and easy all text he searches !
SoftComplete Development wrote > Snipped for sanity .. > System Requirements: > * Operating system: Windows Windows 95, 98, ME, NT, 2000, XP, 2003 What ! no Tru64 ? I am heartbroken. Colin B _______________________________________________________________________ This email h…
RE: Informix and RAID
Spurgeon, John P wrote > The newer servers that are available today (i.e. they are > "approved" by IT, they are compatible with our system > software, and they are within our budget) have lots of space, > but not that many internal hard drives. > RAID 5 is always available for …
RE: Informix and RAID
Db Solution wrote > The argument of loosing a second disk is not a very good one. > With the current MTTF of disks these days the chances of > loosing 2 disks in a array in the same day are very slim. Slim it may be, but I have heard first hand experiences of multiple disk fai…
Onderwerp:7 vs 9
Sounds like you have been exploiting a bug: -- $EXECUTE IMMEDIATE "CREATE TEMP TABLE lvo ( i INT, f char( 16 ) ) -- WITH NO LOG"; -- $EXECUTE IMMEDIATE "INSERT INTO lvo VALUES ( 1, 'A' )"; -- $DECLARE sel CURSOR WITH HOLD FOR SELECT f INTO :f FROM lvo; -- $OPEN sel; -- $FETCH se…
Re: Oracle ?
Mark Townsend said: > Obnoxio The Chav wrote: >> Serge Rielau said: >> >>>Mark Townsend wrote: >>> > >> Anyway, can you guys go have your pissing contest over in the cdo >> hierarchy or in cddb2? > > Fair enough, it was a little bit of a troll which I apologise for. Which little…
RE: Isolation levels in Informix vs Oracle
This is a multi-part message in MIME format. ------_=_NextPart_001_01C4E3F2.999D6FC1 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C4E3F2.999D6FC1" ------_=_NextPart_002_01C4E3F2.999D6FC1 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Enc…
Re: Oracle ?
Obnoxio The Chav wrote: >>Innovation is like the tide. Making it rise raises the IBM ship and with >>it it raises Oracle, Microsoft etc, ... . IBM takes as little offense >>with this as a shark minds cleaner-fish picking its teeth. > > > So what you're saying is that IBM is the …
Re: IDS 9.40 UC5/linux update statistics crashes engine on large
loden@networkip.net said: > Breif background: > I am in the process of doing some migration testing from an hpux system > running 9.21 FC7 to a linux system (fedora core 1 with customer > mainline kernel) running 9.40 UC5. Can you try downgrading to UC4? > I have gone through t…
Re: Oracle ?
Serge Rielau said: > Mark Townsend wrote: >> Serge Rielau wrote: >> >>> IBMs primary business is innovation, It is NOT fighting Oracle or >>> Microsoft. >> >> Tell me one innovative thing that IBM has done with DB2 in the last 5-10 >> years. Feel free to use this deinition of inn…
Re: Oracle ?
Mark Townsend said: > Serge Rielau wrote: > >> IBMs primary business is innovation, It is NOT fighting Oracle or >> Microsoft. > > Tell me one innovative thing that IBM has done with DB2 in the last 5-10 > years. Feel free to use this deinition of innovative - > http://www.hyperd…
Re: Oracle ?
Serge Rielau said: > Mark Townsend wrote: >> Captain Pedantic wrote: >> >>> >>> Definitely true with DB2. It can heal itself you know. >>> And it has a single code base. >>> >> So I have to ask - does anybody actually grok IBM Marketing ? >> >> As some of you may know, IBM inher…
Re: IDS 9.40 UC5/linux update statistics crashes engine on large table
loden@networkip.net wrote: > Breif background: > I am in the process of doing some migration testing from an hpux system > running 9.21 FC7 to a linux system (fedora core 1 with customer > mainline kernel) running 9.40 UC5. > > I have gone through the install and everything seems…
Re: Oracle ?
DA Morgan said: > Captain Pedantic wrote: > >> "DA Morgan" <damorgan@x.washington.edu> wrote in message >> news:1103152256.610955@yasure... >> >>>Dirk Moolman wrote: >>> >>> >>>>I have just completed the Oracle Fundamentals I course, and I was >>>> always >>>>very curious why peo…
Re: 7 vs 9
rotor wrote: > Hi community! > Explain please difference. ESQL/C fragment: > > $EXECUTE IMMEDIATE "BEGIN WORK"; > $EXECUTE IMMEDIATE "CREATE TEMP TABLE lvo ( i INT, f char( 16 ) ) > WITH NO LOG"; > $EXECUTE IMMEDIATE "INSERT INTO lvo VALUES ( 1, 'A' )"; > $DECLARE sel CURSOR WITH…
Re: Byte data
After reading the manual and going through the CDI archives, I think I need to use the LOTOFILE function I tried the following SQL and got the error ... "674: Routine (lotofile) can not be resolved.". I tried running as a user as well as Informix. What am I doing wrong? Thanks! …
Re: IDS 9.40 UC5/linux update statistics crashes engine on large table
I do have a case open. I figured I would post to the group as well and see if anyone else has had the problem. The af file did not produce the normal stack trace it only has about 7 lines, basically a repeat of the error in the online.log. ~tisha…
Runner C functions for TEXT and BYTE
Hi folks, before I spend some time maybe re-inventing the wheel, does anyone have some C source for functions that manipulate BLOBs from 4GL? We're looking at a few straight-forward string-like functions for TEXT, such as substringing, and probably functions similar strcat, str…
RE: Informix and RAID
Hi Art, You certainly make a strong argument against RAID 5. I'm wondering what you reaction is to some of the reasons we have chosen to use RAID 5 in the past. Namely: About 4 years ago when we purchased our database servers, some of them were 4-way systems with 12 8G drives a…
Re: Oracle ?
Captain Pedantic said: > "DA Morgan" <damorgan@x.washington.edu> wrote in message > news:1103152256.610955@yasure... >> Dirk Moolman wrote: >> >>> I have just completed the Oracle Fundamentals I course, and I was >>> always >>> very curious why people said "for every Informix DBA…
Re: Running Informix on 2 different Servers in parrallel
Neil Truby said: > Are they enough to persuade the average user to pay a > hefty uplift for? It depends. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass"…
Re: Running Informix on 2 different Servers in parrallel
scottishpoet said: > My alter ego was called many things in the past, but and Informix God?? Why not? You have the body of a god: Buddha! -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, b…
Re: Isolation levels in Informix vs Oracle
DA Morgan said: > rkusenet wrote: > >> "PK" <pk26au@yahoo.com> wrote in message >> news:667bf0c6.0412150133.7e4ce123@posting.google.com... >> >>>Hi, >>> >>>As you know Informix offers 'set isolation to dirty read' - a facility >>>to read dirty buffers. I believe DB2 UDB too offer…
Re: Running Informix on 2 different Servers in parrallel
Neil Truby said: > "Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message > news:10s070nqi9utl9f@corp.supernews.com... >> Obnoxio The Chav wrote: >> >>> Speed? Better diagnostics (I mean much, much, *much*, _*much*_ better >>> diagnostics)? New features? I mean, would you ad…
RE: Isolation levels in Informix vs Oracle
Concider the following situation: An application is trying to analyze bank's balance during the operational day - that is, some records in the 'account' table might change while the query is running. In Informix, DB2, MS SQL the only way to implement the consistent query in suc…
IDS 9.40 UC5/linux update statistics crashes engine on large table
Breif background: I am in the process of doing some migration testing from an hpux system running 9.21 FC7 to a linux system (fedora core 1 with customer mainline kernel) running 9.40 UC5. I have gone through the install and everything seems normal. Took a copy of one of our "s…
Byte data
I have a vendor supplied application. The images (JPG format) are stored in a byte field within IDS 9.4 database. I need to download these images to individual jpg files to be served as static content. I used the unload command in dbaccess. The resulting file has binary data. I f…
RE: ontape -s to disk
This is a multi-part message in MIME format. ------_=_NextPart_001_01C4E37B.56083EAA Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 Gene, I can't find my stuff/scripts we used back then.... probably archived/deleted during "clean t…
Let your customer find fast and easy all text he searches !
AlphaTIX is a powerful, fast, scalable and easy to use Full Text Indexing and Retrieval library that will completely satisfy your application's indexing and retrieval needs. AlphaTIX indexing technology provides you with highest indexing performance, possibility to index very lar…