Threads from 1999

Greetings to all! I have the great pleasure of sitting on site during the rollover, hence the volume of posting at this auspicious time. I mean I wouldn't want anyone to think I was a life donor. Anyway, seeing as Informix is trying to become a powerhouse of e-commerce, could s…

Happy new year !!!

Stefan Weideneder

Hi, I just want to wish everybody of this NG A Happy New Millenium Best regards, -- Stefan Weideneder Phone: +49 89/3565478-2 --------------- --- Fax: +49 89/3565478-3 ------------- ------ mailto:/stefan@weideneder.de --- -------- http://www.weideneder.de -----…

php+apache+informix

biggiealec@my-deja.com

both of the .h files don't exist on my machine. can someone send them to me, or let me know where I can get them. This is for linux. send via attachment to aginsberg@safeconnect.net if possible. Thanks, -Alec ps. once again, the files are locator.h and sqltypes.h Sent via …

Re: tracing of SQL-Statements

From: "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> > >I am looking for a way to trace really each SQL statement >an application sends to the database server. I-Spy? ______________________________________________________ Get Your Private, Free Email at http://www.hot…

Re: Tools for www pages and informix

From: "Kevin Hunt" <khhunt@triplecrownsvc.com> > >I'm starting a web page project that will need to query Informix from >Apache >server. Anyone have any suggestions for a good set of tools to do this? I.Sell? :-) i.reach, PHP, Perl (DBD::Informix), cgi + 4GL or ESQL/C, .... __…

Error -908 when connecting to remote db-server

Henk van der Geld

Hi, I try to make a connection from my W98 workstation with a remote db-server (lives on Linux machine) and then I get error -908. I verified my hosts file, my services file. I entered the correct data in SetNet32. What could I have forgotten? Any help will be appreciated. Happ…

Re: Row locking in dynamic server

From: Jonathan Leffler <jleffler@earthlink.net> > >R�diger Breit wrote: > > > General question: how can I achive row locking in a > > multi user environment. Seems not to work for me > > > > I experiences a problem with row locking with > > Dynamic Server 7.3 under Linux. Even a …

Re: Linux SE lotsa users

From: "person1544" <craig@bdsn.com> > >We have a Linux RH 6.0 system running SE and RDS. When there are about 45 >users in the system, new users get forking errors. Is there a document that >describes the tuning requirements of SE and Linux. Have you upped NPROCS in to kernel? Y…

Re: K shell

From: "Mukund Shevkar" <mukundshevkar@hotmail.com> > >Hi list, I wanna know where I can find Shell (k) programs on database >maintenance / performance etc for IDS engine. Can somebody give steps to go >to repository etc to give a look at them. I am in need of K shell programs >ur…

SPRL/I - an interpreter for Informix Stored Procedure regression

Hi all I have written an interpreter for a simple scripting language I call SPRL/I, that will allow one to run a series of canned tests for a group of stored procedures. It is written using GNU flex, bison and ESQL/gcc and is available for download at my web site: http://www.ge…

Re: IDS 7 slower than OnLine 5 - why?

From: "Andy Kent" <andykent.bristol@virgin.net> > >I've heard a lot of talk about people managing to get IDS 7 to run more >slowly than OnLine 5 on an identical configuration. That's not strictly true, it's only really a valid observation at fairly small sites (say < 150 users, …

Re: php+informix+apache

Alec Another thought. Check out the -I in the gcc call(s). Perhaps the makefile is not able to find the include directory. HTH Sujit Sujit.Pal@bankamerica.com on 12/30/99 05:43:32 PM To: biggiealec@my-deja.com cc: informix-list@iiug.org (bcc: Sujit Pal) Subject: Re: php+…

Help nedeed for restore

Jorge Lopez

I have an IDS 7.30 on SCO 5.0.5. IDS use raw devices. I use ontape -s -L 0 for backups. How could I recover a copy of level 0 in another machine? This machine has less space in disk that the production machine, but I only strictly need restore a table and this table is the only o…

Re: i.sell

From: Mark Spanglet <mspanglet@anexsys.com> > >Is anyone using i.sell? I am looking for some good documentation >concerning the application server and it's capabilities/limitations. >All I am a ware of is what comes on the cd as online docs and that is >poor at best. Huh? Infor…

Re: How to choose a DB

From: spam@admin.u.nu (Miguel Cruz) > >Mark Townsend <mtownsen@us.oracle.com> wrote: > > Miguel - you mentioned a requirement for transparent or near transparent > > clustering - can I ask you what for ? > >The goal is scalability - availability is an added plus but not the prim…

Re: Cooked vs raw

From: "Anne Shelp" <shean@mcdss.co.gov> > >I know, I know, this is a real beginners question. I inherited this >database server all set up (and not very well). How can I tell if a dbspace >is set up with cooked files or raw? The system admin here thought they were >raw but it loo…

Re: Bufwaits and Foreground Writes

From: Daniel Marshall <dtmarshall@worldnet.att.net> > >SAP is almost totally client-server, isn't it? If that's the case and the >clients are all connecting via TCP, >the the NETTYPE for soctcp should be CPU, rather than the one for ipcshm, >which isn't used as much. I disagree…

Re: Bufwaits and Foreground Writes

From: "Bernstein, Rick" <rbernste@alarismed.com> > >Despite our tuning efforts, we are encountering a significant number of >bufwaits and foreground writes >on our production SAP system. This system runs IDS 7.30.UC7XK on a 4-way >RS6000 R50 (AIX). >I attended Informix's Perform…

Re: Bringing up a new instance of Informix

From: ram_cnc <rsivaguru@my-deja.com> > >I am configuring a new instance of informix 9.20 UC1. I am having >problems if I add DBSERVERALIASES. > >I have the 9.14 and 7.31 configured and working properly. > >The /etc/services entries on the HP box (starfish) looks like: > >sqlexec…

Re: Best way to config OWS on SCO box

From: "Steven L Cooper" <scooper@thecompounders.com> > >We are running SCO 5.0.4 on a 4-way (P200) Intel DG AV/3600 >Running RAID5 (yes Art, I know this is bad) w/100+ users using 4GL based >OE/IC/AR/etc. > >I have tried to "tune" the config for OLTP per suggestions from this >ne…

Re: Assert Fail / 7.31 FC2

From: beach_bummer@my-deja.com > >06:48:17 Action: Run 'oncheck -cI mcommsg:"info".isidextid#idextid_pk' So, what happened when you ran this? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…

RE: Urgent support need

Rick Rabe

Is this on restarting the instance? Sounds like a disk drive problem. > -----Original Message----- > From: W. J. Hsu [SMTP:wjhsu@pti.com.tw] > Sent: Thursday, December 30, 1999 8:24 PM > To: informix-list@iiug.org > Subject: Urgent support need > > Hello, > > I got problem on In…

Urgent support need

W. J. Hsu

Hello, I got problem on Informix database, the system complained: can not open primary chunk /dev/online_root1 errno:5 I am running with Informix 5.0, hook up with two raw device chunk. online_root & online_root1. Can I shutdown chunk 1 since I got only 60% data of chunk 0? …

Re: php+informix+apache

Alec You may want to look at functions/php3_ifx.h to see how the sqltypes.h and locator.h files are called. They should be called as EXEC SQL include sqltypes; and EXEC SQL include locator; The files are in $INFORMIXDIR/incl/esql. I have a small writeup at http://www.geocities.…

output to a delimited file

kirt

I have written a shell script that outputs to a flat file. I want to actually have a delimited flat file. If I use a command called selectfile I get a nice pipe delimited file but this does not let me pass to it a variable for the file name. There will be close to 200 similar…

Informix position

H

Anybody looking for a Senior Informix DBA position, please contact Andy. There is a very strong position opening in Northern NJ. Thanks, Andy Sacks…

php+informix+apache

biggiealec@my-deja.com

I get the following error, I've been doing ./configure --with- informix=yes and my informix server is located in /opt/informix. Please let me know if there is anything special about this, I do have INFORMIXDIR defined as well. Are there any guides to php+informix+apache install?…

Re: How to choose a DB

Kudzi Muchaka

Tim, Are you sure you don't work for the Informix marketing dept? Oh, sorry Informix does not have a marketing dept... or do they? Makes one wonder!!! Anyway Tim, I think you should get compensated by Informix for doing their job... just my thought! To all... have a blessed Y2…

InterBase/Informix/MS SQL Server

John Stephenson

Have any of you had any good/bad experiences with Inprise's InterBase? We're comparing it to Informix and MS SQL Server for a new server for medium sized client - server applications. Probably on NT, but Unix is still in the running. Our programmers will be writing windows 98 ap…

Shared memory ran out

Chetan Anand

Hi : We have situation where Java user defined rountine (UDR) when being called from a INFORMIX 4GL in a loop, after certain iterations (30000) , INFORMIX Engine CRASHES. When I looked at INFORMIX onstat -g seg, I could see many shared memory being allocated dynamically. Even t…

Re: Who can help with ODBC

Noel Griffin

We have used the InterSolv 3.11 driver for some time now and it works well. However it does not work properly via ADO, particullarly with DECIMAL data types. Intersolv posted a patch to the 3.11 driver on their web site about a year ago. If you use this it should be fine with A…

web datablade issues with IDS 9.20 and DBI/DBD

Jack Avenevoli

Hello all, We have 2 informix databases, one on a SGI Origin 200 (IRIX 6.5.6) (IDS 9.14UC7) and one on a linux machine (Redhat 6.0) (IDS 9.20UC1). We are porting a lot of perl scripts from the SGI box to the Linux box, and are running into the following error when running ou…

Re: Bufwaits and Foreground Writes

John Coyle

Rick, While I'm running IDS 7.24UC8 and my response may not be totally correct the ideas may be relevant. Your: NETTYPE ipcshm,2,30,CPU # Override sqlhosts nettype parameters NUMCPUVPS 4 # Number of user (cpu) vps but until NETTYPE references 4 CPUs…

IDS 7 slower than OnLine 5 - why?

Andy Kent

I've heard a lot of talk about people managing to get IDS 7 to run more slowly than OnLine 5 on an identical configuration. For what kind of reasons does this come about? What parameters simply cannot be left the same when you migrate to IDS? I've never had a client experience …

RE: Bringing up a new instance of Informix

mosserp@WellsFargo.COM

Kinda obvious, I know, but... Are you sure that 1544 isn't already being used by something ELSE in your /etc/services file? -----Original Message----- From: ram_cnc [mailto:rsivaguru@my-deja.com] Sent: Thursday, December 30, 1999 11:35 AM To: informix-list@iiug.org Subject: Re:…

Bufwaits and Foreground Writes

Despite our tuning efforts, we are encountering a significant number of bufwaits and foreground writes on our production SAP system. This system runs IDS 7.30.UC7XK on a 4-way RS6000 R50 (AIX). I attended Informix's Performance Tuning class last week in Menlo Park. Their suggest…

Informix Manuals

Jorge Torralba

A wide variety of original Informix books which were passed down to me. http://cgi.ebay.com/aw-cgi/eBayISAPI.dll?ViewItem&item=227930211…

Re: DBCENTURY and Y2K

Allen It will be 1/1/2000. We found this indirectly from our Y2K testing. We get a feed with 2 digit years, which a Java program puts into one of our Informix databases. We had set the DBCENTURY in our environment but the Java program which used Intersolv's JDBC driver sees the …

Re: Importing flat files to database

=?iso-8859-1?Q?R=FCdiger?= Breit

aginsberg How about the Informix-SQL LOAD and UNLOAD? HTH Sujit aginsberg@safeconnect.net on 12/29/99 07:45:18 PM Please respond to aginsberg@safeconnect.net To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Importing flat files to database I have a flat file t…

Informix Restore asking for tape 2 when there is none

Sue Athey

I am restoring an Informix test database from a production Informix database using ontape -r. I have done this process many times in the past with no problems. This past week, however, I have tried two different backup tapes and each time, the restore gives me the message "Pl…

Re: How to choose a DB

Miguel Cruz

Mark Townsend <mtownsen@us.oracle.com> wrote: > Miguel - you mentioned a requirement for transparent or near transparent > clustering - can I ask you what for ? The goal is scalability - availability is an added plus but not the primary factor at this point. The client app will…

Error 263 (ISAM 107) - Can not lock row for update

Randy Hao

When I get this error -263, is there a way to know who locks the row and which row is? TIA & Happy NewYear Randy…

DBCENTURY and Y2K

allenj

I am using 7.31.UC2 IDS. My DBCENTURY env var is not set. The manual says that, in this case, Informix will use the current century for 2 digit years. Depending on whom you believe, 2000 is either the last year of the 20th century OR the first year of the 21st century. (There …

Se Engine Problem ( Systables )

Lloyd AJ Wilson

Hi, A little problem here ... ;-) Using an SE Engine on Alpha 4.0D. In systables there is an entry for example xtable which has a directory path pointing to the proper data file ... in the *.dbs directory. This file does exist with data in it. When trying to access the table…

Error in Log file

Paulo Amorim

Hello again !!! The log file above shows an error received yesterday, wich I do not have an idea of its causes... maybe it's a bug, I don't know. I hope that somebody can help me. Our machine is an Unisys SMP6400 and we're using IDS 7.20.UC2 Thanks!! 08:45:10 Checkpoint Compl…

Row locking in dynamic server

Hi General question: how can I achive row locking in a multi user environment. Seems not to work for me I experiences a problem with row locking with Dynamic Server 7.3 under Linux. Even a simple test would not run: Databse create with ANSI compliant. Created a table with LOCK…

collation order

Thomas Vatter

I try to set up a german collation order with dynServer 7.3 TNT. In setnet i have set db_locale, client_locale and dblang to "de_de". Though i never have the correct order of data sets after a query. 'ä' still comes at the very end of the data set. Thomas Vatter…

RE: Why does IN work but NOT IN fails?

Thiel Franky

Try this and it will work... Select u.ticker from universe u > where u.ticker NOT in ( select ticker from holdings ); Regards, Franky Thiel -----Oorspronkelijk bericht----- Van: Bashar Chalabi [mailto:bashar@ctl.com] Verzonden: donderdag 30 december 1999 00:44 Aan: informix-l…

Re: Importing flat files to database

Sue_Davidson@exe.com.au

from command line: export DBDELIMITER=; or whatever character you want to delimit with from isql: (to import) load from filename insert into tablename dbload is better if you are going to regularly import large files, it has parameters that allow you to import a number of record…

Informix User Group Forum 2000

Lester Knutsen

---------------------------------------------------------------------- Informix User Group Forum 2000 ---------------------------------------------------------------------- Solutions for Informix Users A Two-Day User Group Technical Conference …

Importing flat files to database

aginsberg@safeconnect.net

I have a flat file that is currently colon delimited (can be changed with regex easily). I need to import this flat file into a table. Is there a utility, or script that will do this for me? I've thought about just using coldfusion server with <cfloop> but that doesn't seem li…

Re: Substring selection in Stored Procedure

--Boundary_(ID_N3N5FjuoDH2tmAOehBDNnw) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Paulo There is a SUBSTR() function in 7.30 upwards. for k = 1 to 10 select substr(vllimite, k, 1) from tab1 where 1=1; end for; sho…

Why does IN work but NOT IN fails?

KONE

I have two tables, universe and holdings. Holdings are always drawn from universe. There are 1650 rows in universe and 157 in holdings. Sometimes I want to connect the tables and sometimes I want to look in universe for items not in holdings. This NOT IN approach used to work …

Bringing up a new instance of Informix

ram_cnc

I need some help. Platform HP UX 10.20 Informix version 9.20 UC1 Informix version 9.14 UC7 Informix version 7.31 UC4 I am configuring a new instance of informix 9.20 UC1. I am having problems if I add DBSERVERALIASES. I have the 9.14 and 7.31 configured and working properly. …

Re: whoever

Info Temp

Surfer! wrote: > What version of the engine? > > What version of the tools? > > What setting of DBCENTURY (or whoever you spell it?) Shouldn't that read: What setting of CDBENTURY (or whoever you spell it?) -- ------------------------------------------------------------------…

Re: Fw: FWD: use of ISM and ONBar vs ontape

Denmark Weatherburn

Ok, Can you help with two sample commands using a level 0 ontape to restore a dbspace(s) or a database? Thanks, Denmark W. ----- Original Message ----- From: Art S. Kagel <kagel@bloomberg.net> Newsgroups: comp.databases.informix To: Denmark Weatherburn <dweatherb@btl.net> Sen…

Substring selection in Stored Procedure

Paulo Amorim

Hi Does anybody knows if there is a way of perform a substring selection inside a stored procedure ??? I�m sending an example above, wich is Hope somebody can help me Thanks in advance for k = 1 to 10 select vllimite[k] from tab1 where 1=1;with a syntax error, but I don�t kn…

Fw: FWD: use of ISM and ONBar vs ontape

Denmark Weatherburn

Ok Listers, I'll digress a little. You are aware of the famous quote: "If it ain't broke don't fix it." I have had no problem with using ontape for our backups, however, how can I use ontape (What command) to backup or restore one or more than one dbspace. Currently I do a leve…

Re: Indexing troubles

Scott Holmes

It is very odd and has me baffled. I'm currently running the clustered index as a clustered index without the field j_status. I was unable to create the index with j_status either as clustered or not clustered. Given that the reported problem is indeed NOT the real problem, I'm…

Re: Description fields in Informix databases

--Boundary_(ID_RpQD+FKrLma5uhmiFKvQfA) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Lauri Try using TEXT datatype. HTH Sujit Lauri Pietarinen <lauri.pietarinen@atbusiness.com> on 12/29/99 02:13:38 AM Please respond to…

Re: Someone has compiled PHP with Informix support?

Leslie and Mark Stevenson

Daniele I have installed php as a dynamic shared module (APXS approach) with apache. You can look at http://www.geocities.com/sujitpal/artli007.html for a complete description. HTH Sujit Daniele Medri <madrid@kjws.com> on 12/28/99 04:31:09 PM Please respond to madrid@linux.it…

Help: Ontape Warm Restore

Bashar Chalabi

Hello, IDS7.31 on NT4. I am trying to do a warm restore using ontape. I first do a cold restore (not all DBSpaces), which works fine. I then bring the server online, and do a warm restore of the remaining DBSpaces. After the warm restore, the newly restored DBSpaces are flagged…

Re: Indexing troubles

Scott Holmes

Here is the relevant schema: create table journal ( jrnlnmbr serial, j_date date, casenmbr integer, casecode char(11), peopnmbr integer, peopcode char(17), evntnmbr integer, evntcode char(11), j_descr char(45), j_rate decimal(8,3), j…

Informix 4GL Positions - Colorado

Looking for 1 Informix DBA and 2 Informix 4GL developers for contract and contract to hire positions in Colorado. If interested please respond to: Mark Stevenson ACS Technology Solutions 877-221-6877 mstevenson@acsts.com…

Description fields in Informix databases

Lauri Pietarinen

As Informix does not support varchar-fields over 255, how would you recommend saving descriptions, that usually are under 255 but sometimes can be over 1 K long. Using a fixed 2K field is a possibility, but it does waist a lot of space. I would be most grateful for any suggesti…

Re: [networker] Legator NetWorker and Informix: Saving Client Index

Richard Spitz

Dear NetWorker and Informix experts, a couple of weeks ago I posted a question about the Networker module for Informix: > The database and log data are backed up to their respective media > pools just fine. However, each backup run also saves the Networker > client index, and t…

IDS on Linux weirdnesses

Peter Eckhardt

Hello to all, after we had a catastrophich failure yesterday (finally the restore from tape worked and everything seems to run smoothly again) i have some questions about Linux and IDS. We made the following observations 1. - when MULTIPROCESSOR is set to 0 network connect…

error code -240!

paul

Dear all When I perform Delete SQL command for one table, I often got an error code -240, but there are nothing useful message from "finderr" command, can someone help! Thanks in advance!…

SQLIDEBUG, sqliprint

Reinhard Habichtsberg

Following a hint of that friendly guy at Siemens Informix Support I found SQLIDEBUG (an environment variable) and sqliprint (a tool) to trace sql statements and other traffic between client and server. It seems that these are "undocumented features". Anyhow, I am looking for a d…

Re: running dbaccess via perl

Jonathan Leffler

When did you ask for help compiling DBD::Informix on AIX? I don't recall seeing such a request, and would have been very happy to try and help. Andrea Ferguson wrote: > I have a perl script which will be doing many selects and inserts to an > Informix database at various times…

Software keeps data of members and their downline

Brenda Taylor

I am looking for a way to keep track of people who becomes members in my company. When they sign up on line or telephone the call center it will instantly give them a membership number and assign them to the correct person (membership number)who referred them to join. Anyone's he…

Indexing troubles

Scott Holmes

--------------BCABC43242098CEEC4C871C8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit While trying to create a cluster index on four fields in one table I get an error 350: Index already exists on column; with 108 key already exists. This is a syste…

ODBC Help

Callum

When using either the Intersolve or Informix ODBC connection software I get problems with date fields, in fact any software that connects remotely. I am connecting to three instances of Informix all of which are configured the same (DBCENTURY & DBDATE fields are the same). When…

Someone has compiled PHP with Informix support?

Daniele Medri

Hi, i didn't compile php+informix support linked with apache. Someone has got experiences on these? Let's me know.. info, docs... and other else. Thank Thank.. very a lot -- Daniele Medri e-mail: madrid@linux.it madrid@erlug.linux.it If a listener nods his head when you're expl…

Auto RAID and IDS 9.20

Sue Brooker

Has anyone tried running IDS 2000 9.20.HC1 with Auto RAID on HPUX 11? We have 6 x 18 Gb disks with 2 disk controllers and are thinking about creating 3 separate volumes each with their own array to ensure the busy data is physically spread over 3 disks. Has anyone experianced a…

RE: Best way to config OWS on SCO box

See comments below... > -----Original Message----- > From: Steven L Cooper [mailto:scooper@thecompounders.com] > Sent: Tuesday, December 28, 1999 2:08 PM > To: informix-list@iiug.org > Subject: Best way to config OWS on SCO box > > > Howdy, > We are running SCO 5.0.4 on a 4-way …

GUI universe admin tool

James Muir

Has anyone used this administration tool called the universe file manager from Sunergos Software (www.sunergossoftware.com)? It looks pretty impressive.…

Best way to config OWS on SCO box

Steven L Cooper

Howdy, We are running SCO 5.0.4 on a 4-way (P200) Intel DG AV/3600 Running RAID5 (yes Art, I know this is bad) w/100+ users using 4GL based OE/IC/AR/etc. I have tried to "tune" the config for OLTP per suggestions from this newgroup over the years and the good news is that is run…

RE: onbar question

mosserp@WellsFargo.COM

Phillip, (1) Make two copies of the current log_full.sh script. Call them, for example, log_full_A.sh and log_full_B.sh. (2) In the log_full_A.sh script, insert some lines in the area where PROG, USER_LIST, and BACKUP_CMD environment variables are set. In that same place, inse…

Re: Apache and JDBC to Informix

Kevin I use it on Linux 5.1 at home. JDK 1.1.7 JSDK downloaded separately, not sure of version number. Informix JDBC driver 1.4 (I think). You should have servlet support in your webserver. To do this, you can check out Alliare's JRUN product, the mod_java from blackdown (you …

Re: Tools for www pages and informix

Kevin I know of - Perl or other language (4GL, C) with CGI - Java with JDBC and JSDK - PHP For rapid application development, I would recommend PHP. HTH Sujit Kevin Hunt <khhunt@triplecrownsvc.com> on 12/28/99 10:49:26 AM Please respond to Kevin Hunt <khhunt@triplecrownsvc.c…

ISM message during onbar backup

Ron Schwingel

1st question I received the following unix e-mail during a full backup of the database on /dev/rmt0. /dev/rmt1.1 is the Logical Log backup device. device automatically disabled ISM Device Disabled: Device /dev/rmt1.1 is automatically disabled. Consecutive error (21) exceeded t…

Anyone looking for an Informix DBA position in Cambridge, MA.

Sandra Carr

If you have a good Informix skill-set and are interested in working at a leading internet company in Cambridge, MA, please e-mail your resume to sandycarr@mindspring.com. Thanks…

RE: onbar question

mosserp@WellsFargo.COM

I have a similar setup on one of my servers, i.e., 2 instances, same INFORMIXDIR, using ALARMPROGRAM to backup the logs (except that I'm using ontape -a to disk for the backups). I use a different ALARMPROGRAM script for each instance. And I don't leave any of the environment p…

Assert Fail / 7.31 FC2

beach_bummer@my-deja.com

Assert Fail messages during deletions,always the same index, Running on TruUnix64 4.0D: 06:48:17 Assert Failed: Error during recovery left index inconsistent. 06:48:17 Informix Dynamic Server Version 7.31.FC2 06:48:17 Who: Session(713, info@blue, 0, 285820304) …

onbar question

Phillip Tien

Hello, I have two instances of informix running on the same machine. Let's call them instance A & B. They have the same INFORMIXDIR but obviously different INFORMIXSERVER and ONCONFIG variables. Both instances are set to use onbar to automatically back up the logical logs whe…

Apache and JDBC to Informix

Kevin Hunt

Anyone using Apache to Informix with jdbc? I'm trying to get all the pieces required to do this. -- Kevin H. Hunt khhunt@hunts.com…

Tools for www pages and informix

Kevin Hunt

I'm starting a web page project that will need to query Informix from Apache server. Anyone have any suggestions for a good set of tools to do this? -- Kevin H. Hunt khhunt@hunts.com…

Re: Assistance Installing SCO Unix IDS

Tracy Sweeney

We have found the problem was with the hardware installation. Thank you to everyone for trying to offer assistance. Tracy Sweeney wrote: > We are installing the following products on SCO Unix 5.04: > > # cat *-cr > INFORMIX-4GL Version 7.20.UE2 > Copyright (C) 1984-1996 Inform…

OnBar/IDS.2000

Doug McAllister

Hi all... I see by the IDS.2000 documentation that the bar_version table in sysutils is gone and that the information that was in that table now belongs only in the sm_version file. The Legato documentation makes no reference to IDS.2000, does anyone know if the current version …

OnBar/IDS.2000

Doug McAllister

Hi all... I see by the IDS.2000 documentation that the bar_version table in sysutils is gone and that the information that was in that table now belongs only in the sm_version file. The Legato documentation makes no reference to IDS.2000, does anyone know if the current version …

Server Agent ..HELP PLEASE!!

ferrari0@my-deja.com

IDS 7.31 AIX 4.3.2 When I startsa (as user informix), I get VisiBroker: Unable to locate agent. Will try every 15 seconds to locate agent osagent is running, OSAGENT_PORT is set to 14016 a second server is setup similarly, no problem. Any ideas anyone ? Sent via Deja.com ht…

RE: IDS 7.30 CPU Usage

Comments follow. >===== Original Message From "Jay Turner" <tjay@edcpub.com> ===== >Back in November we upgraded both our OS and Informix engine. From AIX >3.2.5 to AIX 4.3.2 and SE 5.03 UC1 to IDS 7.30 UC5. We are still using the >same system (RISC 6000 59H 768 meg. memory) a…

RE: number of extents

Tina McAllister

I am in a new Informix shop and have been told that it is a very bad idea to have a large first extent. They say the first extent should be small and the next extent large or performance is affected and temporary tables are too large. That is opposite of what I have done in the…

Informix on Linux and Archive restore problems

Peter Eckhardt

Hi, we use Informix IDS 7.30.UC7. Today we had a catstrophic failure and needed to get the last backup back via ontape -r. The restore started normally and after around 30 secs I received a message that an Interrupt was received and the restore stopped. We always had problems w…

informix to access

Alain Gonzalez Castillo

Hi, anyone knew any form of translate bd's & tables from informixSQL to Access? Please reply too at mi mail. Thanks.…

Re: Informix problems afters Y2K Solaris 2.5 patch

Looking at your onconfig file I saw the error stating there a no shared memory available. May be this patch has modified the shared memory or virtual memory process limit kernel parameters. Check them and change them to be as stated in the Informix Dynamic Server release notes. …

Re: Empty onconfig file

Zeljan Silje

Kudzi Muchaka wrote: > > Online Version 7.23 UC1 > AIX 4.3.2 > RS6000 J30 > > I have continuous log backup going at all times. On Wed, last week I > presumed that logical log backup had been stopped, CNTRL-C. But, alas > this had not happened. Our nightly backup is done via a cro…

Informix problems afters Y2K Solaris 2.5 patch

Has van der Krieken

Since I did the Y2K patch for Solaris 2.5 on a Ultra Sparc 1 system, Informix 7.22 refuses to startup properly. Anyone experienced a simular problem? Any suggestions? Attached some system information and the relevant part of the online.log Has van der Krieken. # uname -a SunOS …

table memory resident

Mukund D Shevkar

This is a multi-part message in MIME format. ------=_NextPart_000_0019_01BF511F.B6DBD700 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi list Help wanted , what is the syntax for making table memory resident. I've worked on 7.x = t…

error -206 dbschema dbexport

Frank Linde

Hi, we can't use dbexport or dbschema (always get the message "The specified table informix.sysroleauth is not in the database. (Error -206)"). Do you have any idea how to solve this problem? Regards, Frank…

Re: Linking raw disk space to a /dev file in SCO

You didn't specified what SCO operating system are you using. In short: on SCO OpenServer your rturbo could be a division created with divvy (just check with divvy what divisions you have on your disks and I think you'll find somewhere a division named 'turbo'). On SCO OpenServer…

tracing of SQL-Statements

Reinhard Habichtsberg

I am looking for a way to trace really each SQL statement an application sends to the database server. Because the source code of the application cannot be changed I have to use means of the DBMS. onstat -g sql sid -r seconds > file records sql statements. The minimum interval …

Help!

paul

Dear all. Can anyone help me, what happen with our Informix Server! Thanks in advance! 21:55:17 Checkpoint Completed: duration was 0 seconds. 21:58:39 CDR connection to server lost, id 3, name <PI> Reason: Connect failed reason: -908 21:58:39 CDR: Re-connected to server, id …

Informix 4GL programmer seeking for a job in Toronto

Frank Wei

Hi, there, I have a few years 4GL programming experience in the UK, now seeking for a job in Toronto. Any one knows info. of the job opportunity please send me an E-mail: frank_gwei@hotmail.com. Thanks. Frank.…

RE: IDS 7.30 CPU Usage

I will mention some possible causes of your problems: 1) Have you run UPDATE STATISTICS against your tables in the manner recommended by the Release Notes? Failure to do so can cause performance problems. 2) Run the "onstat -P | tail -8" command. If a large percentage of …

RE: I'm looking for a documentation about the product dbaccess

family.cavaille@libertysurf.fr

The DB-Access User Manual can be found at the following Web address: http://www.informix.com/answers/english/alpha.htm Rick Bernstein -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Monday, December 27, 1999 2:47 PM To: informix-list@iiug.org Su…

RE: checkpoints taking as much as 25 secs

Scott Huppert

It's logical that turning the entire buffer pool every 10 minutes is probably bad, but what is a reasonable time frame? Is there any rule of thumb? -Scott > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Art …

Re: Empty onconfig file

Kudzi Muchaka

For those who were thinking about responding, please don't. The problem was that the backup logs were full, due to the inability of the backups to kick in. All the errors were being recorded in the error log, thus my logs grew. I ended up with no room/space in that file system. …

I'm looking for a documentation about the product dbaccess

Hello I use a tool 'Continuus'. This product manages the configurations of developpement and it uses the database Informix. In its scripts, I have found an SQL interpretor 'dbaccess', but I have nothing about it. Where I can find a help (man , howto, ...? ) to use it ? Thanks…

IDS 7.30 CPU Usage

Jay Turner

Back in November we upgraded both our OS and Informix engine. From AIX 3.2.5 to AIX 4.3.2 and SE 5.03 UC1 to IDS 7.30 UC5. We are still using the same system (RISC 6000 59H 768 meg. memory) and programs (4gl programs recompiled with I4GL 7.20 UD6). We were told to expect a hug…

RE: i.sell

We are using i.sell. I haven't been able to find any great documentation on it myself, ATG has online documentation, but to access it I believe you have to purchase Dynamo from them. As far as batch processing goes, you do not have to go through the application server for that.…

Empty onconfig file

Kudzi Muchaka

Online Version 7.23 UC1 AIX 4.3.2 RS6000 J30 I have continuous log backup going at all times. On Wed, last week I presumed that logical log backup had been stopped, CNTRL-C. But, alas this had not happened. Our nightly backup is done via a cronjob. We were closed Thurs & Friday.…

RE: restoring possibly damaged logs

As far as the informix database is concerned, your data will remain consistent and good through the rolling forward of all logs. You will not end up with a corrupt chunk. Whether or not the operations done by your programs after the chunk went in error is a question which needs…

how to use make for the myschema.source.ar

Edward Rosenthal

having the myschema.source.ar i unarchived ( ar -x myschema.source.ar ) then uncommented out the hp variables in the myschema.mk file, then ran the make so: make -f myschema.mk and got this hit - Make: Don't know how to make myschema.ec,v. Stop..SUFFIXES: the top of the make no…

Linking raw disk space to a /dev file in SCO

RossDC74

Hi, I know this is truly a SCO question, but I thought someone might have had some similar experience... I'm trying to link my raw space to a character-special device file. So far I'm looking at /dev/rdsk and that's about as far as I get. Which file should I be linking to? Anoth…

i.sell

Mark Spanglet

Is anyone using i.sell? I am looking for some good documentation concerning the application server and it's capabilities/limitations. All I am a ware of is what comes on the cd as online docs and that is poor at best. My major questions concern writing backend and "batch" style…

missing en_us.1252 - installation problem

Jay Silverman

Informix 7.2, NT4 Workstation, SP3. Installed Informix from the local administrator account, set up the environment variables. The Informix tools seem to work fine, and I am able to create and populate a database. When I log on as any other user (including the Informix user), …

Re: Cooked vs raw

You should check "onstat -d" and from the second part of its output, last column specifies the files used for chunks. Check those files. They could be: 1. A link (soft or hard). In this case check the file the link points to and see the cases described below. 2. A charact…

RE: IDS features

I seem to recall an Informix rep saying 9.21 when I asked. Will >===== Original Message From kagel@bloomberg.net ===== >David Williams wrote: >> >> In article <385FF9B1.3293BDAA@bloomberg.net>, Art S. Kagel >> <kagel@bloomberg.net> writes >> >Harry Sheng wrote: >> >> >> >> hi, a…

Cooked vs raw

Anne Shelp

Hi All, I know, I know, this is a real beginners question. I inherited this database server all set up (and not very well). How can I tell if a dbspace is set up with cooked files or raw? The system admin here thought they were raw but it looks to me like cooked space. Solaris …

RE: Error message generated by IDS 7.30 with oncheck -pr ...

You might check the permissions on chunk 1. It looks like that is what oncheck had trouble opening Will >===== Original Message From "Denmark Weatherburn" <dweatherb@btl.net> ===== >Hi Listers, > >Please for your comments about this error generated as a result of running >the f…

Linux SE lotsa users

person1544

Hi all, We have a Linux RH 6.0 system running SE and RDS. When there are about 45 users in the system, new users get forking errors. Is there a document that describes the tuning requirements of SE and Linux. Also, is the shadow password bug fixed yet? thanks in advance...…

RE: number of extents

After you reach the maximum number of extents, you will be unable to insert more rows into your table. A large number of extents will also adversely impact database performance. The maximum number of extents for 2K page systems is approximately 200. To quote the Informix trainin…

Re: SCO 4GL 4.x programs against Linux OnLine 7.x

Have you tried to set in case two beside INFORMIXDIR and SQLEXEC env. variables the DB_LOCALE, CLIENT_LOCALE and DBNLS environment variables. I'm not sure about this but it could help. Best Regards, Octav On Sat, Dec 25, 1999 at 06:30:58PM +0100, Michael Engel wrote: > Hi, > > …

K shell

Mukund Shevkar

Hi list, I wanna know where I can find Shell (k) programs on database maintenance / performance etc for IDS engine. Can somebody give steps to go to repository etc to give a look at them. I am in need of K shell programs urgently. TIA ___________________________________________…

SCO 4GL 4.x programs against Linux OnLine 7.x

Michael Engel

Hi, we have a somewhat unusual problem here - one of our clients has a bunch of old 4GL programs compiled with Informix 4.10 on SCO Unix (OpenServer 5). He wants to migrate to a Linux system running Online 7.x (Linux native version). Unfortunately, the source code to some of th…

Error mesages

The Great Green B*****d

Can anyone help me diagnose the following messages. An application was moved from a Dynix server to a SCO UNIX 3.2.4.2 server (to get over y2k hardware problems) and the folowwing errors occured. Any help would be greatly appreciated. Regards, Pete Date: 21/12/1999 Time: 15:…

Re: dbexport / dbimport

Neil Truby

dbexport -ss will include lock modes, extent sizes etc. What's the problem with the raw devices exactly? Is it that you have the chunk path as the raw device name itself? If so, use a symbolic link as the chunk name instead - it'll save heartache somewhere along the line. bsag…

dbexport / dbimport

bsagonda@my-deja.com

hie guys i am running Informix 7.30 on HP-UX 10.20, i have i 15Gig database which i want to export becauze the system tables have very large extent sizes and that some of the dbspaces are sitting on raw device names which could be a problem. My question is how can i include the …

Date value representation problem with 4GL developement tools 7.20 UD6 on Alpha ?

Joerg Spilker

Hello, after recompiling some software formerly running on Siemens RM technology machine (compiled with 4GL developement tools 4.1x) we recently changed to a Alpha Cluster (with TrueUnix 4.0) and 7.20 UD6 developement tools. After this change, every formatting of DATE values wi…

RE: Re-organisation of tablespace

Steven, Let me try to address your questions. 1) SAP tries to isolate DBAs from many of the "how-to" details. This approach has advantages and disadvantages. The advantages include vendor-supplied tools for many administrative tasks. The tools make the DBA's work is ea…

Informix products for each OS?

Richard Puchalsky

Hi, I was wondering if anyone knows of a reasonably authoritative list of Informix products available *now* for each major operating system. I keep talking to different Informix sales people, and checking different parts of their Web site, and every time I get a different answer…

dates and DBCENTURY

Phillip Tien

Hello, does anyone know how IDS 7.3 handles dates with regards to the DBCENTURY paramter? Specifically, what format does Informix use when handling dates? DD-Mon-YYYY or mm/dd/yyyy or what? -- Phillip…

number of extents

MATTHEW H. DEVLIN

I think I remember reading somewhere that with newere versions of IDS you did not need to worry about the number of extents. Is this correct? I have some tables with over 100 extents and I suspect that they are severely fragmented. I am formulating a plan for fixing this situat…

Error message generated by IDS 7.30 with oncheck -pr ...

Denmark Weatherburn

Hi Listers, Please for your comments about this error generated as a result of running the following command: oncheck -pr | grep TAPE I/O open() chunk 1, pagenum 0, pagecnt 12 --> errno = 13 finderr 13 says permission denied. I executed the command as dba users (informix). on…

Re: silly question

Evelio =?iso-8859-1?Q?Mart=EDnez?=

From: Mark Spanglet <mspanglet@anexsys.com> > >Hmmmm. Why does the informix books web site (really fatbrain) run, and >run badly, on MS Sql server? Hehe. Score another one for Informix's brilliant self-promotion. ______________________________________________________ Get Your Pr…

Re: runtime does not log the program name that produces the error?

I know what the errors mean. The question is if there is a bug in Informix 7 and does not log the errors with the program and line number and I have to debug manually. Some has told me that it is the case. Thanks jair wrote: > Evelio Mart�nez wrote: > > > Hello! > > Since I m…

Receiving "Changing data structure forced command termination." from onstat!

Bryan Osborne

Getting a "Changing data structure forced command termination." message when executing onstat (-g ses, -g ath, and others). oninit is running at ~98% of CPU (via "top"), so system is busy, but can things change that fast?!?! What makes me more nervous is that I receive a "Memor…

Re: silly question

michael martin

>Hmmmm. Why does the informix books web site (really fatbrain) run, and >run badly, on MS Sql server? Maybe Informix has secretly acquired Microsoft ? Or could it be a shortage of Informix trained people at Informix ?…

Re: Y2K problem on Standard Engine

David Williams

In article <38613362.EEA35D2D@informix.com>, Madison Pruet <mpruet@informix.com> writes >This sounds like bug 60150. Fixed in 7.24UC5. > Latest SE is 7.24.UC8, we have moved all our customers to this version. >Carlos wrote: > >> We've got a problem with dates in SQL. >> Th…

Re: runtime does not log the program name that produces the error?

jair

Evelio Mart�nez wrote: > Hello! > Since I migrate some apps from Informix 4 to INFORMIX-4GL Version > 7.20.UD7, there are some errors > that does not log in the error file. > > Is there any bug or reason for this? > > Exception > Date: 23/12/1999 Time: 11:21:24 > FORM…

Re: CASE TOOL

Andrej Falout

In article <fxd84.450$j9.53249@tw11.nn.bcandid.com>, vmessner@netaxis.com says... > all has fewer capabilities than Designer. > > ERwin is terrible. Nice features that do not work (in many cases), at least for us Informix folks. Good only for prototyping and presentations. -- Y…

silly question

Mark Spanglet

Hmmmm. Why does the informix books web site (really fatbrain) run, and run badly, on MS Sql server?…

Re: Informix ODBC driver - extremely limited

Werner Driezen

David Fishburn <spamoff_dfishburn@home.com> wrote in message news:83ru3o$at7$1@newswest.sybase.com... > I have been trying to use the ODBC driver that came with my 7.3 NT Informix. > The driver version is: > INTERSOLV 3.11 32-BIT INFORMIX 9 3.11.00.07 > > There must be a newer…

Problems with informix and apache

Santiago Martin

>> I'm trying to install php, apache and informix but, after compiling >php >> (--with-informix) always get the same error when i restart apache : >> 'ifx_module_entry' error. > >Did you define informix libs for PHP BEFORE making PHP, as suggested? Yes I did. > >> I suspect thi…

Problems with informix and apache

Santiago Martin

>> I'm trying to install php, apache and informix but, after compiling >php >> (--with-informix) always get the same error when i restart apache : >> 'ifx_module_entry' error. > >Did you define informix libs for PHP BEFORE making PHP, as suggested? Yes I did. > >> I suspect thi…

D4GL V3.0 java version

Shaun Campbell

Has anyone got an application to run using D4GL V3.0 java version. I seem to be having a problem with the lines in the cjac.cnf file whic are used to run the application. If I have two arg lines as in the example I get an error in my Web server log files. If I run the -c argum…

Re: checkpoints taking as much as 25 secs

Tam McLaughlin

Thanks for all your help everyone. I will not these suggestions and make necessary changes and hopefully will have time to monitor the engine and spend less time on other tasks (where have i heard this before haha). There seems to be a lot of help and info available in this grou…

CISAM Umask misbehavior

Chris Wood

We are just starting to use CISAM files with Acucobol and ICobol. It seems that when Informix creates a file, it is not letting the OS set the Umask to what it should be. Informix is setting it to some other value. This then causes problems later. Acucobol doesn't do this wit…

Re: checkpoints taking as much as 25 secs

Art S. Kagel

Great answers from Peter, Obnoxio, and Lloyd. Yes you are seeing a bufwaits ratio of around 40% which is horrific, we need to try to get that under 10% with a preference for a value under 7%. Take Lloyd's or Obnoxio's recommendations for LRUS and CLEANERS and the LRU_MIN/MAX_DI…

Re: SQL -

Alex Did you check out UNION? HTH Sujit "A. Bernaards" <Xpiet@bruynzeel.com> on 12/23/99 03:38:27 AM Please respond to "A. Bernaards" <Xpiet@bruynzeel.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: SQL - Hi All, I've got table 1 with 4 articles A, B, C…

UDRs in 7.3

hhac

I was wondering if it is possible to create a C UDR on the Infromix Server version 7.3 running on NT. I don't seem to see the DataBlade modules anywhere although I'm not sure if I need them. When I try to register the function I wrote with the server, the CREATE FUNCTION statem…

Re: Re-organisation of tablespace

Art S. Kagel

I'm going to have to leave a specific answer to the SQP gurus in the group. If maxnext does indeed correspond to the systables column nextsize then you are setting the table to grow by 10MB at a time which should not explain a 320MB increase in size after a reorg. I just do not …

Re: Informix SE on Linux

Lloyd AJ Wilson

Be sure as well that your client is added to the /etc/hosts.equiv file. I have had this problem with SHADOW password authentication off ... and still resulted in this error. Lloyd AJ Wilson. "Serafin Veloso" <serafin.veloso@gmx.net> wrote in message news:83r7rs$69b$1@newsread.…

Re: checkpoints taking as much as 25 secs

Lloyd AJ Wilson

Try modifying your LRU's to something like 63. Make your page cleaners equal to your LRU's value. I find I get considerable performance from my server set this way. As well, checkpoints on high end machines running hundreds of users using ~10GIG+ databases range from 1 -2 secs. …

Re: extent sizes

Paul Watson

Robert Taylor wrote: > > Attached is a PERL script I wrote to calculate extent sizes. Very basic I > know but I just did it to help me try to learn PERL. Hope it helps. > > BTW feel free to say if its a pile of cack ! > It's a pile of cack - hope that helps :-))) -- Paul Watson…

DataMart Developer w/ERP

Calian - Susan Ryan

As a publicly traded company, CALIAN Technology Services (TSE: CTY) has been providing technical and project management support since 1982. With annual revenues in excess of $80 million dollars and more then 1,200 dedicated employees, CALIAN provides diversified technology and pr…

Re: SQL -

Diego Morales

Try this, perhaps it works select * from A where ? = not in (select * from B) This will select the records of A not in B select * from B where ? = not in (select * from A) This will select the records of B not in A select * from A where ? in (select * from B) This will sel…

EXPLAIN ON !

Rok Vizintin

How can I get the directory where the informix.out is located ? (ie. c:\\Informix\\sqexpln) I want to get it in application? Is it in any system tables? Thynks Rok…

Re: Informix session connect time

a_blonde@mindless.com

---- you wrote: > In article <83r8ql$2vc$1@nnrp1.deja.com>, > dineshjoshi@my-deja.com wrote: > > Would any one help me in find the connect or start time of informix > > user sessions. > > database sysmaster; > > select s.sid sesssion_id, > s.username, > datetime(…

Re: extent sizes

From: "Robert Taylor" <robertt@scotlegal.com> > >BTW feel free to say if its a pile of cack ! Always happy to oblige... :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…

SQL -

A. Bernaards

Hi All, I've got table 1 with 4 articles A, B, C, D and i've got a second table 2 with articles B, D, E, F, and I want to create a third (temp)table 3 with the articles from table 1 & 2, from A throw F. How do I manage that? I've tried a lot with temp tables, joins and outer j…

4GL on Linux: Problems with floats "/*.81"

F. Fernandez

Hi all! We are porting several apps from SCO 4GL 4.X to Linux 4GL 7.20.UD7 and we're experiencing several problems with floats. When we read a float from the database, very often, when we put the values on reports, we get a value of ".81", sometimes precedeed by "/*". We have b…

Re: extent sizes

Robert Taylor

Attached is a PERL script I wrote to calculate extent sizes. Very basic I know but I just did it to help me try to learn PERL. Hope it helps. BTW feel free to say if its a pile of cack ! #!/usr/bin/perl -w ############################################################# # Calcula…

Re: Very urgent: I need your help. Please, answer me quickly.

From: "Diego Morales"<dmorales@giro.es> > I need your help again. > > I need to restore one table of my Informix Database. > Is it possible to restore a table form my db without restore all the > database??? If it is possible, how I can do it??? > > Details of my system: HP…

Very urgent: I need your help. Please, answer me quickly.

Diego Morales

I need your help again. I need to restore one table of my Informix Database. Is it possible to restore a table form my db without restore all the database??? If it is possible, how I can do it??? Details of my system: HP UX 10.20, Informix 7.31 UC2A. Please, ask me at dm…

Re: checkpoints taking as much as 25 secs

Evelio =?iso-8859-1?Q?Mart=EDnez?=

From: "Tam McLaughlin" <tamm@scotlegal.com> > >LRUS 8 Try more LRUS, something like 50. >LRU_MAX_DIRTY 20 >LRU_MIN_DIRTY 15 Try dropping these to 2 and 1, respectively. HTH. ______________________________________________________ Get Your Private, Free Email at…

runtime does not log the program name that produces the error?

Hello! Since I migrate some apps from Informix 4 to INFORMIX-4GL Version 7.20.UD7, there are some errors that does not log in the error file. Is there any bug or reason for this? Exception Date: 23/12/1999 Time: 11:21:24 FORMS statement error number -1260. It is …

Re: checkpoints taking as much as 25 secs

Peter Dzvonyar

Hi Tam, try to increase CLEANERS in ONCONFIG (6 -> 10), and decrease LRU_MAX_DIRTY and LRU_MIN_DIRTY, and also the range of them. Example: LRU_MAX_DIRTY 10 LRU_MIN_DIRTY 8 But I think if you have the most checkpoints under 10 seconds it is OK. R…

checkpoints taking as much as 25 secs

Tam McLaughlin

The online log file shows that some checkpoints can take from 4 secs up to 25 secs but the average is prob 0 secs roughly every 5 mins. The long checkpoint times prob occur when some large progs are running e.g. cron jobs. I have not been on an IDS7 admin course yet so not too su…

RE: Y2K problem on Standard Engine

Goldsbrough, David

I am using SE 7.20 UD4 with DBCENTURY set to "C" In the name of research only - make sure all your "0" are in fact zeros and not the character "O" !!!!! I know it is a wild shot but you never know........ Strange but true......... select....... where date_field = "2902O0" …

Re: oninit execution failure!!! Help ~~~ME ASAP.

Paul Watson

Not having a Korean character set or being able to read Korean doesn't help but if KAIO has been disabled it can be turned on within Smit Brian.Foster@iiug.org wrote: > > If I understand this right, what you may be running into is > that KAIO isn't on at the OS level... > > I wi…

Re: Informix ODBC driver - extremely limited

Serguei I. Ivantsov

Hi there ! > > Does Informix have their own driver, or is Intersolve the only one > available? > Is there any other options for me. > There are a great number of companies, which have thier own ODBC drivers for Informix (and other databases). I can advise you OpenLink drivers htt…

Re: Informix ODBC driver - extremely limited

Reinhard Habichtsberg

David Fishburn <spamoff_dfishburn@home.com> schrieb in im Newsbeitrag: 83ru3o$at7$1@newswest.sybase.com... [...] > Does Informix have their own driver, or is Intersolve the only one > available? > Is there any other options for me. > AFAIK the Intersolv driver will not longer be…

Informix ODBC driver - extremely limited

David Fishburn

I have been trying to use the ODBC driver that came with my 7.3 NT Informix. The driver version is: INTERSOLV 3.11 32-BIT INFORMIX 9 3.11.00.07 There must be a newer version, since this one is essentially useless. It does not support transactions (ie insert, insert, insert, c…

Re: CASE TOOL

Van Messner

ERwin is good but it runs around $3500. It works with many databases, but overall has fewer capabilities than Designer. Van Kevin Moriarty <schmerd@primenet.com> wrote in message news:83rga3$gup$1@nnrp03.primenet.com... > I've been using oracle for ~3 months. > > What are proc…

Re: Informix session connect time

Vardan Aroustamian

In article <83r8ql$2vc$1@nnrp1.deja.com>, dineshjoshi@my-deja.com wrote: > Would any one help me in find the connect or start time of informix > user sessions. > database sysmaster; select s.sid sesssion_id, s.username, datetime( 1970-01-01 00:00:00 ) year to se…

extent sizes

James

Does someone have a methodology for calculating extent sizes?…

RE: Exception MT_EX_OS ??

Wang Jean

We had same issue after we upgrade Informix from 723uc3 to 731uc3 in Sun solaris 2.5.1. We got the similar error when we were doing daily export which may be related with BUG 113804. And we also get the error everytime while we were runing some update-select statement. Based on I…

Informix session connect time

dineshjoshi@my-deja.com

Would any one help me in find the connect or start time of informix user sessions. Any help will be appreciated. Sent via Deja.com http://www.deja.com/ Before you buy.…

2 new Informix books

Judy Bowman

Informix Press (an Informix-Prentice Hall joint operation) has just put out two new books: 1. SAP R/3 for the Informix DBA, Sari Nathans 12/1999 by Prentice Hall PTR (ECS Professional) Paper, 350 pages ISBN 0-13-022554-1 $49.99 list price 2. Dynamic Web Programming:…

oninit execution failure!!! Help ~~~ME ASAP.

Park Soon Sung

I'm programming on AIX 4.3.3 with Informix Dynamic Server I installed jdk1.2.2 for AIX and compiled and run my application which connects to informix database. because my application uses the port that snmpd use, I killed snmp daemon and rebooted AIX, after rebooting oninit com…

Re: Dealing with Informix 3

Michael Krzepkowski

Hi! Use: informer databasename to access the data manipulation tool. You can type help to see all commands. The one you are looking for is: unload ascii tablename to "filename"; This will create a Unix file which is compatible with the SQL load. Table schema can also be retrie…

Link to Y2K weekend alternate Tech supp. phone #'s

Colin McGrath

FYI, For those utilizing Informix technical support: Informix has recently posted to TechInfo Center an updated chart with all alternate technical support phone numbers for the Y2K weekend. The following link will take you directly to the numbers: <http://www.informix.com/i…

CASE TOOL

Richard Cuello

Anyone know of a modestly priced case tool to help me design processes of a database?…

JDBC timestamp escape syntax

Matthias Ernst

Both Informix JDBC drivers I have (1.40, 2.00), have a bug in the timestamp escape syntax handling. A query select * from resources where creationDate = {ts '1999-12-12 12:00:00.00'} results in the following error SQLError: -217 Column (1999-12-12 12:00:00.00) not found i…

Re: NULL Values