Drop indexes that are attached and recreate them detached. as a temp solution (if you have attached indexes) You may check with oncheck -pt...

Model-Bosch, Tilman

01-05-2006 12:45 PM
mark.scranton@gmail.com

On 4 Jan 2006 07:36:21 -0800, carsten (AT) uniqsys (DOT) com <carsten (AT) uniqsys (DOT) com> wrote: No, No, No, No, No, NO, **NO** !!!! Do not...

Jonathan Leffler

01-05-2006 05:20 AM
scottishpoet

Hi, We have a Central Server with 10 Local Servers. S.O. RedHat Linux SE 3 Update 4 IDS 7.31.UD1 The problem is some users connect to Central...

Cesar Cruz

01-04-2006 04:00 PM
Cesar Cruz

hello allo, Am using informix on Unix system and I get now this error: Program stopped at "cpt001.4gl" line number 0. Sql statment error number -329...

maca

01-04-2006 02:34 PM
Mike Badar

Michael Segel wrote: Too bad humility, civility, and gratitude are not related technologies. -- Daniel A....

Bill Dare

01-04-2006 12:48 PM
Obnoxio The Clown

Hello all Working on IDS 9.30, I need to retrieve the identifier (say: SERIAL-typed ID as primary key) of the latest row immediately after having...

Salvo Giubili

01-04-2006 03:43 AM
Surfer!

I need to get access to older versions of the CSDK that will run on SCO OpenServer. I need a version of the CSDK that will work with SE 5.1...

Stewart Bourke

01-04-2006 01:42 AM
Jonathan Leffler

My understanding is,that Informix is now an OLTP engine. I don't think they sell a significant number of XPS licences anymore. So if they opensource...

Jürgen Buck

01-03-2006 09:01 PM
Christine Normile

http://blogs.sun.com/roller/page/webmink?entry=announcing_java_db Apache Derbywith be included in future releases of the Solaris Enterprise...

david@smooth1.co.uk

01-03-2006 07:56 PM
david@smooth1.co.uk

hello all; am using informix on unix; how can I add a new user B that can use the same database/tables-information of an existing user A, thanks a...

maca

01-03-2006 07:48 PM
Art S. Kagel

Hi Forum, I got a somewhat strange issue. I was running a level -0 archive with ontape and after 10% completion, the Informix instance crashed with...

sputnik

01-03-2006 05:25 PM
sputnik

Two days late and in need of (minor) updates. I wish you a Happy (nearly) New Year. Eleven FAQ's About comp.databases.informix and informix-list...

Jonathan Leffler

01-03-2006 02:08 PM
Jonathan Leffler

Hi guys, is there any way to obtain ip address (not a symbolic name) directly from server ? onstat -g ntt returns symbolic name, onstat -g dmp...

smitin@gmail.com

01-03-2006 12:39 PM
Doug Lawry

So that explains why my IDS-List has suddenly changed into Informix in the Garden: Performance Tuning Your Petunias. -----Original...

Everett Mills

01-03-2006 10:53 AM
Everett Mills

Hello friends, We are going to use a connection pool DataSource on the Websphere application server. DataSource uses standard JDBC properties to...

Rivka Shisman

01-03-2006 02:26 AM
Rivka Shisman

Hello, Question: My application is a simple application that connects to the Informix instance, validates that some preconditions are fulfilled and...

Thor Kristensen

01-02-2006 03:38 PM
david@smooth1.co.uk

I have a query regarding I4GL Compiler licenses. What is the difference between development and runtime (concurrent users) licenses? That is, when...

Mrinal Kant

01-02-2006 06:00 AM
Obnoxio The Clown

hi everyone, I have informix installed on Unix machine, and i get access to my database trough Unix-shell, last time when i want to access to some...

maca

01-02-2006 05:16 AM
Martin Fuerderer

IDS 1.FC4 HP-UX 11.11 When I try to start ipload, I get the following error. Bus error. coredump. ipload works on my other servers (IDS 9.21)...

Laurie Gustin

01-01-2006 01:40 PM
Andreas Legner

Hi, does anyone has an idea about this program : 4G systeme Ver 5. it is installesd on UNIX system to access Database 'dbaccess' when i want to...

maca

01-01-2006 12:46 AM
Jonathan Leffler

I want to do an imported restore to a system that has had ISM on it in the past. Even when I do ism_startup -init I find that all devices, policies...

mweallans@panacea.co.uk

12-31-2005 01:25 PM
Milton J. Vidrine, Jr.

The ads were hilarious. We all enjoyed them.

Jean Georges Perrin

12-31-2005 09:44 AM
Jean Georges Perrin

saludos a la lista: Cuantas instancias INFORMIX puedo crear en un mismo servidor ???. IBM Informix tienen algun limite de instancias a crear en un...

Juan Pablo

12-30-2005 06:47 AM
mweallans@panacea.co.uk

HPUX machines, Informix 9.4 We have a primary database server, srvA, and a server we want to use HDR to back the database up to, srvB. Both...

MMarks

12-29-2005 11:21 PM
MMarks

Folks, I have posted all the presentations from Forum 2005 and some of the pictures on our web...

Lester Knutsen

12-29-2005 04:51 PM
Lester Knutsen

Hi All, We are using Informix 9.3 and SP needs to get data from other application through MQ Series - Synchronous mode of transfer . Please let me...

Deenadhayalan Subramani

12-29-2005 09:39 AM
scottishpoet

Has anyone done an imported restore using onbar and ISM? Apparently you can a) use onbar/Ism on one host to backup to disk b) restore onto another...

david@smooth1.co.uk

12-29-2005 05:23 AM
Andreas Breitfeld

Well I have seen the release notes for IDS 10.00.UC4 but it is still not on the trail download site... why the delay? It's very nice of IBM to make...

david@smooth1.co.uk

12-29-2005 05:21 AM
scottishpoet

Thanks every one for providing untiring assistance & contribution to this group through out the year. Wish you all a Merry Christmas and Happy New...

hariog@yahoo.com

12-28-2005 11:22 PM
John Carlson

Why do you want Online 5.x to be opensourced ? Just to save your own licence costs ? or to grow marketshare ?

Adam Tauno Williams

12-28-2005 06:16 PM
Jean Sagi

Hi, all. Actually, I am working with Sybase AS IQ 12.6, but hope that your SQL experience would be helpful Situation - I have several tables,...

gucis

12-28-2005 10:44 AM
Jonathan Leffler

Jorge Silva said: SELECT EXTEND(datetime_column, HOUR TO HOUR) FROM table WHERE ... SELECT EXTEND(datetime_column, MINUTE TO MINUTE) FROM table...

Jorge

12-27-2005 11:59 PM
Serge Rielau

We have had IDS 9.4 UC3 installed for over a year with no problems. except now Our live database errored yesterday and the client program thats...

coleas@gmail.com

12-27-2005 05:44 PM
Andreas Legner

Hello, We are looking for a senior level Informix DBA for a full time position in the Orlando, FL area, salary is negotiable based on skill, moving...

Bronson Tubb

12-27-2005 04:14 PM
Bronson Tubb

Wow, thanks for enlightening me. That is pretty awful what happened to those women. Thanks for looking into that. But take a look at the history to...

CKGeier@nwc.edu

12-27-2005 09:33 AM
Obnoxio The Clown

I am glad to present to the community of this group the new version of our component intended for visual building of SQL queries via an intuitive...

sales@activedbsoft.com

12-27-2005 06:50 AM
sales@activedbsoft.com

I am getting following error while performing 0 level backup using ontape command. "Archive failed - function write to tape failed code -1 errno...

Vijay

12-24-2005 05:37 AM
Claus Samuelsen

Hello All, IDS version 9.40FC6. Does anyone know of a function that will return the position of the first occurrence of a value within a...

Ekstrand, Pam

12-23-2005 08:58 AM
Scott O'Rourke

http://www.ibm.com/software/data/informix/ids/ on the right hand side " We're here to help Easy ways to get the answers you need. Call me (link)

david@smooth1.co.uk

12-23-2005 06:18 AM
scottishpoet

The DB is IDS 7.31.UC6. I was looking at the online.log this morning and discovered these lines: 22:10:10 Level 0 Archive started on rootdbs,...

HarryH

12-22-2005 08:00 PM

Folks, Just an FYI, we will be moving the IIUG server to new hardware donated by Sun. The move will happen tomorrow, 12/22/2005 at noon EST. The...

Lester Knutsen

12-22-2005 05:53 PM
Lester Knutsen

The JBossAS tries to execute this query and gets a syntax error: SELECT MAX(TXID) FROM ( SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT...

Frank Langelage

12-22-2005 01:52 PM
Obnoxio The Clown

A request for the list. Change table owner without dropping/recreating table - 12/22/2005 Andrew Ford sending to informix-list

Ford, Andrew G

12-22-2005 11:45 AM
Ford, Andrew G

I have just received a brochure from IBM partnerworld with At A Glance , Enablement and Certification Opportunities for Software Business Partners...

mweallans@panacea.co.uk

12-22-2005 11:20 AM
scottishpoet

Greetings All, This is just a followup to let the Peoplesoft/Informix community in on why I'm searching for current customers. I have recently...

Darren_Jacobs@carmax.com

12-22-2005 10:02 AM
Darren_Jacobs@carmax.com

Guys, This had been question of discussion in the iiug forum in many occasions or for years. Correct me if I am wrong, I can recall one saying that...

jpierrot@chubb.com

12-21-2005 05:13 PM
Art S. Kagel

Greetings, If you are a Peoplesoft customer running on informix please send me an email. I would like to get an idea of what version of informix...

Darren_Jacobs@carmax.com

12-21-2005 01:57 PM
Darren_Jacobs@carmax.com

Any thoughts on this folks - Will appreciate it. Setting "Set Optimization Low" for stored procedures is one of the suggested workaround. Have not...

jpierrot@chubb.com

12-21-2005 01:27 PM
jpierrot@chubb.com

Morning all I have a problem with the following script which is designed to run a database export (dbexport) after cancelling all currently...

gary.cobden@nhs.net

12-21-2005 10:58 AM
Bill Dare

Hi all, I want acquire password from Informix Connect. In registry HKEY_CURENT_USER\Software\Informix\netrc I have password, but hashed...

Elvis

12-21-2005 07:31 AM
Sheshnarayan Agrawal