Database Forum - Informix Topics

Thread preview

Thread	Last Post	Replies

indexing	31 Aug 2004 17:20 GMT	5
a few indexing questions: If the columns I filter on in my query are a subset of the columns in an index, will the index be used? Also -- does the order in which the columns are specified in my filter
Functions messing up with the optimizer calc	31 Aug 2004 17:05 GMT	1
Do functions like trim,upper,lower,etc.. on sqls instructions mess up with the optimizer cost calculations or best path definition? I'm having a serious performance problem in my production environment, and I think the problem is:
DBI connect timeout question	31 Aug 2004 06:34 GMT	2
I'm using DBI to write a monitoring program for our informix servers. Problem I am running into is that if the database server (to which I am always connecting via a tcp connection) is down completely, the connect() takes a very long time before it returns.
IDS V7.30 and Windows 2000	31 Aug 2004 03:38 GMT	3
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin
creating runner in fourj's	30 Aug 2004 18:15 GMT	1
Dear Sir/madam I have installed the windows (xp) versipn of 4j's universal compiler. I have followed the indtructions and when l try to create a runner, using fglrun -d ifx940 i get the error message "could not link runner"
Re: Why there is no controlfile in Informix like Oracle ? Also	30 Aug 2004 11:56 GMT	6
Andrew Hamm said: > Neil Truby wrote: >> >> Don't tar us all with the brush of your own ignorance, Andrew :-)
RE: Also now: raw devices on Sun	30 Aug 2004 11:03 GMT	2
Neil Truby wrote > (*) We are setting up two new Sun StoreEdge arrays for a new > Informix installation. These devices come pre-configured as > RAID-5. Obviously we love and fear Art so much that we
Question about replication	30 Aug 2004 07:39 GMT	7
I'm trying to set up a replication environment with 2 informix server. According to the example procedures on the document, I issued the following commands(of cource,I've done with sqlhosts & ONCONFIG file): 1. cdr define server --init group_source
Converting character column to upper case	28 Aug 2004 16:34 GMT	5
I have an easy question (hopefully). Is there a function in SQL to convert all characters of a column to uppercase? I know in 4GL you can use upshift.
Select for update in SPL	28 Aug 2004 10:46 GMT	8
I am trying to put a promotable lock on a table row inside a stored procedure and for some reason SPL does not allow me to use SELECT FOR UPDATE ... Any suggestions? (Informix 7.31)
Imported restore using ISM	28 Aug 2004 09:42 GMT	6
For reasons that are still not exactly clear to me I have been asked to migrate a complete IDS system from one IDS 9.40 server to another. I think it has something to do with a SAGE support statement that
Passport Advantage query	28 Aug 2004 02:23 GMT	9
Can anyone explain to me the connection, if any, between the list of contacts that have to be submitted to IBM for the setting up of a new PA agreement, and the list of people who are allowed to call IBM Informix Tech Support.
Slow network connection	27 Aug 2004 22:32 GMT	3
I'm running Informix Online V7.3 on Windows NT4 (sp3). In the beginning all worked fine, but after about 1 year I observed an extended delay when I connect to the server (via the native Informix driver that come with PowerBuilder 5) over the network from any
Can the 32 bit version of Informix 9.4 (9.40.UC3) use chunks over 2 gig, and if so, any recommendations?	27 Aug 2004 22:15 GMT	1
My group is preparing to move our Informix 9.40.UC3 instances running under Solaris 2.6 to newer, more powerful Sun servers running under Solaris 2.8. We currently (using Veritas volume manager) have or chunks defined as 2 gig on one server from which we plan to migrate and 1 ...
ODBC connection forces engine to hang	27 Aug 2004 19:53 GMT	1
HELP HELP HELP ... Installed RHL 8.0, CSDK 2.81 UC3, IDS 9.40 UC3, 4js (3.50.1a) on a DELL Xeon server. dbimport, dbaccess etc. looks ok. Ran onchecks. No problem at all.