If I want to use HPL for migrating from 7.2x to 9.3x which format I must use for uloading / loading data? Is there anything else I have to be aware...

Nebojsa Sevo

09-18-2003 01:54 PM
Richard Kofler

I'm doing a restore using ontape -r. onstat - gives the following output onstat - *** WARNING: Informix Dynamic Server 2000 is no longer running....

Jack A

09-18-2003 12:14 PM
Fernando Nunes

Saludos: Cuando creo una nueva BD en mi instancia, por defecto el estado de mi estado de mi sistema es NO LOGGING. Sabemos que IDS tiene tres...

in4mix peru

09-18-2003 12:05 PM
GDES Tapia La Torre Pedro

I don't think that this message is fatal since the error code indicates the situation is temporary. ----- Original Message ----- From: "jorge...

Mark Denham

09-18-2003 12:04 PM
Mark Denham

Hi ! Little annoying problem :) Here it is. When i try to run a cursor in poerbuilder, i get a -1 error and a SQLDBCODE = 2 If i keep the same...

hobbes

09-18-2003 10:49 AM
hobbes

Hello All, I have a clarification regarding the database restore. We are planning for a h/w upgrade for our SAP R/3 database server running on IDS...

Rajasekaran, Rajesh

09-18-2003 08:23 AM
Phil Rule

Just wait until it springs a leak....then it will get interesting. ----- Original Message ----- From: "Andrew Hamm" <ahamm (AT) mail (DOT) com> To:...

Mark Denham

09-18-2003 08:05 AM
Mark Denham

Don't go updating systables. This is not the correct approach. Alter table <tabname> lock mode row; Mark ----- Original Message ----- From:...

Mark Denham

09-18-2003 08:02 AM
Mark Denham

Hi This hint given in online.log 17:02:53 Results: Possible inconsistencies in index 'baandb:"".#' 17:02:53 Action: Run 'oncheck -cI...

hiten.bhawsar

09-17-2003 10:42 PM
hiten.bhawsar

Hi, group today i found another problem about my informix. The ROOTPATH pointed to /dev/dbroot instead of /dev/rdbroot. in the manul, however, i...

steven

09-17-2003 09:01 PM
Andrew Hamm

Dirk Moolman wrote: HTML post. 164 lines for something that is even more off-topic than I usually am. Nice one. -- "C'est pas parce qu'on n'a...

Obnoxio The Clown

09-17-2003 08:58 PM
Andrew Hamm

Well, OK, it took the special breed of programmer we have here to find them and any fool should have known not to use these words in...

Malc P

09-17-2003 08:52 PM
Andrew Hamm

Hi, Any pointers to a Nagios plugin for Informix? (IDS 9.30.FC5, SunOS 5.9) Thank you, -- Tielman de Villiers

Tielman de Villiers

09-17-2003 06:41 PM
Obnoxio The Clown

IDS 7.31 FD3 Solaris 8 I know this statement is a bit vague, but if I have the choice to use Enterprise Replication or not, should I go for it ? ...

Dirk Moolman

09-17-2003 05:22 PM
Dave Thacker

Quoting from page 17-10 of the IBM Informix Dynamic Server Administrator's Guide (IDS 9.4 on Solaris 8) -- "A data page is read from either the...

Rajesh Kapur

09-17-2003 04:57 PM
Rajesh Kapur

Hi, I get an error 1069 logon failure when starting the informix 7.30.TC7 service on Windows NT4 SP4. I have a user "informix" which is assigned to...

ofero

09-17-2003 04:12 PM
Murray Wood \(IList\)

Dear All, I have got the subjected error in my online.log file. Please let me know why this error has occured, how serious it is? what should I do...

Kalgaonkar, Ruturaj S.

09-17-2003 03:16 PM
Kalgaonkar, Ruturaj S.

Three guys in a hotel call room service and order two large pizzas. The delivery boy brings them up with a bill for exactly $30.00. Each guy gives...

Dirk Moolman

09-17-2003 02:49 PM
Art S. Kagel

hi, Is there any command or query that returns the table structure informix.

fxthomas

09-17-2003 11:11 AM
Obnoxio The Clown

Hi All We are running production box with informix 9.21 on solaris, the present database has installed with DATABLADES (ETX,LLD adn TXT) but we are...

KalpanaPai

09-17-2003 10:54 AM
vivek.chaudhary@st.com

"Gorazd Hribar Rajteriè" <gorazd.hribar (AT) telekom (DOT) si> wrote Well, on any platform. "Fixed" in IDS 9.40. A few other things to bear in...

Rüdiger Mähl

09-17-2003 10:06 AM
Neil Truby

KalpanaPai wrote: My guess is that the tables have got too many extents, but they're probably in their own dbspace, so they're increasing...

Obnoxio The Clown

09-17-2003 09:46 AM
malcolm.iiug

Hi, I have an application running on Tomcat on Windows 2000 and the database is Informix running on a HP-UX box. Once in a while i get this...

shivas

09-17-2003 05:11 AM
Simmons, Keith

Hi Alan, we seem to suffer from the same problem. Did you get a solution for this? cheers

knikkink

09-17-2003 04:10 AM
knikkink

Hello. I´ve been trying to find some information about changes in the way IDS 9.40 handles LRU Queues. It seems that there is a new algorithm...

rdtbra

09-17-2003 03:19 AM
David Brent

Can someone provide me the output of the onstat -d command for a 32 bit version of 9.4? Thanks in advance.

dcgigem

09-16-2003 03:59 PM
Langelage, Frank

about 60,000 rows in all, but only about 1000 rows are involved when the procedure is run. The procedure runs fine for 3 months worth of data...

Mark Denham

09-16-2003 08:00 AM
Mark Denham

If you're using IDS 7.3x there is some very useful documentation available at my...

Scott Burns

09-15-2003 06:44 PM
Obnoxio The Clown

See the suggestions below ... Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: ...

Rajib Sarkar

09-15-2003 05:33 PM
Mark D. Stock

A co-worker is trying to get the following SPL procedure to work and gets error 674 when he runs it. What he wants to do is have a generic stored...

John David Adamski

09-15-2003 12:06 PM
Paul Watson

some of my jobs are very faster with OPTCOMPIND at 0 and others are faster with OPTCOMPIND at 2. is it possible to dynamically change this value ???

bil

09-15-2003 10:58 AM
Abhishek Mathur

Leonid Vorontsov wrote: Have you done what the error description suggests? Mind you, if I was a query optimiser, I think one look at your SQL, and...

Mark D. Stock

09-15-2003 09:55 AM
Rajib Sarkar

Hi Could naybody clarify me , which is the best datatype to use VARCHAR or LVARCHAR? I need to store data like Comments could be less than 255 or >...

KalpanaPai

09-15-2003 09:53 AM
Rajib Sarkar

You cannot turn off logging for a single table, unless you convert it to raw. Raw tables cannot have indexes. You can make the process more...

Mark Denham

09-15-2003 07:42 AM
Mark Denham

Having not used 4gl to C for a while something is doing my head in, IDS 9.30, 4gl 7.30.UC3 on Solaris 7 Why doesn't this not work, it cores on the...

Paul Watson

09-15-2003 06:55 AM
Paul Watson

Hi, i am working with ER replication. I have 2 computers : A 4 CPU RM400 (siemens) with sinix OS (or reliant unix) and a 7.31UD2 database server. A...

Jean-Francois BOUDRY

09-15-2003 04:53 AM
Jean-Francois BOUDRY

Andrew Hamm wrote: Finally, someone with some sense. It's all very well being able to go fast round a corner, but where is the thrill if you're not...

Jack A

09-15-2003 01:09 AM
Obnoxio The Clown

Hallo specialists! I am running a 4ge-application since years. The database-tables are situated in some different databases (DATABASE arzt, DATABASE...

Philipp Walderdorff

09-13-2003 02:47 PM
Philipp Walderdorff

Hi : I want to convert a char column to a num type; I don't known which internal function can be used! Sample : select to_num( char_column_name )...

Killwind

09-13-2003 04:14 AM
Paul Watson

ok, I run some onstat and get the following: --------------------------- cut ---------------------------------------------- $ onstat...

steven

09-13-2003 04:03 AM
steven

I would like to know if the following scenario will work (or whether it's feasible): 1) Primary goes down. 2) Secondary is changed to standard...

antzz

09-12-2003 05:42 PM
Everett Mills

Hi, My client has an Informix SE database on Windows Platform (NT). How do I export such a db to MS SQL Server 2000? I've searched this...

Doug Baroter

09-12-2003 05:03 PM
sysprog@yahoo.com

I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok...

Diego Morales

09-12-2003 11:58 AM
Obnoxio The Clown

I have been doing an imported restore of 5 servers for 5 months without a problem. Recently I had a file system fail and my backup up scripts were...

Colin Bull

09-12-2003 11:49 AM
Brice Avila

Hello! I am using Informix 7 se and having problems with updating the stored procedure everytime I run it. Basically, I have made changes to the...

Ahmer Sajjad

09-12-2003 11:37 AM
Diego Morales

This in my mind is a daft question but I have to be clear. Can I have the same instance name running on different servers on the same...

Clanmac4

09-12-2003 11:29 AM
Mark D. Stock

What is significance of Informix database buffered log or unbuffered log parameter.

Suket

09-12-2003 08:36 AM
Robert A. Reissaus

Hi all, How can I debug 4gl program with Querix under Windows 2000? Is it necessary debug under Unix with d4gl or Querix have a debugger...

Renza Rebecchi

09-12-2003 08:07 AM
Mark D. Stock

Jean Sagi wrote: You have had several solutions to this. You can, you just don't want to. Something like: " where field_code = ?", ...

Mark D. Stock

09-12-2003 06:03 AM
Mark D. Stock

Here's the quote . . . . International Business Machines Corp. IBM.N unseated Oracle as the overall leader in total new database software sales with...

John Carlson

09-12-2003 06:00 AM
Mark D. Stock