Hi everybody, I want to make a spare db server installation, for disaster recovery purposes, and I'm looking for advices. Our present setup is a...

Pawel Paron

05-22-2006 06:45 PM
Art S. Kagel

Art S. Kagel wrote: Or you use datetimes and intervals in SQSL, eg LET start_time=CURRENT; <your sql here>; DISPLAY CURRENT-start_time; LET...

Dave Thacker

05-22-2006 03:43 PM
rick

just running an input screen and doing some updating... got following error msg: rshd: 0826-813 Permission is denied Any help/suggestion is greatly...

Frank

05-22-2006 03:29 PM
Frank

Just got the latest copy of DB2 Magazine today, and I found that Stuart Litel has once again revised the history of Informix. (I say once again...

DaveK

05-22-2006 09:39 AM
Gentsch, Sam

Can someone tell me if it is easily possible to do the following with the unload command: 1. Put double quotes around every field in the file. 2....

AT

05-22-2006 09:33 AM
Marco Greco

hi, please help me how to leave onstat -i mode? thanks

Maumas

05-22-2006 09:29 AM
Obnoxio The Clown

online log out put Sat May 20 17:01:32 2006 17:01:32 Event alarms enabled. ALARMPROG = '/u/informix/etc/log_full.sh' 17:01:37 DR: DRAUTO is 0...

AT

05-22-2006 08:27 AM
scottishpoet

Hi there, I have query for replication in IDS workgroup edition, I would like to know what is the procedure for implementing online replication in...

faisal_qadri

05-22-2006 06:56 AM
scottishpoet

Paul Fox said: All platforms? What about IMS, RedBrick Warehouse, UniVerse, UniData, Derby ...? -- Bye now, Obnoxio Information within this post...

Obnoxio The Clown

05-22-2006 05:59 AM
Obnoxio The Clown

I am trying to restore my backup done with ontape -s and I am getting this error. What could be the problem. I can bring informix online but can not...

AT

05-22-2006 03:19 AM
Superboer

Hi, we have Syteline ERP 6 on a unix database server. Users are printing quotations from Impromptu 6. Database is Progress. Since 16 May 06, users...

coffeekopi

05-21-2006 04:01 PM
Obnoxio The Clown

The heading says it all! I need to connect to a datasource from an esqlc program running on a Linux box. The dataSOURCE is on the same box. Thanks...

kjuliff (AT) gmail (DOT) com

05-21-2006 07:39 AM
Richard Spitz

IDS 7.31 .UC5 and HP UX 11.11 . Do these work together. What do I need to do to make them work together I have IDS 7.31 UC5 running on 11.0

AT

05-20-2006 04:15 PM
Neil Truby

Hi, We have Syteline ERP (Progress db on unix) and running quotations from Impromptu 6. Since 16 May 06, users complain that they are unable to...

coffeekopi

05-20-2006 12:41 AM
Jonathan Leffler

I am using EasySoft's odbc driver on a Linux box. I can successfully connect to the datasource which access legacy C-ISAM files. But I want to...

kjuliff (AT) gmail (DOT) com

05-19-2006 08:19 PM
kjuliff (AT) gmail (DOT) com

If we create an index on a field that is mostly containing null values ( 90% nulls ), will the index still use the same amount of space whether the...

Floyd Wellershaus

05-19-2006 03:19 PM
bozon

<Also posted to IIUG Forum> OH I CAN'T RESIST! Informix mirroring OVER RAID5? Do you have a death wish? NO RAID5!!! NO RAID5!!! NO RAID5!!! NO...

ART KAGEL, BLOOMBERG/ 731 LEXIN

05-19-2006 12:43 PM
ART KAGEL, BLOOMBERG/ 731 LEXIN

With just dbaccess running on a linux box, and with a datasource to another Informix database, can I load tables into my IDS database, and if so, how?

kjuliff (AT) gmail (DOT) com

05-19-2006 12:32 PM
Obnoxio The Clown

We have an Informix 7.31.UD6 database running on HPUX 11.11i. For various reasons, the parituclar machine that this database runs on has had quit a...

Salch, Chris

05-19-2006 12:14 PM
scottishpoet

david (AT) smooth1 (DOT) co.uk wrote: I disagree. LTXHWM and LTXEHWM should be set, so that any transaction that might be executed by you...

Model-Bosch, Tilman

05-19-2006 03:53 AM
Model-Bosch, Tilman

Hi Family. I have just uploaded a miniscule upgrade of a tried-and-true script I wrote sooo long ago: beautify-unl.sh. Most of my other...

Jacob

05-19-2006 12:12 AM
Jacob

When the DB2 DBAs who have encountered no bugs ask why Informix is so unreliable what do I say? Hmmmm. Tell them that they are not using the...

AT

05-18-2006 10:45 PM
David Williams

I have some VB programs running on Win98 that connect to a SCO 5.0.5 server running Informix SE 7.23.UC13. I'm using Informix connect version...

Howard Darcy

05-18-2006 04:53 PM
Howard Darcy

We are planning an upgrade to Informix 9.4 from 7.31 on HP-UX 11.11. Our client side is running the latest driver (3.82 32bit), but some of our...

donsem

05-18-2006 03:19 PM
donsem

I ran a query on sysdistrib to see when update statistics had been run and the constructed column was blank for a number of tables even though I...

Colin Dawson

05-18-2006 12:52 PM
AT

Hi, we have HW problem on our old archive server with SCO and Informix Online 5. We have backup on tape ( in ontape format ). We also have Informix...

URBAN Leos

05-18-2006 05:41 AM
scottishpoet

Hi, I have a problem with IDS 10.0 running on HP-UX 11.23, I'm trying to change the lock mode, i've seen the sintaxis about the alter command to...

rachisa

05-18-2006 02:53 AM
Nog

I'm tring to do some mass insertion, so i'm using data binding, now the question is that i have (for the moment) a some field that will get the same...

goliathuy

05-18-2006 12:46 AM
Jonathan Leffler

I am using HPUX 11.11 for Informix 7.31 when I run oninit -i I get this on the log. The database does not initialize. My file settings are as...

AT

05-17-2006 12:57 PM
AT

Hi everybody, I want to make a spare db server installation, for disaster recovery purposes, and I'm looking for advices. Our present setup is a...

Pawel Paron

05-17-2006 08:24 AM
Pawel Paron

Trying to get data from sysmaster (dbtest1) and store them in a database on a second server (dbtest2) I created a query: Script runs on...

Habichtsberg, Reinhard

05-17-2006 06:05 AM
Habichtsberg, Reinhard

This is not new but was discussed in Tampa and I was asked to mail over to people, but having put their email into a DB2 system I find I'm no longer...

Paul Watson

05-17-2006 03:31 AM
Richard Harnden

I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the...

AT

05-17-2006 02:35 AM
AT

Do you mix several instances like I tried to do. There is no problem if I access only one instance.

Habichtsberg, Reinhard

05-17-2006 01:31 AM
SaltTan

hello all, how does one "install" Blade Manager? HP-UX 11i IDS v10 we have a developer who wants to use the datablade API to generate auditing...

tomcaml (AT) yahoo (DOT) com

05-16-2006 08:42 PM
tomcaml (AT) yahoo (DOT) com

can anyone please point me to where I can find what the available options are for ESQL / COBOL precompile (ECFLAGS)? We only use '-e' and are...

BigBob

05-16-2006 06:43 PM
Reece

Hi, How to get information on all primary keys, unique keys, indexes? Please advise. Regards Jignesh

Myjish

05-16-2006 01:43 PM
Mike Badar

I can't beleve it ! We have a table in the database and the tabel hase 199 extents. Ok - we can enlarge the next extent size - but this is not...

Matthias

05-16-2006 01:26 PM
Michael Schmid

Does anyone have a feeling for how well, or otherwise, IDS 10 for Linux will work on AMD/Opteron rather than Intel processors? thanks -- Neil Truby ...

Neil Truby

05-16-2006 04:38 AM
Obnoxio The Clown

I know we've all seen the comments on marketing for Informix as opposed to DB2 and the respective audiences for IBM products as opposed to SQL...

malcolm weallans

05-16-2006 12:24 AM
Double Echo

I need to install informix IDS 7.31 from a cd. I have mounted the cd on /cdrom I have tried to use cpio as started in the manual but i am getting...

AT

05-15-2006 01:15 PM
Machaya Chivaviro

Hi All Hope someone can help me with this little pain. I am creating a output flat file for a 3rd party company. The file is fix length...

Franz Grutzmacher

05-15-2006 01:06 PM
Art S. Kagel

Hi, I want to execute query for that i require end date of the month, suppose if the month is April then it should return 30 if March then in...

Prateek Jain

05-15-2006 12:58 PM
Art S. Kagel

Back in 1998 Art S Kagel wrote a remarkable article, "Tuning Informix Dynamic Server and Your System for Optimum Performance" I was wondering if...

alkyr

05-15-2006 12:52 PM
Art S. Kagel

Hi all, I know its repeated question....Can you please send me the script "to delete duplicate data from Fragmented table". Rowid cannot be used...

Prashant Shirude

05-15-2006 12:12 PM
Prashant Shirude

Does anyone have IDS 10 running on Solaris 10 and, if so, is NOAGE OK? My new instance is coming up with this error: Wed May 10 12:54:08...

Neil Truby

05-15-2006 11:57 AM
Neil Truby

Hello, I am trying to find out the procedure for preventing updates on an Informix database by changing it to read-only. Is there a stored procedure...

Howard Jones

05-15-2006 11:50 AM
plumas4u via DBMonster.com

I'd like to move my Infomix 7.25 SE database to a new location, so I tried to export it with dbexport, but I get this error: create table...

Carson Douglas

05-14-2006 12:23 PM
rick

Hi, Can anyone tell me why I get the different exit status for the following script execution while calling the informix program (/proj/prog.exe)...

yy4 via DBMonster.com

05-12-2006 08:44 PM
Jonathan Leffler

Can anyone tell me why I am getting the following error? /usr/bin/ld: skipping...

kjuliff (AT) gmail (DOT) com

05-12-2006 08:02 PM
Jonathan Leffler